For Requisition Fulfilled By Material Stock Request in Inventory, Display Open Pre-Encumbrances Only Checkbox Not Working in Commitment Control Review Budget Details or Review Budgets Overview (Doc ID 2759033.1)

Last updated on APRIL 05, 2023

Applies to:

Symptoms

When sourcing a requisition from inventory via a material stock request from reservation through to depletion, then creating cost management accounting entries from the inventory depletion, after budget checking the depletion accounting entries which relieves the PreEncumbrance ledger and posts to the expense ledger, when view the activity log for PreEncumbrance though it appears that the PreEncumbrance amount from the req has been fully relieved by the budget checking of the depletion accounting entry amount, when click "Display Open PreEncumbrance Only" still see the row from the budget checked depletion accounting entry.

Replication Steps:
1.Set up new inventory item, ITEMA, with cost and price both $50/EA
2.Link both PO BU US005 and INV BU US011 to GL BU US005, for requisitions and for cost accounting entries, respectively
    >> Set Up FIN/SCM > Business Units > Purchasing > Purchasing Definition
    >> Set Up FIN/SCM > Business Units > Inventory > Inventory Definition
3.In Item Balance by All Units, ensure inventory available in INV BU US011
    >> Manage Inventory > Review Inventory Balance Info > Item Balance By All Units
4.Set up Distribution Network Code USA1 that sources from INV BU US011 first
    >> Set Up FIN/SCM > Common > Shipping & Receiving > Distribution Networks
5.Set Ship To Location US001 to have distribution network code USA1 to source from INV BU US011 first
    >> Set Up FIN/SCM > Product Related > Procurement Options > Purchasing > Ship To Locations
6.Create Requisition with req line for ITEMA, qty 20, price $50/EA, total $1000; run budget check
    >> Purchasing > Requisitions > Add/Update Requisitions
7.Review Budget Details, see PreEncumbrance now $1000
   Drilldown to Activity Log for PreEncumbrance, view row with chartfield string, budget period and amount +1000.00 from Req
    >> Commitment Control > Review Budget Activities > Budget Details
8.Run Autosource (PO_AUTO_SRC), with Source From Inventory checked
    >> Purchasing > Purchase Orders > Stage/Source Requests > PO Autosourcing
9.View Sourcing Workbench; see Req stage status "Completed" with no PO thus sourced to inventory
    >> Purchasing > Purchase Orders > Stage/Source Requests > Sourcing Workbench
10.In Manage Requisitions, see that it is being sourced from Inventory.
     Click on Inventory icon to view Stock Request Status for INV BU US011, PO BU US001 & Req ID
     >> ePro > Manage Requisitions
11.In Maintain Material Stock Requests, update the MSR to include a Distrib Type, since no Distrib Type comes over from the Req
     >> Inventory > Fulfill Stock Requests > Stock Requests > Maintain Stock Requests
12.Run Reserve Materials Process (IN_FUL_RSV)
     >> Inventory > Fulfill Stock Requests > Stock Requests > Reserve Materials Process
     View Review Fulfillment Info > Stock Request Status after reserved
     >> Inventory > Fulfill Stock Requests > Review Fulfillment Info > Stock Requests
13.Run Order Release (IN_FUL_RLS) with Advance to Depleted;
     >> Inventory > Fulfill Stock Requests > Picking > Order Release Request
     View Review Fulfillment Info > Stock Request Status after depleted
     >> Inventory > Fulfill Stock Requests > Review Fulfillment Info > Stock Requests
14.Before running Cost Accounting Creation, ensure Transaction Accounting Rules are set up for INV BU US011, specifically Transaction Group 030 for Shipments
     >> Set Up FIN/SCM > Product Related > Cost Accounting > Transaction Accounting Rules
15.Run Cost Accounting Creation (CM_CSTACCTG) with budget checking for INV BU US011. Check status of cost accounting lines to confirm lines were costed.
     >> Cost Accounting > Inventory & Mfg Accounting > Create Accounting Entries > Cost Accounting Creation
     After run Cost Accounting Creation, check status of cost accounting lines (see all transactions were costed)
     >> Cost Accounting > Inventory & Mfg Accounting > Analyze Inventory > Pending Transactions
16.Review Accounting Lines created for Transaction Group 030, confirm budget status V
     >> Cost Accounting > Inventory & Mfg Accounting > Review Accounting Lines > Accounting Entries
17.Review Budget Details, see PreEncumbrance now $0
    >> Commitment Control > Review Budget Activities > Budget Details
     Drilldown to Activity Log for PreEncumbrance, view rows with chartfield string, budget period and amount
         <1000.00> from MSR
         +1000.00 from Req
     When check "Display Open Pre-Encumbrances Only" checkbox, see only the 1 line
         <1000.00> from MSR
     NOTE: This is the issue; should not see the 1 line for the MSR
18.Back on Review Budget Details, see Expense is now $1000
     Drilldown to Activity Log for Expense, see one row (this is correct)
          +1000.00 from MSR

Changes

Cause

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