EGO_ITEM_PUB.PROCESS_ITEMS API Is Validating End Dated Child Orgs Accounts When Update Master Item (Doc ID 2548467.1)

Last updated on JUNE 01, 2023

Applies to:

Symptoms

Problem Statement
When this EGO_ITEM_PUB.PROCESS_ITEMS API runs for Master Organization,
Below error occur cause some COST_OF_SALES_ACCOUNT, SALES_ACCOUNT, EXPENSE_ACCOUNT have been end dated.
But these end dated accounts (Code combinations) are assigned only to the Child Organizations which are End Dated.

Error
Error Messages:
TABLE NAME : MTL_SYSTEM_ITEMS_INTERFACE
COLUMN NAME : COST_OF_SALES_ACCOUNT
MESSAGE NAME : INV_IOI_ERR
ERROR MESSAGE : The Cost of Sales Account specified is not a valid account or has expired in organization

TABLE NAME : MTL_SYSTEM_ITEMS_INTERFACE
COLUMN NAME : SALES_ACCOUNT
MESSAGE NAME : INV_IOI_ERR
ERROR MESSAGE : The Sales Account specified is not valid or has expired for the organization

TABLE NAME : MTL_SYSTEM_ITEMS_INTERFACE
COLUMN NAME : EXPENSE_ACCOUNT
MESSAGE NAME : INV_IOI_ERR
ERROR MESSAGE : The Expense Account specified is not valid or has expired in GL Code Combinations for the Organization's Chart of Accounts.

Steps to Reproduce

1. Run EGO_ITEM_PUB.PROCESS_ITEMS API on master level item
2. STEP2
3. STEP3

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.