R12:CE: Org_id: Bank Statements Load Imported With Incorrect org_Id Null Causing No Reconciliation (Doc ID 1322062.1)

Last updated on JULY 16, 2024

Applies to:

Symptoms

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.