My Oracle Support Banner

R12: Supplier Merge Fails MSG-05070: Error in After Report Trigger REP-1419: 'afterreport': PL/SQL program aborted - Brazilian Localizations Installed (Doc ID 1567336.1)

Last updated on APRIL 04, 2025

Applies to:

Oracle Payables - Version 12.0.1 and later
LAD Add-on Localizations - Version 12.0.1 and later
Information in this document applies to any platform.

Symptoms

Supplier Merge fails with the following error:

MSG-05000: Start After Report Trigger.
MSG-05010: Call before
AP_VENDOR_PARTY_MERGE_PKG.Other_Products_VendorMerge...
:P_DUP_VENDOR_ID: xxxx
MSG-05070: Error in After Report Trigger
REP-1419: 'afterreport': PL/SQL program aborted.

...

PO: Calling iSP API
1.Begin handle_merge:new vendorid:XXXX:new vendor site id:xxxx
:old vendor id :xxxx:old vendor site id:xxxx
Inside POS_MERGE_SUPPLIER_PKG.supplier_site_uda_merge p_to_fk_id: xxxx
p_to_fk_id: xxxx p_from_id : xxxx
PO: Calling Procurement API
PO: Complete
PO: Calling Receiving API

It appears that the invoice and POs are merged, but there is an error when checking for / merging Receiving information.

Changes

 SELECT * FROM all_triggers 
 WHERE trigger_name IN 
     ('CLL_F189_RETURN_TRANS_T1', 'JAI_RCV_RT_ARIUD_T1', 
      'ITG_IP_RCV_TRANSACTIONS_ARI', 'JAI_RCV_RT_BRIUD_T1', 
      'CLL_F189_TRANSACTIONS_T1') 

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.