Firm Planned Order (FPO) Fails When Released For Some Items - Find No BOM/Routing Was Collected (Doc ID 2304810.1)

Last updated on SEPTEMBER 06, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.4 and later
Oracle Process Manufacturing Process Planning - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

12.2.4.1

PROBLEM
-------------
The Auto Release of Planning suggestions for APS failed to create FPO with the following error for OPM batches

GMPRELAP Auto Release of Planning suggestions for APS
.....

GMP Item Effectivity for Group Id = 5187592 is Invalid for Item_no(id) = 103229(489030)
-Primary product does not match the current validity rule.

We noted that the alternate BOM and Routing values in the work bench are null for these items.
Business users confirm they were able to release the FPO without any issue till recently and could able to see alternate BOM and Routing.

Compared
-- Working
ITEM_NAME AAA
INVENTORY_ITEM_ID 1234
SR_INVENTORY_ITEM_ID 4567

-- NOT working - found that BOM / Routing is not collected.
ITEM_NAME BBB
INVENTORY_ITEM_ID 8901
SR_INVENTORY_ITEM_ID 23456

ANALYSIS
----------------
Found that the recipe and formula, routing details are not collected for the Non working item
Ran Data Pull standalone and find they are not pulled into the staging tables - msc_st_boms, msc_st_routings, msc_st_process_effectivity

Got comparison data for items in OPM tables per <Note 2012449.1>

STEPS
--------
Run plan with production box checked so that auto-release process runs at end of plan.

BUSINESS IMPACT
----------------------
cannot use this process for certain items.

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