R12 OPM Create Batch With Error 'Invalid Item' (Doc ID 2216380.1)

Last updated on MAY 01, 2023

Applies to:

Symptoms

When attempting to create Batch with a specific recipe validity rule,
the following error occurs.

ERROR
Invalid Item

ERROR in inventory debug log
Inv_Transfer_Order_PVT.Trolins: exc error in validate_attributes
Inv_Transfer_Order_PVT.Trolinsexc error in validate_attributes

ERROR in sql trace file
RPC CALL:PROCEDURE APPS.GME_API_MAIN.CREATE_BATCH(P_VALIDATION_LEVEL IN NUMBER, P_INIT_MSG_LIST IN VARCHAR2, X_MESSAGE_COUNT OUT NUMBER, X_MESSAGE_LIST OUT VARCHAR2, X_RETURN_STATUS OUT VARCHAR2, P_BATCH_HEADER_REC IN GME_BATCH_HEADER%ROWTYPE, X_BATCH_HEADER_REC
OUT GME_BATCH_HEADER%ROWTYPE, P_BATCH_SIZE IN NUMBER, P_BATCH_SIZE_UOM IN VARCHAR2, P_CREATION_MODE IN VARCHAR2, P_RECIPE_ID IN NUMBER, P_RECIPE_NO IN VARCHAR2, P_RECIPE_VERSION IN NUMBER, P_PRODUCT_NO IN VARCHAR2, P_PRODUCT_ID IN NUMBER, P_SUM_ALL_PROD_LINES
IN VARCHAR2, P_IGNORE_QTY_BELOW_CAP IN VARCHAR2, P_USE_WORKDAY_CAL IN VARCHAR2, P_CONTIGUITY_OVERRIDE IN VARCHAR2, P_USE_LEAST_COST_VALIDITY_RULE IN VARCHAR2, X_EXCEPTION_MATERIAL_TBL OUT GME_COMMON_PVT.EXCEPTIONS_TAB);
...
SAVEPOINT CREATE_BATCH
...
ROLLBACK TO SAVEPOINT CREATE_BATCH
...
INV_INT_ITMCODE

STEPS
The issue can be reproduced at will with the following steps:
1. Define Item Substitution List for one of ingredient in the specific recipe
2. Create new Batch via the recipe validity rule
3. Saw the error.

Cause

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