For more information, please refer to this announcement explaining best practices for getting answers to questions.
ORA-06553: PLS-306: wrong number or types of arguments in call to 'XMLTYPE'
Summary:
When trying to replace HRC_TXN_DATA.DATA_CACHE with HRC_TXN_HEADER.XML_DATA_CACHE; facing error - ORA-06553: PLS-306: wrong number or types of arguments in call to 'XMLTYPE'
Content (required):
As in Fusion Cloud Applications Update 21C, Oracle will deprecate a column in a table in the BIP Data Models (HRC_TXN_DATA.DATA_CACHE). Starting in Update 20C, a replacement column has been created (HRC_TXN_HEADER.XML_DATA_CACHE).
(For details ,please go to https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=73512892579936&id=2692905.1&_afrWindowMode=0&_adf.ctrl-state=ixhwhgk2s_53)
When trying to replace HRC_TXN_DATA.DATA_CACHE with HRC_TXN_HEADER.XML_DATA_CACHE; facing error - ORA-06553: PLS-306: wrong number or types of arguments in call to 'XMLTYPE'