Data Exchange ORA-38141: SQL plan baseline SQL_PLAN_7sk2xfbbyuh0s07759eef does not exist
Loads are failing in Prod and we think the error is shown in the following lines of log:
2024-11-08 13:59:06,840 INFO [AIF]: Fetching dim col mapping for Application:FinRptgMGMT, Load Id:133982, DLC Flag:false, Target App Sub Type:null
2024-11-08 13:59:06,934 ERROR [AIF]: Error getting Dimensions mapping details:ORA-38141: SQL plan baseline SQL_PLAN_7sk2xfbbyuh0s07759eef does not exist
2024-11-08 13:59:06,934 DEBUG [AIF]: ORA-38141: SQL plan baseline SQL_PLAN_7sk2xfbbyuh0s07759eef does not exist
2024-11-08 13:59:06,934 ERROR [AIF]: Error in importData:ORA-38141: SQL plan baseline SQL_PLAN_7sk2xfbbyuh0s07759eef does not exist
2024-11-08 13:59:06,937 ERROR [AIF]: java.lang.RuntimeException: ORA-38141: SQL plan baseline SQL_PLAN_7sk2xfbbyuh0s07759eef does not exist