Create Bank Account Using AR_RECEIPT_API_PUB.CREATE_CASH API Error - CREATE_CASH : ORA-01403: No Data Found (Doc ID 1514677.1)

Last updated on NOVEMBER 17, 2016

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Attempting to use the API  AR_RECEIPT_API_PUB.CREATE_CASH to create bank account and receive the following error:

CREATE_CASH : ORA-01403: No Data Found

The API is being called with the following parameters :

AR_RECEIPT_API_PUB.CREATE_CASH
  (p_api_version => 1.0
  ,p_commit => 'F' --< false, don't commit within the API, commit will be handled externally
  ,p_init_msg_list => 'T' --< true, have the API clear the message list before each call
  ,p_receipt_number => arrech.receipt_number
  ,p_amount => ABS(arrech.amount)
  ,p_currency_code => arrech.currency_code
  ,p_receipt_date => arrech.receipt_date
  ,p_gl_date => arrech.gl_date
  ,p_remittance_bank_account_id => arrech.remit_bank_acct_use_id --GECA R12 Change
  ,p_customer_bank_account_id => arrech.customer_bank_account_id
  ,p_deposit_date => arrech.deposit_date
  ,p_receipt_method_id => arrech.receipt_method_id
  ,p_customer_id => arrech.pay_from_customer
  ,p_exchange_rate_type => arrech.exchange_rate_type
  ,p_exchange_rate => arrech.exchange_rate
  ,p_exchange_rate_date => arrech.exchange_date
  ,p_cr_id => ln_cash_receipt_id --> out variable new cash_receipt_id needed for APPLY
  ,x_return_status => lc_return_status --> out variable
  ,x_msg_count => ln_msg_count --> out variable
  ,x_msg_data => lc_msg_data --> out variable
  );
 

 

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