E1:39 Stock Valuation On-Line Activation (P39042) Causes ALL Item Ledger (F4111) Records to be Copied to Period Workfile (F39120) (Doc ID 3052721.1)

Last updated on OCTOBER 29, 2024

Applies to:

Symptoms

On-Line Activation in the Stock Valuation Constants (P39042) causes all inventory transactions for all companies to be copied from the Item Ledger (F4111) to the Period Workfile (F39120W). This occurs even for companies NOT activated for Advanced Stock Valuation.

In the Stock Valuation companies, the workfile records are cleared when the period close is run, but the records accumulate forever and are never cleared for companies that do not use Advanced Stock Valuation.

Steps to Duplicate:

1. Stock Valuation Constants (P39042) are activated for On-Line Extraction for Company 00000.
   1. Three specific companies (00001, 00070 and 00249) are activated for Advanced Stock Valuation.
2. Create an Inventory Transaction in the Canadian Company (00077) for the Canadian Branch Plant (77) which does NOT use Advanced Stock Valuation.
3. Find the transaction in the Item Ledger (P4111).
   1. Note the UKID number 
4. Using Databrowser open the Period Workfile (F39120W) table and find the transaction using the UKID Number
   1. The transaction should not have been copied from the Item Ledger (F4111).

Cause

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