RCA : NULL ACCOUNTING EVENT ID In AP_INVOICES_PAYMENTS_ALL When Generating Payments Via API FV_IPAC_AUTOPAYMENTS_PKG.CALL_APPROVAL_API (Doc ID 1909452.1)

Last updated on AUGUST 11, 2015

Applies to:

Oracle Payables - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.3 version, Accounting Issues in AP
 

Changes

By using this API FV_IPAC_AUTOPAYMENTS_PKG.Call_Approval_Api the following data corruption occurs:

Acounting_event_id  is null in the following table ap_invoice_payments_all for all types of Payments : Negotiable or Voided

On the other hand accounting_event_id  exist in the additional table ap_payment_history_all

The following selects where run in order to identify the data fix corruption:

 

 

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