My Oracle Support Banner

In Oracle Contract Lifecycle Management, Data From PO_UDA_interface Table Is Not Getting Deleted After Its Usage From Database (Doc ID 2283052.1)

Last updated on JULY 03, 2017

Applies to:

Oracle Contract Lifecycle Management for Public Sector - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.3 version, MICC Transfer to TSC

ACTUAL BEHAVIOR
---------------


  In Oracle Contract Lifecycle Management, the data from PO_UDA_INTERFACE table is not getting deleted after its usage.
 



UDA data can be created in the following flows:
-------------------------------------------------------------
1. PAR to MOD (UDA Data populated)
2. PDOI
3. PDS
4. Webservice

Try to add the data into po_uda_interface table by above flows.
->
For PDOI, run a concurrent program 'Purge Purchasing Open Interface
Processed Data', After completion of this program, the
corresponding uda data was not deleted from the po_uda_interface table.

Cause

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
Symptoms
Cause
Solution
References


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