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

Last updated on FEBRUARY 26, 2014

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

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 hundreds of Community platforms