My Oracle Support Banner

R12: AP: ECC: No Data on Payables ECC Dashboards and Error on Load Program: java.sql.SQLSyntaxErrorException: ORA-00903: invalid table name (Doc ID 2940290.1)

Last updated on OCTOBER 11, 2023

Applies to:

Oracle Enterprise Command Center Framework - Version 12.2.6 and later
Oracle Payables - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms


No data is visible on the ECC Payables Dashboards.

The Payables Command Center Data Load program ended in error:

java.sql.SQLSyntaxErrorException: ORA-00903: invalid table name

trx_v.aging_bucket as aging_bucket, trx_v.NEXT_DISCOUNT_DATE, trx_v.EARLIEST_OPEN_HOLD_DATE,
   trx_v.INVOICE_ON_HOLD_FLAG from AP_ECC_INSTALLMENT_V trx_v  , () dfv
   where language in ('F','US')  AND TRX_V.ROW_ID = DFV."'AP_ROW_ID'"(+


STEPS
-----------------------

1. Payables > Payables command center > No data seen on dashboards

2. Go to Requests > Run > Payables Command Center Data Load program

3. Program ends in error



Changes

 

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
Changes
Cause
Solution
References


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