R12 Q/A ORG_ID: BANK STATEMENTS LOAD IMPORTED WITH INCORRECT ORG_ID NULL CAUSING NO RECONCILIATION
Last updated on MARCH 08, 2017
Applies to:Oracle Cash Management - Version 12.0.0 to 12.2.4 [Release 12 to 12.2]
Information in this document applies to any platform.
Scenario: On : 12.1.3 version, Bank Statement Load and Import and Autoreconciliation
You have Migrated from 11i to R12: When Bank Statements are Loaded / Imported this is with incorrect ORG_ID value NULL This is resulting in No Reconciliation for many Transactions.
Bank statements were getting loaded with the default ORG_ID as per the profile set for the user. Bank statements are per bank account which are owned by legal entity. A bank account can have access to multiple OU's so defaulting an OU is misleading. Note that org_id having a value or not has no impact on reconciliation or accounting.
The org_id column was more of an 11i requirement where bank accounts were setup per operating unit. That is not the case in R12. Hence the org_id column is not populated when a bank statement is loaded.
Further: Following will point out the issue clearly:
select * from ce_bank_accounts
where bank_account_num in( '')
order by bank_account_num
You will observe that bank account number is same however there more then one bank_account_id, this is because in 11i bank account were created for each org and hence when you migrate to R12 all such bank account are identified as separate bank account.
Q1: Please clarify Bank Statement Loader function for Operating Unit (OU)?
Q2: Whether R12 allow to share a bank account across multiple operating units (yes)?
Q3: Whether you will be able to run autoreconciliation against the account for any bank statements you import (not sure).
Q4: If so, two questions: First, would a single user be able to run the autoreconciliation for both operating units assuming you had proper access?
Q5: Second, could the autoreconciliation process be run partially, once for each operating unit by
Q9: Latest Patches for Bank statement Loader?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms