R12: AP: The Payables Open Interface Import by Create Adjusting Documents in Payables Program Is Running a Long Time and Has Caused Locks on Related Tables
(Doc ID 2586835.1)
Last updated on OCTOBER 13, 2020
Applies to:Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.
The Payables Open Interface Import by Create Adjusting Documents in Payables program was submitted. Usually this program completes in few minutes, but now it running for nearly a long period of time. The following script was run, in order to check for locks:
select c.owner, c.object_name, c.object_type, b.sid, b.serial#, b.status, b.osuser, b.machine
from v$locked_object a , v$session b, dba_objects c
where b.sid = a.session_id
and a.object_id = c.object_id;
The results show that locks exist on two tables related to the Payables Open Interface Import process:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document