The Sales Journal By Gl Account Report Ended With APP-FND-01564 Error

(Doc ID 1224513.1)

Last updated on JANUARY 21, 2016

Applies to:

Oracle Receivables - Version 12.1.1 and later
Information in this document applies to any platform.
RAXGLR.RDF


Symptoms

On : 12.1.1 version, Subledger Accounting Uptake for Receivables

When attempting to run Sales Journal by GL Account Report in Receivables,
the following error occurs.

ERROR
-----------------------
APP-FND-01564: ORACLE error 904 IN fdfgdf
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

The report works fine if you do not pass Customer Name parameter.

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