PO XML Error: ORA-06502: PL/SQL: Numeric or Value Error ECX_ACTIONS.BIND_VARIABLES_FOR_VIEW (Doc ID 332727.1)

Last updated on FEBRUARY 01, 2023

Applies to:

Symptoms

POXML workflow errors out as follows:

An Error occurred in the following Workflow.
    Item Type = POXML
    Item Key = 287-1095
    User Key =
    Error Name = ECX_PROGRAM_EXIT_EMBD
    Error Message = 6012: XML Gateway process aborted : 'ORA-6502: PL/SQL: numeric
    or value error: character to number conversion error -
    ECX_ACTIONS.BIND_VARIABLES_FOR_VIEW'. For further details, see the log
    corresponding to FND-Logging AFLOG MODULE Name:
    'ecx.plsql.OAG.out.PO.PRO.10040:0:0.63.log'.
    Error Stack =
    ECX_STANDARD.getXMLCover(OAG, PO, PRO)
    ECX_STANDARD.getXMLTP(POXML, 287-1095, 149097, RUN)
    Wf_Engine_Util.Function_Call(ECX_STANDARD.GETXMLTP, POXML, 287-1095,149097, RUN)
    Activity Id = 149097
    Activity Label = POXMLSEND:GETTPXML
    Result Code = #EXCEPTION
    Notification Id =
    Assigned User =

The xml log file indicates the following error:
.
Enter ECX_ACTIONS.BIND_VARIABLES_FOR_VIEW
              Bind Variable Name ==>DOCUMENT_ID
              Enter ECX_ACTIONS.GET_VAR_ATTR
                i_variable_level==>0
                i_variable_name==>DOCUMENT_ID
                i_variable_pos==>1
                i_variable_direction==>G
                Enter ECX_ACTIONS.FIND_STACK_VARIABLE
                  i_variable_name==>DOCUMENT_ID
                  i_stack_pos==>3
                  bFound==>TRUE
                Exit ecx_actions.find_stack_variable
                x_value==>10025:1:0
                x_stack_var==>TRUE
                x_stack_pos==>3
              Exit ecx_actions.get_var_attr
              Prev Variable Val ==>10025:1:0
              Prev Variable Pos ==>3
              Data Type==>2
              [ECX_PROGRAM_ERROR]
PROGRESS_LEVEL=ECX_ACTIONS.BIND_VARIABLES_FOR_VIEW
              [ECX_ERROR_MESSAGE] ERROR_MESSAGE=ORA-6502: PL/SQL: numeric or
value error: character
    to number conversion error
            Exit ecx_actions.bind_variables_for_view
            Clean-up i_stack, l_node_stack, i_tmpxml and last_printed
          Exit ecx_outbound.process_outbound_documents
          ORA-6502: PL/SQL: numeric or value error: character to number
conversion error -
    ECX_ACTIONS.BIND_VARIABLES_FOR_VIEW
        Exit ecx_outbound.getxml

Changes

Upgraded to 11.5.10. This can occur in R12 as well.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.