R12:AP: Generic Data Fix (GDF) Patch to Correct the Data Corruption for Posted Flag having Value as 'S' (Doc ID 1088872.1)

Last updated on JUNE 21, 2023

Applies to:

Symptoms

There are Payables transactions (invoices and payments) with incorrect status of Posted_flag as 'S'.

The transactions are stuck in processing status and they are shown as Unprocessed.

This value, 'S', should be there only when there is an accounting operation going on the record and a concurrent program is in progress.  
Once the accounting of the record goes through successfully in which case the event status code in XLA_EVENTS table is 'P', the value of this flag should be 'Y'. Else for all other conditions, it should be 'N'.

Steps to reproduce:

1. Log into Oracle applications using a Payables responsibility.
2. (N) Payables Responsibility -> Submit Create Accounting program. If the Create Accounting program completes in error and the issue is encountered then Posted Flag of transactions are stuck in status: 'S'.
3. This will cause the transactions to be shown in incorrect accounting status: Unprocessed. 

Note: Currently, the issues is not reproducible on will. Patches 7351478 and 9756762 are available in code lines of R12.1.x and R12.2.x

Changes

Cause

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