Adjust Supporting Reference Initial Balances
Supporting References provides you the flexibility to store and report on additional information about a subledger journal at the journal line level.
You can choose to use supporting references with balances to record subledger balances for a source using a combination of supporting references plus the chart of account combination.
The Import Supporting Reference Initial Balances spreadsheet lets you upload the initial balances for Supporting References. The initial balance is the starting balance for a supporting reference in the context of an application, ledger, and account combination.
Access the task from the Setup and Maintenance work area.
Initialize Supporting Reference Balances when no balances exist
Let's say you already maintain a balance for certain dimensions in the legacy system which aren't available in Oracle Fusion and want to bring in those balances when migrating to Oracle Fusion Cloud ERP. Let's assume supporting reference balances are to be initialized against the supporting references - Account Number, Customer Category, Line Type, Country Code, State Code as follows:
|
Ledger |
Subledger |
Period |
Account Combination |
Currency |
Balance (Debit) |
Balance (Credit) |
Account Number |
Customer Category |
Line Type |
Country Code |
State Code |
|---|---|---|---|---|---|---|---|---|---|---|---|
|
Vision Operations |
Payables |
Jun-20 |
01-120-2210-0000-000 |
USD |
12654 |
76768 |
Gold |
Goods |
US |
NY |
|
|
Vision Operations |
Payables |
Jun-20 |
01-120-2210-0000-000 |
USD |
2030 |
76576 |
Silver |
Services |
US |
CA |
You must navigate to the Adjust Supporting Reference Balances task and download the spreadsheet template. Use the Adjust Supporting Reference Balances ADFdi spreadsheet to initialize supporting reference balances for the supporting references - Account Number, Customer Category, Line Type, Country Code, State Code. The journal entry that gets created in the background doesn't have supporting reference information for both sides that’s, the supporting reference is NULL for the offsetting entry. In this example journal entries get created as follows:
|
Period |
Account Combination |
Entered (Debit) |
Entered (Credit) |
Currency |
Accounted (Debit) |
Accounted (Credit) |
ANALYTICAL_BALANCE_FLAG |
SR1 |
SR2 |
SR3 |
SR4 |
SR5 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
6/20/2021 |
01-120-2210-0000-000 |
12654 |
EUR |
15050 |
P |
76768 |
Gold |
Goods |
US |
NY |
||
|
6/20/2021 |
01-120-2210-0000-000 |
12654 |
EUR |
15050 |
||||||||
|
6/20/2021 |
01-110-2240-0000-000 |
2030 |
USD |
2030 |
P |
76456 |
Silver |
Services |
US |
CA |
||
|
6/20/2021 |
01-110-2240-0000-000 |
2030 |
USD |
2030 |
The journal entries created for initializing the supporting reference balances are created in Final status but not transferred to GL, if all validations are successful. If you don't want balances to be maintained in the entered currency ( XLA_ENABLE_ENTERED_CURR_BAL_SUPP_REF is disabled), the supporting reference balances table is updated as follows on initialization:
|
LEDGER_ID |
APPL_ID |
PERIOD |
CCID |
PERIOD_BALANCE_DR |
PERIOD_BALANCE_CR |
SR1 |
SR2 |
SR3 |
SR4 |
SR5 |
|---|---|---|---|---|---|---|---|---|---|---|
|
1 |
200 |
6/20/2021 |
01-120-2210-0000-000 |
15050 |
76768 |
Gold |
Goods |
US |
NY |
|
|
1 |
200 |
6/20/2021 |
01-110-2240-0000-000 |
2030 |
76456 |
Silver |
Services |
US |
CA |
If you maintain balances in the entered currency (XLA_ENABLE_ENTERED_CURR_BAL_SUPP_REF is enabled), the supporting reference balances table is updated as follows on initialization:
|
LEDGER_ID |
APPL_ID |
PERIOD |
CCID |
PERIOD_BALANCE_DR |
PERIOD_BALANCE_CR |
PERIOD_ENTERED_BALANCE_DR |
PERIOD_ENTERED_BALANCE_CR |
ENTERED_CURRENCY_CODE |
SR1 |
SR2 |
SR3 |
SR4 |
SR5 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1 |
200 |
6/20/2021 |
01-120-2210-0000-000 |
15050 |
12654 |
EUR |
12654 |
Gold |
Goods |
US |
NY |
||
|
1 |
200 |
6/20/2021 |
01-110-2240-0000-000 |
2030 |
2030 |
USD |
76456 |
Silver |
Services |
US |
CA |
Adjust Supporting Reference Balances when balances exist
Let's say supporting reference balances already exist and you just want to adjust the balances. Assuming supporting reference balances are existing for the following account and supporting reference combination in the XLA_AC_BALANCES table and you want to do an upward adjustment of 200.00 USD.
|
LEDGER_ID |
APPL_ID |
PERIOD |
CCID |
PERIOD_BALANCE_DR |
PERIOD_BALANCE_CR |
SR1 |
SR2 |
SR3 |
SR4 |
SR5 |
|---|---|---|---|---|---|---|---|---|---|---|
|
1 |
200 |
6/20/2021 |
01-120-1210-0000-000 |
12354 |
76768 |
Bronze |
Goods |
US |
NY |
Navigate to the Adjust Supporting Reference Balances task and downloads the spreadsheet template. Use the Adjust Supporting Reference Balances ADFdi spreadsheet to update supporting reference balances.
Manual journal entry is created in the background having supporting reference information for one of the lines which is used to adjust balances, supporting reference is NULL for the offsetting entry. In this example journal entries get created as follows:
|
Period |
Account Combination |
Entered (Debit) |
Entered (Credit) |
Currency |
Accounted (Debit) |
Accounted (Credit) |
ANALYTICAL_BALANCE_FLAG |
SR1 |
SR2 |
SR3 |
SR4 |
SR5 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
6/20/2021 |
01-120-1210-0000-000 |
200 |
USD |
200 |
P |
76768 |
Bronze |
Goods |
US |
NY |
||
|
6/20/2021 |
01-120-1210-0000-000 |
200 |
USD |
200 |
The journal entries created for adjusting the supporting reference balances are created in Final status but not transferred to GL, if all validations are successful. If you don't want balances to be maintained in the entered currency (XLA_ENABLE_ENTERED_CURR_BAL_SUPP_REF is disabled), the supporting reference balances table is updated as follows on initialization:
|
LEDGER_ID |
APPL_ID |
PERIOD |
CCID |
PERIOD_BALANCE_DR |
PERIOD_BALANCE_CR |
SR1 |
SR2 |
SR3 |
SR4 |
SR5 |
|---|---|---|---|---|---|---|---|---|---|---|
|
1 |
200 |
6/20/2021 |
01-120-1210-0000-000 |
12554 |
76768 |
Bronze |
Goods |
US |
NY |
Correct Supporting Reference Balances
Let's say the supporting reference balances have been entered for an incorrect supporting reference combination. You would want to correct the balance so that it is represented against the correct supporting reference combination.
Assuming supporting reference balances exist for the following account and supporting reference combination in the XLA_AC_BALANCES table:
| LEDGER_ID | APPL_ID | PERIOD | CCID | PERIOD_BALANCE_DR | PERIOD_BALANCE_CR | SR1 | SR3 | SR4 | SR5 |
| 1 | 200 | Jun-21 | 01-120-1240-0000-000 | 16200 | 76768 | Goods | US | NY |
It was observed that the supporting reference combination used above is incorrect since the value for the supporting reference SR2 was not entered while entering or initializing the balances.
Navigate to the Adjust Supporting Reference Balances task and download the spreadsheet template. Use the Adjust Supporting Reference Balances ADFdi spreadsheet to update supporting reference balances as follows:
| LEDGER_ID | APPL_ID | PERIOD | CCID | ENTERED_BALANCE_DR | ENTERED_BALANCE_CR | SR1 | SR2 | SR3 | SR4 | SR5 |
| 1 | 200 | Jun-21 | 01-120-1240-0000-000 | 16200 | 76768 | Goods | US | NY | ||
| 1 | 200 | Jun-21 | 01-120-1240-0000-000 | 16200 | 76768 | Silver | Goods | US | NY |
In this case, two manual journal entries are created in the background with supporting reference information for one of the lines, which is used to update the balances. The supporting reference is NULL for the offset entry.
| Period | Account Combination | Entered (Debit) | Entered (Credit) | Currency | Accounted (Debit) | Accounted (Credit) | ANALYTICAL_BALANCE_FLAG | SR1 | SR2 | SR3 | SR4 | SR5 |
| Jun-21 | 01-120-1240-0000-000 | 16200 | USD | 16200 | P | 76768 | Goods | US | NY | |||
| Jun-21 | 01-120-1240-0000-000 | 16200 | USD | 16200 | ||||||||
| Jun-21 | 01-120-1240-0000-000 | 16200 | USD | 16200 | P | 76768 | Silver | Goods | US | NY | ||
| Jun-21 | 01-120-1240-0000-000 | 16200 | USD | 16200 |
The journal entries created for adjusting the supporting reference balances are created in Final status but not transferred to GL if all validations succeed. If you don't want balances maintained in the entered currency (XLA_ENABLE_ENTERED_CURR_BAL_SUPP_REF is disabled), the supporting reference balances table is updated as follows on initialization:
| LEDGER_ID | APPL_ID | PERIOD | CCID | PERIOD_BALANCE_DR | PERIOD_BALANCE_CR | SR1 | SR2 | SR3 | SR4 | SR5 |
| 1 | 200 | Jun-21 | 01-120-1240-0000-000 | 16200 | 16200 | 76768 | Goods | US | NY | |
| 1 | 200 | Jun-21 | 01-120-1240-0000-000 | 16200 | 76768 | Silver | Goods | US | NY |