Fusion HCM BIP Notifications: How to Identify BIP Reports Accessing DATA_CACHE Column and Replace References with XMLType
(Doc ID 2692905.1)
Last updated on MAY 18, 2023
Applies to:
Oracle Fusion Global Human Resources Cloud Service - Version 11.13.20.07.0 and laterInformation in this document applies to any platform.
Goal
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).
To take advantage of the performance gains by using the new column in BIP notifications and customer reports, we encourage you to replace the deprecated column in your reports.
Transaction data is stored in the below 2 table columns as follows:
| HRC_TXN_DATA.DATA_CACHE | HRC_TXN_HEADER.XML_DATA_CACHE | |
| Transactions created from Release 20C to Release 21B | Available | Available |
| Transactions created from Release 21C | Not available. Column will be empty. | Available |
Solution
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
| Goal |
| Solution |
| References |