R12:AP:Encountered an exception 100-error ORA-01403: no data found in callAP_Acctg_Prepay_Dist_Pkg.Delete_hist_dists<- AP_ACCTG_PREPAY_DIST_PKG.Prepay_Dist_Appl<- Repopulate_Prepay_Distributions <- GDF script ap_trx_missing_event_fix.sql (Doc ID 2094085.1)

Last updated on AUGUST 22, 2016

Applies to:

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

Symptoms

Getting the error below when trying to run the fix script ap_trx_missing_event_fix.sql from R12: Generic Data Fix (GDF) Patch 18484204 - Approved Invoice Distributions and / or Payments Missing ACCOUNTING_EVENT_ID (Doc ID 972261.1):

Encountered an exception 100-error ORA-01403: no data found in callAP_Acctg_Prepay_Dist_Pkg.Delete_hist_dists<- AP_ACCTG_PREPAY_DIST_PKG.Prepay_Dist_Appl<- Repopulate_Prepay_Distributions <- GDF script ap_trx_missing_event_fix.sql

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