My Oracle Support Banner

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




To view full details, 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 a vibrant support community of peers and Oracle experts.