R12: AP: Accounted Amount for Payment Does Not Match Payment Amount When Paying Multiple Invoices
(Doc ID 3077818.1)
Last updated on MARCH 20, 2025
Applies to:
Oracle Payables - Version 12.0.0 and laterInformation in this document applies to any platform.
Symptoms
Incorrect accounting is seen for some payments, the accounted amount for Cash does not match the payment amount.
Steps to reproduce the issue:
1. Create a Payment Process Request (PPR) to pay multiple invoices
Go to Payables responsibility - Payments - Entry - Payments Manager
Click on Payment Process Requests tab
Click on Submit Single Request
Fill the details
Click on Submit button.
2. Once the payment is created, check the payment amount on Payment Workbench
4. Run concurrent program Create Accounting.
Go to Payables responsibility - Other - Requests - Run
Single Request - OK
Name: Create Accounting
3. Check the output of Create Accounting, the accounted credit amount doesn't match with the payment amount
4. While doing undo-accounting for affected payment, the following error message appears in the FND Debug Log:
MODULE MESSAGE_TEXT
AP.PLSQL.AP_ACCTG_PAY_DIST_PKG.Primary_Pay_Events Inside loop Invoice_Dists: After Procedure Pay_Dist_Proc executed
AP.PLSQL.AP_ACCTG_PAY_DIST_PKG.Primary_Pay_Events Loop start for cur Invoice_Dists : Invoice_Dists, Invoice_Distribution_ID = &invoice_distribution_id, l_inv_dist_rec.dist_count - 15, Invoice_Dists%rowcount - 2, l_inv_dist_rec.dist_number - 2, G_When_To_Acct_Pmt - CLEARING ONLY
AP.PLSQL.AP_ACCTG_PAY_DIST_PKG.Primary_Pay_Events Calling procedure Pay_Dist_Proc for dist: &invoice_distribution_id
AP.PLSQL.AP_ACCTG_PAY_DIST_PKG.Pay_Dist_Proc.begin Begin of procedure Pay_Dist_Proc
AP.PLSQL.AP_ACCTG_PAY_DIST_PKG.Pay_Dist_Proc Parameters: Invoice_ID = &invoice_idInvoice_Dist_ID = &invoice_distribution_id
[...]
AP.PLSQL.AP_ACCTG_PAY_DIST_PKG.Pay_Dist_Proc Procedure Pay_Dist_Insert executed
AP.PLSQL.AP_ACCTG_PAY_DIST_PKG.Pay_Dist_Proc Calling procedure Pay_Dist_ERV for dist:&invoice_distribution_id and pmt l_prorated_amount =0and discount amount prorated = 0
AP.PLSQL.AP_ACCTG_PAY_DIST_PKG.Pay_Dist_ERV.begin Begin of procedure Pay_Dist_ERV
fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log "APP-SQLAP-10000: ORA-01403: no data found occurred in
AP_ACCTG_PAY_DIST_PKG.Pay_Dist_ERV<- AP_ACCTG_PAY_DIST_PKG.Pay_Dist_Proc<- AP_Acctg_Pay_Dist_Pkg.Primary_Pay_Events<- AP_Accounting_Pay_Pkg.Do_Pay_Accounting<- AP_SLA_PROCESSING_PKG.EXTRACT
with parameters (&PARAMETERS)
while performing the following operation:
&DEBUG_INFO"
Even though the undo-accounting was successfully processed, the newly accounted payment is still incorrect.
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 |