Error Occurs While Running Seeded Concurrent Program For Import Standard Purchase Orders
(Doc ID 1636843.1)
Last updated on OCTOBER 02, 2024
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 = ######
************************************
TRANSACTION ID : ######
ORGANIZATION ID : ###
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 : #######
ORGANIZATION ID : ###
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 : ######
ORGANIZATION ID : ###
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 #####.
Review your concurrent request log and/or report output file for more detailed information.
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 = ######
************************************
TRANSACTION ID : ######
ORGANIZATION ID : ###
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 : #######
ORGANIZATION ID : ###
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 : ######
ORGANIZATION ID : ###
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 #####.
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
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 |