Sales Journal by GL Account (XML) Run by Customer Name Returns Error - APP-FND-01564: ORA-00904: "PARTY"."PARTY_ID": Invalid Identifier (Doc ID 1638672.1)

Last updated on DECEMBER 04, 2015

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

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":

ERROR
-----------------------
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.

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