OPM Accounting Pre-Processor is Giving "Cannot find Item Id <Item_ID> in Organization Id <Organization_ID>" for Items That are Not Used in the Organization (Doc ID 2819422.1)

Last updated on MAY 05, 2023

Applies to:

Symptoms

Customer applied patch 31449247:R12.GMF.C to resolve performance issue in OPM Accounting Pre-Processor (OPP), but now they are getting errors like "Cannot find Item Id 123456 in Organization Id 789" when running for Production source, and they had not gotten these errors previously. These items are in fact not set up in this org, and they do not know why OPP is now looking for them when it did not before. Checking data for two of the items, they are not used in any batches in that org, and none of the formulas that use those items have recipes with either a blank validity rule or a validity rule for this org.

ERROR
-----------------------
On View Update Errors, errors such as the following are seen:

Cannot find Item Id <Item_ID> in Organization Id <Organization_ID>

The log file shows errors such as:

  411 s - gmfxpmupd_compute_matl_sub_yld FM_Item/PM_Org: <item_id><organization_id>
  411 s - gmfxupd_item_search item/org <item_id><organization_id>
  411 s - Item Ptr Null item_id - <item_id>, organization_id - <organization_id>Not Found
  411 s - gmfxpmupd_compute_matl_sub_yld FM_Item/PM_Org: <item_id><organization_id>
  411 s - gmfxupd_item_search item/org <item_id><organization_id>
  411 s - Item Ptr Null item_id - <item_id>, organization_id - <organization_id>Not Found

The actual item_id's and organization_id are shown in the messages.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run OPM PreProcessor (OPM Financials > OPM Accounting Pre-Processor).
2. Check error messages (from OPM Accounting Pre-Processor screen, go to Actions > View Error Messages).
3. Check log file (from OPM Accounting Pre-Processor screen, click View Log button).

Changes

Customer applied patch 31449247:R12.GMF.C.

Cause

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