Approval Email Notifications Errors: ORA-06502: PL/SQL: numeric or value error: associative array shape is not consistent with session parameters (Doc ID 465146.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Purchasing - Version 11.5.10 to 12.0.6 [Release 11.5 to 12]
Information in this document applies to any platform.

Symptoms

After upgrading to Oracle 10.2.0.3,  users do not get the notifications through e-mail when the requisition or the purchase order is approved. Instead you found a workflow error similar to the ones described below:

Error for Purchase Requisition Notifications:

Activity : PO_REQ_APPROVED
Result : #MAIL
Error_Name : WF_ERROR
Error_Message: [WF_ERROR] ERROR_MESSAGE=3835: Error '-20001 - ORA-20001: Oracle
error -6502: ORA-06502: PL/SQL: numeric or value error: associative array shape is not consistent with session parameters has been detected in fnd_global.put(CONC_LOGIN_ID,-1).' encountered during execution of Generate function 'WF_XML.Generate' for event 'oracle.apps.wf.notification.send'.

ERROR_STACK=
Error_Stack : PO_REQAPPROVAL_LAUNCH.POREQ_SELECTOR(REQAPPRV, 535706-320784, SET_CTX)
Wf_Engine_Util.Function_Call(PO_REQAPPROVAL_LAUNCH.POREQ_SELECTOR, REQAPPRV,535706-320784, SET_CTX)
Wf_Engine_Util.Execute_Selector_Function(REQAPPRV, 535706-320784, SET_CTX)
Wf_Engine_Util.Function_Call(PO_REQAPPROVAL_LAUNCH.POREQ_SELECTOR, REQAPPRV,535706-320784, TEST_CTX)
Wf_Engine_Util.Execute_Selector_Function(REQAPPRV, 535706-320784, TEST_CTX)
Wf_Engine.CB(TESTCTX, REQAPPRV:535706-320784:281449, ::::)
Wf_Engine.oldCB(TESTCTX, REQAPPRV:535706-320784:281449, ::::)
WF_MAIL.SetContext(5574873)
WF_XML.GenerateDoc(oracle.apps.wf.notification.send, 5574873)
WF_XML.Generate(oracle.apps.wf.notification.send, 5574873)
Wf_Event.setMessage(oracle.apps.wf.notification.send, 5574873, WF_XML.Generate)
Wf_Event.dispatch_internal()

Error for Purchase Order Notifications:

Activity : EMAIL_PO_PDF_SUPP
Result : #MAIL
Error_Name : WF_ERROR
Error_Message: 3835: Error '-6502 - ORA-06502: PL/SQL: numeric or value error: associative array shape is not consistent with session parameters' encountered during execution of Generate function 'WF_XML.Generate' for event' oracle.apps.wf.notification.send'.
Error_Stack :PO_REQAPPROVAL_LAUNCH.POREQ_SELECTOR(POAPPRV, 20722-84382, TEST_CTX)
Wf_Engine_Util.Function_Call(PO_REQAPPROVAL_LAUNCH.POREQ_SELECTOR, POAPPRV, 20722-84382, TEST_CTX)
Wf_Engine_Util.Execute_Selector_Function(POAPPRV, 20722-84382, TEST_CTX)
Wf_Engine_Util.Function_Call(PO_REQAPPROVAL_LAUNCH.POREQ_SELECTOR, POAPPRV, 20722-84382, TEST_CTX)
Wf_Engine_Util.Execute_Selector_Function(POAPPRV, 20722-84382, TEST_CTX)
Wf_Engine.CB(TESTCTX, POAPPRV:20722-84382:211264, ::::)
Wf_Engine.oldCB(TESTCTX, POAPPRV:20722-84382:211264, ::::)
WF_MAIL.SetContext(442340)
WF_XML.GenerateDoc(oracle.apps.wf.notification.send, 442340)
WF_XML.Generate(oracle.apps.wf.notification.send, 442340)
Wf_Event.setMessage(oracle.apps.wf.notification.send, 442340, WF_XML.Generate)
Wf_Event.dispatch_internal()

Also seen in some error messages: Error Message = 6012: XML Gateway process aborted : 'ORA-06502: PL/SQL: numeric or value error: associative array shape is not consistent with session parameters - ECX_OUTBOUND.FETCH_DATA_FROM_VIEW'.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms