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 'oracle.apps.cs.sr.ServiceRequestApproval', 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
SELECT * FROM ECX_MAPPINGS WHERE MAP_CODE like 'oracle.apps.cs.sr.ServiceRequestApproval';

Thanks,
Harish Nunna

Legend

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