E1: 41: How to Reverse Redundant, Unwanted IB Records Created in Item Ledger (F4111) and G/L (F0911) by Item Cost Unedited Transaction Inbound Processor (R4105Z1I) (Doc ID 3052155.1)

Last updated on OCTOBER 07, 2024

Applies to:

Goal

Situation

1. The client has accidentally imported multiple redundant IB transactions in F4105Z1 Item Cost Revisions (P4105Z1) Transaction Data table and then processed these using the Item Cost Unedited Transaction Inbound Processor (R4105Z1I).
2. These transactions did not change the amounts stored in the Item Cost (F4105) table because as each record processed by the Item Cost Unedited Transaction Inbound Processor (R4105Z1I), overwrites the current 07 standard cost record in the Item Cost Table (F4105).
3. However, this does result in redundant, unwanted Item Ledger (F4111) and General Ledger (F0911) IB entries being created and subsequently posted to the General Ledger Balances (F0902) table for Inventory.
4. These incorrect Financial Adjustments that were made to Inventory Financial Amounts in the Item Ledger and General Ledger must be corrected.

Question
The client wants to know if there is a way to reverse these redundant, unwanted Item Ledger (F4111) and General Ledger (F0911) IB entries to restore Inventory Financial Amounts to the correct amounts.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.