Skip to Main Content
Forums

E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ERES process is giving error in Case Management

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

Comments

561093
create or replace function ean_13(P_Str In Varchar2) Return Varchar2 Is
l_Sum Number;
l_Multiple Number;
Begin
For I in 1..12 Loop
If mod(i,2) = 0 Then
l_Multiple := 3;
Else
l_Multiple := 1;
End If;

l_Sum := Nvl(l_Sum, 0) + Substr(P_Str, i, 1) * l_Multiple;
End Loop;
If Floor(l_Sum/10) - Mod(l_Sum, 10) = Substr(P_Str, 13) Then
Return('TRUE');
Else
Return('FALSE');
End If;
End;
/


SQL> select ean_13('2741023456884') from dual;

EAN_13('2741023456884')
-------------------------------------------------------
TRUE

SQL> select ean_13('2741023456881') from dual;

EAN_13('2741023456881')
-------------------------------------------------------
FALSE
547235
Thanks for you prompt response,

why it does not work for the following:
2741012605644
2741012605651
2741000000017
it returns false.
561093
create or replace function ean_13(P_Str In Varchar2) Return Varchar2 Is
l_Sum Number;
l_Multiple Number;
Begin
For I in 1..12 Loop
If mod(i,2) = 0 Then
l_Multiple := 3;
Else
l_Multiple := 1;
End If;

l_Sum := Nvl(l_Sum, 0) + Substr(P_Str, i, 1) * l_Multiple;
End Loop;

If 10 - Mod(l_Sum, 10) = Substr(P_Str, 13) Then
Return('TRUE');
Else
Return('FALSE');
End If;
End;
/


SQL> select ean_13('2741012605644') from dual;

EAN_13('2741012605644')
------------------------------------------------
TRUE


SQL> select ean_13('2741012605651') from dual;

EAN_13('2741012605651')
--------------------------------------------------
TRUE


SQL> select ean_13('2741000000017') from dual;

EAN_13('2741000000017')
------------------------------------------------
TRUE
547235
THANKS BUDDY...YOU SAVED MY DAY
547235
HI CITRUS,

DO YOU HAVE THE OUTPUT PROCEDURE FOR GENERATING TEXT FILE FOR THE AIRMILES PROGRAMME

THANKS.
572471 
SQL> with t as (select '2741023456884' str from dual)
  2  --
  3  select decode(substr(10 - mod(sum(substr(str, level, 1) *
  4                             decode(mod(level, 2), 1, 1, 3)),
  5                         10),-1,1),
  6                substr(str, -1, 1),
  7                'TRUE',
  8                'FALSE')
  9    from t
 10  connect by level < length(str)
 11  /

DECODE(SUBSTR(10-MOD(SUM(SUBST
------------------------------
TRUE

SQL>
547235
thanks volder
1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 19 2012
Added on Sep 21 2012
#crm, #customer-experience-cx, #in, #service
0 comments
905 views