- What are the approval hierarchy
- What approval hierarchy you use in your implementation?
- How to check what is the approval hierarchy used in your system? Ans: If Use Approval Hierarchy option is enabled in the Financial Options form, it will use the position based hierarchy. If it is disabled then it will use the supervisor based hierarchy.
- How to send the PO to a person before even approval who has that approval limit not through workflow hierarchy
- Where to do the setup for specific approval limit for a person?
Oracle SCM Functional Interview Questions: Purchasing
18 MayOracle SCM Functional Interview Questions : Order Management
18 May- How can we create a normal order line and a return line in a single order
- How to change price in sales order line after booking without using any modifier. Is it possible, if Yes how?
- Advanced Pricing
- Configurator
- What is Item validation org and how it is different from Item Master Org
- Is it possible to do any transaction (receiving) transaction in Item master org?
- What steps you will do to check if picking did not happen for an order after pick release?
- What is system parameter and what is its significance?
- What all setups required for an ATO order?
- What all setups required for Back to Back order?
- In an IR, the price of the item, from where it populates?
- How can you change the price of the item in an IR?
- How invoice get generated for IR?
- What is the accounting entry happens for an IR invoice?
- What is allocation means in sales order and in which step it happens?
- What is the difference between allocation and reservation?
- If an item is not allowed to enter in any sales order form, what is the setup behind this?
- What is the difference between customer ordered and customer order enabled flag?
- What are the drop shipment setups and explain the flow?
- What are the tables involved in Drop Shipment
- What is the difference between Pick Slip and Pack Slip?
- What is Bill Of Lading?
- If I want to have single invoice generated for all the lines of a sales order even if the lines were shipped in different delivery, what can I do?
- What to do if I want to create a same delivery for all the lines of an order even if they were picked in different pick slip and delivery already created for few lines?
- Any major issue you have faced in order management during implementation from standard oracle process, not customization
Interview Q&A -5: Form Personalization & Customization
7 JulYes. It is CUSTOM.ZOOM_AVAILABLE function
Q. What is the use?
Generally the function CUSTOM.ZOOM_AVAILABLE was used for navigation from a block to another and it by default returns BOOLEAN value; False. It was used in earlier time in Oracle Apps. Now we are using Open_Form, Call_Form etc.
Ex: If Zoom is available for this block, then return TRUE; otherwise FALSE.Always test for the form and block name. Refer to the SYSTEM variables for form name and block name in your code and branch accordingly. The module name of your form must match the form file name.
By default this routine must return FALSE.
The following example enables Zooms in the following places:
END zoom_available;
Q. What is the sequence of Trigger firing in Form?
a) Pre-Form
h) When-New-Item-Instance
Q. What is the process of Form registration in Oracle Apps?
- Send the file through FTP in binary mode to …/forms/US
- Generate *.fmx by running the fmx script
- f60gen module= userid=APPS/adm1n output_file= module_type=form batch=no compile_all=special
Q. What is the default directory of Forms in Oracle Apps?
Application top(autop)/forms/US
Q. How can we disable a form from the menu?
System Administrator (Responsibility) > Security > Responsibility -> Define (at Menu) > Find Responsibility Name & The Menu attached to it > Exclusion > Exclude the Function of the Form
Q. How can you call DFF from Form?
By using a procedure called fnd_descr_flex.define
Ex: FND_DESCR_FLEX.DEFINE(BLOCK=>’ORDER_DETAIL’, FIELD=>’DESCFF’,
APPL_SHORT_NAME=>’FND’,
DESC_FLEX_NAME=>’MYDESC’)
a) Create a displayed field to hold your concatenated segment values (the [ ] field).
b) Create fields (normally hidden) for each of the flexfield columns in your table (the
c) In the form-level WHEN-NEW-FORM-INSTANCE,
In the form-level WHEN-NEW-ITEM-INSTANCE,
where TRIGGER_NAME is the name of the trigger,
e.g. in the PRE-QUERY trigger …. FND_FLEX.EVENT(‘PRE-QUERY’);
Interview Q&A -4: Basic Concepts of Organization
7 JulAnd accounting calendar. Oracle General Ledger secures transaction information (such as journal entries and balances) by set of books. When you use Oracle General Ledger, you choose a responsibility that specifies a set of books. You then see information for that set of books only.
Invoices: – AP_INVOICES_ALL
(organization_id is the Inventory Org)
Interview Q & A: FlexFields
18 Apr
Desc Flex is used to just capture extra information.
Key Flexfields have qualifiers whereas Desc Flexfields do not.
Desc Flexfields can have context sensitive segments while Key flexfields cannot.
,FIELD => ‘FORM_FIELD_NAME’
,APPL_SHORT_NAME => ‘APP_NAME’
,DESC_FLEX_NAME => ‘DFF_NAME’
);
a) Create a displayed field to hold your concatenated segment values (the [ ] field).
b) Create fields (normally hidden) for each of the flexfield columns in your table (the
c) In the form-level WHEN-NEW-FORM-INSTANCE,
In the form-level WHEN-NEW-ITEM-INSTANCE,
where TRIGGER_NAME is the name of the trigger,
What are the components of DFF (like structure, segment)?
Howmany Key flexfiels are there in Inventory?
Interview Q & A -1: FlexFields
18 Apr
Desc Flex is used to just capture extra information.
Key Flexfields have qualifiers whereas Desc Flexfields do not.
Desc Flexfields can have context sensitive segments while Key flexfields cannot.
,FIELD => ‘FORM_FIELD_NAME’
,APPL_SHORT_NAME => ‘APP_NAME’
,DESC_FLEX_NAME => ‘DFF_NAME’
);
a) Create a displayed field to hold your concatenated segment values (the [ ] field).
b) Create fields (normally hidden) for each of the flexfield columns in your table (the
c) In the form-level WHEN-NEW-FORM-INSTANCE,
In the form-level WHEN-NEW-ITEM-INSTANCE,
where TRIGGER_NAME is the name of the trigger,
What are the components of DFF (like structure, segment)?
Howmany Key flexfiels are there in Inventory?
What is Value Set?
Value Sets define and store the valid items of data, which may be entered into a field. Key Flexfields, Descriptive Flexfields and many standard fields use Value Sets. Oracle already comes with hundreds of Value Sets. We define additional Value Sets to support our own user-defined Key and Descriptive Flexfields (although we may use any existing standard Value Sets if they suit our purpose). In defining a new Value Set, we are defining the physical format of valid data, which can reside in that Value Set. Data in a Value Set can be of several types:
- Independently loaded into a Value Set (through a standard form).
- Resident in a table (to which we direct the Value Set definition).
- There could be No Validation (any data can go into the field, but still subject to the formatting rules.)
- Dependent on the value of data in a preceding Independent segment (loaded through a standard form).
Ex: For Supplies & Accessories CC in ATP, we define GEMS_GPO_ASSIGN_SET value set for the assignment set associated with that OU.