BOM Redlining Data Transfer from Agile To Oracle E-Business Does Not Work (Doc ID 1125755.1)

Last updated on JUNE 05, 2017

Applies to:

Agile Product Lifecycle Management Integration Pack for Oracle E-Business Suite - Version 2.5 to 2.5 [Release 2.5]
Information in this document applies to any platform.

Symptoms

When using Agile to E-Business PIP 2.5 and E-Business is version 11.5.10,
Create an ECO in Agile changing the sequence number on the components on the assembly.  The changes are saved and progress through to the PIP integration where it errors with the following error. Error is on the assembly:

TRANSACTION ID : 123456
ORGANIZATION ID : 00
TABLE NAME : MTL_SYSTEM_ITEMS_INTERFACE
COLUMN NAME : MRP_SAFETY_STOCK_CODE
MESSAGE NAME : INV_IOI_MRP_SAF_STK_CODE
ERROR MESSAGE : The column MRP_SAFETY_STOCK_CODE must be either 1 (Non-MRP
Planned) or 2 (MRP Planned Percent).

Changes

 

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