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 JANUARY 21, 2022
Applies to:
Oracle Payables - Version 12.2.10 and laterInformation in this document applies to any platform.
Symptoms
Unable to Create a new 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
-----------------------
The issue can be reproduced at will with the following steps:
- Log into Oracle Applicaitons using Cash Management responsibility.
- Open the "Manage Bank Accounts" OAF Page.
(N) Setup > Banks > Bank Accounts - Click on [Create]
- 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 - Enter/Select "Bank Account Owner" and "Account Use" and click on [Next].
This takes you to the "Create Bank Account: Account Information" OAF Page - 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 - 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. - Click on [Add Organization Access] to grant access to an organization.
This takes you to the "Create Bank Account: Organization Access" OAF Page - Enter/Select Account Use and Organization and click on [Continue]
- 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 |