July 27, 2013
July 7, 2013
Q. Have you heard about Zoom function in Oracle Apps Forms?
Yes. 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:
Q. What is the sequence of Trigger firing in Form?
a) Pre-Form
Q. What is the process of Form registration in Oracle Apps?
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’)
Read More
Yes. 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:
Form: FNDSCAUS, Block USER and
Form: FNDCPMCP, Block PROCESS
FUNCTION zoom_available RETURN BOOLEAN IS
form_name VARCHAR2(30)
:= NAME_IN(‘system.current_form’);
block_name
VARCHAR2(30) :=
NAME_IN(‘system.cursor_block’);
BEGIN
IF (form_name =
’FNDSCAUS’ AND block_name = ’USER’) OR
(form_name =
’FNDCPMCP’ AND block_name = ’PROCESS’)
THEN
RETURN TRUE;
ELSE
RETURN FALSE;
END IF;
END zoom_available;Q. What is the sequence of Trigger firing in Form?
a) Pre-Form
b) Pre-Block
c) Pre-Record
d) Pre-Text-Item
e) When-New-Form-Instance
f) When-New-Block-Instance
g) When-New-Record-Instance
h) When-New-Item-Instance
i) Post-Text-Item
j) Post-Record
k) Post-Block
l) Post-Form
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=<FORMNAME.fmb> userid=APPS/adm1n output_file=<FORMNAME.fmx> module_type=form batch=no compile_all=special
Q. What is the default directory of Forms in Oracle Apps?
Application top(autop)/forms/
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’)
In Brief,
We need to follow the
following steps in your form:
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
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
one used for your flex).
c) In the form-level WHEN-NEW-FORM-INSTANCE,
c) In the form-level WHEN-NEW-FORM-INSTANCE,
call
FND_DESCR_FLEX.DEFINE,
setting BLOCK
parameter to the name of the block containing your [ ] field,
the FIELD parameter
to the name of your [ ] field,
the APPL_SHORT_NAME
parameter to the short name of your application and the DESC_FLEX_NAME
parameter to the name of your descriptive flex.
In the form-level WHEN-NEW-ITEM-INSTANCE,
In the form-level WHEN-NEW-ITEM-INSTANCE,
WHEN-VALIDATE-ITEM,
PRE-INSERT,
PRE-UPDATE,
POST-QUERY and
PRE-QUERY triggers
place a call to FND_FLEX.EVENT as follows:
FND_FLEX.EVENT ( 'TRIGGER_NAME');
where TRIGGER_NAME is the name of the trigger,
e.g. in the PRE-QUERY trigger ....
FND_FLEX.EVENT('PRE-QUERY');where TRIGGER_NAME is the name of the trigger,
Q. What is the difference between Operating Unit
and Inventory Organization?
Read More
Operating Unit :- An Organization
that uses Oracle Cash management, Order
management and Shipping Execution, Oracle Payables, Oracle Purchasing, and
Oracle Receivables. It may be a sales Office, a division, or a dept. An
operating unit is associated with a legal entity. Information is secured by
operating unit for these applications. Each user sees information only for their
operating unit. To run any of these applications, you choose a responsibility
associated with an organization classified as an operating unit.
An organization for which
you track inventory transactions and balances, and/or an organization that
manufactures or distributes products. Examples, include (but are not limited
to) manufacturing plants, warehouses, distribution centers, and sales offices.
The following applications secure information by inventory organization: Oracle
inventory, Bills of Material, Engineering, and Work in Process, Master
Scheduling/MRP, Capacity, and Purchasing receiving functions. To run any of
these applications, you must choose an organization that has been classified as
an inventory organization.
Q. What is Set of Books?
A financial reporting entity that uses a particular chart of
accounts, functional currency,
And 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.
Q. What is Item Validation Organization?
The organization that
contains your master list of items. You define it by setting the OM : Item Validation Organization parameter. You must
define all items and bills in your Item Validation Organization, but you also
need to maintain your items and bills in separate organizations if you want to
ship them from other warehouses.
OE_System_Parameters à master item organization à contains the item
validation org
Q. Mention the table or views where Inventory Org,
Items, Set of Books, GL Code Combinations, Operating Unit, Location,
Customers, Vendors, and Invoices are stored in Apps.
Inventory Org: -
MTL_PARAMETERS/ORG_ORGANIZATION_DEFINITIONS
Items: - MTL_SYSTEM_ITEMS_B
Set of Books: - GL_SETS_OF_BOOKS
GL Code Combinations: -
GL_CODE_COMBINATIONS
Operating Unit: -
HR_ALL_OPERATING_UNITS
Location: - MTL_ITEM_LOCATIONS
Customers: - RA_CUSTOMERS
Vendors: - PO_VENDOR_CONTACTS
Invoices: - AP_INVOICES_ALL
Q. What is the profile to be read to find out what
Inventory Organization and Operating Unit are you on?
Help à Diagonistics à Examine à $PROFILES$(org_id is the Operating Unit)
(organization_id is the Inventory Org)
Q. What is Inventory Master Organization?
Items are defined in an
Inventory Master Organization
Labels
- inventory (26)
- order management (24)
- Oracle WMS (22)
- WMS (8)
- Oracle Apps Interview question (7)
- order to cash (7)
- Interview QA (5)
- Setup for WMS (5)
- purchasing (5)
- Functional Interview (4)
- Picking (4)
- Shipping (4)
- drop ship (4)
- item attributes (4)
- API (3)
- profile options (3)
- Customization (2)
- LPN (2)
- MSCA Page setup (2)
- 11i vs R12 (1)
Connect With Me
Popular Posts
- Order to Cash Cycle Step by step hands on
- Oracle SCM Functional Interview Questions: Inventory
- Form Personalization in Oracle Apps
- Overview of Purchasing in Oracle Apps
- Oracle Inventory: Inventory Organizations
- Oracle SCM Functional Interview Questions : Order Management
- Oracle Inventory Defining Organization
- Conversion in Oracle
- Oracle Order Management Pick Release Process
- Defining Shipping Method in Oracle