Releasing a Hold or Canceling an Invoice Gives APP-SQLAP-10000 ORA-01407 (Doc ID 556873.1)

Last updated on MARCH 02, 2009

Applies to:

Oracle Payables - Version: 11.5.10.2 to 11.5.10.2
This problem can occur on any platform.
FORM:APXINWKB.FMB - Invoice Workbench

Symptoms

Problem Statement:
On 11.5.10.2 in Production:
When attempting to cancel an invoice or manually release a hold, the following error occurs:

APP-SQLAP-10000 ORA-01407 cannot update
PO.PO_DISTRIBUTIONS_ALL.LAST_UPDATE_DATE to NULL occured in AP_CANCEL_PKG.AP_CANCEL_SINGLE_INVOICE
<-APXINWKB with parameters (P_invoice_id =227451 P_last_updated_by=2854 P_last_update_login
=11838248 P_set_of_books_id=1 P_accounting_date=16-oct-07 P_period_name=OCT-07-FY-08)

While performing the following operations:
Adjust quantity_billed and amount_billed in po_distributions

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms