ORA-00942

Drilldown Error ORA-00942 - Table Or View Does Not Exist [ID 1190343.1]

Applies to:

Oracle Payables - Version: 12.1.1 and later   [Release: 12.1 and later ]
Information in this document applies to any platform.

Symptoms

On : 12.1.1 version, Standard Reports & Inquiries

When attempting to drill down to payables,
the following error occurs.

ERROR
-----------------------
ORA-00942: table or view does not exist

STEPS
-----------------------
1. Go to Inquiry : Account
2. Click on drill down for a Payables transaction
3. Verify the output

Cause

This was due to the missing gl_sl_link_id for upgraded transactions.
This is explained in the below bug:
Bug 9968726 - R12:DATAFIX: DRILLDOWN ERROR ORA-00942: TABLE OR VIEW DOES NOT EXIST

Solution

Please use the below query to identify such kind of corruption:

SELECT *
FROM xla_ae_lines
WHERE application_id = :appl_id
AND gl_sl_link_id is null
AND ae_header_id IN
(SELECT ae_header_id
FROM xla_ae_headers
WHERE application_id = :appl_id and upg_batch_id is NOT NULL
AND ledger_id =:ledger_id and gl_transfer_date IS NOT NULL
AND accounting_entry_status_code='F'
AND period_name in (:period_name));

If the above query returns rows then please log a SR with Oracle Support
to get the data fix from Oracle Development.