Oracle Apps Interview Questions

1.      What is SET-OF-BOOKS OR Ledgers?

Collection of Chat of Accounts and Currency and Calendars, Convention is called SOB

2.      How can u call a standard interface program from sql or pl/sql code

FND_REQUEST .SUBMIT_REQUEST (PO,EXECUTABLE NAME ,,,,PARAMETERS)

3.      API0s FOR CUSTOMER INTERFACE

HZ_CUST_A/C_VZPUB .UPDATE_CUST_A/C HZ_CUST_A/C_VZPUB .CREATE_CUST_A/C FND_PROFILES

FND_APPLICATIONS FND_GLOBAL

FND-FILE

FND_CONCSUB (can submit cone program in host environment)

4.      Mandatory for pl/sql type concurrent program

Procedure/function (ERRBUF OUT RETCODE OUT 0000000.)

ERRBUF: - Used to write the error message to log or request file.

RETCODE    Populate log request file with program submission details info.

5.      What is Value Set

·   The value set is a collection (or) container of values.

·   Whenever the value set associated with any report parameters. It provides

·   List of values to the end user to accept one of the values as report parameter value.

·   If the list of values needed to be dynamic and ever changing and define a tab le based values set.

6.      What r the validation types

a.   None -------- validation is minimal.

b.   Independent ------input must exist on previously defined list of values

c.    Dependent ------input is checked against a subset of values based on a prior value.

d.   Table ----- input is checked against values in an application table

e.   Special ------values set uses a flex field itself.

f.     Pair ------ two flex fields together specify a range of valid values.

g.   Translatable independent ----- input must exist on previously defined list of values; Translated values can be used.

h.   Translatable dependent ------- input is checked against a subset of values based on a prior values; translated value can be used.

7.      What is template

a)      The TEMP LATE form is the required starting point for all development of New Forms.

b)      The TEMP LATE form includes platform independent attachments of several Libraries s.

APPSCORE: - It contains package and procedures that are required of all forms to support the MENUS, TOOLBARS.

APPSDAYPK: It contains packages that control the oracle applications CALENDER FEATURES.

FNDSQF: It contains packages and procedures for MESSAGE DICTONARY, FLEX FIELDS, PROFILES AND CONCURRENT PROCESS ING.

CUSTOM: It allows extension of oracle applicant ions forms without modification of oracle application code, you can use the custom library for customization Such as zoom (such as moving to another form and querying up specific records)

8.      What are ad-hoc reports

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

9.      What is responsibility

Is collection of menus, request security groups and data groups Menus: collection of forms is nothing but menus?

Request security groups: collection of programs.

Data groups: is a group of modules to be made accessible by the user through Responsibility System Admin.

10.  What are different execute ion methods of executable

The execution file is written using the Flex Report API.
FlexSql The execution file is written using the FlexSql API.
Host The execution file is a host script.

Oracle Reports the execution file is an Oracle Reports file.
PL/SQL Stored Procedure The execution file is a stored procedure.
SQL Loader The execution file is a SQL script.

SQL Plus The execution file is a SQL Plus script.

SQL Report The execution file is a SQL Report script.
Spawned the execution file is a C or Pro C program.

Immediate the execution file is a program written to run as a subroutine of the concurrent manager. We recommend against defining new immediate concurrent programs, and suggest you use either a PL/SQL Stored Procedure or a Spawned C Program instead.

Composite Data types

PL/SQL TABLES
PL/SQL RECORDS
Nested TABLE
VARRAY

11.  What is the sequence of functions D  group by , having , order by in a select statements

Select. Group by, Having, 0rder by

12.  Difference between User and Super User

User: login user or front end user

Super User: It has full access of particular module

13.  Oracle E-Business suite

Oracle apps analytical components software.

(Oracle discover) (Oracle sales analyzer) (Oracle financial analyzer) (Oracle

Marketing analyzer)

14.  What is multi org?

Legal entity has more than one operating unit is called as multi org

a)      Business group --- Human resources information is secured by Business group

b)      Legal entity. --- Inter-company and fiscal/tax reporting Operating unit.

15.  Function FND_REQUEST.SUBMIT_REQUEST

(application in varchar2 default null , program in varchar2 default null, description in varchar2 default null, start-time in varchar2 default null, sub request in book an default False, argument1, arguemnt2, Argument 100) return number;

