R12 Q/A ORG_ID: BANK STATEMENTS LOAD IMPORTED WITH INCORRECT ORG_ID NULL CAUSING NO RECONCILIATION
(Doc ID 1322062.1)
Last updated on MARCH 08, 2017
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.
QUESTIONS: 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 multiple users? Q9: Latest Patches for Bank statement Loader?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!