My Oracle Support Banner

Advanced Collections: Attempting to Create an Adjustment in Universal Work Queue (UWQ) and Receive Error - ARP_PROCESS_ADJUSTMENT.Insert_Adjustment Exception (Doc ID 1430523.1)

Last updated on FEBRUARY 12, 2019

Applies to:

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


Attempting to create and adjustment and receive the following error:

arp_process_adjustment.insert_adjustment exception
User-Defined exception

The debug log shows the following:
ar.plsql.arp_det_dist_pkg.reconciliation 1 Reconciliation gross amount
ar.plsql.arp_det_dist_pkg.reconciliation 1 From the detail gt the amount l_sum :-259.82
ar.plsql.arp_det_dist_pkg.reconciliation 1 adjustment record the amount:-779.47
ar.plsql.arp_det_dist_pkg.reconciliation 1 Gross transaction amount do not reconcile
ar.plsql.arp_det_dist_pkg.reconciliation 4 OTHERS IN adjustment_with_interface :User-Defined Exception
ar.plsql.ar_process_adjustment.insert_adjustment 4 EXCEPTION: ar_process_adjustment.insert_adjustment()
ar.plsql.ar_process_adjustment.insert_adjustment 1 Create_Adjustment: Error in Insert Entity handler. Rolling back and setting status to ERROR




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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps

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