My Oracle Support Banner

R12:AP: Inactivating "Ex-employee" Type Supplier Raises Stale Data Error After Migration From R11i To R12 (Doc ID 2692467.1)

Last updated on JUNE 21, 2023

Applies to:

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


On product version 12.2.8 version while trying to re-activate "Ex-employee" type Supplier it raises Stale Data Error after migration from R11i to R12.

While saving it raises the following error:

Also, the Supplier Site for the same supplier is not found despite its existence in ap_supplier_sites_all table.

The issue can be reproduced at will with the following steps:

  1. Supplier web setup page.
  2. Organization - Suppliers.
  3. Search for Supplier Number: 99999 with Inactive Date field not blank.
  4. Remove the Inactive Date.


Migration from R11i to R12.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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