My Oracle Support Banner

11i : AP: Troubleshooting AP Health Check Issues (Doc ID 2021359.1)

Last updated on MARCH 29, 2021

Applies to:

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


 How to troubleshoot  AP Health Check issues before upgrading to R12

Troubleshooting Steps

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
Troubleshooting Steps
 Results of the AP Health Check script can fall into two categories:

1) Data corruption issues:
 Out of sync posted flags
 <Internal_Only>11i Mass Datafix for Bug 3232467 (Doc ID 317255.1)</Internal_Only>
 Accounting dates out of sync/unaccounted events in a closed period
 <Internal_Only>11i Mass Datafix for Bugs 3257972, 3257936, 3476167 and 5237825 (Doc ID 313477.1)</Internal_Only>
 Type 5 Orphans
 Mass Datafix for Bug 3181211
 Distributions marked posted with null ACCOUNTING event ids
 <Internal_Only>Mass Datafix for Bug 2691008 (Doc ID 223754.1)</Internal_Only>
 Payments with Large Writeoff Lines Detected from the AP Accounting Health Check
 <Internal_Only>11i Mass Datafix for Orphan Accounting Events (Doc ID 356188.1)</Internal_Only>
 Accounting_Event_ID is null for the cancellation lines
 <Internal_Only>Mass datafix for Bugs 3777506, 3574680 and 3396694 (Doc ID 364327.1)</Internal_Only>
 AWT distribution lines created at payment time will not account
 <Internal_Only>Mass Datafix for bugs 2993905 and 3235893 </Internal_Only>
 Events labeled INCOMPLETE 
 Mass Datafix for Bug 4725016 
 Unaccounted events in closed period
 <Internal_Only>11i Mass Datafix for Bug 3232467 (Doc ID 317255.1)</Internal_Only>
 Wrong Parent reversal id and reversal flag on 11i distributions
 11i: Generic Data Fix (GDF) Patch 13088668 - GDF to Correct the Invoice Reversal Distributions
That May Have Multiple Corruptions. (Doc ID
 Transactions with invalid accounts cannot be updated on the Update Accounting Entries form. EF05 when transferred to GL
 <Internal_Only> Mass Datafix for bug 2997006 (Doc ID 317083.1)</Internal_Only>
 EC12 in GL import for data transferred from Payables
  <Internal_Only>Mass datafix for Bug 3415600 (Doc ID 362280.1)</Internal_Only>
 Invoice Cancellation Events with an accounting date on the last day of the period will not transfer to GL
 <Internal_Only>Mass datafix for Bug 5666500 (Doc ID 414626.1)</Internal_Only>
 Payables Accounting ends with an ORA-1403 error
  <Internal_Only>Mass datafix for Bug 3113023 (Doc ID 266515.1)</Internal_Only>

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