R12: AP: Error 'ORA-01400' During Creation of 'Quick Credit' Credit Memo
(Doc ID 3025315.1)
Last updated on MAY 27, 2024
Applies to:
Oracle Payables - Version 12.0.0 and laterInformation in this document applies to any platform.
Symptoms
Application gave error 'ORA-01400' during creation of a 'Quick Credit' Credit Memo.
Steps:
- Navigate to Payables responsibility > Invoices > Entry. Enter the header data for a new Credit Memo.
- Select the 'Quick Credit' checkbox and enter the Credited Invoice Number.
- Application gives below error when User tries to save the Credit Memo:
"APP-SQLAP-10000: ORA-01400: cannot insert NULL into ("AP"."AP_INVOICE_DISTRIBUTIONS_ALL"."PERIOD_NAME") occurred in
AP_QUICK_CREDIT_PKG.Full_Reversal<-AP_QUICK_CREDIT_PKG.Quick_CreditInv_Sum_Folder_Quick_Credit.Event
with parameters ( P_Invoice_Id = XXXXX P_Error_Code = P_Calling_Sequence = AP_QUICK_CREDIT_PKG.Quick_CreditInv_Sum_Folder_Quick_Credit.Event)
while performing the following operation:
create distributions"
AP_QUICK_CREDIT_PKG.Full_Reversal<-AP_QUICK_CREDIT_PKG.Quick_CreditInv_Sum_Folder_Quick_Credit.Event
with parameters ( P_Invoice_Id = XXXXX P_Error_Code = P_Calling_Sequence = AP_QUICK_CREDIT_PKG.Quick_CreditInv_Sum_Folder_Quick_Credit.Event)
while performing the following operation:
create distributions"
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 |