R12: AP: Invoice Line Can't Be Created Because An APP-SQLAP-10000 ORA-01476 Error Occurred (Doc ID 2491557.1)

Last updated on MAY 11, 2022

Applies to:

Symptoms

Can't create invoice line.
The following error occurs when creating and saving AWT line manually.

Error Massage:
APP-SQLAP-10000: ORA-01476: divisor is equal to zero occurred in
AP_INVOICE_LINES_UTILITY_PKG.Manual_Withhold_Tax
with parameters (P_invoice_id = 99999999, p_manual_withhold_amount = -9900)
while performing the following operation:
Updating payment schedules due to a manual withholding tax


1.Create invoice on the invoice workbench screen.

  (1) Create a header with Type: Standard .Invoice amount:0.00
  (2) Create a Line
       Line Type "Miscellaneous" on Line created with 9900.
       Line Type "AWT" on Line created with -9900.
2.Save
  Error occurred.

Changes

Cause

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