ORA-00904 Error With Third Party Balance Reports (Doc ID 2120715.1)

Last updated on MARCH 25, 2016

Applies to:

Oracle Fusion Payables Cloud Service - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Symptoms

When the 'Third Party Detail And Balances Report' and 'Third Party Balances Summary Report' are run, depending on what is selected as the 'Third-Party Type' parameter, the process will Error with the message "Cause: An internal error has occurred in the program xla_tp_balance_rpt_pkg.beforeReport , ORA-00904: "TABLE1"."PARTY_SITE_NAME": invalid identifier."

This is the case if you select the DEFAULT parameter "Any". However if you change the parameter to 'Customer' or 'Supplier' the process completes successfully and the report is generated.

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