How to Optimize Execution time to create Standard PO Fr0m interface Table
Hi EveryOne,
I have created a procedure to create Standard PO from interface Table .I am running import Standard Purchase Orders API Concurrent Program.But it is taking time around 17 Seconds.
How Much this Program Should take time .I have assign priority High to this request.
Code to Run program is
v_request_id :=
apps.fnd_request.submit_request (application => 'PO', --Application,
program => 'POXPOPDOI', --Program,
argument1 => p_agent_id, --Buyer ID,
argument2 => 'STANDARD', --Document Type,
argument3 => '', --Document Subtype,
argument4 => 'N', --Process Items Flag,
argument5 => 'N', --Create Sourcing rule,
argument6 => 'APPROVED', --Approval Status,
argument7 => '', --Release Generation Method,
argument8 => po_headers_interface_s.CURRVAL, --NULL,
I have created a procedure to create Standard PO from interface Table .I am running import Standard Purchase Orders API Concurrent Program.But it is taking time around 17 Seconds.
How Much this Program Should take time .I have assign priority High to this request.
Code to Run program is
v_request_id :=
apps.fnd_request.submit_request (application => 'PO', --Application,
program => 'POXPOPDOI', --Program,
argument1 => p_agent_id, --Buyer ID,
argument2 => 'STANDARD', --Document Type,
argument3 => '', --Document Subtype,
argument4 => 'N', --Process Items Flag,
argument5 => 'N', --Create Sourcing rule,
argument6 => 'APPROVED', --Approval Status,
argument7 => '', --Release Generation Method,
argument8 => po_headers_interface_s.CURRVAL, --NULL,
0