General Ledger - Journals Real Time

Description

Information that can be used to analyze General Ledger journals. Journals can be segregated based on their processing status.

Business Questions

This subject area can answer the following business questions:

• What unposted journals exist for a given period?

• What journals were created for a given period and category?

• What unapproved journals exist for a given period?

• What journals were created for a given account by source for this period?

• What are the journal entered and accounted amounts for a given account and period?

• What journals were created for a given period for a given account?

Job Roles

The following job roles secure access to this subject area:

• Accounts Payable Manager

• Accounts Receivable Manager

• Accounts Receivable Manager Segregated Role

• Billing Manager Segregated Role

• Financial Analyst

• General Accountant

• General Accounting Manager

Duty Roles

The following duty roles secure access to this subject area:

• General Ledger Transaction Analysis Duty

• Payables to Ledger Reconciliation Transaction Analysis Duty

• Receivables to Ledger Reconciliation Transaction Analysis Duty

Primary Navigation

Home > General Accounting > Journals

Time Reporting

This subject area supports general ledger journals history.

Time dimension is linked to GL Effective Date.

Transactional Grain

This subject area returns data at the grain of general ledger import references (GL_IMPORT_REFERENCES). For those not transferred from subledgers, the grain is at the journal line level (GL_JE_LINES).

Special Considerations

There can be a minor difference between the BIP data and OTBI because of the Oracle BI EE Data Type Limitations. For more information see the Oracle BI EE Data Type Limitations topic.