Norma de Carácter General N°91

Oracle Subledger Accounting starts maintaining the balance for supporting reference from the date it is enabled and does not maintain balances prior to that. So if you are upgrading from an earlier version or migrating from a legacy system then, you need to specify the initial balance for a period prior to which SLA started maintaining the supporting reference balance. This ensures that SLA displays the correct balance for a supporting reference.

The initial balance is the starting balance in ledger currency for a supporting reference (Analytical criteria) and a combination of supporting reference values, in the context of an application, ledger, CCID, and a period. You can specify the initial balance either as debit balance or credit balance.

Note: There is no journal entry in SLA to support initial balances.

To specify the initial balance for supporting references, SLA provides an interface table and a concurrent program to upload the data to the SLA table. Using these you can do the following:

Define Initial Balance

You can specify the initial balance for a period prior to which SLA started maintaining the balance. You can define initial balances as Net of Debit and Credit balance. You can define initial balance for a closed period and also after SLA created balances and entries for the supporting reference value.

When you define an initial balance for a supporting reference source value, SLA synchronizes the balance for all the periods that fall after the period for which you are defining the initial balance.

If there is a balance record for a combination for which you are defining initial balance, SLA updates the balance record for subsequent periods for which the balance exist to synchronize the balance. The subsequent periods for which balance needs to be updated depends on the Carry Forward Balance and Account Type for which initial balance record is created. The following table describes the Carry Forward Balance and Account Type combination.

Carry Forward Balance and Account Type Combination Carry Forward

Balance Account Type Result

Always Any Balance record is updated for all the

subsequent period for which balance record exists.

Carry Forward

Balance Account Type Result

Never Any Balance record is updated for all the

subsequent periods of the financial year in which the initial balance record falls.

Based on Account Asset or Liability or Owner's Equity or Null

Balance record is updated for all the subsequent period for which balance record exists.

Based on Account Income or Expense or Budget-DR or Budget-CR

Balance record is updated for all the subsequent periods of the financial year in which the initial balance record falls.

Update Initial Balances

Once the initial balance is entered, you can modify the initial balance if required. You can either change the initial balance amount or change the period or both. SLA

synchronizes the balances for the periods following the initial balance due to change in the initial balance. The period up to which SLA synchronizes the balance depends on the same conditions as mentioned in the Define Initial balance section.

To change the initial balance, upload a record for the same period, ledger, and CCID for the supporting reference detail value combination for which the initial balance is uploaded.

Note: You cannot update the period of an initial balance prior to a period for which the initial balance is already defined

Delete Initial Balances

To delete the initial balance, upload a record with zero amount for the same period, ledger, and CCID for the supporting reference detail value combination for which the initial balance is already uploaded. When you delete the initial balance record, SLA re-synchronizes the balances for the subsequent period.

Steps to Upload Initial Balances

To define, update, or delete initial balances for supporting references, follow these steps:

• Upload data into the XLA_AC_BALANCES_INT interface table.

• Run the Import Supporting Reference Initial Balances concurrent program. This program does the following:

• Imports the data from the XLA_AC_BALANCES_INT interface table.

• Validates the record in the interface table.

• Uploads all the records to the SLA table that passes the validation check.

• Generates an error report for records that fails the validation check.

• Purges the interface table based on the purge mode selected.

See: XLA_AC_BALANCES_INT interface table.

Error Conditions

Error Message Description

Invalid or Not an SLA Application

Application should be a subledger application defined in the Subledger Accounting architecture.

Invalid Ledger Ledger Identifier should correspond to a valid ledger defined in General Ledger application.

Missing Account or Segment Values

Account information is missing. Either the Accounting Code combination or the Accounting Segments should be provided to identify the account.

Invalid Account Invalid Account. The Account does not represent a valid account for the ledger.

Invalid Period Name for Ledger

Invalid Period. The period name is not valid for the ledger OR

An initial balance record for the supporting reference detail value combination already exists for a period that is earlier than the period for which the initial balance is attempted to be loaded.

Journal Entries exists previous to this period

The supporting reference balance already exists for a period prior to the period for which the initial balance is uploaded for the Account and combination of supporting reference values due to existing journal entries in SLA.

Initial Balance Amount is NULL

Initial Balances provided for both the Debit and Credit side are NULL.

Error Message Description

Either Invalid Amount or Negative Amount

Initial Balance provided for either the Debit or Credit side is negative or non-numeric.

Invalid Supporting Reference

Interface table contains a supporting reference that has not been enabled.

OR

Supporting reference for which the maintain balance flag is set to No.

OR

Invalid Supporting Reference Code.

5