TCA API – Create Customer Account / Party and Customer Profile
The following code snippet can be used to create: 1. Customer Account 2. Party Associated with the Customer Account 3. Customer Profile We can use one API to create all the 3 entities in Oracle Apps R12. I am using a custom table that holds the customer details. Hope this helps. I have also included a […]
APP-FND-1564: ORACLE error 24347 in FDFGVD
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), […]