2 Replies Latest reply: Oct 12, 2013 4:01 PM by Cuauhtemoc Amox RSS

    Xml gateway for purchasing in R12.1.3 failing with ORA-06502: PL/SQL: numeric or value error: character to number conversion error - ECX_ACTIONS.BIND_VARIABLES_FOR_VIEW

    steve.g
      Generation Status  http://pintail.hypertherm.com:8046/OA_HTML/cabo/images/swan/t.gifError  http://pintail.hypertherm.com:8046/OA_HTML/cabo/images/swan/t.gif
      Generation Message  http://pintail.hypertherm.com:8046/OA_HTML/cabo/images/swan/t.gifORA-06502: PL/SQL: numeric or value error: character to number conversion error - ECX_ACTIONS.BIND_VARIABLES_FOR_VIEW  http://pintail.hypertherm.com:8046/OA_HTML/cabo/images/swan/t.gif
      Module Name  http://pintail.hypertherm.com:8046/OA_HTML/cabo/images/swan/t.gif

      ecx.plsql.OAG.out.PO.PRO.192126:0:102.8.log

       

       

      • Set up Supplier in XML Gateway - Define Trading Partners
      • New PO: PO-PRO-OAG-PO-PROCESS
      • Change PO: PO-POCO-OAG-PO-CHANGE
      • Created new PO and XML option now shows in approval
      • PO Fails on Send step with error: ORA-06502: PL/SQL: numeric or value error: character to number conversion error - ECX_ACTIONS.BIND_VARIABLES_FOR_VIEW (see attached log)
      • Investigated another Supplier and changing parameters with no luck.
      • Also tried a change PO with no luck

       

      Question:  Is there any information on this error?  I did a log by turning on FND_Logging and it fails at following:

       

           Enter ECX_OUTBOUND.FETCH_DATA_FROM_VIEW

              i_level==>1

              Source level==>8

              target_source_levels==>8

              SQL Statement==>SELECT  NULL, ACCEPTANCE_REQUIRED_FLAG, TO_CHAR(ACCEPTANCE_DUE_DATE,'YYYYMMDD HH24MISS'), BILLTO_ORG_ADD

              R_LINE1, BILLTO_ORG_ADDR_LINE2, BILLTO_ORG_ADDR_LINE3, BILLTO_ORG_CITY, BILLTO_ORG_COUNTRY, BILLTO_ORG_CURRENCY, BILLTO_

              ORG_NAME, BILLTO_ORG_OTF, BILLTO_ORG_PHONE1, BILLTO_ORG_PHONE2, BILLTO_ORG_PHONE3, BILLTO_ORG_STATE, BILLTO_ORG_ZIP, BIL

              LTO_PARTNER_TYPE, BUYER_EMAIL, BUYER_FULL_NAME, TO_CHAR(BUYER_ID), BUYER_TELEPHONE, BUYING_ORG_ADDR_LINE1, BUYING_ORG_AD

              DR_LINE2, BUYING_ORG_ADDR_LINE3, BUYING_ORG_CITY, BUYING_ORG_COUNTRY, BUYING_ORG_CURRENCY, BUYING_ORG_NAME, BUYING_ORG_O

              TF, BUYING_ORG_PARTNER_TYPE, BUYING_ORG_PHONE1, BUYING_ORG_PHONE2, BUYING_ORG_PHONE3, BUYING_ORG_STATE, BUYING_ORG_ZIP,

              CARRIER_ORG_NAME, CARRIER_ORG_OTF, CARRIER_PARTNER_TYPE, COMMENTS, CONFIRMING_ORDER_FLAG, CONTRACTB, TO_CHAR(CREATION_DA

              TE,'YYYYMMDD HH24MISS'), TO_CHAR(END_DATE_ACTIVE,'YYYYMMDD HH24MISS'), FOB_CODE, FOB_DESC, FOB_NAME, FREIGHT_CODE, FREIG

              HT_DESC, FREIGHT_NAME, NOTE_TO_AUTHORIZER, NOTE_TO_RECEIVER, NOTE_TO_VENDOR, NUM_1099, TO_CHAR(ORDER_TOTAL), TO_CHAR(PAR

              TNER_ID), PARTNER_ID_X, PAYMENT_TERMS_DESCRIPTION, TO_CHAR(PAYMENT_TERMS_ID), PAYMENT_TERMS_NAME, TO_CHAR(POID), PO_CURR

              ENCY, TO_CHAR(REVISION_NUM), TO_CHAR(START_DATE_ACTIVE,'YYYYMMDD HH24MISS'), SUPPLIER_ORDER_NUM, TO_CHAR(SUPPLIER_PARTNE

              R_ID), SUPPLIER_PARTNER_ID_X, SUPP_ADDR_LINE1, SUPP_ADDR_LINE2, SUPP_ADDR_LINE3, SUPP_CITY, SUPP_COUNTRY, SUPP_CURRENCY,

               SUPP_ORG_NAME, SUPP_OTF, SUPP_PARTNER_TYPE, SUPP_PHONE, SUP_SITE_CODE, SUPP_STATE, SUPP_ZIP, TYPE_LOOKUP_CODE, TO_CHAR(

              RELEASE_ID), RELEASE_NUM, VAT_REGISTRATION_NUM, EXCHANGE_RATE, TO_CHAR(EXCH_RATE_DATE,'YYYYMMDD HH24MISS'), DFF_HDR_ATTR

              1, DFF_HDR_ATTR2, DFF_HDR_ATTR3, DFF_HDR_ATTR4, DFF_HDR_ATTR5, DFF_HDR_ATTR6, DFF_HDR_ATTR7, DFF_HDR_ATTR8, DFF_HDR_ATTR

              9, DFF_HDR_ATTR10, DFF_HDR_ATTR11, DFF_HDR_ATTR12, DFF_HDR_ATTR13, DFF_HDR_ATTR14, DFF_HDR_ATTR15, DFF_HDR_ATTR16, CARD_

              NAME, CARD_NUM, TO_CHAR(CARD_EXP_DATE,'YYYYMMDD HH24MISS'), DFF_VEND_ATTR1, DFF_VEND_ATTR2, DFF_VEND_ATTR3, DFF_VEND_ATT

              R4, DFF_VEND_ATTR5, DFF_VEND_ATTR6, DFF_VEND_ATTR7, DFF_VEND_ATTR8, DFF_VEND_ATTR9, DFF_VEND_ATTR10, DFF_VEND_ATTR11, DF

              F_VEND_ATTR12, DFF_VEND_ATTR13, DFF_VEND_ATTR14, DFF_VEND_ATTR15, DFF_VEND_ATTR16, DFF_VEND_SITE_ATTR1, DFF_VEND_SITE_AT

              TR2, DFF_VEND_SITE_ATTR3, DFF_VEND_SITE_ATTR4, DFF_VEND_SITE_ATTR5, DFF_VEND_SITE_ATTR6, DFF_VEND_SITE_ATTR7, DFF_VEND_S

              ITE_ATTR8, DFF_VEND_SITE_ATTR9, DFF_VEND_SITE_ATTR10, DFF_VEND_SITE_ATTR11, DFF_VEND_SITE_ATTR12, DFF_VEND_SITE_ATTR13,

              DFF_VEND_SITE_ATTR14, DFF_VEND_SITE_ATTR15, DFF_VEND_SITE_ATTR16, CUSTOMER_NUM, SUPPLIER_FAX, SUPPLIER_EMAIL, SUP_CONTAC

              T_NAME, SUP_CONTACT_PHONE  FROM  PO_ECX_HEADER_ARCH_V  WHERE 1=1   and PO_ECX_HEADER_ARCH_V.POID= :DOCUMENT_ID  and (PO_

              ECX_HEADER_ARCH_V.RELEASE_ID IS NULL OR PO_ECX_HEADER_ARCH_V.RELEASE_ID = 0 OR PO_ECX_HEADER_ARCH_V.RELEASE_ID = :PARAME

              TER1)  and PO_ECX_HEADER_ARCH_V.REVISION_NUM=0

              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==>36

                  i_variable_direction==>G

                  Enter ECX_ACTIONS.FIND_STACK_VARIABLE

                    i_variable_name==>DOCUMENT_ID

                    i_stack_pos==>7

                    bFound==>TRUE

                  Exit ecx_actions.find_stack_variable

                  x_value==>192124:0:102

                  x_stack_var==>TRUE

                  x_stack_pos==>7

                Exit ecx_actions.get_var_attr

                Prev Variable Val ==>192124:0:102

                Prev Variable Pos ==>7

                Data Type==>2

                [ECX_PROGRAM_ERROR] PROGRESS_LEVEL=ECX_ACTIONS.BIND_VARIABLES_FOR_VIEW

                [ECX_ERROR_MESSAGE] ERROR_MESSAGE=ORA-06502: 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

              Enter ECX_OUTBOUND.LOG_SUMMARY

                Processing Summary==>====

                0 row(s) processed for Level : PROCESS_PO_007(0)

                0 row(s) processed for Level : ECX_OAG_CONTROLAREA_V(1)

                0 row(s) processed for Level : PO_ECX_HEADER_ARCH_V(2)

                0 row(s) processed for Level : ECX_MSGNAME_V(3)

                0 row(s) processed for Level : ECX_HEADER_V(4)

                0 row(s) processed for Level : PO_ECX_LINE_ARCH_V(5)

                0 row(s) processed for Level : PO_ECX_LINE_LOC_ARCH_V(6)

                0 row(s) processed for Level : PO_ECX_DISTRBN_ARCH_V(7)

              Exit ecx_outbound.log_summary

            Exit ecx_outbound.process_outbound_documents

            ORA-06502: PL/SQL: numeric or value error: character to number conversion error - ECX_ACTIONS.BIND_VARIABLES_FOR_VIEW

          Exit ecx_outbound.getxml

       

      Any help would be appreciated.

      Steve