My Oracle Support Banner

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

Last updated on AUGUST 07, 2021

Applies to:

Oracle Item Master - Version 12.1.3 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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