If this is submitted from oracle forms, all the arguments (1 to 100) must be specified.

16.  How to submit concurrent programs through OS

·   From the operating system the utility .CONCSUB is used to submit is concurrent program.

·   This is basically used to test a concurrent program.

·   By using the WAIT token. The utility checks the request status every 60 second s and returns the OS prompt upon completion of the request.

·   Concurrent manager does not abort, shutdown or start up until the concurrent re quest completes.

If the concurrent program is compatible with itself, it can be checked for data integrity and dead locks by submitting it many times so that it runs Concurrently with itself.

PL/SQL procedures can submit a request to run a program as a concurrent process by calling.

FND_REQUEST. SUBMIT_REQUEST.

Before submitting a request, the following functions also should be called optionally.

FND_REQUEST .SET_OPTIONS FND_REQUEST .SET_REPEAT_OPTIONS FND_REQUEST .SET_PRINT_OPT IONS FND_REQUEST .SET_MODE

17.  How to checks the request states

·   A PL/SQL procedure can check the status of a concurrent request by calling.

·   FND_CONCURENT .GET_REQUEST_STATUS

·   FND_CONCURRENT .WAIT_FOR_REQUEST

·   FND_CONCURREN T.GET_REQUEST_STATUS

·   This function returns the status of a concurrent request

·   If the request is already computed, it also returns the completion message.

·   This function returns both user friendly (translatable) phase and status value s as well as developer phase and status vales that can drive program logic.

( request_id in outnumber , application in varchar2 default null, program in varchar2 default null, phase out varchar2 ,status out varchar2 , dev_phase out varchar2 , dev_status out varchar2, message out varchar2) return BOOLEAN ;

·   When application and program are specified, the request_id of the last request for the specified program should be returned to request_id.

·   Phase, and status values should be taken from FND_LOOKUPS

dev_phase dev_status

Pending normal, standby, scheduled, paused running normal, waiting, resuming, terminating

Complete normal, Error, warning, cancelled, terminated Inactive disabled, on-hold, No-manager, suspended

·   FND_REQUEST .WAIT_FOR_REQUEST

·   This function waits for request completion, then returns the request phase/status and completion message to the caller.

·   Goes to sleep between checks for request completion.

Syntax

( request_id in number default null, interval in number default 60, max_wait in numbe default 0, 14

Phase out varchar2, status out varchar2, dev_phase out varchar2, dev_status out varchar2,

Message out varchar2) return BOOLEN; FND_CONCURRENT .SET_COMPLETION_STATUS

·   This function should be called from a concurrent program to set its completion states.

·   This function returns TRUE on success, otherwise FALSE.

ENT .SET_COMPLET ION_STATUS

(status in varchar2 ,

Message in varchar2) return BOOLEAN; normal

Status warning Error

18.  What is the reason for not getting any data when a multi org view is quired

·   To get the data correctly, the xxx-ALL must be referenced and the ORG_ID value should be specified to extract portioned data

·   Multi_org views are part intoned by using ORG_ID

·   So access through multiorg views will not return any roes, as the CLIENT_INFO Value is not set

·   Use HR_OPERATING UNITS to identify the organization _id of the OU on which query is based.

·   Use FND_CLIENT_INFO package to set the value in CLIENT INPO using set_org_contest .

·   Execute fnd_client_info . Set_org_context (0<org_id>?);

·   Now qurying of mult iorg views can be done.

19.  How do you find that multi_org is installed?

·   Multi organization architecture is meant to allow multiple companies or subsidiaries to store their records with in a single data base.

·   Multiple organization Architecture allows this by partitioning data through Views in APPS schema.

·   Implementation of Multi org generally includes more than one business group.

To know whether multiorg is existing or not

Select multi_org_flag

  Form fnd_product_groups

·   If the result is DY? Means the database is group for multiorg

20.  What are Handlers?

·   Handler is a group of packaged procedures which is used by Oracle Applications to organize. PL/SQL code in forms.

·   Handlers provide a way to centralize the code so that it becomes easier to

Develop, maintain and debug.

·   The packaged procedures available le in a handler are called form the triggers by

Oracle Order Management Interview Questions

1.       What is a Standard Item?
A standard item is a finished good that is not an assembled or configured item, a service or a component.

