My Oracle Support Banner

R12: AP: When Applying Credit Memo to An Invoice Gets Error APP-SQLAP-10000: ORA-01426: numeric overflow occurred in Get_Dist_Proration_Info<-Create_Invoice_Lines_Dists<-AP_INVOICE_CORRECTIONS_PKG.Invoice_Correction (Doc ID 2896294.1)

Last updated on SEPTEMBER 20, 2022

Applies to:

Oracle Payables - Version 12.1.1 to 12.2.11 [Release 12.1 to 12.2]
Information in this document applies to any platform.


In Oracle Payables, when a user attempts to apply Credit Memo against the invoice using the invoice workbench form (APXINWKB.fmb) the following error occurs:

APP-SQLAP-10000: ORA-01426: numeric overflow occurred in
Get_Dist_Proration_Info<-Create_Invoice_Lines_Dists<-AP_INVOICE_CORRECTIONS_PKG.Invoice_Correctionwith parameters (corrected invoice id = XXXXX, line amount = -YYYY, prorate distributions Flag=Y)
while performing the following operations:
populate distribution proration info

Steps to Reproduce

  1. Navigate to Payable responsibility > Invoices > Entry > Invoices
  2. create credit memo, with match_action Field as 'Invoice' at header level
  3. click on Corrections Button, without entering details at line level
  4. Select invoice number, click on find
  5. enter credit amount and click on correct and then click on Ok button
  6. gets the error message




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.