Database Objects Going Invalid Daily On MFCS_RDS_CUSTOM
(Doc ID 3060423.1)
Last updated on NOVEMBER 29, 2024
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version 24.0 to 24.1 [Release 24.0 to 24.1]Information in this document applies to any platform.
Goal
Database Objects Going Invalid Daily on MFCS_RDS_CUSTOM
The RDS view 'RDS_WV_ITEM_LOC_SOH_EOD' in the source MFCS schema gets invalidated every day. As a result, the dependent SYNONYMs in the MFCS_RDS_CUSTOM schema, i.e. 'RDS_WV_ITEM_LOC_SOH_EOD' and 'DCV_WV_ITEM_LOC_SOH_EOD', also get invalidated.
Even though the view is compiled the day before, it becomes invalidated the next day.
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 |