My Oracle Support Banner

Patching EAM_WORKORDERREP_PVT Is Erring With PL/SQL: ORA-00932: Inconsisitent Datatypes: (Doc ID 2393267.1)

Last updated on APRIL 30, 2018

Applies to:

Oracle Enterprise Asset Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms



After patching APPS.EAM_WORKORDERREP_PVT is erring with PL/SQL: ORA-00932: inconsistent data types: expected CLOB got LONG

Patches applied:


25796080.B FND Recommended Patch Collection (4/2017) ; 22644544.1 Oracle E-Business Suite Release 12.1.3+ Recommended Patch Collection 5 [RPC5] ;23335336.B R12.ADO.B.DELTA.9 ; 27040859.1 ORACLE APPLICATIONS RELEASE 12.1:CPU PATCH FOR JAN 2018 ;18219424.C R.TST1213RPC1: UNABLE CREATE ITEM WITHOUT TEMPLATE IN PWB
19514167.C Didn't create Shopping Category and Mapping in iProcurement by API
20854500.B INV:12.1.3 + Oracle Inventory Recommended Patch Collection (08-Apr-2015).
21610837.C ITEMS RECOMMENDED PATCH COLLECTION ( Aug 2015)
21886153.B In Oracle Inventory Management, it fails to do negative correction against Receive transaction.
22350639.B R12.1: PAYMENTS RECOMMENDED PATCH COLLECTION (IBY) , FEB 2016
22453253.B R12.1: E-BUSINESS TAX RECOMMENDED PATCH COLLECTION (ZX RPC), FEB 2016
22458196.B R12.1: E-BUSINESS TAX REPORTING RECOMMENDED PATCH COLLECTION (ZX Reports RPC), FEB 2016
22687240.B Oracle Projects Release Update Pack 7 for 12.1 (R12.PJ_PF.B.delta.7)
24287284.B Oracle Sourcing Recommended Patch Collection July 2016
24396610.B 12.1.3 - EAM 2016 CONSOLIDATION PATCH
25040280.B CU4 ON PJ_12.1.3.DELTA.7 AND ON PN_12.1.3_DELTA.5 - RELEASE DATE 15-FEB-17
25052442.B In Oracle Purchasing, the amount approved is more than gbpa's amount limit
25671161.B R.TST1227: SQL ERROR WHEN PO RECEIPT
26183102.B In Oracle Purchasing, users can see the receipts of other OUs in po summary form.
27395555.B US & CANADA END OF YEAR 2017 STATUTORY UPDATE III FOR R12.1.X
 

ERROR

PL/SQL: ORA-00932: inconsistent data types: expected CLOB got LONG




STEPS

The issue can be reproduced at will with the following steps:

Apply patches in above list


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!


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