Show TOC Start of Content Area

InfoCube documentation Flexible General Ledger  Locate the document in its SAP Library structure

Technical name 0ORA_C01

Use

This InfoCube contains all postings in the general ledger (debits, credits, and quantities) that are loaded from the connected Oracle Applications source system(s). In addition to accounting information such as company, cost center, and account, the InfoCube contains multiple account assignments for project, customer, material, distribution channel, and business area as long as these are available in the definition of the accounting flex field in the source system.

Superordinate Objects

Queries

The following queries can access this InfoCube:

·        Cost Center Plan/Actual Current (BWBCT_ORAC_QR_C01_Q0002)

·        Cost Center Plan/Actual Quarters (BWBCT_ORAC_QR_C01_Q0004)

·        Cost Center Plan/Actual Year (BWBCT_ORAC_QR_C01_Q0003)

·        Cost Centers Plan/Actual Detail (BWBCT_ORAC_QR_C01_Q0001)

·        Cost Centers Plan/Actual Quarters Detail (BWBCT_ORAC_QR_C01_Q0006)

·        Cost Centers Plan/Actual Year Detail (BWBCT_ORAC_QR_C01_Q0006)

·        Cost Centers Statistical Key Figures Current (BWBCT_ORAC_QR_C01_Q0012)

·        Cost Centers Statistical Key Figures Quarters (BWBCT_ORAC_QR_C01_Q0013)

·        Cost Centers Statistical Key Figures Year (BWBCT_ORAC_QR_C01_Q0014)

·        Cost Center Actual/Actual Current (BWBCT_ORAC_QR_C01_Q0007)

·        Cost Centers Actual/Actual Year (BWBCT_ORAC_QR_C01_Q0008)

·        Cost Centers Actual/Actual Detail (BWBCT_ORAC_QR_C01_Q0010)

·        Cost Centers Actual/Actual Detail (BWBCT_ORAC_QR_C01_Q0009)

·        Cost Centers Actual Year Detail (BWBCT_ORAC_QR_C01_Q0011)

Notes on Query Definition

If you are aggregating different currency types or plan versions, incorrect results arise in the query. A aggregation of the different values of this characteristic is not beneficial.

InfoSources

·        0ORA_FI_GL_1: Oracle General Ledger Transaction Data

·        0ORA_FI_GL_2: Oracle General Ledger Statistical Key Figures 

Loading Behavior

The InfoCube is fed by the InfoSources 0ORA_FI_GL_1 and 0ORA_FI_GL_2. This necessitates a special procedure for loading data from the source systems to the InfoCube.

The transaction data in the Oracle general ledger is updated with the Accounting Flex Field key field. This field contains all account assignment information. When loading the data to the InfoCube in the BW, the technical flex field segments are transferred to semantic BW InfoObjects. The assignment of flex field segment to InfoObject takes place in the update rules using the structure of the accounting flex field previously loaded from Oracle Applications. The structure of the accounting flex field is stored as master data of the Oracle Flex Field Structure (0ORA_SEGID) and can also be maintained manually in the BW.  Before loading transaction data, make sure that the master data attributes of the InfoObject 0ORA_SEGID are loaded and that they correspond to the definition of the accounting flex field.

We recommend the following procedure for loading transaction data:

·        Create an info package for your InfoSources to load the actual data with. Wherever possible, load your actual data at the end of the period- after the period has been concluded-thus restricting the selection to the completed period.

·        Create precisely one InfoPackage for your InfoSources to load the remaining data (plan/budget, committed). This is necessary due to the different loading times. Restrict the selection to the appropriate value type (for example, 'plan') and the corresponding period(s), for example, „1 – 3" for the first quarter, or „1 – 12" for the entire year.

 

End of Content Area