R12: Unable To Apply Invoice To a Receipt in Receipt Workbench - Debug Log Shows Exception: 'ORA-01400: cannot insert NULL into ("AR"."AR_DISTRIBUTIONS_ALL"."SOURCE_ID")'
(Doc ID 3014581.1)
Last updated on MAY 20, 2024
Applies to:
Oracle Receivables - Version 12 and laterInformation in this document applies to any platform.
Symptoms
When attempting to apply a receipt to a transaction, the application is not saved. No Error Message displayed in Receipt Forms.
FND Debug Log shows below Exception:
ar.plsql.ARP_ALLOCATION_PKG.Build_Tax.end 2 ARP_ALLOCATION_PKG.Build_Tax()-
ar.plsql.ARP_ALLOCATION_PKG.Build_Lines.end 2 ARP_ALLOCATION_PKG.Build_Lines()-
ar.plsql.ARP_ALLOCATION_PKG.Process_Amounts.end 2 ARP_ALLOCATION_PKG.Process_Amounts()-
ar.plsql.ARP_ALLOCATION_PKG.Process_Amounts 1 upgrade method
ar.plsql.ARP_ALLOCATION_PKG.Summarize_Accounting_Lines.begin 2.00 ARP_ALLOCATION_PKG.Summarize_Accounting_Lines()+
ar.plsql.ARP_ALLOCATION_PKG.Summarize_Accounting_Lines 1.00 EXCEPTION: ARP_ALLOCATION_PKG.Summarize_Accounting_Lines:ORA-01400: cannot insert NULL into ("AR"."AR_DISTRIBUTIONS_ALL"."SOURCE_ID")
ar.plsql.ARP_ALLOCATION_PKG.Summarize_Accounting_Lines 1.00 EXCEPTION: ARP_ALLOCATION_PKG.Allocate_Tax:ORA-01400: cannot insert NULL into ("AR"."AR_DISTRIBUTIONS_ALL"."SOURCE_ID")
ar.plsql.ARP_ALLOCATION_PKG.Summarize_Accounting_Lines 4.00 EXCEPTION: ARP_RECEIPTS_MAIN.Create_Ae_Lines_RA
ar.plsql.ARP_ALLOCATION_PKG.Summarize_Accounting_Lines 4.00 EXCEPTION: ARP_RECEIPTS_MAIN.Create_Ae_Lines_Common
ar.plsql.ARP_ALLOCATION_PKG.Summarize_Accounting_Lines 4.00 EXCEPTION: ARP_RECEIPTS_MAIN.Derive_Accounting_Entry
ar.plsql.ARP_ALLOCATION_PKG.Summarize_Accounting_Lines 4.00 EXCEPTION: ARP_RECEIPTS_MAIN.Execute
ar.plsql.ARP_ALLOCATION_PKG.Summarize_Accounting_Lines 4.00 EXCEPTION: ARP_ACCT_MAIN.Create_Acct_Entry
ar.plsql.ARP_ALLOCATION_PKG.Summarize_Accounting_Lines 4.00 EXCEPTION: Overloaded ARP_ACCT_MAIN.Create_Acct_Entry
ar.plsql.ARP_ALLOCATION_PKG.Build_Lines.end 2 ARP_ALLOCATION_PKG.Build_Lines()-
ar.plsql.ARP_ALLOCATION_PKG.Process_Amounts.end 2 ARP_ALLOCATION_PKG.Process_Amounts()-
ar.plsql.ARP_ALLOCATION_PKG.Process_Amounts 1 upgrade method
ar.plsql.ARP_ALLOCATION_PKG.Summarize_Accounting_Lines.begin 2.00 ARP_ALLOCATION_PKG.Summarize_Accounting_Lines()+
ar.plsql.ARP_ALLOCATION_PKG.Summarize_Accounting_Lines 1.00 EXCEPTION: ARP_ALLOCATION_PKG.Summarize_Accounting_Lines:ORA-01400: cannot insert NULL into ("AR"."AR_DISTRIBUTIONS_ALL"."SOURCE_ID")
ar.plsql.ARP_ALLOCATION_PKG.Summarize_Accounting_Lines 1.00 EXCEPTION: ARP_ALLOCATION_PKG.Allocate_Tax:ORA-01400: cannot insert NULL into ("AR"."AR_DISTRIBUTIONS_ALL"."SOURCE_ID")
ar.plsql.ARP_ALLOCATION_PKG.Summarize_Accounting_Lines 4.00 EXCEPTION: ARP_RECEIPTS_MAIN.Create_Ae_Lines_RA
ar.plsql.ARP_ALLOCATION_PKG.Summarize_Accounting_Lines 4.00 EXCEPTION: ARP_RECEIPTS_MAIN.Create_Ae_Lines_Common
ar.plsql.ARP_ALLOCATION_PKG.Summarize_Accounting_Lines 4.00 EXCEPTION: ARP_RECEIPTS_MAIN.Derive_Accounting_Entry
ar.plsql.ARP_ALLOCATION_PKG.Summarize_Accounting_Lines 4.00 EXCEPTION: ARP_RECEIPTS_MAIN.Execute
ar.plsql.ARP_ALLOCATION_PKG.Summarize_Accounting_Lines 4.00 EXCEPTION: ARP_ACCT_MAIN.Create_Acct_Entry
ar.plsql.ARP_ALLOCATION_PKG.Summarize_Accounting_Lines 4.00 EXCEPTION: Overloaded ARP_ACCT_MAIN.Create_Acct_Entry
Steps to Reproduce
-----------------------
1. Responsibility: Receivables Manager
2. Navigation: Receipts > Receipts
3. Query Receipt > Click on Search and Apply
4. Apply Invoice to the Receipt and Save
5. Application is not saved and No Error Message is shown
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |