I am not able to see the balance sheet under GL dashboard

Issue: I am not able to see the balance sheet under GL dashboard

Observations:

1. Placed the all the csv files related to finance module.

2. W_GL_GROUP_ACCOUNT_D is having the correct data from csv files

3. Data not loaded into W_GL_BALANCE_A table

Solution:

Missed the two parameter values ($$FILTER_BY_LEDGER_ID&$$LEDGER_ID_LIST) in DAC set up.

To configure the list of ledgers to extract the GL datafor, do the following:

Ø  In DAC, go to the Design view, and select the appropriate custom container fromthe drop-down list.

Ø  Display the Source System Parameters tab.

Ø  Query for the parameter $$FILTER_BY_LEDGER_ID.

Ø  Double-click the Value column to open the text box, and enter the value 'Y'.

Ø  Make sure to put single quotes around the Y.

Ø  Save the changes.

Ø  Query for the parameter $$LEDGER_ID_LIST.

Ø  Double-click the Value column to open the text box, and enter the IDs of ledgersfor which you want to extract GL data for.

Specify the list of ledger IDs separated by commas (do not use single quotes).

For example, if you want to extract GL data for ledgers with IDs: 101, 207, and 303,

then set the value of this parameter as follows:101, 207, 303

Ø  Save the changes.

Note:

Use below SQL to check the ‘$$LEDGER_ID_LIST’ value.

SELECT SET_OF_BOOKS_ID,NAMEFROM GL_SETS_OF_BOOKS;