My Oracle Support Banner

R12: AP: Encountered an exception 100-error ORA-01403: no data found in call AP_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 NOVEMBER 02, 2021

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

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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