2.       What happens when you enter an Order?
After you enter an order, the items on the order are validated in Oracle Inventory; a price is calculated for the items using the pricing engine; the availability of the items are checked and may be reserved; the items are then pick released and shipped to the customer.

3.       Explain about Processing Constraints
Processing Constraints are a security framework where you can define rules in Oracle Order Management that validate back-end operations such as Create, Update, Delete and Cancel.
Examples:
You cannot change the Order Type in the order header once the order is Booked.
You cannot delete the line in an order once the Order Status is Closed (if the order is ship confirmed or invoice interfaced).

4.       What are Defaulting Rules?
Defaulting Rules enable you to speed up data entry by passing values in the window based on some key values you have entered.
Examples:
In the order header, Ship-To Address and Bill-To Address values default in the window once you enter the customer name or number.
If you enter an item number, the Unit of Measure and Item Description automatically default on the order line.

5.       How Drop Ship Order is created?
Drop shipments are created as sales orders in Order Management, indicated as drop shipments when their Source Type is entered as External.

6.       When will you create a Drop Ship Order?
Drop shipments are used due to the following reasons:

·         Customer requires an item that is not normally stocked

·         Customer requires a large quantity of the item which is not available with you

·         It is more economical when the supplier ships directly to the customer.

7.       What are the types of Drop Ship Order?

There are three types of drop shipments:

·   Full Drop Shipment:

The seller sends the purchase order to the supplier for the full quantity that the customer had ordered

·   Normal Shipments and Full Drop Shipment:

The seller ships some goods from inventory to the customer, and the other goods are always shipped from an external source (supplier)

·   Normal Shipments and Partial Drop Shipment:

o If the seller has only part of the quantity available for shipping to the customer, then that quantity is shipped.

o The user looks at the availability for the order qty by using the ATP check and if the whole qty is not available the balance qty is fulfilled using the drop ship process.

o A purchase order is created for the remaining quantity which the seller was not able to fulfill.

8.       What is a Sales Agreement?
A Sales Agreement is a supplier’s representation of an agreement with a customer for the supplier to sell and the customer to buy goods or services.

9.       What is ASN?
ASN stands for Advanced Shipment Notice. ASN is transmitted via Electronic Data Interchange (EDI) from a supplier to let the receiving organization know that a shipment is coming. The ASN contains details including shipment date, time, and identification number, packing slip data, freight information, and item detail including cumulative received quantities, purchase order number, and returnable container information.

10.   What are Modifiers and Qualifiers?
Modifiers are discount, surcharge or special charge that may be applied to the base price and may alter the value of the item. It can be applied either at order level or at the line level.
A qualifier helps you define who is eligible for a price list or modifier. A qualifier can be a customer name, a customer class, an order type, or an order amount that can span orders.

11.   Explain One Step Pick Release Process:
The one-step process consists of selecting the Auto Allocate box on the Inventory tab and the Auto Pick Confirm box on the Inventory tab when you run Pick Release, which means that the Pick Recommendation is automatically created and Pick Confirmed without any manual intervention.

12.   Explain Two Step Pick Release Process:
The two-step process consists of selecting Auto Allocate (not Auto Pick Confirm), which creates a move order that is automatically detailed.  It enables you to view the Pick Recommendation and provides the opportunity to change quantity, location, and sub-inventory. You can report a missing quantity at the Pick Confirmation step in the Transact Move Orders window. Once you have made your changes, you can transact the move order to Pick Confirm the inventory.

13.   Explain Three Step Pick Release Process:
The three-step process consists of selecting neither the Auto Allocate or Auto Pick Confirm check boxes. This creates a move order whose details you can enter manually or automatically in the Transact Move Orders window. After the details are entered, you can transact the move order to pick confirm the transaction.

14.   What are various ways you can run Pick Release?

·         Release Sales Orders Window

·         Using a Concurrent Program

·         SRS – Pick Selection List Generation – SRS.

·         Release Rule Name need to be specified to proceed with the pick release when using the concurrent program or SRS.

15.   At which stage the item is moved from ware house to staging inventory?
During Pick Confirm

16.   What happens during Ship Confirm?
Ship Confirm indicate that the items are loaded onto the carrier from staging location.
At which stage the Oracle Inventory is decremented and Sales Order Line status is updated?
During Ship Confirm

