AXXPSMAN - "unbalanced accounting entries" Translation Error in AX Inventory for Intransit Shipments with FOB Point=Shipment

(Doc ID 1920418.1)

Last updated on DECEMBER 20, 2017

Applies to:

Oracle Global Accounting Engine - Version and later
Information in this document applies to any platform.
Executable:AXXPSMAN - Posting Manager
Executable:AXXPSETR - Event Translation Report


On release

Find stuck events in AX Inventory with the following error in the Event Translation Report (AXXPSETR).

Related Inventory transaction type is Int Order Intr Ship.
Issue originally reported for INV_EVENT_211TO AX Event type (profile "CST: Transfer Pricing Option" is set to No), but the problem would occur with other Event Types like "INV_EVENT_211..."

At shipping network level, transfer type is Intransit and FOB is set to Shipment.

"The translation of the event ... has generated unbalanced accounting entries in the posting set of books ..."

The issue can be reproduced at will with the following steps:
1. Select the AX Inventory responsibility for the problematic set of books.
2. Go to Submit Posting Manager form.
AX Inventory: (N) Accounting Close Cycle > Post Transactions
3. Press button Submit.
4. Close the form.
5. Go to View Requests window.
6. Once the AX Posting Manager completed, review the Event Translation Report.

Business impact
Due to this issue, a large and increasing amount of accounting data are missing in AX Inventory and then in General Ledger.


The problem started to occur after patching AX Inventory, for instance after applying <Patch:12579221>. Same kind of events were successfully translated prior to applying the patch. 


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