My Oracle Support Banner

R12: RCA: UPGRADED PAYABLES SUBLEDGER ACCOUNTING TRANSFERRED AFTER THE UPGRADE (Doc ID 1092913.1)

Last updated on FEBRUARY 06, 2019

Applies to:

Oracle Payables - Version 12.0.6 to 12.2 [Release 12.0 to 12.2]
Information in this document applies to any platform.

Symptoms

Symptom 1: R12 Upgraded Payables Accounting xla_ae_lines gl_sl_link_id is NULL.

Symptom 2:  Upgraded Payables Accounting that was created before the upgrade and transferred after the upgrade is missing from the ap_liability_balance table.

Symptom 3: R12 Upgraded Payables Accounting is incorrectly reported on OR missing from the Accounts Payable Trial Balance.

Symptom 4: The subledger accounting appears correctly in the subledger accounting tables, but it can not be found or linked to balances in the GL tables.

Symptom 5: In Subledger Accounting "Standard Reports & Inquiries" drilling down to Payables (AP) raises ORA-00942 Table or view does not exist (caused by missing gl_sl_link_id issue below)

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
 Code fix for missing gl_sl_link_id issue (BEFORE the upgrade to R12)
 Code fix for missing ap_liability_balance data (BEFORE the upgrade to R12)
 Data fix for missing ap_liability_balance data (AFTER the upgrade to R12)
 Data fix for missing gl_sl_link_id issue (After the upgrade to R12)
 Standard Patching Process
 Patch Wizard
 Have more questions?
References


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