Interorg transfer very slow
Hi there,
We are facing sever performance issue while doing the interorg transfer.
our database is Oracle 10g RAC, with multnode application tier.
As per the document I enabled QUEUE for Transport Type from PIPE, as its Oracle 10g RAC.
Now initial 2-3 transaction is damn slow after opening the form, the it becomes fast. What could be the reason.
Trace:
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;
Thanks,
saroj
0