Performance of Interface Trip Stop is Slow for Internal sales orders (Doc ID 1075935.1)

Last updated on JULY 19, 2016

Applies to:

Oracle Inventory Management - Version 12.0.0 and later
Oracle Shipping Execution - Version 12.0.0 and later
Information in this document applies to any platform.
ConcurrentProgram:WSHINTERFACES - Interface Trip Stop - SRS

Symptoms

Interface Trip stop concurrent program for Internal sales orders is taking a long time to complete.  The trace and tkprof output show that the major portion of time is spent for calling the function fnd_transaction.synchronous ie.

DECLARE
pragma autonomous_transaction;
rpc_timeout NUMBER := 172800 ;
BEGIN
:1 :=
fnd_transaction.synchronous(rpc_timeout,:2,:3,'PO','RCVTPO','ONLINE',:4,
NULL, NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL,NULL, NULL, NULL, NULL);
COMMIT;
END;

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms