Here are some Basic Oracle Apps Interview Questions & Oracle Apps Practice Tests Basics:
Explain the points of difference between organisation_id and org_id.
What do you understand by one full life cycle implementation.
Describe the various steps of form customization.
Method of implementation of Flex fields in forms.
Explain the set ups needed for approval of AP invoice. How do we build an approval hierarchy for it?
What do you understand by Invoice accounting?
What do you call the TDS entry which is not built in service bills?
Where is the information about receipts stored?
Describe the various profile options available to you. What options do you have in AR/AP?
Name the various templates used in oracle reports for applications.
Describe the use of _ALL tables in oracle apps.
What do you mean by APIs. Give examples of some APIs.
Which triggers and user exits are there in Flexfields?
Describe the invoicing rule.
Explain the whole process cycle for OE/AR.
Explain the various steps involved in set up for Credit card transactions.
Explain the points of difference between data migration and data conversion.
What do you undestand by flex field? Why and how do we use these?
Why are Temp tables required in interface programs?
Why do we need cursors in PL/SQL?
Define the REF Cursor.
Method of attaching reports in oracle apps
Debugging the form.
What do you know about auto reduction?
Explain the various context sensitive segments.
What do you understand by global segments?
Reason for using FND Currency in reports.
Where does the form go when we register?
Explain the key and descriptive flexfield.
Method of passing parameters to a report. Is it necessary to register with AOL?
Describe the segment qualifier.
Method to register reports.
More Oracle Apps Basic Interview Questions:
Where is the host source code kept?
How do you display the message to test a modified form?
Explain balancing segment.
What do you understand by cost center segment?
Is it possible to have 2 accounting flexfields in AR?
Explain the process of customer merging.
What do you mean by auto invoice in OM Module? Why do we need auto invoice?
Explain the points of difference between Organization_id and org_id
What do we store in RA_CUSTOMER_TRX?
Explain chargebacks.
What do you mean by lockbox
Describe the profile options. Explain different profile options available in AR / AP.
Explain the record group.
What do you mean by validation of address?
Explain the meaning of “finance charge”
What is the relation between AR and OE?
What do you mean by concurrent program?
What is the relation between CM and invoice?
Method to determine overdue invoices.
Explain the accounting rules used.
Name the various flexfields used in AR.
Describe the dunning letter.
Explain pick release.
Explain the whole order cycle.
After which stage, are you unable to cancel an order?
List various tables in OE / AR.
More Oracle Apps Technical Interview Questions For Database Administrator Job Tests & Placement Papers.
Practice Tests for Oracle Apps Exams:
Explain the method to manage various rows without loops in PL/SQL?
Describe cycles in AP, GL and AR.
What do you know about Data Migration and conversion?
Explain the difference between data migration and conversion.
What do you know about Summary accounts and rollup groups.
Which is the first trigger when form builder opens up?
How do we manage null values in SQL Loader?
Explain the points of difference between Interfaces and conversions.
Method to set up multi org.
Explain the points of difference between security rules and cross validation rules.
Name the module which is not considered a multiorg.
What do you understand by User Exits. Various kinds of User Exits used in Oracle Apps.
How many tables are required in valueset if it is of type ?TABLE
Benefit of bitmap and char mode in system paramters in oracle reports.
Explain the method to build strucute2 in KFF. Assume that Strucutre1 has already been used. IS it possible to use the same KFF Code number in case of Structure2?
Explain the points of difference between Quick Pick and Quick Codes.
How are OM and AR related by Column?
How are AR and GL linked by Column?
Method to stop access to a user group using personalization.
Explain the emthod of enabling trace or debug in apps.
What do you mean by Date Tracked Option?
Explain the points of difference between APIs and DataPumps.
What do you mean by User hooks?
How do you implement if an entity has different operating systems.
How can you use personalization to get ZOOM funcitonality?
How do we know about the requisition used to make a PO?
Submission of concurrent program via pl/sql.
How do we use the user_exits FND FLEXSQL FND FLEXIDVAL in reports having display/query flex fields.
Various value sets available to us.
How do we determine which value set to use?
What do you know about request sets? How do we build one?
What do you mean by RFQ report from PO?
Various concurrent managers used.
How can we have a lexical parameter in a report to have ‘From’ and ‘To’ Date parameters? Various steps to do so.
How to build custom program for chargeback?
How do various modules integrate with each other?
What do you understand by an invoice? Various invoice types in AP and AR.
How many types of Journal entries are there?
Explain the benefit of Custom Library in Oracle Apps.
How will you locate Template.FMB file?
Describe the multiple organization technical architecture.
What do you understand by User Exits?
Method of registration of tables and columns in AOL.
What do you understand by Set of Books?
Various conditions needed to change your SOBs.
Various types of periods.
Name the various libraries with Template form.
Various steps involved in customer interface. How do we handle errors here?
How do we call APPCORE library in Custom library?
What is the need of REF cursors in custom library?
Various flexfields used in AR.
what is the use of MRC?
What is the number of possible reporting currencies in primary set of books?
Various features introduced in Release 11i?
What do you know about ad-hoc reports?
What do you mean by FSG?
Various types of transactions taking place in AR.
What do you mean by Value sets?
What is HZ_ in customer tables?
Various files used in SQL Loader.
How do you go to a journal in GL?
Explain the ICA. Full form – Internet Computing Architecture.
Is it possible to add a descriptive flexfield to a table having data?
Various steps involved in AP Setup.
Explain recurring invoices.
Various testing setup steps.
Various differences between discounts and adjustments.
List various types of Journal Entries.
See more of Oracle Interview Questions and Our Technical Interviews Section, Oracle Interviews and Oracle Placement Test Papers.