My Oracle Support Banner

R12: AP: ORA-00942 Error When Trying To Drilldown From GL To XLA For Upgraded AX Transactions (Doc ID 2068794.1)

Last updated on MARCH 29, 2021

Applies to:

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


When attempting to drill down to payables entry from GL Journal for 1 ledger for which AX was implemented in 11i, the following error occurs.

ORA-00942: table or view does not exist

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

After migration from 11i 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!

In this Document

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