R12: JE: (ARXTWMAI) 'ORA-01403 no data found' and next appear the error 'FRM-41084: Error getting Group Cell' (Doc ID 1278955.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

Oracle Financials for EMEA - Version 12 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.
Form:ARXTWMAI.FMB - Transactions
Package: JE.pll
Package: JE.pld
Procedure:ARXTWMAI_PL_TGW_HEADER_GF_BV


Symptoms

When attempting to add transaction, the following error occurs.

ERROR
-----------------------
'ORA-01403 no data found' after entering the customer with receipt and payment method on transaction form.

Next, appear the window with some notes:

Note box:
select cba.bank_account)id
from ce_bank_accounts cba,
ce_bank_acct_uses_ba
where ba. Bank_acct_use_id in
(select distinc remit_bank_acct_use_id
from ar_receipt_method_id = 2020)
and cba.bank_account_id = ba.bank_account_id
and cba.ar_use_allowed_flag = 'Y'
OK is the only option

FRM-41084 Error getting Group Cell

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