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

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 11.5.10.2 version, All Others

ACTUAL BEHAVIOR
---------------
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
Create
Status: Change to Open
Update
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
Update
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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms