Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Data Exchange ORA-38141: SQL plan baseline SQL_PLAN_7sk2xfbbyuh0s07759eef does not exist

in EPM Platform and Freeform 2 comments

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!