ECC ICX Incremental Data Load Does Not Reflect Item Ratings Updates Made In EBS
(Doc ID 2657742.1)
Last updated on APRIL 15, 2020
Applies to:Oracle iProcurement - Version 12.2.8 and later
Information in this document applies to any platform.
ECC ICX Incremental Data Load does not reflect Item Ratings updates made in EBS
The ECC ICX incremental data load for data set icx_catalog does not update the ECC data when updates are made to item ratings in EBS. The reason is the icx_cat_ecc_items_v view used to load / update the ECC icx_catalog data set only uses last_update_date from the icx_cat_punchout_items table to determine when the data was last updated. The table icx_rvw_reviews_summary_tbl, which is also in the icx_cat_ecc_items_v is the table where the last_update has been updated to reflect the record has been changed.
The issue has the following business impact:
Due to this issue, The ECC ICX incremental data load for data set icx_catalog does not update the ECC data when updates are made to item ratings in EBS.
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