Specify the Ledger or Set of Books for which GL Data is Extracted

If you have an Oracle EBS source system, you can specify from which set of books or ledgers you extract the GL data.
Oracle BI Applications enables you to configure:

• The list of ledgers or set of books from which to extract the GL data.
  
• The types of ledgers or set of books for which to extract the GL data.
  

You can use either of these configuration points separately and combine them. When installed by default, Oracle BI Applications extract all GL data for all ledgers or set of books.
For Oracle 11i customers, to configure the list of sets of books for which to extract the GL data, do the following:

1. In DAC, go to the Design view, and select the appropriate custom container from the drop-down list.
   
2. Display the Source System Parameters tab.
   
3. Query for the parameter $$FILTER_BY_SET_OF_BOOKS_ID.
   
4. Double-click the Value column to open the text box, and enter 'Y'.
   Make sure to put single quotes around the Y.
   
5. Save the changes.
   
6. Query for the parameter $$SET_OF_BOOKS_ID_LIST.
   
7. Double-click the Value column to open the text box, and enter the IDs of the sets of books for which you want to extract GL data.
   Specify the list of sets of book IDs separated by commas (do not enter single or double quotes).
   For example, if you want to extract GL data for sets of books with IDs: 101, 207, and 303, then set the value of this parameter to the following:
   

   101, 207, 303
   

8. Save the changes.
   

You can also specify the Set of Books type for which you want to extract GL data. In Oracle 11i, there are three set of books types (this is based on the column GL_SETS_OF_BOOKS.mrc_sob_type_code):

• P (Parent)
  
• R (Reporting)
  
• N (None)
  

For Oracle 11i customers, to configure the types of set of books to extract the GL data, do the following:

1. In DAC, go to the Design view, and select the appropriate custom container from the drop-down list.
   
2. Display the Source System Parameters tab.
   
3. Query for the parameter $$FILTER_BY_SET_OF_BOOKS_TYPE.
   
4. Double-click the Value column to open the text box, and enter the value 'Y'.
   Make sure to put single quotes around the Y.
   
5. Save the changes.
   
6. Query for the parameter $$SET_OF_BOOKS_TYPE_LIST.
   
7. Double-click the Value column to open the text box, and enter the types of set of books for which you want to extract GL data.
   Specify the list of set of book IDs in single quotes and separated by commas.
   For example, if you want to extract GL data for all Parent set of books and all Reporting set of books, then set the value of this parameter as follows:
   

   'P', 'R'
   

8. Save the changes.
   

For Oracle EBS R12 customers, to configure the list of ledgers to extract the GL data for, do the following:

1. In DAC, go to the Design view, and select the appropriate custom container from the drop-down list.
   
2. Display the Source System Parameters tab.
   
3. Query for the parameter $$FILTER_BY_LEDGER_ID.
   
4. Double-click the Value column to open the text box, and enter the value 'Y'.
   Make sure to put single quotes around the Y.
   
5. Save the changes.
   
6. Query for the parameter $$LEDGER_ID_LIST.
   
7. Double-click the Value column to open the text box, and enter the IDs of ledgers for 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
   

8. Save the changes.
   

You can also specify types of ledgers you want to extract GL data for. In Oracle EBS R12, there are four types of ledgers (this is based on the column GL_LEDGERS.ledger_category_code):

• PRIMARY
  
• SECONDARY
  
• ALC
  
• NONE
  

For R12 customers, to configure the types of ledgers to extract the GL data for, do the following:

1. In DAC, go to the Design view, and select the appropriate custom container from the drop-down list.
   
2. Display the Source System Parameters tab, and query for the parameter $$FILTER_BY_LEDGER_TYPE.
   
3. Double-click the Value column to open the text box, and enter the value 'Y'.
   Make sure to put single quotes around the Y.
   
4. Save the changes.
   
5. Query for the parameter $$LEDGER_TYPE_LIST.
   
6. Double-click the Value column to open the text box, and enter the types of ledgers for which you want to extract GL data for.
   Specify the list of set of book IDs in single quotes and separated by commas.
   For example, if you want to extract GL data for all Primary ledgers and all Secondary ledgers, then simply set the value of this parameter to as follows:
   

   'PRIMARY', 'SECONDARY'
   

7. Save the changes.