My Oracle Support Banner

Trade Management - Accounting At Product Line Level is not happening (Doc ID 1667406.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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


On : version, All Others

Trade Management - Accounting at product line level

During Accrual processing (when an order qualifies for an offer), when viewing the accounting string after the accrual via running OZF-TM: Transfer to General Ledger, the string is not generating the product line code as expected for accrual/sales expense accounts.

During the Claim process and again running OZF-TM: Transfer to General Ledger, the reversal of the accrual is pointing to one constant product code "00000" (as defined in the Claim Setup for each Claim Type). Expectation is the reversal should be at the actual product line level (Prorate Associated Earnings by Products was flagged during claim process)

Steps Taken:

1. Accrual Offer Created: ABC Offer, 10% of all items
2. Offer linked to budget / approved
3. OM Order Organizer -> Order 210624 entered
4. All lines modifier applied: ABC Offer
5. Order Booked
6. Trade Management Admin: Ran FAE with
Show Exception Messages: Yes
Debug Mode: Yes
-> Budget Updated with Utilized amount
7. OM Shipping: Shipping -> Transactions -> Select all lines -> Launch Pick Release
Delivery -> Ship Confirm -> OK
8. Trade Management Admin: Ran FAE with
Show Exception Messages: Yes
Debug Mode: Yes
Trade Management User -> Trade Planning query
ABC Offer Earnings posted
9. Trade Managemen Create a Claim
Claim Number: ABC THREAD 2014 - UAT
Customer: ABC BV
Amount: 291.69
Status: Change to Open
Lines ->
Settlement Method: On Account
Amount: 291.69
Associate Earnings
Accruals and Adjustments for Customers:
Amount available: 291.69
Amount Claimed: 291.69
Prorate Associated Earnings by Products flagged
Lines Summary
Associated earnings per line shown and flagged green
Request Approval -> Confirm
OZF-TM: Transfer to General Ledger -> Claim Postings not at product level
ZML AR Accountant -> Interface Lines, check lines are transferred, run Auto-invoice. AR Credit Memo created but not with product line accounting


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.