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