17.   What is Autoinvoice?
AutoInvoice is a concurrent program in Oracle Receivables that performs invoice processing at both the order and line levels. Once an order or line or set of lines is eligible for invoicing, the Invoice Interface workflow activity interfaces the data to Receivables. Oracle Order Management inserts records into the following interface tables: RA_INTERFACE_LINES and RA_INTERFACE_SALES_CREDITS.

18.   If the order or lines are On Hold, what happens during Invoice Interface?
The Invoice Interface workflow activity will complete with a status of On Hold and the order details will not be interfaced to Receivables.

19.   What is Credit Check?
Credit Checking feature is the process by which orders are validated and released against your credit checking business rules.

20.   What are the two Invoicing Rules?
Advance Invoice and Arrears Invoice

21.   How many types of Purchase Order are there?

·         Standard Sales Orders.

·         RMA sales Order.

·         Back to Back Sales Orders.

·         Drop Ship.

22.    What happens when you enter an Order?
After you enter an order, the items on the order are validated in Oracle Inventory; a price is calculated for the items using the pricing engine; the availability of the items are checked and may be reserved; the items are then pick released and shipped to the customer

23.   Explain about Processing Constraints
Processing Constraints are a security framework where you can define rules in Oracle Order Management that validate back-end operations such as Create, Update, Delete and Cancel.
Examples:
You cannot change the Order Type in the order header once the order is Booked.
You cannot delete the line in an order once the Order Status is Closed (if the order is ship confirmed or invoice interfaced).

24.    What are Defaulting Rules?
Defaulting Rules enable you to speed up data entry by passing values in the window based on some key values you have entered.
Examples:
In the order header, Ship-To Address and Bill-To Address values default in the window once you enter the customer name or number.
If you enter an item number, the Unit of Measure and Item Description automatically default on the order line.

25.   When will you create a Drop Ship Order?
Drop shipments are used due to the following reasons:

·         Customer requires an item that is not normally stocked

·         Customer requires a large quantity of the item which is not available with you

·         It is more economical when the supplier ships directly to the customer

26.   What are Modifiers and Qualifiers?
Modifiers are discount, surcharge or special charge that may be applied to the base price and may alter the value of the item. It can be applied either at order level or at the line level.
A qualifier helps you define who is eligible for a price list or modifier. A qualifier can be a customer name, a customer class, an order type, or an order amount that can span orders.

27.   At which stage the item is moved from ware house to staging inventory?
During Pick Confirm

28.   What happens during Ship Confirm?
Ship Confirm indicate that the items are loaded onto the carrier from staging location.

29.   What is Auto invoice?
Auto Invoice is a concurrent program in Oracle Receivables that performs invoice processing at both the order and line levels. Once an order or line or set of lines is eligible for invoicing, the Invoice Interface workflow activity interfaces the data to Receivables. Oracle Order Management inserts records into the following interface tables: RA_INTERFACE_LINES and RA_INTERFACE_SALES_CREDITS.

30.   If the order or lines are On Hold, what happens during Invoice Interface?
The Invoice Interface workflow activity will complete with a status of On Hold and the order details will not be interfaced to Receivables.

31.   What are the Inventory Set ups required for Back to Back Order Processing?
Order Management Tab: Customer Orderable, Assemble to Order (ATO), Purchasing Tab: Purchasable, WIP Tab: Build in WIP, General Planning Tab: Buy

32.   What is a Pick Release?
Pick Release finds and releases eligible delivery lines that meet the release criteria, and creates move orders. You can pick release by order, trip, stop, container, delivery, warehouse, and customer, scheduled or requested dates, shipment priority, or combinations of the above criteria.

33.   What is a Pick Slip?
The Pick Slip Report prints all picking line details in a picking batch. This report is used by warehouse personnel to collect all items included in shipments.

34.   What is Ship Confirming?
Ship Confirming the item removes the existing reservations and performs the sales order issue transaction

35.   What is a trip?
A trip is an instance of a specific freight carrier departing from a particular location containing deliveries. A trip is a carrier specific and contains at least two stops, such as a stop to pick up goods and another stop to drop off goods and may include intermediate stops

