My Oracle Support Banner

Trade Management Accruals Are Posting Multiple Times For The Same Order Line (Doc ID 2802753.1)

Last updated on JUNE 06, 2023

Applies to:

Oracle Trade Management - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, Offers

ACTUAL BEHAVIOR
---------------
Trade Management accruals are posting multiple times for the same order line.  There was no adjustment against the offer.

EXPECTED BEHAVIOR
-----------------------
Expect no unwanted records to be inserted into ozf_funds_utilized_all_b table for the order line and accrual offer.



STEPS
-----------------------
The issue cannot be reproduced at will but observed with the following steps:
1. Login to Applications
2. Go to Order Management
3. Query for an existing order
4. Ensure Funds Accrual Engine is successfully completed
5. Check the query output for -
  SQL>SELECT * from ozf_funds_utilized_all_b where plan_id=<> and order_line_id=<>



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
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.