ORA-00904 Error With Third Party Balance Reports
Last updated on MARCH 25, 2016
Applies to:Oracle Fusion Payables Cloud Service - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
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.
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