(R12) Rows Left In Msc_st_trading_partner_sites With Process_flag=2 After Legacy Collection
(Doc ID 1299202.1)
Last updated on APRIL 04, 2025
Applies to:
Oracle Advanced Supply Chain Planning - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
=== ODM Issue Clarification ===
Client upgraded to R12 (12.1.3) from 11i (could also be from earlier versions of R12) and after that their Legacy Collections started failing with the following symptoms:
Trading Partner Data remains in process_flag= 2 (in process) most likely due to the ORA-01427 error observed in the Request Log
+---------------------------------------------------------------------------+
Advanced Supply Chain Planning: Version : 12.0.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
MSCPPM module: Pre-Process Monitor
+---------------------------------------------------------------------------+
Current system time is 21-FEB-2011 09:36:45
+---------------------------------------------------------------------------+
**Starts**21-FEB-2011 09:36:45
**Ends**21-FEB-2011 09:45:17
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
.
.
.
21-FEB 09:36:50 : UPDATE MSC_ST_LOCATION_ASSOCIATIONS SET process_flag = 2,SR_INSTANCE_ID = 0, company_name = NVL(company_name,:v_my_company) , REQUEST_ID = :request_id , LAST_UPDATE_DATE = :current_date , LAST_UPDATED_BY = :current_user WHERE nvl(process_flag,1) = 1 AND sr_instance_code = :instance_code
21-FEB 09:36:50 : Table Name : MSC_ST_LOCATION_ASSOCIATIONS - No. of Records : 0
21-FEB 09:36:50 : UPDATE MSC_ST_TRADING_PARTNER_SITES SET process_flag = 2,SR_INSTANCE_ID = 0, company_name = NVL(company_name,:v_my_company) , REQUEST_ID = :request_id , LAST_UPDATE_DATE = :current_date , LAST_UPDATED_BY = :current_user WHERE nvl(process_flag,1) = 1 AND sr_instance_code = :instance_code
21-FEB 09:36:50 : Table Name : MSC_ST_TRADING_PARTNER_SITES - No. of Records : 83
21-FEB 09:36:50 : UPDATE MSC_ST_PARTNER_CONTACTS SET process_flag = 2,SR_INSTANCE_ID = 0, company_name = NVL(company_name,:v_my_company) , REQUEST_ID = :request_id , LAST_UPDATE_DATE = :current_date , LAST_UPDATED_BY = :current_user WHERE nvl(process_flag,1) = 1 AND sr_instance_code = :instance_code
.
.
.
21-FEB 09:36:50 : UPDATE MSC_ST_COMPANY_USERS SET process_flag = 2,SR_INSTANCE_ID = 0, company_name = NVL(company_name,:v_my_company) , REQUEST_ID = :request_id , LAST_UPDATE_DATE = :current_date , LAST_UPDATED_BY = :current_user WHERE nvl(process_flag,1) = 1 AND sr_instance_code = :instance_code
21-FEB 09:36:50 : Table Name : MSC_ST_COMPANY_USERS - No. of Records : 0
21-FEB 09:36:50 : The name in GET_MY_COMPANY :My Company
21-FEB 09:36:51 : MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID(9)ORA-01427: single-row subquery returns more than one row
Note that the error might also show itself as:
MSC_ST_UTIL.DERIVE_PARTNER_SITE_ID(12)ORA-01427:single-row subquery returns more than one row
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 |
| Cause |
| Solution |