My Oracle Support Banner

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 20, 2020

Applies to:

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


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 :

  (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





To view full details, sign in with your My Oracle Support account.

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

In this Document

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