My Oracle Support Banner

R12: CE: While Creating a New Bank Account, User Gets Error "The organization already exists for this bank account. Please re-enter." (Doc ID 2825383.1)

Last updated on NOVEMBER 22, 2023

Applies to:

Oracle Cash Management - Version 12.2 and later
Oracle Payables - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

Unable to Create a new Internal Bank Account.

While Creating a New Bank Account, User Gets Error:

The organization already exists for this bank account. Please re-enter."

The FND Debug Log of the issue reproduced shows the following log messages:

MODULE MESSAGE_TEXT
 
... ...
fnd.framework.webui.OAFormValueHelper OAF LOG: Event : Get Attribute Value, in: oracle.apps.fnd.framework.webui.OAFormValueHelper: View:null ,Attribute:ContinueButton$$unvalidated , Return Value without datatype conversion :false
fnd.framework.webui.OAFormValueHelper OAF LOG: Event : Get Attribute Value, in: oracle.apps.fnd.framework.webui.OAFormValueHelper: View:null ,Attribute:ContinueButton$$processFormDataCalled , Return Value without datatype conversion :true
fnd.framework.webui.OAFormValueHelper OAF LOG: Event : Get Attribute Value, in: oracle.apps.fnd.framework.webui.OAFormValueHelper: View:null ,Attribute:FORM_MAC_LIST , Return Value without datatype conversion
:evtSrcRowIdx^_fwkActBtnName_Treasury_check$$serverUnvalidated^lovCriteriaHiddenFieldOrgName^_FORM^BankAccountIdOrg^serverValidate^ContinueButton$$processFormDataCalled^ViewOptions
^CurrencyFormValue^DefaultAcctFlag^BranchId^_hdfpPayables^dbgEna^BankAccountName^_hdfpPayroll^_AM_TX_ID_FIELD^CancelButton$$processFormDataCalled^CancelButton$$unvalidated
^_pkBankAccountAM.AccountAM.BankAcctUsesVOBankAccountId^BankAccountIdTop^_fwkActBtnName_Payroll_check$$serverUnvalidated^evtSrcRowId^BankId^_fwkAbsolutePageName
^lovAutoClearHFOrgName^_pkBankAccountAM.AccountAM.BankAcctUsesVOBankAcctUseId^UpdateOptions^ContinueButton$$serverUnvalidated^_FORM_SUBMIT_BUTTON^_hdfpReceivables
^ContinueButton$$unvalidated^BankAcctUseId^AuthorizedFlag^CountryCode^_FORMEVENT^_hdfpTreasury^_fwkActBtnName_Receivables_check$$serverUnvalidated^BASE_FORM_NAME^AcctOrgId
^_fwkActBtnName_Payables_check$$serverUnvalidated^openPopupSourceId^_pkBankAccountAM.AccountAM.BankAccountsVOBankAccountId^CancelButton$$serverUnvalidated
***@@@FORM_MAC_LIST***@@@lovOnClickJSExecutedHiddenFieldOrgName^OrgName^Payables^Receivables^partialTargets^lovJSHiddenFieldOrgName^lovPassiveCriteriaHFOrgName^EndDate
^OrgTypeDesc^Treasury^OrgId^OrgPartyId^LegalEntityId^source^Payroll^event^lovOnClickJSHiddenFieldOrgName^FORM_MAC_LISTNpERTboF5CbbLx-sVZOIsw..
fnd.framework.webui.OAFormValueHelper OAF LOG: Event : Set Attribute Value, in: oracle.apps.fnd.framework.webui.OAFormValueHelper: OldValue:evtSrcRowIdx^_fwkActBtnName_Treasury_check$$serverUnvalidated
^lovCriteriaHiddenFieldOrgName^_FORM^BankAccountIdOrg^serverValidate^ContinueButton$$processFormDataCalled^ViewOptions^CurrencyFormValue^DefaultAcctFlag^BranchId^_hdfpPayables
^dbgEna^BankAccountName^_hdfpPayroll^_AM_TX_ID_FIELD^CancelButton$$processFormDataCalled^CancelButton$$unvalidated^_pkBankAccountAM.AccountAM.BankAcctUsesVOBankAccountId
^BankAccountIdTop^_fwkActBtnName_Payroll_check$$serverUnvalidated^evtSrcRowId^BankId^_fwkAbsolutePageName^lovAutoClearHFOrgName
^_pkBankAccountAM.AccountAM.BankAcctUsesVOBankAcctUseId^UpdateOptions^ContinueButton$$serverUnvalidated^_FORM_SUBMIT_BUTTON^_hdfpReceivables^ContinueButton$$unvalidated
^BankAcctUseId^AuthorizedFlag^CountryCode^_FORMEVENT^_hdfpTreasury^_fwkActBtnName_Receivables_check$$serverUnvalidated^BASE_FORM_NAME^AcctOrgId
^_fwkActBtnName_Payables_check$$serverUnvalidated^openPopupSourceId^_pkBankAccountAM.AccountAM.BankAccountsVOBankAccountId^CancelButton$$serverUnvalidated
***@@@FORM_MAC_LIST***@@@lovOnClickJSExecutedHiddenFieldOrgName^OrgName^Payables^Receivables^partialTargets^lovJSHiddenFieldOrgName^lovPassiveCriteriaHFOrgName^EndDate
^OrgTypeDesc^Treasury^OrgId^OrgPartyId^LegalEntityId^source^Payroll^event^lovOnClickJSHiddenFieldOrgName^FORM_MAC_LISTNpERTboF5CbbLx-sVZOIsw..
,NewValue:evtSrcRowIdx^_fwkActBtnName_Treasury_check$$serverUnvalidated^lovCriteriaHiddenFieldOrgName^_FORM^BankAccountIdOrg^serverValidate
^ContinueButton$$processFormDataCalled
^ViewOptions^CurrencyFormValue^DefaultAcctFlag^BranchId^_hdfpPayables^dbgEna^BankAccountName^_hdfpPayroll^_AM_TX_ID_FIELD^CancelButton$$processFormDataCalled
^CancelButton$$unvalidated^_pkBankAccountAM.AccountAM.BankAcctUsesVOBankAccountId^BankAccountIdTop^_fwkActBtnName_Payroll_check$$serverUnvalidated^evtSrcRowId^OrgId^BankId
^_fwkAbsolutePageName^lovAutoClearHFOrgName^_pkBankAccountAM.AccountAM.BankAcctUsesVOBankAcctUseId^UpdateOptions^ContinueButton$$serverUnvalidated
^_FORM_SUBMIT_BUTTON^_hdfpReceivables^ContinueButton$$unvalidated^BankAcctUseId^AuthorizedFlag^OrgTypeDesc^CountryCode^_FORMEVENT^_hdfpTreasury
^_fwkActBtnName_Receivables_check$$serverUnvalidated^BASE_FORM_NAME^_fwkActBtnName_Payables_check$$serverUnvalidated^AcctOrgId
^_pkBankAccountAM.AccountAM.BankAccountsVOBankAccountId^openPopupSourceId^CancelButton$$serverUnvalidated
***@@@FORM_MAC_LIST***@@@lovOnClickJSExecutedHiddenFieldOrgName^OrgName^Payables^Receivables^partialTargets^lovJSHiddenFieldOrgName^lovPassiveCriteriaHFOrgName^EndDate
^Treasury^OrgPartyId^LegalEntityId^source^Payroll^event^FORM_MAC_LIST^lovOnClickJSHiddenFieldOrgNamemghvFUl0EIEn8XXkogD8oA..
fnd.profiles.Profiles getProfileOptionValue:  name=OAM_UALERT_SHOW_ICON; levelID=10004; levelValue=1354; levelValueApplID=0
fnd.profiles.Profiles getProfileOptionValue:  name=OAM_UALERT_SHOW_ICON; levelID=10003; levelValue=50675; levelValueApplID=200
fnd.profiles.Profiles getProfileOptionValue:  name=OAM_UALERT_SHOW_ICON; levelID=10002; levelValue=200; levelValueApplID=0
fnd.profiles.Profiles getProfileOptionValue:  name=OAM_UALERT_SHOW_ICON; levelID=10001; levelValue=0; levelValueApplID=0
ce.bankaccount.webui.AccountAccessOrgCO OAF LOG: Event : Call Process Form Request, in: oracle.apps.ce.bankaccount.webui.AccountAccessOrgCO: Entering Process Form Request
fnd.framework.webui.OAFormValueHelper OAF LOG: Event : Get Attribute Value, in: oracle.apps.fnd.framework.webui.OAFormValueHelper: View:BankAcctUsesVO ,Attribute:OrgId , Return Value without datatype conversion :83
fnd.framework.webui.OAFormValueHelper OAF LOG: Event : Get Attribute Value, in: oracle.apps.fnd.framework.webui.OAFormValueHelper: View:BankAcctUsesVO ,Attribute:OrgId , Return Value:83
fnd.framework.webui.OAFormValueHelper OAF LOG: Event : Get Attribute Value, in: oracle.apps.fnd.framework.webui.OAFormValueHelper: View:BankAcctUsesVO ,Attribute:LegalEntityId , Return Value without datatype conversion :null
fnd.framework.webui.OAFormValueHelper OAF LOG: Event : Get Attribute Value, in: oracle.apps.fnd.framework.webui.OAFormValueHelper: View:BankAcctUsesVO ,Attribute:LegalEntityId , Return Value:null
fnd.common.Message.auto_log
CE
fnd.framework.OAException The organization already exists for this bank account.  Please re-enter.
fnd.framework.webui.OAPageErrorHandler OAF LOG: Event : Check Errors, in: oracle.apps.fnd.framework.webui.OAPageErrorHandler: Exception: The organization already exists for this bank account.  Please re-enter. ,In VO: null
fnd.framework.webui.OAPageErrorHandler OAF LOG: Event : Check Errors, in: oracle.apps.fnd.framework.webui.OAPageErrorHandler: Exception: The organization already exists for this bank account.  Please re-enter.
fnd.profiles.Profiles getProfileOptionValue:  name=OAM_UALERT_SHOW_ICON; levelID=10004; levelValue=1354; levelValueApplID=0
fnd.profiles.Profiles getProfileOptionValue:  name=OAM_UALERT_SHOW_ICON; levelID=10003; levelValue=50675; levelValueApplID=200
fnd.profiles.Profiles getProfileOptionValue:  name=OAM_UALERT_SHOW_ICON; levelID=10002; levelValue=200; levelValueApplID=0
fnd.profiles.Profiles getProfileOptionValue:  name=OAM_UALERT_SHOW_ICON; levelID=10001; levelValue=0; levelValueApplID=0
fnd.framework.webui.OAPageErrorHandler OAF LOG: Event : Check Errors, in: oracle.apps.fnd.framework.webui.OAPageErrorHandler: Exception: The organization already exists for this bank account.  Please re-enter. ,In Bean: null
... ...

