How to invoke another form in oracle apps form?

In Oracle Applications, we can use FND_FUNCTION.EXECUTE instead of CALL_FORM / OPEN_FORM

Syntax

FND_FUNCTION.EXECUTE
                    (function_name  IN varchar2,
                     open_flag      IN varchar2 default ’Y’,
                     session_flag   IN varchar2 default ’SESSION’,
                     other_params   IN varchar2 default NULL,
                     activate       IN varchar2 default ’ACTIVATE’,
                     browser_target IN varchar2 default NULL);



Description

Execute the specified form function; only executes functions that have a form attached.

Arguments

 
Example
 

How do use the same LOV for 2 form fields?

We can achieve by passing the return values in global values / parameters and using the values in the code.

in another way ... we can create the diff LOV with the same Record groups

How to submit the concurrent request from shell scripts?

CONCSUB utility used for submit the concurrent request from shell scripts. CONCSUB are described in the "System Administration User Guide" as follow:

$ CONCSUB {APPS username}/{APPS password} \
{responsibility application short name} \
{responsibility name} \
{username} \
[WAIT=N|Y{n seconds}] \
CONCURRENT \
{program application short name} \
{program name} \
[PROGRAM_NAME={description}] \
[REPEAT_TIME={resubmission time}] \
[REPEAT_INTERVAL= {number}] \
[REPEAT_INTERVAL_UNIT={resubmission unit}] \
[REPEAT_INTERVAL_TYPE={resubmission type}] \
[REPEAT_END={resubmission end date and time}] \
[START={date}] \
[IMPLICIT={ type of concurrent request} \
[{parameter 1} ... {parameter n}]

For parameters that follow the CONCURRENT parameter and include spaces, enclose the parameter argument in double quotes, then again in single quotes.

-------------------------------------------
More details @ Meta link ID 457519.1

Setting Organization Context in Oracle R12 and 11i

Release 12

BEGIN
apps.mo_global.set_policy_context ('S', org_id_value);
END;

11i Releases

BEGIN
DBMS_APPLICATION_INFO.set_client_info (client_info => 'org_id_value');
END;
--------------- or----------
BEGIN
fnd_global.initialize (NAME => 'ORG_ID', VALUE => 'org_id_value');
END;

Meaning of table's suffix

Standard Sales Order (Data Flow)

Steps
1. Order Entry
2. Order Booking
3. Pick Release
4. Ship Confim
5. Invoice Entry
6. Transfer 2 GL

Steps in Detail
1. Order Entry

(for an example I am creating dummy item & increasing on hand quantities)
Item Creation
Navigation: Inventory, Vision Operations (USA) - Items >> Master Items

Navigation: Inventory, Vision Operations (USA) - Items >> Master Items : Organization Assignment

For on hand quantity, to receive the item by miscellaneous transaction

Navigation: Order Management Super User, Vision Operations (USA) - Inventory >> Transaction : Miscellaneous Transaction

Transaction Lines

On hand Quantity verification

Navigation: Inventory, Vision Operations (USA) - On-hand, Availability : On-hand Quantity

Navigation: Order Management Super User, Vision Operations (USA) - Order, Returns : Sales Orders

Line Items

2. Order Booking

3. Pick Release

Navigation: Order Management Super User, Vision Operations (USA) - Shipping - Release Sales Orders >> Release Sales Orders (Order Number - 56733)

Execute Now

Navigation: Order Management Super User, Vision Operations (USA) - Shipping - Release Sales Orders >> Transactions

Delivery Tab

4. Ship Confim

Delivery Confirmed

Run the "Workflow Background Process" Concurrent Program

5. Invoice

Navigation: Receivables, Vision Operations (USA) - Transactions >> Transactions
In Query Mode (Reference - Sales Order Number - 56733)

Distributions

Navigation: Receivables, Vision Operations (USA) - Receipts >> Receipts

Apply & Save

6. Transfer 2 GL

Navigation: Receivables, Vision Operations (USA) - Interfaces >> General Ledger