Using Oracle Business Intelligence (BI) Publisher Reports to Support Configured ChartFields

Oracle BI Publisher (formerly XMLP) technology streamlines report and form generation and is accessible from PeopleTools 8.52 PS Query and all PeopleTools 8.52-based applications and beyond. This technology enables PeopleSoft to deliver BI Publisher reports. The BI Publisher reports do not require manual changes to support ChartField configuration.

The following is a list of the reports that can be generated in the BI Publisher formats:

  • Installation Options: FSX0001 BI Publisher report.

  • Detail Calendars: FSX0002 BI Publisher report.

  • TimeSpans: FSX0003 BI Publisher report.

  • Account Types: FSX0004 BI Publisher report.

  • Statistics Units of Measure: FSX0005 BI Publisher report.

  • Valid SpeedTypes: FSX0007 BI Publisher report.

  • Valid Accounts: FSX0010 BI Publisher report.

  • Valid Departments: FSX0011 BI Publisher report.

  • Valid Products: FSX0012 BI Publisher report.

  • Valid Project IDs: FSX0013 BI Publisher report.

  • Valid Statistics Codes: FSX0015 BI Publisher report.

  • Tables by Record Group: FSX0016 BI Publisher report.

  • Valid SetIDs: FSX0017 BI Publisher report.

  • Detail Ledger Definition: FSX0022 BI Publisher report.

  • Ledger Template: FSX0023 BI Publisher report.

  • Budget Reference: FSX0024 BI Publisher report.

  • Scenario: FSX0025 BI Publisher report.

  • List of PS/nVision Reports: FSX0030 BI Publisher report.

  • List of PS/nVision Scopes: FSX0031 BI Publisher report.

  • Valid Operating Units: FSX0032 BI Publisher report.

  • Alternate Accounts: FSX0033 BI Publisher report.

  • Currency Codes: FSX0035 BI Publisher report.

  • ChartField1: FSX0037 BI Publisher report.

  • ChartField2: FSX0038 BI Publisher report.

  • ChartField3: FSX0039 BI Publisher report.

  • Valid Funds: FSX0050 BI Publisher report.

  • Valid Programs: FSX0052 BI Publisher report.

  • Valid Sub Class: FSX0053 BI Publisher report.

  • Journal Types: FSX0057 BI Publisher report.

  • Journal Codes: FSX0058 BI Publisher report.

  • Document Types: FSX0059 BI Publisher report.

  • Document Sequence Ranges: FSX0060 BI Publisher report.

  • Regulatory Ledger Translation Error: FSX5101 BI Publisher report.

  • Ledger Code: GLX1001 BI Publisher report.

  • Combination Edit Group: GLX4003 BI Publisher report.

  • Adjustment Type ChartField: GLX4004 BI Publisher report.

  • Book Code: GLX4005 BI Publisher report.

  • Account Balancing Group: GLX4006 BI Publisher report.

  • Journal Entry Template: GLX4007 BI Publisher report.

  • Inconsistent ChartField on Combination Editing: GLX4009 BI Publisher report.

  • ADB Processes: GLX5501 BI Publisher report.

  • Allocation Group Definition: GLX6001 BI Publisher report.

  • Budget Attributes: GLX8100 BI Publisher report.

  • Associated Budgets: GLX8110 BI Publisher report.

  • Budget Checking Batch Process Statuses: GLX 8530 BI Publisher report.

  • Activity Log Detail: GLX8570 BI Publisher report.

  • Activity Log Summary: GLX8571 BI Publisher report.

Note:

The navigation to the reports listed above is included in this report lists for PeopleSoft Application Reports and in the report lists for each of the applications.

See PeopleSoft Global Options and Reports: PeopleSoft Global Options and Reports: A-Z.

See PeopleSoft Commitment Control: Managing ChartFields for Reports.

The BI Publisher report templates are designed in Microsoft Word's rich text format and contain the report layout and BI Publisher tags (placeholders) that are associated with the BI Publisher input file elements.

The following are general formatting features:

  • All elements are placed in tables to optimize exact placement and alignment when the template is transformed to the actual report format.

  • BI publisher can split columns to multiple pages if the columns exceed one page.

    However, the GL report templates are designed to display all of the columns for a row on one page in most instances. There will be exceptions if some of the columns will be split on multiple pages. For example, if you have additional ChartFields. Multiple ChartFields will be grouped in a single column to optimize horizontal space.

  • Some of the reports use intelligent formatting to display ChartFields only where a value exists in a row.

  • Intelligent formatting is also used on other data such as statistical amount and statistical code to optimize horizontal spacing.