Receivables

Technical Topics in Oracle Receivables

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 …

TCA API – Create Customer Account / Party and Customer ProfileRead More »

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), …

APP-FND-1564: ORACLE error 24347 in FDFGVDRead More »

RSS
Follow by Email
Facebook
Facebook
SHARE