Notice the highlighted lines.

 

Steps to reproduce:

  1. Log into Oracle Applicaitons using Cash Management responsibility.
  2. Open the "Manage Bank Accounts" OAF Page.
    (N) Setup > Banks > Bank Accounts
  3. Click on [Create]
  4. Enter/Select Country, Bank Name, and Branch Name and click on [Continue].
    This takes you to the "Create Bank Account: Account Owner and Use" OAF Page
  5. Enter/Select "Bank Account Owner" and "Account Use" and click on [Next].
    This takes you to the "Create Bank Account: Account Information" OAF Page
  6. Enter/Select the following, at least: Account Name, Account Number, and Currency and click on [Save and Next]
    This takes you to the "Create Bank Account: Account Controls" OAF Page
  7. Enter/Select the Cash account under "General Controls" and click on [Save and Next]
    This takes you to the "Create Bank Account: Account Access" OAF Page.
  8. Click on [Add Organization Access] to grant access to an organization.
    This takes you to the "Create Bank Account: Organization Access" OAF Page
  9. Enter/Select Account Use and Organization and click on [Continue]
  10. The error raises.

Changes

Fix for Bug 21746955 already installed.  Bug 21746955 - RCA : CREATE BANK ACCOUNT: ACCOUNT ACCESS TAB IS SAVING DUPLICATE RECORDS

Cause

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
Symptoms
Changes
Cause
Solution
References


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