This discussion is archived
0 Replies Latest reply: Sep 21, 2012 4:53 AM by Harish Nunna RSS

ERES process is giving error in Case Management

Harish Nunna Newbie
Currently Being Moderated
Hi All,

I am trying to implement ERES in Case Management -> Agent Dashboard -> Case Summary (click on 'E-Record' button).

I have done the setups as mentioned in the Doc ID 1067744.1.
I am facing the below issues
1. As per the step 9 (Expected results), 'E-Record Details' is not enabled in 'Tools1' menu. It's still disabled.
2. As per the step 11, I am able to test the AME setups - No Issues.
3. As per the step 6 (ERES Administrator), when I validate the event '', I am getting the below error under XML Payload.

An unexpected error has occurred while generating the XML payload. ORA-20001: The DB to XML transformation has failed with the following error: ECX_MAP_NOT_FOUND. The log file details are: ecx.plsql.out.61034.1609.log ORA-06512: at "APPS.APP_EXCEPTION", line 72 ORA-06512: at "APPS.EDR_UTILITIES", line 1488 ORA-06512: at line 2

Could anyone help me to resolve this error for "ECX_MAP_NOT_FOUND"?

I noticed that there is NO data in ECX_MAPPINGS table for the event when I run the below query

Harish Nunna


  • Correct Answers - 10 points
  • Helpful Answers - 5 points