Sales Journal by GL Account (XML) Run by Customer Name Returns Error - APP-FND-01564: ORA-00904: "PARTY"."PARTY_ID": Invalid Identifier
Last updated on FEBRUARY 12, 2018
Applies to:Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Receivables EDI/XML Gateway
Attempting to run the Sales Journal by GL Account Report (XML) and receive the following error, when choosing the parameter "Customer Name":
APP-FND-01564: ORACLE error 904 IN FDFGDF
Cause: FDFGDF failed due to ORA-00904: "PARTY"."PARTY_ID": invalid identifier.
The SQL statement being executed at the time of the error was: SELECT PARTY.PARTY_NAME FROM HZ_PARTIES WHERE PARTY.PARTY_ID=:a1 and was executed from the file &ERRFILE.
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