How to change Oracle forms and reports standalone configuration for custom directory???

Recently i encountered one issue to configure Oracle Forms and Reports Standalone to point to custom directory.

Below is the solution for that

Got to httpd.conf file which is located in ORACLE_HOME/Apache/Apache/conf directory.

Before changing anything in httpd.conf, take backup of httpd.conf.

Change DocumentRoot value to your directory as shown below

DocumentRoot "your custom directory"

Hope this helps!!!

Code for calling oracle report and oracle form in oracle apps

The below is the code to call oracle report from oracle form in oracle apps.

DECLARE
v_order_imp_id number;
v_admno VARCHAR2(20);
begin
v_admno := :STD_PER_INFO_50448.ADMNO;
v_order_imp_id:= fnd_request.submit_request ('CUSTOM','EMP98','hi', NULL, FALSE,
v_admno,'','','','','','','','','','','','','','','','','','','',
'','','','','','','','','','','','','','','','','','','','',
'','','','','','','','','','','','','','','','','','','','',
'','','','','','','','','','','','','','','','','','','','',
'','','','','','','','','','','','','','','','','','','','');
COMMIT;
MESSAGE ('Your Request Id is'v_order_imp_id);
MESSAGE ('Your Request Id is'v_order_imp_id);
END;

The below is the code to call oracle form from oracle form in oracle apps.

FND_FUNCTION.execute(‘Function Name you want to call and function should exist in your menu’);