1. Home
  2. Support
Article - CS167819

Transaction fails to publish to Oracle with error "ORA-01422: exact fetch returns more than requested number of rows" in Windchill Enterprise Systems Integration

Modified: 31-May-2023   


Applies To

  • Windchill Enterprise Systems Integration 10.1 to 12.1

Description

  • Transaction failed to publish part to Oracle with error in TIBCO Process Archive Log:
validation of data failed while publishing a Part to Oracle,0000000104,,,,[tibcosoftwareinc][ODBC Oracle Wire Protocol driver][Oracle]ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APPS.PK_TIB_OPENITEM_IMPORT", line 3964
ORA-06512: at line 1,
                   GLOBAL_ATTRIBUTE12 = NULL
                   ASSET_CREATION_CODE = NULL
                   WIP_SUPPLY_TYPE = NULL
YYYY MON DD HH:MM:SS:MS GMT +5  ESI [User Name] - ,16,1:V1,1,1,1,51105,failed to publish Part to Oracle for create,0000000104,,,,[tibcosoftwareinc][ODBC Oracle Wire Protocol driver][Oracle]ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APPS.PK_TIB_OPENITEM_IMPORT", line 3964
ORA-06512: at line 1,
                   DEFAULT_SHIPPING_ORG = NULL
                   DESCRIPTION = c(String)
                   GLOBAL_ATTRIBUTE13 = NULL
                   RETEST_INTERVAL = NULL
  • Following query in ESI user schema from Oracle Apps database returns greater than 1:
SELECT count(*) FROM TIB_INT_MTL_SYS_ITEMS_IFACE WHERE PTC_BATCH='O';
  • Using OOTB script such as MasterConfiguration_OpenItem_all_Mods.sql
This is a printer-friendly version of Article 167819 and may be out of date. For the latest version click CS167819