Q1: Difference between customization, enhancement and implementation?
Ans: Customization: Customization is the developing of the forms, reports and SQL script from the beginning or changing the existing.
Enhancement: Enhancement is the modification of forms & Other components according to client user requirement.
Implementation: Implementation is the testing of Applications.
Q2: What are the Types of Customizations?
Ans: There are two types of customizations.
1). Customization by extensions
2). Customizations by Modifications.
Customization by extensions: Customization by extension means developing new:
Component for existing Oracle applications and develop new application using the
Development feature of AOL (Application object Library).
Customization by extensions means Copying an Existing Oracle Application Component (Forms, Report, PL/SQL etc.) to a custom application directory and modifying the Copy.
Customizations by Modifications: Modifying existing oracle application Component to meet your specific Requirement.
Q3: What are the most Common Types of Customization?
Ans: TYPE 1: # Changing Forms:
1) . Changing Forms
2) . Validation logic
3) . Behavior
TYPE2: # Changing Report or Program
1) . Appearance
2) . Logic
TYPE3: # Database Customizations:
1) . Adding read only Schema
2) . Augment (add) logic with database Triggers.
TYPE4: # integrating third Party Software
(NOTE: For more Information on customization goes 115devg.pdf Chapter Twenty-Seven)
Q4: What is Legacy system?
Ans: System other than Oracle is legacy System. Like FoxPro, spreadsheet.
Q5: What is ERP?
Ans: Resource Planning with in Enterprise. ERP is a term that covers whole Product line. ERP means integration of different module. Any business will greatly benefits by
adapting this feature because u can customize it or integrate it with other Packages to satisfy unique requirements.
BENEFITS OF ERP: 1). Flow of Information Effectively.
2). Maintaining Standardizations.
Q6: What is Oracle Apps ?
Ans: Oracle-apps is an ERP Package. The Key Feature of all the oracle-Application
module is Data Integration.
Master data is Integrated: All the application share common files of customers, suppliers, employee, items and other entities that are used by multiple applications.
Transaction data is Integrated: Oracle automatically bridge transactions from one system to another.
Financial data is integrated: Financial data is carried in a common format, and financial data is transmitted from one application to another.
Q7: What is ad-hoc Report?
Ans: Ad-hoc Report is made to meet one-time reporting needs. Concerned with or formed for a particular purpose. For example, ad hoc tax codes or an ad hoc database query
Q8: What is Localization?
Ans: Localization is designed to meet the specific needs of certain territories or countries. Most localization is necessary because the local laws or accountings practice differ from country to country.
Region of Localization: Three Region of Localization.
1). EMEA REGION: Europe, Middle East, Asia pacific and Africa.
2). America REGION: Canada plus Latin America.
3). Global REGION: localization that applies territories through the world. For example
Localization used in both Europe and Latin Americaare classified in the Global Region.
Q9: Library used in Localization?
Ans: #Globe: Globe library allows Oracle Application developer to incorporate global
Or regional feature into oracle application forms without modification of
The base Oracle Application forms.
# JA: JA library contains codes specific to Asia\Pacific Region. And is called
Globe Library.
# JE: JA library contains codes specific to EMEA Region. And is called
By Globe Library.
# JL: The JL Library contains code specific to Latin America Region.
And is called by Globe Library.
Q10: How forms are attached.
Ans: STEP- ONE: First put the form in corresponding module like AP, AR, GL
In appropriate server directory.
STEP-TWO: Second step register form with AOL.
STEP-THREE: Attach form with Function.
STEP-FOUR: Attach function with menu.
STEP-FIVE: Attach menu with responsibility.
STEP-SIX: Attach responsibility to user.
Q11: How Report is attached.
Ans11: STEP- ONE: Register the application.
STEP-TWO: Put Report in appropriate server directory.
STEP-THREE: Define Executables. (NavigatoràConcurrentàProgram
àExecutables)
STEP-FOUR: Define Program (Concurrent à Program à Define)
STEP_FIVE: Define Responsibility (Sysadmin responsibility).
(SecurityàResponsibilityà Define).
STEP-SIX: Define Request Group. (Navigatoràsecurity
àResponsibilityàRequest)
STEP-SEVEN: Define Data Group. (Navigatorà oracleàData group).
STEP-EIGHT: Run the request through SRS. A request Id is created
Through which u can view the request.
Q12: What is workflow?
Ans: To automate and continuously increase business process we use workflow.
Workflow processes represent business process flows and information routings.
Main Function:
1). Routing Information’s (sending or receiving information).
2). Defining & modifying Business Rule.
3). Delivering electronic notification. (By emails).
Q13: What is main workflow Component?
Ans13: 1). Workflow Builder. Workflow is the component that provides user interface For creating, reviewing and maintaining workflow Definitions.
2). Workflow Engine.:workflow is the component that executes and enforces The defined workflow Process.
3). Workflow Monitor Workflow is the component of oracle workflow that
Allow you to review the state or status of an item through any particular workflow process.
4). Workflow Definition Loader: allows u to download the text file.
5). Workflow Directory Services: Tells workflow how to find users.
6). Notification System: Send emails and receives responses from the Oracle Workflow notification system.
Q14: What are Interface table in AP, AR & GL?
Ans:
AP INTERFACE TABLE: 1). AP_INTERFACE_CONTROLS.
2). AP_INTERFACE_REJECTIONS
3). AP_INVOICE_INTERFACE
4). AP_INVOICE_LINES_INTERFACE.
AR INTERFACE TABLE:
1). AR_PAYMENTS_INTERFACE_ALL
2). AR_TAX_INTERFACE
3). HZ_PARTY_INTERFACE
4). HZ_PARTY_INTERFACE_ERRORS
5). RA_CUSTOMERS_INTERFACE_ALL
6). RA_INTERFACE_DISTRIBUTIONS_ALL
7). RA_INTERFACE_ERRORS_ALL
8). RA_INTERFACE_LINES_ALL
9). RA_INTERFACE_SALESCREDITS_ALL
GLINTERFACE TABLE:
1). GL_BUDGET_INTERFACE
2). GL_DAILY_RATES_INTERFACE
3). GL_IEA_INTERFACE
4). GL_INTERFACE
5). GL_INTERFACE_CONTROL
6). GL_INTERFACE_HISTORY
Q15 Total numbers of Tables in AP, AR, GL?
Ans; APà 173
ARà 294
GLà 165
FAà 160
POà 132
OEà 109
Q16: How will u customize a form?
Ans: STEP1: Copy the template.fmb and Appstand.fmb from AU_TOP/forms/us.
Then put in custom directory. The libraries (FNDSQF, APPCORE, APPDAYPK, GLOBE, CUSTOM, JE, JA, JL, VERT) are automatically attached.
STEP2: Create or open new Forms. Then customize.
STEP3: Save this Form in Corresponding Modules.
Q17: What are non-financial modules?
Ans: 1). Projects
2). Manufacturing
3). Supply chain management
4). HR
5). Front Office
6). Strategic Enterprise management.
Q18: Explain Order- cycle in OE.
Ans: Step1: Enter sales order.
Step2: Book the sales order.
Step3: Pick release order.
Step4: Ship or confirm order.
Step5: Backorder Release
Step6: Receivable Interface
Step7: Complete line
Step8: Complete order
Q19: What is AU_TOP.
Ans: This is the Application utility contains PL/SQL library used by oracle forms, reports, oracle form source files and a copy of all Java used to generate the desktop Client.
Q20: What is ad_top?
Ans: ad_top (Application DBA). Contain installation and maintenance utility.
Such as Auto upgrade, Auto Patch and Admin Utility.
Q21: Can we make transaction in close Periods?
Ans: No, we can make only reports.
Q22: If Period is closed how we can enter transactions? (Doubt)
Ans: No, we cannot enter transaction.
Q23: what is SQl*Loader?
Ans: This tool is used to move data from a legacy system to oracle database.
In this two type of inputs to be provided to SQL * Loader.
First is data file, containing the actual data.
Second is the control file containing the specification which drive the
SQL* Loader.
Q24: How can u relate order management with AR?
Ans: sales orders are displayed after confirm release of sales in order management.
Q25: What is the Field of GL_interface?
Ans: 1). SET_OF_BOOKS_ID
2). ACCOUNTING_DATE
3). CURRENCY_CODE
4). DATE_CREATED
5). CREATED_BY
6). CURRENCY_CONVERSION_DATE
7). ENCUMBRANCE_TYPE_ID
8). BUDGET_VERSION_ID
9). CURRENCY_CONVERSION_RATE
10). ACCOUNTED_DR
11).ACCOUNTED_CR
12).TRANSACTION_DATE
Q26: In which directory u store your custom form?
Ans:
App_Top is top directory. We have Core directory Adm., ad (application dba),
Au (application utility), fnd (Foundation), Cust-Dem is Custom directory where
Have 11.0.28 version then we have forms directory. Inside the form we have US
Directory. Where we stand forms.
Q27: Who is Holder of Alerts?
Ans: ALERT Manager.
Q28: Steps for upgradation of 11 to 11i?
Ans28: STEP1: Perform category 1,2,3. (Preupgrade steps).
STEP2: Run auto grade
STEP3: Apply database patch to bring your database to the
Current oracle apps release level.
STEP4: Install online help (optional).
STEP5: Perform Category 4, 5, 6 Steps (Post-upgrade steps).
STEP6: Perform product specific implementation steps as listed in your products Users guide.
STEP7: perform upgrade finishing step.
Q28: How interface program is written and for what purpose
Ans28: Interface Program is written through SQL, PL/SQL.
PURPOSE: 1)Basic Integration
2)Imports valid data that is meaningful to Organization 3). Validate the integrity of any data
Before introducing into oracle apps.
4). Imports data from legacy system.
5). Import data from one module to another.
Q29: What is AOL.
Ans: AOL stands for Application Object Library used for customization
And implementation of forms and Reports.
Q30: which Columns are taking care of descriptive flex fields?
Ans: Attribute Columns
Q31: Can u attach two sets of books with single profile?
Ans: yes we can attach.
Q32: How U Can u attaches two sets of books with single profile.
Ans: we can attach different set of Books with different responsibility
In a single profile.
Q33: can we run FSG report other than GL?
Ans: No, we cannot run. Because FSG reports can only run in GL.
Q34: What are the common libraries in AOL.
Ans34: libraries contain reusable client-side code.
Common Libraries in AOL.
FNDSQF: Contain packages for procedures for Message Dictionary,
Flex fields, profiles, and concurrent processing’s.
APPCORE: Contain packages for procedures for Menus and Toolbar.
APPDAYPK: contain packages that control application Calendar.
APPFLDR: packages for Folder.
Qns35: What is Multilanguage support.
Ans35: Oracle Application provides some feature to support multi language support.
Qns36: Can u delete the posted Journals? Can U make Changes in Posted Journals?
Ans36: No, once the posting program in oracle financial has updated accounts balances, you cannot alter the posted journals; you can only post additional entries that negate the original values. These entries contain either the negative values of the original posted amounts or the original values but with the debit amounts and credit amounts reversed.
These approaches are known as reversal method.
Qns68: Name Few Master tables, Set up table I, transaction table in AP, AR, GL.
Ans68:
Module Name
Master table
setup table
Transaction table
GL
1.GL_SET_OF_BOOKS 2.GL_CODE_COMBINATIONS
FND_CURRENCY
GL_JE_LINES
GL_JE_HEADRES
GL_JE_BATCHES
GL_interface
GL_CONSOLIDATION
GL_SUSPENSE_ACCOUNTS
GL_INTERCOMPANY_ACCOUNTS
AP
PO_VENDORS
AP_BANK_BRANCHES
PO_VENDOR_SITES
AP_HOLD_CODES
FND_CURRENCY
AP_BATCHES_ALL
AP_INVOICE_ALL
AP_DISTRIBUTION_ALL
AP_CHECKS_ALL
AP_PAYMENTS_HISTOTRY_ALL
AR
HZ_CUST_ACCOUNT
FND_CURRENCY
AR_ADJUSTEMENT_ALL
AR_PAYMENTS_SCHEDULE_ALL
AR_CASH_RECEIPT_ALL
AR_DISTRIDUTION_ALL
AR_RECEIVABLE_APPLICATION_ALL.
Qns69: What do u means by FIFO pick and FIFO ship.
Ans69: FIFO pick: First in first out. (Order comes from customer).
FIFO ship: order ship to customer.
Qns70: Difference between SC and NCA.
Ans70:
SC
NCA
1. SMART CLIENT
1. Network computing Architecture
2. No form server in SC. All form is in directory, which is on the client.
2. Forms are in the server. Thus making security higher.
Qns71: What is first step in GL.
Ans71: Creating chart of account.
Qns72: What are standard reports in GL?
Ans72: Trial Balance Report
Journal Report
FSG REPORT
Account Analysis Report.
Qns73: What are standard reports in AP?
Ans73: 1. Supplier Report
2). Payment Report
Qns74: What are standards reports in AR.
Ans74: 1. Tax Report 2. Customer Profile Report
3. Aging Report 4. Dunning Letter Report
Qns75.What are customer table, transaction table, and Receipt table in AR.
Ans
Module
Customer Table
Transaction Table
AR
HZ_CUST_PROFILE_CLASS
HZ_CUST_PROF_CLASS_AMTS
HZ_CUSTOMERS_PROFILES
HZ_CUST_PROFILE_AMTS
HZ_CUST_ACCOUNTS
HZ_CUST_ACCT_SITES_ALL
HZ_CUST_CONTACT_POINTS
HZ_CUST_ACCT_RELATES_ALL
HZ_CUST_SITES_USES_ALL
RA_CUTOMER_TRX_ALL
RA_CUSTOMER_TRX_LINES_ALL
RA_CUST_TRX_TYPES_ALL
RA_CUST_TRX_LINE_SALESREPS_ALL
RECEIPT Table
AR_CASH_RECEIPTS_ALL
AR_RECEIPT_METHOD
AR_CASH_RECEIPT_HISTORY_ALL
AR_INTERIM_CASH_RECEIPT_ALL
Qns76: What is Custom-Library.
Ans76: The custom library allows extension of oracle application without modification
of oracle application code. U can use the custom library for customization Such as zoom (moving to another form), enforcing business rule (for example Vendor name must be in uppercase letters) and disabling field that do not apply for your site.
Custom library is placed in AU_TOP / resource directory.
Event Passed to Custom-Library:
1). WHEN_FORM_NAVIGATE
2). WHEN_NEW_FORM_INSTANCE
3). WHEN_NEW_BLOCK_INSTANCE
4). WHEN_NEW_RECORD_INSTANCE
5). WHEN_NEW_ITEM_INSTANCE.
Qns78: What is the Component of alerts.
Ans78: 1. Message
2.SQL SCRIPT
3.Operating system script
4. Concurrent request.
Qns79: What is difference between charge back and adjustment?
Ans79:
CHARGEBACK
ADJUSTMENT
A new debit item that u assign to your customer closing an existing, outstanding debit item.
A receivable feature that allows u to increase or decrease the amount due of your invoice, debit memos, charge back.
Qns80: What are types of invoice?
Ans80:
TYPES OF INVOICES
NINE Type:
Standard
Credit memo
Debit memo
Expense Report
PO default
Prepayment
Quick match
Withholding tax
Mixed
Qns81: What are sub modules in Financials?
Ans81:
Sub module in Financials
GL
AP
AR
FA
CM (cash management)
Financial Analyzer
Qns82: Concept of Multiorganisation, Explain?
Ans82: Multi organization allows u to setup multiple legal entities within a single installation of oracle applications.
ARCHITECTURE OF MULTIPLE ORGANISATIONS
SET OF BOOKS : Within one set of books u may define one or more legal entities.
LEGAL ENTITY: each legal entity has its own employer tax identification number.
And prepare its own tax forms. Each legal entity has its own Tax forms. Each legal entity has its own set of federal tax rule, State tax rule and local tax rule. Legal entities consist of one or More operating units.
OPERATING UNIT: operating units’ represents buying and selling units with in your
Organization. Oracle order Entry, Oracle receivables, Oracle Purchasing, And Oracle Payables.
INVENTORY ORGANIZATION: an Inventory organization is a unit that has inventory
transactions. Possibly manufactures and or distribute products.
Qns83: How will u attach SOB?
Ans83: STEP1: Create a new Responsibility.
(NàsecurityàResponsibilityàDefine).
STEP2: Attach the new responsibility to an existing user.
STEP3: Defining a new Period Type.
STEP4: Defining an accounting calendar.
STEP5: Defining a set of books.
STEP6: Attach the set of books to your responsibility.(NàProfileàSystem)
STEP7: Signing on as new responsibility.
Qns84: What are key functions provided by Oracle General Ledger?
Ans84:
Function Provided by GL
General Accounting
Budgeting
Multiple Currencies
Intercompany Accounting
Cost Accounting
Consolidation
Financial Reporting
Qns85: What do u means by cost center?
Ans85: COST center gives the information about investment and returns on different projects.
Qns86: what is Fiscal Year.
Ans86: Any yearly accounting Period without relationship to a calendar year.
Qns87: What is Credit-memo?
Ans87: A document that partially or reverse an original invoice.
Qns88: How data is transferred from legacy system to Oracleapps table.
Ans88: A system other than oracle apps system is called legacy System.
Qns89: What is Chart of Accounts?
Ans89: The account structure your organization uses to record transaction and maintain account balances.
Qns90: What are different types of budgets?
Ans90:
Types of Budgets
Operating
Capital
Master Production Schedule
Variable
Time-Phased
Qns91: How others modules are integrate through GL.
Ans91: Integration of module With GL
Qns92: Explain Payable Cycles
Ans92: Four steps in AP Cycle
PAYABLE CYCLE
Four steps in Payable Cycles:
STEP1: Enter Invoice (this process may or may not include matching each invoice with PO).
STEP2: Approve invoice payment.
STEP3: Select and pay approval invoices.
STEP4: Reconcile the payment with bank statement
Qns95: AGING BUCKETS?
A. Time periods you define to age your debit items. Aging buckets are used in the Aging reports to see both current and outstanding debit items. For example, you can define an aging bucket that includes all debit items that are 1 to 30 days past due.
Payables uses the aging buckets you define for its Invoice Aging Report
Q96. CREDIT INVOICE?
A. An invoice you receive from a supplier representing a credit amount that the supplier owes to you. A credit invoice can represent a quantity credit or a price reduction.
Q97. CREDIT MEMO?
A document that partially or fully reverses an original invoice.
Q98.CUTOFF DAY?
The day of the month that determines when an invoice with proximate payment terms is due. For example, if it is January and the cutoff day is the 10th, invoices dated before or on January 10 are due in the next billing period; invoices dated after the 10th are due in the following period.
Q99. DEBIT INVOICE?
A. An invoice you generate to send to a supplier representing a credit amount that the supplier owes to you. A debit invoice can represent a quantity credit or a price reduction.
Q100. JOURNAL ENTRY HEADERS?
A. A method used to group journal entries by currency and journal entry category within a journal entry batch. When you initiate the transfer of invoices or payments to your general ledger for posting, Payables transfers the necessary information to create journal entry headers for the information you transfer. Journal Import in General Ledger uses the information to create a journal entry header for each currency and journal entry category in a journal entry batch. A journal entry batch can have multiple journal entry headers.
Q101 What is Oracle Financials?
Oracle Financials products provide organizations with solutions to a wide range of long- and short-term accounting system issues. Regardless of the size of the business, Oracle Financials can meet accounting management demands with:
Oracle Assets: Ensures that an organization's property and equipment investment is accurate and that the correct asset tax accounting strategies are chosen.
Oracle General Ledger: Offers a complete solution to journal entry, budgeting, allocations, consolidation, and financial reporting needs.
Oracle Inventory: Helps an organization make better inventory decisions by minimizing stock and maximizing cash flow.
Oracle Order Entry: Provides organizations with a sophisticated order entry system for managing customer commitments.
Oracle Payables: Lets an organization process more invoices with fewer staff members and tighter controls. Helps save money through maximum discounts, bank float, and prevention of duplicate payment.
Oracle Personnel: Improves the management of employee- related issues by retaining and making available every form of personnel data.
Oracle Purchasing: Improves buying power, helps negotiate bigger discounts, eliminates paper flow, increases financial controls, and increases productivity.
Oracle Receivables:. Improves cash flow by letting an organization process more payments faster, without off-line research. Helps correctly account for cash, reduce outstanding receivables, and improve collection effectiveness.
Oracle Revenue Accounting gives organization timely and accurate revenue and flexible commissions reporting.
Oracle Sales Analysis: Allows for better forecasting, planning and reporting of sales information.
Q102 What is the most important module in Oracle Financials?
The General Ledger (GL) module is the basis for all other Oracle Financial modules. All other modules provide information to it. If you implement Oracle Financials, you should switch your current GL system first. GL is relatively easy to implement. You should go live with it first to give your implementation team a chance to be familiar with Oracle Financials.
Q103 What is MultiOrg and what is it used for?
MultiOrg allows multiple operating units and their relationships to be defined within a single installation of Oracle Applications. This keeps each operating unit's transaction data separate and secure. Use the following query to determine if MultiOrg is intalled: Select multi_org_flag from fnd_product_groups;
Oracle apps Interview questions – 4
1. Q: How do you make your own query when you are in forms query mode? A: You can use a placeholder to achieve this. If you enter a single colon ( : ) in one of your query fields during the Enter Query mode, Oracle Forms Run Query will prompt you to enter the text of SQL Where clause.
2. Q: What is concurrent processing? A: Concurrent processing is a process that simultaneously runs programs in the background (usually on the server rather than your workstation) while working online.
3. Q: What is a Concurrent Manager? A: A Concurrent Manager is a component of concurrent processing that monitors and runs requests while you work online. Once the user submits a request to run the job, the information is stored in the request table. A concurrent manager gets the information from the request table and executes the specified concurrent job.
4. Q: What is a request set? A request set is a collection of reports or programs grouped together. Once you submit a request set job, it executes all the programs in a report set sequentially or in a parallel manner as defined in the request set.
5. Q: What are the four phases of a concurrent request? The four phases are as follows: inactive, pending, running, and completed.
6. Q: How would you identify the results of the request in the Concurrent View Requests window? Whenever a concurrent job is submitted, Applications creates a Request ID. You can use this Request ID to view the results.
7. Q: What are the profile options? How many levels of profile options are available? Profile options are set to determine how the applications look and feel. There are four levels of profile options available: site level, application level, responsibility level, and user level. You can have various categories of profile options, such as personal options, system options, auditing profile options, currency options, Flexfield options, online reporting options, personal output viewer options, and user profile options.
8. Q: What is a document sequence? A document sequence assigns unique numbers to the documents (transactions) generated by Oracle Applications. For example, each invoice has its own unique invoice number and each purchasing document has its own unique purchase order (PO) number.
9. Q: What are the steps involved in adding a custom program to Oracle Applications?
a) Develop a concurrent program or report.
b) Identify the corresponding executable and register it with the application.
c) Create a concurrent program and its parameters.
d) Add a concurrent program to a request set.
10. Q: How do you register a printer? To add a new printer, go to Install Printer Register.
11. Q: What is a Flexfield? How many types of Flexfields exist? A Flexfield is a field made up of segments. Each segment has an assigned name and a list of valid values. Two types of Flexfields exist: Key Flexfields and Descriptive Flexfields (DFFs).
12. Q: What is a Key Flexfield? A Key Flexfield is a unique identifier that is made up of meaningful segments to identify GL account numbers and item numbers. Key Flexfields are usually stored in SEGMENT1...SEGMENTn database columns.
Some examples would be Item No 34H-AFR-223-112.G and GL Account No:
100-00-1000-324-11100.
For an example GL Account, segments could be identified as Organization,Cost Center, Account, Product, Product Line.
13. Q: What are the Key Flexfields in Oracle Applications? The following table lists some of the Key Flexfields available in Oracle Applications.
Key Flexfields
Using Applications
Accounting
General Ledger
Asset Key
Fixed Assets
Location
Fixed Assets
Category
Fixed Assets
Account Aliases
Inventory
Item Catalogs
Inventory
Item Categories
Inventory
System Iitems
Inventory
Stock Locators
Inventory
Sales Orders
Inventory
Sales Tax Location
Receivables
Territory
Receivables
Job
Human Resources
Grade
Human Resources
Position
Human Resources
Soft Coded Key
Human Resources
14. Q: What is a Descriptive Flex Field? A DFF lets you define the custom fields into Oracle Application forms without customizing the program code. DFFs in forms are represented by a "beer mug" field (a single space field enclosed by brackets) that looks like the following symbol: [ ]. They are usually stored in ATTRIBUTE1...ATTRIBUTEn database columns. DFFs can also be used to accept report parameters.
15. Q: What types of segments can be set up for DFFs? Global or context-sensitive.
16. Q: What is a value set? A value set is a list of values validated against segments. You can create a value set and assign it to a Flexfield segment.
17. Q: How many validation types are there? Six validation types exist:none, dependent, independent, table, special, and pair.
18. Q: What are the required and optional steps for setting up Flexfields? The required steps are as follows: define the value sets, define the structures, and define the values, if needed. The optional steps are as follows: define the security rules, define the cross-validation rules, and define the shorthand aliases, if necessary.
19. Q: Can you define cross-validation rules for DFFs? No, you cannot. You can only define them for Key Flexfields.
20. Q: Can a value set be shared between Flexfields? Yes, value sets can be shared between Flexfields.
21. Q: Can a value set be shared within a Flexfield structure? No, value sets cannot be shared between segments within a Flexfield as long as they do not carry the same type of information. For example, date information can be shared between segments within a Flexfield.
22. Q: What are the advanced validation options? Three types of advanced validation options are available. $PROFILES$, which references the current value of a profile option. An example would be $PROFILES$.profile_option_name. Block.field, which references the block field. $FLEX$, which refers to the current value of a previously used value set. An example would be $FLEX$.value_set_name (cascading dependencies).
23. Q: What is the next step after defining the segments for Flexfields? Freezing and compiling the structure.
24. Q: What are the steps required to set up value security rules? Make sure security is enabled, define rules for the value set, and assign rules to the user's responsibility.
25. Q: What is Oracle Alert? Oracle Alert is an exception reporting system. It keeps you informed on an as-needed basis. It also communicates with other users through e-mail regarding exception messages.
26. Q: How many types of alerts are there? Two types of alerts exist: Periodic Alerts and Event Alerts. Periodic Alerts fire at a time interval, and Event Alerts are fired by database table changes.
27. Q: What are Quick Codes? Quick Codes, also known as Quickpicks, are standard sets of user-defined values. Lookup is a combination of a code and a description. The lookup tables are generally populated by the scripts located in /install/odf directory.
28. Q: What is an Open Interface in Oracle Applications? Open Interface, also known as the Application Programmer Interface (API), is a process whereby the Oracle Applications are linked with external or legacy systems. Open Interface works as a temporary staging area to load the external information into Oracle Applications tables. Once the data is validated, it sends the information to the permanent tables. Rejected transactions can be corrected and resubmitted.
29. Q: Which schema has complete access to the Oracle Applications data model? The APPS schema. AutoInstall automatically sets the FNDNAM environment variable to the name of the APPS schema.
30. Q: What is the top directory in Oracle Applications? $APPL_TOP.
31. Q: What is a product top directory? It starts with the product shortname and is suffixed with TOP, such as TOP. For example, General Ledger's top directory is GL_TOP.
32. Q: What are the log and output directory names for a product group? The product group environment file sets the APPLLOG variable to log and APPLOUT to out. For example, the output directory for General Ledger is $GL_TOP/$APPLOUT. For log, it is $GL_TOP/_$APPLLOG.
33. Q: What data dictionary tables do you use to obtain detailed information regarding? You can write a query by joining the FND_TABLE and FND__COLUMNS tables. FND_INDEXES and FND_INDEX_COLUMNS tables are part of the data dictionary. All the FND_ table names are self-explanatory.
34. Q: What are the primary underlying tables for concurrent processing? FND_CONCURRENT_PROGRAMS, FND_CONCURRENT__REQUESTS, FND_CONCURRENT_PROCESSES, and FND_CONCURRENT_QUEUES tables.
35. Q: What are the primary underlying tables for Flexfields? FND_DESCR_FLEX_CONTEXTS, FND_FLEX_VALIDATION__RULES, FND_FLEX_VALUE_SETS, FND_ID_FLEXS, FND_ID__FLEX_SEGMENTS, and FND_ID_FLEX_STRUCTURES tables.
36. Q: What is the primary underlying table for AOL QuickCodes? FND_LOOKUPS table.
37. Q: What is the application dummy table used by a form block? FND_DUAL table.
38. Q: What is the main underlying table for Profile Options? FND_PROFILE_OPTIONS table.
39. Q: What are the main prerequisites for creating a custom application or responsibility? Set up a directory structure for a custom application, and define an environment variable that translates to your application base path.
40. Q: What are the WHO columns? WHO columns are used to track the changes to your data in the application tables. WHO columns exist in all Oracle Applications standard tables. The following five are considered WHO columns:
Column Name
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
41. Q: Do I need to have WHO column information in custom forms? Yes. It is strongly recommended to add WHO columns to the custom tables and call standard API, FND_STANDARD.SET_WHO in PRE-INSERT, and PRE-UPDATE triggers in each block of the form. Also, specify these fields as hidden in each block of the form.
42. Q: What are the additional WHO columns used for concurrent programs? Concurrent programs use all the following WHO inncluding the following four.
Column Name
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
43. Q: Can you disable the WHO columns' information in a form block? Yes. You can disable HELP -> ABOUT THIS RECORD information within a block. Call the following procedures in a block level WHEN-NEW-BLOCK-INSTANCE
Trigger:app_standard.event('WHEN-NEW-BLOCK-INSTANCE');
app_standard.enable('ABOUT','PROPERTY_OFF');
44. Q: How do you register your custom tables in PL/SQL? You can use AD_DD package to register custom tables in PL/SQL.
45. Q: How do you define the passing arguments in SQL/PLUS and PL/SQL concurrent programs? You must name your passing arguments as &1, &2, &3 and so on.
46. Q: How do you call your custom reports from a form? You can call your custom Oracle reports in a form using the FND_REQUEST.SUBMIT_REQUEST procedure.
47. Q: What is a template form? A template form is a starting point for the development of custom forms. Copy the Template.fmb file from $AU_TOP/forms/US directory to your local directory and rename it.
48. Q: Which libraries are attached to the template form? The following main libraries are directly attached to the template form. APPCORE contains packages and procedures for standard menus, toolbars, and so on. APPDAYPK contains a calendar package. FNDSQF contains packages and procedures for Flexfields, concurrent processing, profiles, and a message dictionary.
49. Q: What is a calendar? A calendar is an object that lets you select the date and time. It is automatically included in the template form. A Calendar package example would be calendar.show.
50. Q: Which template form triggers require some modifications? The ACCEPT, FOLDER_RETURN_ACTION, KEY-DUPREC, KEY-MENU, KEYCLRFRM, ON-ERROR, KEY-LISTVAL, POST-FORM, PRE-FORM, QUERY_FIND, WHEN-NEW-FORM-INSTANCE, WHEN-NEW-BLOCK-INSTANCE, WHEN-NEWRECORD-INSTANCE, and WHEN-NEW-ITEM-INSTANCE triggers.
51. Q: Which template form triggers cannot be modified? The CLOSE_WINDOW, EXPORT, FOLDER_ACTION, KEY-COMMIT, KEY-EDIT, KEY-EXIT, KEY-HELP, LASTRECORD, WHEN-WINDOW-CLOSED, WHENFORM-NAVIGATE, and ZOOMtriggers.
52. Q: What are the main template files for Pro*C concurrent programs? The main template files are EXMAIN.c and EXPROG.c .
53. Q: What is the Oracle-recommended application short name for extensions? Oracle recommends an application short name begin with XX. As an example, extensions to Oracle Purchasing would be XXPO.
54. Q: Where do you maintain the list of your custom programs? All custom programs should be listed in the applcust.txt file. This file is located in the $APPL_TOP/admin directory. When you apply the patches, Oracle Applications uses this file for informational purposes.
55. Q: What are the steps involved in modifying an existing form? First, you identify the existing file and then you copy the file to a custom application directory, making sure to rename it. You then make the necessary modifications, generate the form, and document it in the custom program list using applcust.txt file.
56. Q: Where do you maintain database customizations? You can maintain all your table changes by creating a new schema. You can use your custom application short name (such as XXPO) as your Oracle schema name for easy identification. The new schema must be registered in the Oracle AOL.
57. Q: Can you create extensions to Oracle Applications without modifying the standard form code? Yes. This can be done using the CUSTOM library, which is an Oracle Forms PL/SQL library. You can integrate your custom code directly with Oracle Applications without making changes to your Oracle Applications forms code. The CUSTOM library is located in the $AU_TOP/res/plsql directory. Once you write the code, you compile and generate the CUSTOM procedures to make your changes.
58. Q: When do you use the CUSTOM library? You can use the CUSTOM library in a variety of cases. You can use it to incorporate Zoom logic, logic for generic events, logic for product-specific events, and to add entries for the special menu.
Oracle Apps Interview questions - 6
1.
What are the various types of Exceptions?
User defined and Predefined Exceptions.
2.
Can we define exceptions twice in same block?
No.
3.
What is the difference between a procedure and a function?
Functions return a single variable by value where as procedures do not return any variable by value. Rather they return multiple variables by passing variables by reference through their OUT parameter.
4.
Can you have two functions with the same name in a PL/SQL block ?
Yes.
5.
Can you have two stored functions with the same name ?
Yes.
6.
Can you call a stored function in the constraint of a table ?
No.
7.
What are the various types of parameter modes in a procedure ?
IN, OUT AND INOUT.
8.
What is Over Loading and what are its restrictions?
Over Loading means an object performing different functions depending upon the no. of parameters or the data type of the parameters passed to it.
9.
Can functions be overloaded?
Yes.
10.
Can 2 functions have same name & input parameters but differ only by return data type
Ans: Customization: Customization is the developing of the forms, reports and SQL script from the beginning or changing the existing.
Enhancement: Enhancement is the modification of forms & Other components according to client user requirement.
Implementation: Implementation is the testing of Applications.
Q2: What are the Types of Customizations?
Ans: There are two types of customizations.
1). Customization by extensions
2). Customizations by Modifications.
Customization by extensions: Customization by extension means developing new:
Component for existing Oracle applications and develop new application using the
Development feature of AOL (Application object Library).
Customization by extensions means Copying an Existing Oracle Application Component (Forms, Report, PL/SQL etc.) to a custom application directory and modifying the Copy.
Customizations by Modifications: Modifying existing oracle application Component to meet your specific Requirement.
Q3: What are the most Common Types of Customization?
Ans: TYPE 1: # Changing Forms:
1) . Changing Forms
2) . Validation logic
3) . Behavior
TYPE2: # Changing Report or Program
1) . Appearance
2) . Logic
TYPE3: # Database Customizations:
1) . Adding read only Schema
2) . Augment (add) logic with database Triggers.
TYPE4: # integrating third Party Software
(NOTE: For more Information on customization goes 115devg.pdf Chapter Twenty-Seven)
Q4: What is Legacy system?
Ans: System other than Oracle is legacy System. Like FoxPro, spreadsheet.
Q5: What is ERP?
Ans: Resource Planning with in Enterprise. ERP is a term that covers whole Product line. ERP means integration of different module. Any business will greatly benefits by
adapting this feature because u can customize it or integrate it with other Packages to satisfy unique requirements.
BENEFITS OF ERP: 1). Flow of Information Effectively.
2). Maintaining Standardizations.
Q6: What is Oracle Apps ?
Ans: Oracle-apps is an ERP Package. The Key Feature of all the oracle-Application
module is Data Integration.
Master data is Integrated: All the application share common files of customers, suppliers, employee, items and other entities that are used by multiple applications.
Transaction data is Integrated: Oracle automatically bridge transactions from one system to another.
Financial data is integrated: Financial data is carried in a common format, and financial data is transmitted from one application to another.
Q7: What is ad-hoc Report?
Ans: Ad-hoc Report is made to meet one-time reporting needs. Concerned with or formed for a particular purpose. For example, ad hoc tax codes or an ad hoc database query
Q8: What is Localization?
Ans: Localization is designed to meet the specific needs of certain territories or countries. Most localization is necessary because the local laws or accountings practice differ from country to country.
Region of Localization: Three Region of Localization.
1). EMEA REGION: Europe, Middle East, Asia pacific and Africa.
2). America REGION: Canada plus Latin America.
3). Global REGION: localization that applies territories through the world. For example
Localization used in both Europe and Latin Americaare classified in the Global Region.
Q9: Library used in Localization?
Ans: #Globe: Globe library allows Oracle Application developer to incorporate global
Or regional feature into oracle application forms without modification of
The base Oracle Application forms.
# JA: JA library contains codes specific to Asia\Pacific Region. And is called
Globe Library.
# JE: JA library contains codes specific to EMEA Region. And is called
By Globe Library.
# JL: The JL Library contains code specific to Latin America Region.
And is called by Globe Library.
Q10: How forms are attached.
Ans: STEP- ONE: First put the form in corresponding module like AP, AR, GL
In appropriate server directory.
STEP-TWO: Second step register form with AOL.
STEP-THREE: Attach form with Function.
STEP-FOUR: Attach function with menu.
STEP-FIVE: Attach menu with responsibility.
STEP-SIX: Attach responsibility to user.
Q11: How Report is attached.
Ans11: STEP- ONE: Register the application.
STEP-TWO: Put Report in appropriate server directory.
STEP-THREE: Define Executables. (NavigatoràConcurrentàProgram
àExecutables)
STEP-FOUR: Define Program (Concurrent à Program à Define)
STEP_FIVE: Define Responsibility (Sysadmin responsibility).
(SecurityàResponsibilityà Define).
STEP-SIX: Define Request Group. (Navigatoràsecurity
àResponsibilityàRequest)
STEP-SEVEN: Define Data Group. (Navigatorà oracleàData group).
STEP-EIGHT: Run the request through SRS. A request Id is created
Through which u can view the request.
Q12: What is workflow?
Ans: To automate and continuously increase business process we use workflow.
Workflow processes represent business process flows and information routings.
Main Function:
1). Routing Information’s (sending or receiving information).
2). Defining & modifying Business Rule.
3). Delivering electronic notification. (By emails).
Q13: What is main workflow Component?
Ans13: 1). Workflow Builder. Workflow is the component that provides user interface For creating, reviewing and maintaining workflow Definitions.
2). Workflow Engine.:workflow is the component that executes and enforces The defined workflow Process.
3). Workflow Monitor Workflow is the component of oracle workflow that
Allow you to review the state or status of an item through any particular workflow process.
4). Workflow Definition Loader: allows u to download the text file.
5). Workflow Directory Services: Tells workflow how to find users.
6). Notification System: Send emails and receives responses from the Oracle Workflow notification system.
Q14: What are Interface table in AP, AR & GL?
Ans:
AP INTERFACE TABLE: 1). AP_INTERFACE_CONTROLS.
2). AP_INTERFACE_REJECTIONS
3). AP_INVOICE_INTERFACE
4). AP_INVOICE_LINES_INTERFACE.
AR INTERFACE TABLE:
1). AR_PAYMENTS_INTERFACE_ALL
2). AR_TAX_INTERFACE
3). HZ_PARTY_INTERFACE
4). HZ_PARTY_INTERFACE_ERRORS
5). RA_CUSTOMERS_INTERFACE_ALL
6). RA_INTERFACE_DISTRIBUTIONS_ALL
7). RA_INTERFACE_ERRORS_ALL
8). RA_INTERFACE_LINES_ALL
9). RA_INTERFACE_SALESCREDITS_ALL
GLINTERFACE TABLE:
1). GL_BUDGET_INTERFACE
2). GL_DAILY_RATES_INTERFACE
3). GL_IEA_INTERFACE
4). GL_INTERFACE
5). GL_INTERFACE_CONTROL
6). GL_INTERFACE_HISTORY
Q15 Total numbers of Tables in AP, AR, GL?
Ans; APà 173
ARà 294
GLà 165
FAà 160
POà 132
OEà 109
Q16: How will u customize a form?
Ans: STEP1: Copy the template.fmb and Appstand.fmb from AU_TOP/forms/us.
Then put in custom directory. The libraries (FNDSQF, APPCORE, APPDAYPK, GLOBE, CUSTOM, JE, JA, JL, VERT) are automatically attached.
STEP2: Create or open new Forms. Then customize.
STEP3: Save this Form in Corresponding Modules.
Q17: What are non-financial modules?
Ans: 1). Projects
2). Manufacturing
3). Supply chain management
4). HR
5). Front Office
6). Strategic Enterprise management.
Q18: Explain Order- cycle in OE.
Ans: Step1: Enter sales order.
Step2: Book the sales order.
Step3: Pick release order.
Step4: Ship or confirm order.
Step5: Backorder Release
Step6: Receivable Interface
Step7: Complete line
Step8: Complete order
Q19: What is AU_TOP.
Ans: This is the Application utility contains PL/SQL library used by oracle forms, reports, oracle form source files and a copy of all Java used to generate the desktop Client.
Q20: What is ad_top?
Ans: ad_top (Application DBA). Contain installation and maintenance utility.
Such as Auto upgrade, Auto Patch and Admin Utility.
Q21: Can we make transaction in close Periods?
Ans: No, we can make only reports.
Q22: If Period is closed how we can enter transactions? (Doubt)
Ans: No, we cannot enter transaction.
Q23: what is SQl*Loader?
Ans: This tool is used to move data from a legacy system to oracle database.
In this two type of inputs to be provided to SQL * Loader.
First is data file, containing the actual data.
Second is the control file containing the specification which drive the
SQL* Loader.
Q24: How can u relate order management with AR?
Ans: sales orders are displayed after confirm release of sales in order management.
Q25: What is the Field of GL_interface?
Ans: 1). SET_OF_BOOKS_ID
2). ACCOUNTING_DATE
3). CURRENCY_CODE
4). DATE_CREATED
5). CREATED_BY
6). CURRENCY_CONVERSION_DATE
7). ENCUMBRANCE_TYPE_ID
8). BUDGET_VERSION_ID
9). CURRENCY_CONVERSION_RATE
10). ACCOUNTED_DR
11).ACCOUNTED_CR
12).TRANSACTION_DATE
Q26: In which directory u store your custom form?
Ans:
App_Top is top directory. We have Core directory Adm., ad (application dba),
Au (application utility), fnd (Foundation), Cust-Dem is Custom directory where
Have 11.0.28 version then we have forms directory. Inside the form we have US
Directory. Where we stand forms.
Q27: Who is Holder of Alerts?
Ans: ALERT Manager.
Q28: Steps for upgradation of 11 to 11i?
Ans28: STEP1: Perform category 1,2,3. (Preupgrade steps).
STEP2: Run auto grade
STEP3: Apply database patch to bring your database to the
Current oracle apps release level.
STEP4: Install online help (optional).
STEP5: Perform Category 4, 5, 6 Steps (Post-upgrade steps).
STEP6: Perform product specific implementation steps as listed in your products Users guide.
STEP7: perform upgrade finishing step.
Q28: How interface program is written and for what purpose
Ans28: Interface Program is written through SQL, PL/SQL.
PURPOSE: 1)Basic Integration
2)Imports valid data that is meaningful to Organization 3). Validate the integrity of any data
Before introducing into oracle apps.
4). Imports data from legacy system.
5). Import data from one module to another.
Q29: What is AOL.
Ans: AOL stands for Application Object Library used for customization
And implementation of forms and Reports.
Q30: which Columns are taking care of descriptive flex fields?
Ans: Attribute Columns
Q31: Can u attach two sets of books with single profile?
Ans: yes we can attach.
Q32: How U Can u attaches two sets of books with single profile.
Ans: we can attach different set of Books with different responsibility
In a single profile.
Q33: can we run FSG report other than GL?
Ans: No, we cannot run. Because FSG reports can only run in GL.
Q34: What are the common libraries in AOL.
Ans34: libraries contain reusable client-side code.
Common Libraries in AOL.
FNDSQF: Contain packages for procedures for Message Dictionary,
Flex fields, profiles, and concurrent processing’s.
APPCORE: Contain packages for procedures for Menus and Toolbar.
APPDAYPK: contain packages that control application Calendar.
APPFLDR: packages for Folder.
Qns35: What is Multilanguage support.
Ans35: Oracle Application provides some feature to support multi language support.
Qns36: Can u delete the posted Journals? Can U make Changes in Posted Journals?
Ans36: No, once the posting program in oracle financial has updated accounts balances, you cannot alter the posted journals; you can only post additional entries that negate the original values. These entries contain either the negative values of the original posted amounts or the original values but with the debit amounts and credit amounts reversed.
These approaches are known as reversal method.
Qns68: Name Few Master tables, Set up table I, transaction table in AP, AR, GL.
Ans68:
Module Name
Master table
setup table
Transaction table
GL
1.GL_SET_OF_BOOKS 2.GL_CODE_COMBINATIONS
FND_CURRENCY
GL_JE_LINES
GL_JE_HEADRES
GL_JE_BATCHES
GL_interface
GL_CONSOLIDATION
GL_SUSPENSE_ACCOUNTS
GL_INTERCOMPANY_ACCOUNTS
AP
PO_VENDORS
AP_BANK_BRANCHES
PO_VENDOR_SITES
AP_HOLD_CODES
FND_CURRENCY
AP_BATCHES_ALL
AP_INVOICE_ALL
AP_DISTRIBUTION_ALL
AP_CHECKS_ALL
AP_PAYMENTS_HISTOTRY_ALL
AR
HZ_CUST_ACCOUNT
FND_CURRENCY
AR_ADJUSTEMENT_ALL
AR_PAYMENTS_SCHEDULE_ALL
AR_CASH_RECEIPT_ALL
AR_DISTRIDUTION_ALL
AR_RECEIVABLE_APPLICATION_ALL.
Qns69: What do u means by FIFO pick and FIFO ship.
Ans69: FIFO pick: First in first out. (Order comes from customer).
FIFO ship: order ship to customer.
Qns70: Difference between SC and NCA.
Ans70:
SC
NCA
1. SMART CLIENT
1. Network computing Architecture
2. No form server in SC. All form is in directory, which is on the client.
2. Forms are in the server. Thus making security higher.
Qns71: What is first step in GL.
Ans71: Creating chart of account.
Qns72: What are standard reports in GL?
Ans72: Trial Balance Report
Journal Report
FSG REPORT
Account Analysis Report.
Qns73: What are standard reports in AP?
Ans73: 1. Supplier Report
2). Payment Report
Qns74: What are standards reports in AR.
Ans74: 1. Tax Report 2. Customer Profile Report
3. Aging Report 4. Dunning Letter Report
Qns75.What are customer table, transaction table, and Receipt table in AR.
Ans
Module
Customer Table
Transaction Table
AR
HZ_CUST_PROFILE_CLASS
HZ_CUST_PROF_CLASS_AMTS
HZ_CUSTOMERS_PROFILES
HZ_CUST_PROFILE_AMTS
HZ_CUST_ACCOUNTS
HZ_CUST_ACCT_SITES_ALL
HZ_CUST_CONTACT_POINTS
HZ_CUST_ACCT_RELATES_ALL
HZ_CUST_SITES_USES_ALL
RA_CUTOMER_TRX_ALL
RA_CUSTOMER_TRX_LINES_ALL
RA_CUST_TRX_TYPES_ALL
RA_CUST_TRX_LINE_SALESREPS_ALL
RECEIPT Table
AR_CASH_RECEIPTS_ALL
AR_RECEIPT_METHOD
AR_CASH_RECEIPT_HISTORY_ALL
AR_INTERIM_CASH_RECEIPT_ALL
Qns76: What is Custom-Library.
Ans76: The custom library allows extension of oracle application without modification
of oracle application code. U can use the custom library for customization Such as zoom (moving to another form), enforcing business rule (for example Vendor name must be in uppercase letters) and disabling field that do not apply for your site.
Custom library is placed in AU_TOP / resource directory.
Event Passed to Custom-Library:
1). WHEN_FORM_NAVIGATE
2). WHEN_NEW_FORM_INSTANCE
3). WHEN_NEW_BLOCK_INSTANCE
4). WHEN_NEW_RECORD_INSTANCE
5). WHEN_NEW_ITEM_INSTANCE.
Qns78: What is the Component of alerts.
Ans78: 1. Message
2.SQL SCRIPT
3.Operating system script
4. Concurrent request.
Qns79: What is difference between charge back and adjustment?
Ans79:
CHARGEBACK
ADJUSTMENT
A new debit item that u assign to your customer closing an existing, outstanding debit item.
A receivable feature that allows u to increase or decrease the amount due of your invoice, debit memos, charge back.
Qns80: What are types of invoice?
Ans80:
TYPES OF INVOICES
NINE Type:
Standard
Credit memo
Debit memo
Expense Report
PO default
Prepayment
Quick match
Withholding tax
Mixed
Qns81: What are sub modules in Financials?
Ans81:
Sub module in Financials
GL
AP
AR
FA
CM (cash management)
Financial Analyzer
Qns82: Concept of Multiorganisation, Explain?
Ans82: Multi organization allows u to setup multiple legal entities within a single installation of oracle applications.
ARCHITECTURE OF MULTIPLE ORGANISATIONS
SET OF BOOKS : Within one set of books u may define one or more legal entities.
LEGAL ENTITY: each legal entity has its own employer tax identification number.
And prepare its own tax forms. Each legal entity has its own Tax forms. Each legal entity has its own set of federal tax rule, State tax rule and local tax rule. Legal entities consist of one or More operating units.
OPERATING UNIT: operating units’ represents buying and selling units with in your
Organization. Oracle order Entry, Oracle receivables, Oracle Purchasing, And Oracle Payables.
INVENTORY ORGANIZATION: an Inventory organization is a unit that has inventory
transactions. Possibly manufactures and or distribute products.
Qns83: How will u attach SOB?
Ans83: STEP1: Create a new Responsibility.
(NàsecurityàResponsibilityàDefine).
STEP2: Attach the new responsibility to an existing user.
STEP3: Defining a new Period Type.
STEP4: Defining an accounting calendar.
STEP5: Defining a set of books.
STEP6: Attach the set of books to your responsibility.(NàProfileàSystem)
STEP7: Signing on as new responsibility.
Qns84: What are key functions provided by Oracle General Ledger?
Ans84:
Function Provided by GL
General Accounting
Budgeting
Multiple Currencies
Intercompany Accounting
Cost Accounting
Consolidation
Financial Reporting
Qns85: What do u means by cost center?
Ans85: COST center gives the information about investment and returns on different projects.
Qns86: what is Fiscal Year.
Ans86: Any yearly accounting Period without relationship to a calendar year.
Qns87: What is Credit-memo?
Ans87: A document that partially or reverse an original invoice.
Qns88: How data is transferred from legacy system to Oracleapps table.
Ans88: A system other than oracle apps system is called legacy System.
Qns89: What is Chart of Accounts?
Ans89: The account structure your organization uses to record transaction and maintain account balances.
Qns90: What are different types of budgets?
Ans90:
Types of Budgets
Operating
Capital
Master Production Schedule
Variable
Time-Phased
Qns91: How others modules are integrate through GL.
Ans91: Integration of module With GL
Qns92: Explain Payable Cycles
Ans92: Four steps in AP Cycle
PAYABLE CYCLE
Four steps in Payable Cycles:
STEP1: Enter Invoice (this process may or may not include matching each invoice with PO).
STEP2: Approve invoice payment.
STEP3: Select and pay approval invoices.
STEP4: Reconcile the payment with bank statement
Qns95: AGING BUCKETS?
A. Time periods you define to age your debit items. Aging buckets are used in the Aging reports to see both current and outstanding debit items. For example, you can define an aging bucket that includes all debit items that are 1 to 30 days past due.
Payables uses the aging buckets you define for its Invoice Aging Report
Q96. CREDIT INVOICE?
A. An invoice you receive from a supplier representing a credit amount that the supplier owes to you. A credit invoice can represent a quantity credit or a price reduction.
Q97. CREDIT MEMO?
A document that partially or fully reverses an original invoice.
Q98.CUTOFF DAY?
The day of the month that determines when an invoice with proximate payment terms is due. For example, if it is January and the cutoff day is the 10th, invoices dated before or on January 10 are due in the next billing period; invoices dated after the 10th are due in the following period.
Q99. DEBIT INVOICE?
A. An invoice you generate to send to a supplier representing a credit amount that the supplier owes to you. A debit invoice can represent a quantity credit or a price reduction.
Q100. JOURNAL ENTRY HEADERS?
A. A method used to group journal entries by currency and journal entry category within a journal entry batch. When you initiate the transfer of invoices or payments to your general ledger for posting, Payables transfers the necessary information to create journal entry headers for the information you transfer. Journal Import in General Ledger uses the information to create a journal entry header for each currency and journal entry category in a journal entry batch. A journal entry batch can have multiple journal entry headers.
Q101 What is Oracle Financials?
Oracle Financials products provide organizations with solutions to a wide range of long- and short-term accounting system issues. Regardless of the size of the business, Oracle Financials can meet accounting management demands with:
Oracle Assets: Ensures that an organization's property and equipment investment is accurate and that the correct asset tax accounting strategies are chosen.
Oracle General Ledger: Offers a complete solution to journal entry, budgeting, allocations, consolidation, and financial reporting needs.
Oracle Inventory: Helps an organization make better inventory decisions by minimizing stock and maximizing cash flow.
Oracle Order Entry: Provides organizations with a sophisticated order entry system for managing customer commitments.
Oracle Payables: Lets an organization process more invoices with fewer staff members and tighter controls. Helps save money through maximum discounts, bank float, and prevention of duplicate payment.
Oracle Personnel: Improves the management of employee- related issues by retaining and making available every form of personnel data.
Oracle Purchasing: Improves buying power, helps negotiate bigger discounts, eliminates paper flow, increases financial controls, and increases productivity.
Oracle Receivables:. Improves cash flow by letting an organization process more payments faster, without off-line research. Helps correctly account for cash, reduce outstanding receivables, and improve collection effectiveness.
Oracle Revenue Accounting gives organization timely and accurate revenue and flexible commissions reporting.
Oracle Sales Analysis: Allows for better forecasting, planning and reporting of sales information.
Q102 What is the most important module in Oracle Financials?
The General Ledger (GL) module is the basis for all other Oracle Financial modules. All other modules provide information to it. If you implement Oracle Financials, you should switch your current GL system first. GL is relatively easy to implement. You should go live with it first to give your implementation team a chance to be familiar with Oracle Financials.
Q103 What is MultiOrg and what is it used for?
MultiOrg allows multiple operating units and their relationships to be defined within a single installation of Oracle Applications. This keeps each operating unit's transaction data separate and secure. Use the following query to determine if MultiOrg is intalled: Select multi_org_flag from fnd_product_groups;
Oracle apps Interview questions – 4
1. Q: How do you make your own query when you are in forms query mode? A: You can use a placeholder to achieve this. If you enter a single colon ( : ) in one of your query fields during the Enter Query mode, Oracle Forms Run Query will prompt you to enter the text of SQL Where clause.
2. Q: What is concurrent processing? A: Concurrent processing is a process that simultaneously runs programs in the background (usually on the server rather than your workstation) while working online.
3. Q: What is a Concurrent Manager? A: A Concurrent Manager is a component of concurrent processing that monitors and runs requests while you work online. Once the user submits a request to run the job, the information is stored in the request table. A concurrent manager gets the information from the request table and executes the specified concurrent job.
4. Q: What is a request set? A request set is a collection of reports or programs grouped together. Once you submit a request set job, it executes all the programs in a report set sequentially or in a parallel manner as defined in the request set.
5. Q: What are the four phases of a concurrent request? The four phases are as follows: inactive, pending, running, and completed.
6. Q: How would you identify the results of the request in the Concurrent View Requests window? Whenever a concurrent job is submitted, Applications creates a Request ID. You can use this Request ID to view the results.
7. Q: What are the profile options? How many levels of profile options are available? Profile options are set to determine how the applications look and feel. There are four levels of profile options available: site level, application level, responsibility level, and user level. You can have various categories of profile options, such as personal options, system options, auditing profile options, currency options, Flexfield options, online reporting options, personal output viewer options, and user profile options.
8. Q: What is a document sequence? A document sequence assigns unique numbers to the documents (transactions) generated by Oracle Applications. For example, each invoice has its own unique invoice number and each purchasing document has its own unique purchase order (PO) number.
9. Q: What are the steps involved in adding a custom program to Oracle Applications?
a) Develop a concurrent program or report.
b) Identify the corresponding executable and register it with the application.
c) Create a concurrent program and its parameters.
d) Add a concurrent program to a request set.
10. Q: How do you register a printer? To add a new printer, go to Install Printer Register.
11. Q: What is a Flexfield? How many types of Flexfields exist? A Flexfield is a field made up of segments. Each segment has an assigned name and a list of valid values. Two types of Flexfields exist: Key Flexfields and Descriptive Flexfields (DFFs).
12. Q: What is a Key Flexfield? A Key Flexfield is a unique identifier that is made up of meaningful segments to identify GL account numbers and item numbers. Key Flexfields are usually stored in SEGMENT1...SEGMENTn database columns.
Some examples would be Item No 34H-AFR-223-112.G and GL Account No:
100-00-1000-324-11100.
For an example GL Account, segments could be identified as Organization,Cost Center, Account, Product, Product Line.
13. Q: What are the Key Flexfields in Oracle Applications? The following table lists some of the Key Flexfields available in Oracle Applications.
Key Flexfields
Using Applications
Accounting
General Ledger
Asset Key
Fixed Assets
Location
Fixed Assets
Category
Fixed Assets
Account Aliases
Inventory
Item Catalogs
Inventory
Item Categories
Inventory
System Iitems
Inventory
Stock Locators
Inventory
Sales Orders
Inventory
Sales Tax Location
Receivables
Territory
Receivables
Job
Human Resources
Grade
Human Resources
Position
Human Resources
Soft Coded Key
Human Resources
14. Q: What is a Descriptive Flex Field? A DFF lets you define the custom fields into Oracle Application forms without customizing the program code. DFFs in forms are represented by a "beer mug" field (a single space field enclosed by brackets) that looks like the following symbol: [ ]. They are usually stored in ATTRIBUTE1...ATTRIBUTEn database columns. DFFs can also be used to accept report parameters.
15. Q: What types of segments can be set up for DFFs? Global or context-sensitive.
16. Q: What is a value set? A value set is a list of values validated against segments. You can create a value set and assign it to a Flexfield segment.
17. Q: How many validation types are there? Six validation types exist:none, dependent, independent, table, special, and pair.
18. Q: What are the required and optional steps for setting up Flexfields? The required steps are as follows: define the value sets, define the structures, and define the values, if needed. The optional steps are as follows: define the security rules, define the cross-validation rules, and define the shorthand aliases, if necessary.
19. Q: Can you define cross-validation rules for DFFs? No, you cannot. You can only define them for Key Flexfields.
20. Q: Can a value set be shared between Flexfields? Yes, value sets can be shared between Flexfields.
21. Q: Can a value set be shared within a Flexfield structure? No, value sets cannot be shared between segments within a Flexfield as long as they do not carry the same type of information. For example, date information can be shared between segments within a Flexfield.
22. Q: What are the advanced validation options? Three types of advanced validation options are available. $PROFILES$, which references the current value of a profile option. An example would be $PROFILES$.profile_option_name. Block.field, which references the block field. $FLEX$, which refers to the current value of a previously used value set. An example would be $FLEX$.value_set_name (cascading dependencies).
23. Q: What is the next step after defining the segments for Flexfields? Freezing and compiling the structure.
24. Q: What are the steps required to set up value security rules? Make sure security is enabled, define rules for the value set, and assign rules to the user's responsibility.
25. Q: What is Oracle Alert? Oracle Alert is an exception reporting system. It keeps you informed on an as-needed basis. It also communicates with other users through e-mail regarding exception messages.
26. Q: How many types of alerts are there? Two types of alerts exist: Periodic Alerts and Event Alerts. Periodic Alerts fire at a time interval, and Event Alerts are fired by database table changes.
27. Q: What are Quick Codes? Quick Codes, also known as Quickpicks, are standard sets of user-defined values. Lookup is a combination of a code and a description. The lookup tables are generally populated by the scripts located in /install/odf directory.
28. Q: What is an Open Interface in Oracle Applications? Open Interface, also known as the Application Programmer Interface (API), is a process whereby the Oracle Applications are linked with external or legacy systems. Open Interface works as a temporary staging area to load the external information into Oracle Applications tables. Once the data is validated, it sends the information to the permanent tables. Rejected transactions can be corrected and resubmitted.
29. Q: Which schema has complete access to the Oracle Applications data model? The APPS schema. AutoInstall automatically sets the FNDNAM environment variable to the name of the APPS schema.
30. Q: What is the top directory in Oracle Applications? $APPL_TOP.
31. Q: What is a product top directory? It starts with the product shortname and is suffixed with TOP, such as TOP. For example, General Ledger's top directory is GL_TOP.
32. Q: What are the log and output directory names for a product group? The product group environment file sets the APPLLOG variable to log and APPLOUT to out. For example, the output directory for General Ledger is $GL_TOP/$APPLOUT. For log, it is $GL_TOP/_$APPLLOG.
33. Q: What data dictionary tables do you use to obtain detailed information regarding? You can write a query by joining the FND_TABLE and FND__COLUMNS tables. FND_INDEXES and FND_INDEX_COLUMNS tables are part of the data dictionary. All the FND_ table names are self-explanatory.
34. Q: What are the primary underlying tables for concurrent processing? FND_CONCURRENT_PROGRAMS, FND_CONCURRENT__REQUESTS, FND_CONCURRENT_PROCESSES, and FND_CONCURRENT_QUEUES tables.
35. Q: What are the primary underlying tables for Flexfields? FND_DESCR_FLEX_CONTEXTS, FND_FLEX_VALIDATION__RULES, FND_FLEX_VALUE_SETS, FND_ID_FLEXS, FND_ID__FLEX_SEGMENTS, and FND_ID_FLEX_STRUCTURES tables.
36. Q: What is the primary underlying table for AOL QuickCodes? FND_LOOKUPS table.
37. Q: What is the application dummy table used by a form block? FND_DUAL table.
38. Q: What is the main underlying table for Profile Options? FND_PROFILE_OPTIONS table.
39. Q: What are the main prerequisites for creating a custom application or responsibility? Set up a directory structure for a custom application, and define an environment variable that translates to your application base path.
40. Q: What are the WHO columns? WHO columns are used to track the changes to your data in the application tables. WHO columns exist in all Oracle Applications standard tables. The following five are considered WHO columns:
Column Name
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
41. Q: Do I need to have WHO column information in custom forms? Yes. It is strongly recommended to add WHO columns to the custom tables and call standard API, FND_STANDARD.SET_WHO in PRE-INSERT, and PRE-UPDATE triggers in each block of the form. Also, specify these fields as hidden in each block of the form.
42. Q: What are the additional WHO columns used for concurrent programs? Concurrent programs use all the following WHO inncluding the following four.
Column Name
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
43. Q: Can you disable the WHO columns' information in a form block? Yes. You can disable HELP -> ABOUT THIS RECORD information within a block. Call the following procedures in a block level WHEN-NEW-BLOCK-INSTANCE
Trigger:app_standard.event('WHEN-NEW-BLOCK-INSTANCE');
app_standard.enable('ABOUT','PROPERTY_OFF');
44. Q: How do you register your custom tables in PL/SQL? You can use AD_DD package to register custom tables in PL/SQL.
45. Q: How do you define the passing arguments in SQL/PLUS and PL/SQL concurrent programs? You must name your passing arguments as &1, &2, &3 and so on.
46. Q: How do you call your custom reports from a form? You can call your custom Oracle reports in a form using the FND_REQUEST.SUBMIT_REQUEST procedure.
47. Q: What is a template form? A template form is a starting point for the development of custom forms. Copy the Template.fmb file from $AU_TOP/forms/US directory to your local directory and rename it.
48. Q: Which libraries are attached to the template form? The following main libraries are directly attached to the template form. APPCORE contains packages and procedures for standard menus, toolbars, and so on. APPDAYPK contains a calendar package. FNDSQF contains packages and procedures for Flexfields, concurrent processing, profiles, and a message dictionary.
49. Q: What is a calendar? A calendar is an object that lets you select the date and time. It is automatically included in the template form. A Calendar package example would be calendar.show.
50. Q: Which template form triggers require some modifications? The ACCEPT, FOLDER_RETURN_ACTION, KEY-DUPREC, KEY-MENU, KEYCLRFRM, ON-ERROR, KEY-LISTVAL, POST-FORM, PRE-FORM, QUERY_FIND, WHEN-NEW-FORM-INSTANCE, WHEN-NEW-BLOCK-INSTANCE, WHEN-NEWRECORD-INSTANCE, and WHEN-NEW-ITEM-INSTANCE triggers.
51. Q: Which template form triggers cannot be modified? The CLOSE_WINDOW, EXPORT, FOLDER_ACTION, KEY-COMMIT, KEY-EDIT, KEY-EXIT, KEY-HELP, LASTRECORD, WHEN-WINDOW-CLOSED, WHENFORM-NAVIGATE, and ZOOMtriggers.
52. Q: What are the main template files for Pro*C concurrent programs? The main template files are EXMAIN.c and EXPROG.c .
53. Q: What is the Oracle-recommended application short name for extensions? Oracle recommends an application short name begin with XX. As an example, extensions to Oracle Purchasing would be XXPO.
54. Q: Where do you maintain the list of your custom programs? All custom programs should be listed in the applcust.txt file. This file is located in the $APPL_TOP/admin directory. When you apply the patches, Oracle Applications uses this file for informational purposes.
55. Q: What are the steps involved in modifying an existing form? First, you identify the existing file and then you copy the file to a custom application directory, making sure to rename it. You then make the necessary modifications, generate the form, and document it in the custom program list using applcust.txt file.
56. Q: Where do you maintain database customizations? You can maintain all your table changes by creating a new schema. You can use your custom application short name (such as XXPO) as your Oracle schema name for easy identification. The new schema must be registered in the Oracle AOL.
57. Q: Can you create extensions to Oracle Applications without modifying the standard form code? Yes. This can be done using the CUSTOM library, which is an Oracle Forms PL/SQL library. You can integrate your custom code directly with Oracle Applications without making changes to your Oracle Applications forms code. The CUSTOM library is located in the $AU_TOP/res/plsql directory. Once you write the code, you compile and generate the CUSTOM procedures to make your changes.
58. Q: When do you use the CUSTOM library? You can use the CUSTOM library in a variety of cases. You can use it to incorporate Zoom logic, logic for generic events, logic for product-specific events, and to add entries for the special menu.
Oracle Apps Interview questions - 6
1.
What are the various types of Exceptions?
User defined and Predefined Exceptions.
2.
Can we define exceptions twice in same block?
No.
3.
What is the difference between a procedure and a function?
Functions return a single variable by value where as procedures do not return any variable by value. Rather they return multiple variables by passing variables by reference through their OUT parameter.
4.
Can you have two functions with the same name in a PL/SQL block ?
Yes.
5.
Can you have two stored functions with the same name ?
Yes.
6.
Can you call a stored function in the constraint of a table ?
No.
7.
What are the various types of parameter modes in a procedure ?
IN, OUT AND INOUT.
8.
What is Over Loading and what are its restrictions?
Over Loading means an object performing different functions depending upon the no. of parameters or the data type of the parameters passed to it.
9.
Can functions be overloaded?
Yes.
10.
Can 2 functions have same name & input parameters but differ only by return data type
Thanks and Regards. Oracle Apps R12 Training Videos at affordable cost. please check oracleappstechnical.com for details
ReplyDelete