How to change the order/arrangement of multi records block?

Normally, multi records are displaying in vertical navigation style. (Like from Left to Right)

How to change the arrangement into horizontal (like Top to bottom)?

Set the BLOCK level properties “RECORD ORIENTATION -> HORIZONTAL”

(example)

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