Error Occurs While Running Seeded Concurrent Program For Import Standard Purchase Orders (Doc ID 1636843.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle Purchasing - Version 12.1 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.2.3 version, Purchasing Processes,


When attempting to run the "Import Standard Purchase Orders" program after migration from 11i, the following error occurs.

+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
To get the log messages for PDOI, please use the following id to query against FND_LOG_MESSAGES table:
AUDSID = 337350523
************************************
TRANSACTION ID : 6929797
ORGANIZATION ID : 471
TABLE NAME : MTL_SYSTEM_ITEMS_INTERFACE
COLUMN NAME : MASTER_CHILD_1D
MESSAGE NAME : INV_IOI_MASTER_CHILD_1D
ERROR MESSAGE : Master - Child Conflict: Catalog Status(CATALOG_STATUS_FLAG), Returnable(RETURNABLE_FLAG), Default Shipping Organization(DEFAULT_SHIPPING_ORG), Collateral Item(COLLATERAL_FLAG), Taxable(TAXABLE_FLAG), Action(QTY_RCV_EXCEPTION_CODE), Allow Description Update(ALLOW_ITEM_DESC_UPDATE_FLAG), Inspection Required(INSPECTION_REQUIRED_FLAG), Receipt Required(RECEIPT_REQUIRED_FLAG), Market Price(MARKET_PRICE), Input Tax Classification Code(PURCHASING_TAX_CODE).
************************************
TRANSACTION ID : 6929797
ORGANIZATION ID : 471
TABLE NAME : MTL_SYSTEM_ITEMS_INTERFACE
COLUMN NAME : MASTER_CHILD_1G
MESSAGE NAME : INV_IOI_MASTER_CHILD_1G
ERROR MESSAGE : Master - Child Conflict in one of these Attributes: Action(RECEIPT_DAYS_EXCEPTION_CODE), Receipt Routing(RECEIVING_ROUTING_ID), Invoice Close Tolerance Percentage(INVOICE_CLOSE_TOLERANCE), Receipt Close Tolerance Percentage(RECEIVE_CLOSE_TOLERANCE), Starting Lot Prefix(AUTO_LOT_ALPHA_PREFIX), Description(DESCRIPTION), Long Description(LONG_DESCRIPTION).
************************************
TRANSACTION ID : 6929798
ORGANIZATION ID : 471
TABLE NAME : MTL_ITEM_REVISIONS_INTERFACE
COLUMN NAME : ITEM_ID
MESSAGE NAME : INV_IOI_REV_NO_ITEM
ERROR MESSAGE : The revision entered is for an item that does not exist in MTL_SYSTEM_ITEMS nor MTL_SYSTEM_ITEMS_INTERFACE.
ORA-01427: single-row subquery returns more than one row in Package po.plsql.PO_PDOI_ITEM_PROCESS_PVT. Procedure insert_master_item.90
ORA-01427: single-row subquery returns more than one row in Package po.plsql.PO_PDOI_ITEM_PROCESS_PVT. Procedure create_items.50
ORA-01427: single-row subquery returns more than one row in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process_lines_add.70
ORA-01427: single-row subquery returns more than one row in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process_lines.10
ORA-01427: single-row subquery returns more than one row in Package po.plsql.PO_PDOI_MAINPROC_PVT. Procedure process.10
ORA-01427: single-row subquery returns more than one row in Package po.plsql.PO_PDOI_PVT. Procedure start_process.110
User-Defined Exception in Package po.plsql.PO_PDOI_Concurrent. Procedure POXPDOI.30
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+



Concurrent Manager encountered an error while running SQL*Plus for your concurrent request 93290379.

Review your concurrent request log and/or report output file for more detailed information.



The issue can be reproduced at will with the following steps:
1. Purchasing responsibility > Requests > Run "Import Standard Purchase Orders" program


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