My Oracle Support Banner

R12:PA:OTL Records Still Exist In PA_TRANSACTION_INTERFACE_ALL Table Even After Successful Import (Doc ID 2540437.1)

Last updated on JULY 08, 2020

Applies to:

Oracle Project Costing - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Labor Costing Flow

OTL records still existing in pa_transaction_interface table even after successful import.

We have quite a few Oracle Time and Labor transactions in pa_transaction_interface_all table related to a particular OU. The purge after import is enabled for transaction source. Even then these transactions with 'A' status still continue to be in interface table. Can you help us know why they still remain and also provide a fix to purge them


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.