3 Replies Latest reply: Jan 24, 2013 12:26 PM by Hussein Sawwan-Oracle RSS

    ARP_PROC_RECEIPTS1.update_cash_receipt throws error while manual execution

    skmVivek
      Hi All,

      I am working on oracle apps AR implementation process in r12.

      I have a requirement for updating the receipt information in my custom code, so i am using using ARP_PROC_RECEIPTS1.update_cash_receipt procedure for updating the receipt details.

      But i am facing following errors while executing this procedure.

      Error

      ORA-06502: PL/SQL: numeric or value error
      ORA-06512: at "APPS.ARP_PROC_RECEIPTS1", line 1775
      ORA-06512: at line 235

      I am passing following input parameters for this oracle procedure.

      p_cash_receipt_id: 152443
      p_status: CONFIRMED
      p_currency_code: USD
      p_amount: 55
      p_pay_from_customer: 117738
      p_receipt_number: 10723
      p_receipt_date: 19-JAN-13
      p_gl_date: 19-JAN-13
      p_maturity_date: 19-JAN-13
      p_comments:
      p_exchange_rate_type:
      p_exchange_rate:
      p_exchange_date:
      p_attribute_category:
      p_attribute1:
      p_attribute2:
      p_attribute3:
      p_attribute4:
      p_attribute5:
      p_attribute6:
      p_attribute7:
      p_attribute8:
      p_attribute9:
      p_attribute10:
      p_attribute11:
      p_attribute12:
      p_attribute13:
      p_attribute14:
      p_attribute15:
      p_override_remit_account_flag: Y
      p_remittance_bank_account_id: 10010
      p_customer_bank_account_id:
      p_customer_site_use_id: 13878
      p_customer_receipt_reference:
      p_factor_discount_amount:
      p_deposit_date: 19-JAN-13
      p_receipt_method_id: 1121
      p_doc_sequence_value: 10723
      p_doc_sequence_id: 500
      p_ussgl_transaction_code:
      p_vat_tax_id:
      p_confirm_date: 19-JAN-13
      p_confirm_gl_date: 19-JAN-13
      p_unconfirm_gl_date:
      p_postmark_date:
      p_rate_adjust_gl_date:
      p_new_exchange_date:
      p_new_exchange_rate:
      p_new_exchange_rate_type:
      p_gain_loss:
      p_exchange_rate_attr_cat:
      p_exchange_rate_attr1:
      p_exchange_rate_attr2:
      p_exchange_rate_attr3:
      p_exchange_rate_attr4:
      p_exchange_rate_attr5:
      p_exchange_rate_attr6:
      p_exchange_rate_attr7:
      p_exchange_rate_attr8:
      p_exchange_rate_attr9:
      p_exchange_rate_attr10:
      p_exchange_rate_attr11:
      p_exchange_rate_attr12:
      p_exchange_rate_attr13:
      p_exchange_rate_attr14:
      p_exchange_rate_attr15:
      p_reversal_date:
      p_reversal_gl_date:
      p_reversal_category:
      p_reversal_comments:
      p_reversal_reason_code:
      p_dm_reversal_flag: N
      p_dm_cust_trx_type_id:
      p_dm_cust_trx_type:
      p_cc_id:
      p_dm_number:
      p_dm_doc_sequence_value:
      p_dm_doc_sequence_id:
      p_tw_status:
      p_anticipated_clearing_date:
      p_customer_bank_branch_id:
      p_global_attribute1:
      p_global_attribute2:
      p_global_attribute3:
      p_global_attribute4:
      p_global_attribute5:
      p_global_attribute6:
      p_global_attribute7:
      p_global_attribute8:
      p_global_attribute9:
      p_global_attribute10:
      p_global_attribute11:
      p_global_attribute12:
      p_global_attribute13:
      p_global_attribute14:
      p_global_attribute15:
      p_global_attribute16:
      p_global_attribute17:
      p_global_attribute18:
      p_global_attribute19:
      p_global_attribute20:
      p_global_attribute_category:
      p_issuer_name:
      p_issue_date:
      p_issuer_bank_branch_id:
      p_application_notes:
      p_new_state:
      p_new_state_dsp:
      p_new_status:
      p_new_status_dsp:
      p_form_name: ARXRWRCT
      p_form_version: 70.1
      p_payment_server_order_num:
      p_approval_code: 1234567890
      p_legal_entity_id: 204
      p_payment_trxn_extension_id: 80539
      p_automatch_set_id:
      p_autoapply_flag:


      Could you please help.

      Thanks,
        • 1. Re: ARP_PROC_RECEIPTS1.update_cash_receipt throws error while manual execution
          Hussein Sawwan-Oracle
          I have a requirement for updating the receipt information in my custom code, so i am using using ARP_PROC_RECEIPTS1.update_cash_receipt procedure for updating the receipt details.
          Do you have the latest patches applied?

          After applying Patch 13694711 Unable To Update Anything After Saving As An Unidentified Receipt Or Unapplied Receipt [ID 1433035.1]
          Comments on Receipts Window Cannot be Updated to NULL [ID 1470192.1]
          But i am facing following errors while executing this procedure.

          Error

          ORA-06502: PL/SQL: numeric or value error
          ORA-06512: at "APPS.ARP_PROC_RECEIPTS1", line 1775
          ORA-06512: at line 235
          Please check line 235 in the package body code and make sure you are passing the correct value.

          OERR: ORA 6502 PL/SQL: numeric or value error [ID 20063.1]
          Master Note for Diagnosing ORA-06502 Error [ID 1137237.1]

          Thanks,
          Hussein
          • 2. Re: ARP_PROC_RECEIPTS1.update_cash_receipt throws error while manual execution
            skmVivek
            No, we did not applied any new patches.

            13694711 patch is not applied in our instance.

            Comments in receipt window is updatable.

            In package body line 235 declared the below variable,

            p_global_attribute17          IN VARCHAR2,

            we passing NULL value for this parameter while execution.

            Thanks,
            • 3. Re: ARP_PROC_RECEIPTS1.update_cash_receipt throws error while manual execution
              Hussein Sawwan-Oracle
              skmVivek  wrote:
              No, we did not applied any new patches.

              13694711 patch is not applied in our instance.
              Can you apply them and see if this helps?
              Comments in receipt window is updatable.

              In package body line 235 declared the below variable,

              p_global_attribute17          IN VARCHAR2,

              we passing NULL value for this parameter while execution.
              Please pass a value to this variable and see if you get the same error -- http://etrm.oracle.com/pls/et1211d9/etrm_pnav.show_details?c_name=ARP_PROC_RECEIPTS1&c_owner=APPS&c_type=PACKAGE%20BODY&c_detail_type=source

              Thanks,
              Hussein