FT GL Drill Down Details

Until now, Oracle Revenue Management and Billing enabled you to extract the trial or actual FT GL records in a flat file using the GL Download Extract (GLDL) batch. This flat file was then used for uploading the data in the General Ledger (GL) system. However, there was no mechanism available through which you can do the following:

  • Validate the extracts which are sent to the GL system

  • Backtrack the FT GL records in ORMB

A new screen named FT GL Drill Down Details is introduced in this release. It contains the following zones:

  • Search GL Extract File - Enables you to search for the GL extract files which are created through the GLDL batch. You can search for files which contain either actual FT GL records or trial FT GL records.

  • GL Extract File Details - Enables you to view the list of GL records in the GL extract file.

  • Financial Transaction Details - Enables you to view the list of financial transactions which are posted against the GL account in ORMB. If you are viewing the details of a GL extract file which contains actual FT GL records, then this zone lists the actual financial transactions posted against the GL account. However, if you are viewing the details of a GL extract file which contains trial FT GL records, then this zone lists the trial financial transactions posted against the GL account.

  • Bill Segment Details - Enables you to view the information of the bill segment for which the financial transaction is created. If you are viewing the details of a GL extract file which contains actual FT GL records, then this zone lists the actual bill segment. However, if you are viewing the details of a GL extract file which contains trial FT GL records, then this zone lists the trial bill segment.

  • Adjustment Details - Enables you to view the information of the adjustment for which the financial transaction is created.

  • Payment Details - Enables you to view the information of the payment for which the financial transaction is created.

To use this feature, you need to set the G/L BATCH CODE field in the Financial Transaction tab of the Installation Options screen to GLDL.