36.   What is Bill of Lading?
The Bill of Lading prints all sales orders that have been confirmed from a selected delivery. This document lists the ship date, carrier, bill of lading number, delivery name, shipper, ship-to address, carrier name, waybill number, quantity and description of unpacked items, quantity and total of items packed in containers, total quantity of items, and weight/volume information defined in shipping. Any hipping notes you may have created are also printed.

37.   What are the possible reasons for Interface trip stop to complete with Error?
Few reasons may be Order is on Hold, Tax is not applied properly, On-Hand qty is not available in the Inventory, Inventory Period is not open,  Make sure Schedule Ship Date or Requested Date is within the range of order Date.

38.   Explain Internal Sales Order
Internal Sales Orders are used to transfer material from one inventory organization to other inventory or warehouse organization with the same company.
Flow of Internal Sales Order
Internal requisition in PO/INV à Requisition Approval à Run Create Internal Sales Order Concurrent Program à Run Order Import Concurrent Program in OM à Pick Item in INV thru OM à Ship Confirm à Receive Internal Order in INV / PO
Select Order Source as Internal while importing Orders. Shipping Network (Intransit or Direct) to be defined between two organizations (Source and Destination). Destination (requesting) Organization should be defined as Internal Customer with a Ship to address in Order Management. An Internal Sales Order does not generate Accounts Receivable Invoice

39.   When scheduling, the line got error "ATP Error Scheduling failed". How will you resolve?
This error may be due to Item setup in Inventory & Order Transaction Type Setup Order management. Ensure the Below Setups

·         Inventory à Items à Organization Items à Order Management à Check ATP should be none.

·         Order Management à Setup à Transaction Types à Define. In 'Shipping' sub-tab uncheck 'Auto Schedule' check box.

·         Profile Option 'OM: Auto Schedule' should be 'No'.

40.   What is ASN?
ASN stands for Advanced Shipment Notice. ASN is transmitted via Electronic Data Interchange (EDI) from a supplier to let the receiving organization know that a shipment is coming. The ASN contains details including shipment date, time, and identification number, packing slip data, freight information, and item detail including cumulative received quantities, purchase order number, and returnable container information.

SQL Query for Oracle R12 Supplier Headers, Sites and Contacts

  SELECT DISTINCT
         asp.vendor_id,
         asp.segment1 "Supplier Num",
         ASp.vendor_name "Supplier Name",
         ass.vendor_site_code "SITE NAME",
         hou.NAME "Operating Unit Name",
         ass.address_line1,
         ass.city,
         ass.state,
         ass.zip,
         ass.country,
         ass.phone,
         person.person_first_name,
         person.person_last_name,
         pty_rel.primary_phone_number,
         (SELECT HCP5.PHONE_AREA_CODE
            FROM HZ_CONTACT_POINTS HCP5
           WHERE     HCP5.OWNER_TABLE_NAME = 'HZ_PARTIES'
                 AND APSC.REL_PARTY_ID = HCP5.OWNER_TABLE_ID
                 AND HCP5.CONTACT_POINT_TYPE = 'PHONE'
                 AND HCP5.PHONE_LINE_TYPE = 'FAX'
                 AND HCP5.PRIMARY_FLAG = 'N'
                 AND ROWNUM < 2)
            FAX_AREA_CODE,
         (SELECT HCP6.PHONE_NUMBER
            FROM HZ_CONTACT_POINTS HCP6
           WHERE     HCP6.OWNER_TABLE_NAME = 'HZ_PARTIES'
                 AND APSC.REL_PARTY_ID = HCP6.OWNER_TABLE_ID
                 AND HCP6.CONTACT_POINT_TYPE = 'PHONE'
                 AND HCP6.PHONE_LINE_TYPE = 'FAX'
                 AND HCP6.PRIMARY_FLAG = 'N'
                 AND ROWNUM < 2)
            FAX,
         pty_rel.EMAIL_ADDRESS
    FROM ap_suppliers asp,
         ap_supplier_sites_all ass,
         ap_supplier_contacts apsc,
         hz_parties person,
         hz_parties pty_rel,
         hr_operating_units hou
   WHERE     1 = 1
         AND ass.vendor_id = asp.vendor_id
         AND apsc.per_party_id = person.party_id
         AND apsc.rel_party_id = pty_rel.party_id
         AND ass.org_id = hou.organization_id
         AND apsc.ORG_PARTY_SITE_ID = ASS.PARTY_SITE_ID
ORDER BY hou.NAME