My Oracle Support Banner

R12: AP: AP_SUPPLIER_INT_REJECTIONS Records Get Deleted For Each New Execution of the "Supplier Open Interface Import" Program. (Doc ID 3042671.1)

Last updated on AUGUST 20, 2024

Applies to:

Oracle Payables - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

The records in table AP_SUPPLIER_INT_REJECTIONS get deleted when next import is executed.

When the user executes the "Supplier Open Interface Import" program, and records are rejected; the rejection reason(s) is(are) stored in table AP_SUPPLIER_INT_REJECTIONS. 
But, when next import program is ran, then the records of the previous run are deleted from this table.

EXPECTED BEHAVIOR
-----------------------
The records of AP_SUPPLIER_INT_REJECTIONS should not get purge the old data after each run

Steps to reproduce:

  1. Create the record in AP_SUPPLIERS_INT and AP_SUPPLIER_SITES_INT
  2. Run Supplier Open Interface Import.
  3. Check the error record in output file.
  4. Record is available AP_SUPPLIER_INT_REJECTIONS
  5. Create another record in AP_SUPPLIERS_INT and AP_SUPPLIER_SITES_INT
  6. Run Supplier Open Interface Import
  7. Previous run Error (Rejected) records are Not available in AP_SUPPLIER_INT_REJECTIONS.

 

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.