FORM BUILDER (CUSTOMIZATION and PERSONALIZATION)

ORACLE Form Builder

GO_BLOCK and WHEN-VALIDATE Trigger

Send Email via Form Developer

Data Loading CSV/Excel

WHO columns 


FND_STANDARD.SET_WHO API 

PERSONALIZATION


Forms Personalization in Oracle Apps Overview - Part 1
Forms personalization - to press a button
Form Personalization, Call a Function, And Return Value To Screen?


='BEGIN
xx_p_pa_update_tasks('''||${item.TASKS.PROJECT_ID.value}||''','''||${item.TASKS.TASK_ID.value}||''','''||${item.TASKS.BILLABLE_FLAG.value}||''');
END'
-------
Forms Personalization: Builtin Type Execute a Procedure
='declare
v_field_value VARCHAR2(200);
begin
xxifs_bsa_tcv.set_hdr_price_mod ifier('''||${item.BLANKET_HEADER.NEW_PRICE_LIST_ID.valu e}||''','''||${item.BLANKET_HEADER.NEW_MODIFIER_LIS T_ID.value}||''','''||${item.BLANKET_HEADER.START_DATE _ACTIVE.value}||''','''||${item.BLANKET_HEADER.END_DATE_A CTIVE.value}||''' );
end'

Disabled/Validation the DFF Attributes

Call Report from Personalization

Call another Form from Standard Form

Execute a Procedure (Run the Concurrent Request)

='DECLARE
l_request_id NUMBER;
v_layout BOOLEAN;
BEGIN
 v_layout := FND_REQUEST.ADD_LAYOUT(''SQLAP''
                                      ,''BEIN_AP_INV_PRINT_XML''
                                      ,''en''
                                      ,''US''
                                      ,''PDF'');
l_request_id := FND_REQUEST.SUBMIT_REQUEST(''SQLAP'',''BEIN_AP_INV_PRINT_XML'',
argument1=> '''||${item.INV_SUM_FOLDER.ORG_ID.value}||''',
argument2=>'''||${item.INV_SUM_FOLDER.VENDOR_ID.value}||''',
argument3=>'''||${item.INV_SUM_FOLDER.INVOICE_TYPE_LOOKUP_CODE.value}||''',
argument4=>'''||${item.INV_SUM_FOLDER.INVOICE_ID.value}||''',
argument5=>'''||${ps.username.value}||'''
                                           );
COMMIT;
FND_FILE.PUT_LINE(FND_FILE.LOG,''Please see the Request :'' || ''-''||  l_request_id);
END'
  

CUSTOMIZATION

COMPILE FORM ON UNIX (10G)

How to compile Oracle forms 10g and create output file on corresponding Top in Linux?
How to compile forms in R12

we have to use frmcmp(Form Compiler) for compiling forms and libraries in Oracle Applications Version R12, But in 11i we need to use f60gen to compile forms and libraries which is deprecated in R12.
1) Login to application server.
2) Go to the directory $AU_TOP/forms/US
3) Place “.fmb” file in binary mode
4) Execute the below command to generate “.fmx”.
frmcmp_batch userid=apps/<apps_paswd> module=<Form_Name>.fmb output_file=<Form_Name>.fmx module_type=form batch=no compile_all=special
EXAMPLE:
frmcmp_batch userid=apps/apps module=RCVRCERC.fmb output_file=$AU_TOP/forms/US/RCVRCERC.fmx module_type=form batch=no compile_all=special

FLEXFIELD in FORM ITEMS

 

Descriptive Flex Field

 

QUERY FIND in TEMPLATE.fmb


Call Function (jsp) from FORM PERSONLIZATION

How to call OAF standard page from form by passing parameters?

Call Concurrent Program from Database
Submit concurrent program FND_REQUEST.SUBMIT_REQUEST along with XML Publisher layout and printer options
FND_REQUEST.SUBMIT_REQUEST:

Launch the Concurrent Program in Personalization

Run Concurrent Program from Form: Launch SRS Built In
Personalization - run a request from menu
Launching a Concurrent with Form Personalization on EBS 11i

Enable Debug in E Business Forms

How To Collect And Use Forms Trace (FRD) in Oracle Applications Release 12 (Doc ID 373548.1)

Create block with FROM Clause Query

No comments:

Post a Comment