0 Replies Latest reply: Sep 21, 2012 6:53 AM by Harish Nunna RSS

    ERES process is giving error in Case Management

    Harish Nunna
      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