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

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.

Symptoms


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?

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