My Oracle Support Banner

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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.