AXXPSMAN - "unbalanced accounting entries" Translation Error in AX Inventory for Intransit Shipments with FOB Point=Shipment (Doc ID 1920418.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On release 11.5.10.2:

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.

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

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

Changes

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. 

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