After upgrading to 12.1.3, I have been getting the below error while submitting the Auto Invoice Master Program from AR Responsibility.
APP-FND-1564: ORACLE error 24347 in FDFGVD
Cause: FDFGVD failed due to ORA-24347: Warning of a NULL column in an aggregate function.
SELECT BATCH_SOURCE_ID,NAME VALUE, DESCRIPTION DESCRIPTION, NVL(‘N’, ‘N’),
NVL(TO_NUMBER(NULL), -1), NULL, NVL(‘Y’, ‘Y’), NVL(TO_CHAR(TO_DATE(NULL),
‘J’), 0), NVL(TO_CHAR(TO_DATE(NULL), ‘J’), 0) FROM AR_AI_BATCH_SOURCE_V WHERE
( GET_ALL = DECODE(:b1, -99, ‘Y’,’N’) AND ORG_ID = DECODE(:b2, -99,
ORG_ID, :b3) ) AND BATCH_SOURCE_ID = :X and was executed from the file
&ERRFILE.
Please see the below screenshots for reference:
Login to Receivables Manager Responsibility:
Click on AutoInvoice function under Interfaces Sub Menu.
Click “Ok”. The SRS window will be opening. Enter all the mandatory parameters. The organization parameter value defaults to “All”.
Once you have entered the mandatory parameters, click on “Submit”. You will receive the below error:
Work Around:- Select a different value for Organization parameter. You can select the operating unit value (US Operating Unit) and then submit the program.
See the screenshot below:
References:
The following note from Oracle Support will be helpful.
AutoInvoice Error: Batch Source List of Values Raises Error: APP-FND-1564: ORACLE error 24347 in FDFGVD (Doc ID 1406558.1)