Using BI Publisher Reports to Support Configured ChartFields

Oracle BI Publisher technology is accessible from PeopleTools PS Query and all PeopleTools-based applications. This technology enables PeopleSoft to deliver BI publisher reports. The BI publisher reports do not require manual changes to support ChartField configuration.

You can generate the following list of Global Options reports in BI Publisher format:

  • Journal Detail - Statutory Reports, Accounts Payable, Journal Detail: Available as an APX1200 BI Publisher report.

  • Journal Detail by Alternate Account: Available as an APX1200A BI Publisher report.

  • Journal Detail, No Document Sequencing: Available as an APX1201 BI Publisher report.

  • Journal Detail, No Document Sequencing by Alternate Account: Available as an APX1201A BI Publisher report.

  • Journal Account Summary: Available as an APX1210 BI Publisher report.

  • Journal Account Summary by Alternate Account: Available as an APX1210A BI Publisher report.

  • Journal Account Summary, No Document Sequencing: Available as an APX1211 BI Publisher report.

  • Journal Account Summary by Alternate Account, No Document Sequencing: Available as an APX1211A BI Publisher report.

  • Transaction Detail by Account: Available as an APX1220 BI Publisher report.

  • Transaction Detail by Alternate Account: Available as an APX1220A BI Publisher report.

  • Balance by Account/Vendor: Available as an APX1230 BI Publisher report.

  • Balance by Alternate Account/Vendor: Available as an APX1230A BI Publisher report.

  • Transaction Detail by Vendor: Available as an APX3200 BI Publisher report.

  • Transaction Detail by Vendor/Alternate Account: Available as an APX3200A BI Publisher report.

  • Balance by Vendor/Account: Available as an APX3210 BI Publisher report.

  • Balance by Vendor/Alternate Account: Available as an APX3210A BI Publisher report.

  • Journal Detail: Available as an ARX80011 BI Publisher report.

  • Journal Detail by Alternate Account: Available as an ARX80011A BI Publisher report.

  • Journal Account Summary: Available as an ARX80012 BI Publisher report.

  • Journal Account Summary by Alternate Account: Available as an ARX80012A BI Publisher report.

  • Balances by Account/Customer: Available as an ARX80013 BI Publisher report.

  • Balances by Alternate Account/Customer: Available as an ARX80013A BI Publisher report.

  • Balance by Customer/Account: Available as an ARX80014 BI Publisher report.

  • Balance by Customer/Alternate Account: Available as an ARX80014A BI Publisher report.

  • Transaction Detail by Account: Available as an ARX80015 BI Publisher report.

  • Transaction Detail by Alternate Account: Available as an ARX80015A BI Publisher report.

  • Transaction Detail by Customer: Available as an ARX80016 BI Publisher report.

  • Transaction Detail by Customer/Alternate Account: Available as an ARX80016A BI Publisher report.

  • Journal Detail, No Document Sequencing: Available as an ARX80017 BI Publisher report.

  • Journal Detail by Alternate Account, No Document Sequencing: Available as an ARX80017A BI Publisher report.

  • Journal Account Summary, No Document Sequencing: Available as an ARX80018 BI Publisher report.

  • Journal Account Summary by Alternate Account, No Document Sequencing: Available as an ARX80018A BI Publisher report.

  • DTAUS EFT File Cover Sheet - Germany: Available as a FINX2026 BI Publisher report.

  • Balance by Employee/Alternate Account: Available as an EXX3210A BI Publisher report.

  • Balance by Employee/Account: Available as an EXX3210 BI Publisher report.

  • Transaction Detail by Employee/Alternate Account: Available as an EXX3200A BI Publisher report.

  • Transaction Detail by Employee: Available as an EXX3200 BI Publisher report.

  • Balance by Alternate Account/Employee: Available as an EXX1230A BI Publisher report.

  • Balance by Account/Employee: Available as an EXX1230 BI Publisher report.

  • Transaction Detail by Alternate Account: Available as an EXX1220A BI Publisher report.

  • Transaction Detail: Available as an EXX1220 BI Publisher report.

  • Journal Account Summary by Alternate Account: Available as an EXX1210A BI Publisher report.

  • Journal Account Summary: Available as an EXX1210 BI Publisher report.

  • Journal Detail by Alternate Account: Available as an EXX1200A BI Publisher report.

  • Journal Detail: Available as an EXX1200 BI Publisher report.

  • Intrastat Form N: Available as an ISTX0050S BI Publisher report.

    Note: This report has been standardized for use by Oracle's PeopleSoft, EBS, and Fusion applications.

  • Intrastat Form R: Available as an ISTX0100S BI Publisher report.

    Note: This report has been standardized for use by Oracle's PeopleSoft, EBS, and Fusion applications.

  • Intrastat Form DEB - France: Available as an ISTX0150 BI Publisher report.

  • Intrastat Movement Statistics: Available as an ISTX0200 BI Publisher report.

    Note: This report has been standardized for use by Oracle's PeopleSoft, EBS, and Fusion applications.

  • VAT Return Germany: Available as a VATX0100 BI Publisher report.

  • VAT Return France: Available as a VATX0200 BI Publisher report.

  • VAT Return Spain: Available as a VATX0300 BI Publisher report.

  • VAT Return Canada: Available as a VATX0350 BI Publisher report.

  • VAT Recovery by Tax Authority - Canada: Available as a VATX0400 BI Publisher report.

  • VAT Return Belgium: Belgian Annual VAT Declaration available as a VATX0550 BI Publisher report, and Belgian Monthly VAT Preparation available as a VATX0560 BI Publisher report.

    Note: These reports have been standardized for use by Oracle's PeopleSoft, EBS, and Fusion applications.

  • Business Activity Statement Calculation Sheet - Australia: Available as a VATX0600 BI Publisher report.

  • VAT Input Report - Spain: Spanish Input VAT Journal Report VATX0700S available as a BI Publisher report.

    Note: This report has been standardized for use by Oracle's PeopleSoft, EBS, and Fusion applications.

  • VAT Input Report by Transaction Type - Spain: Available as a VATX0750 BI Publisher report.

  • VAT Output Report - Spain: Spanish Output VAT Journal Report available as a VATX0800S BI Publisher report.

    Note: This report has been standardized for use by Oracle's PeopleSoft, EBS, and Fusion applications.

  • VAT Output Report by Transaction Type - Spain: Available as a VATX0850 BI Publisher report.

  • VAT Liquidation Report - Italy: Available as a VATX0900 BI Publisher report.

  • VAT Register for Italian Sales and Purchase - Italy: Available as a VATX0910 BI Publisher Report.

    Note: This report has been standardized for use by Oracle's PeopleSoft, EBS, and Fusion applications.

  • EC Sales List: European Sales Listing available as a VATX1002 BI Publisher report.

    Note: This report has been standardized for use by Oracle's PeopleSoft, EBS, and Fusion applications.

  • Generic VAT Return: Available as a VATX1003 BI Publisher report.

  • European Sales List - UK layout: Available as a VATX1004 BI Publisher report.

  • VAT Return - UK: Available as a VATX1005 BI Publisher report.

  • VAT Return - Switzerland: Available as a VATX1006 BI Publisher report.

  • VAT Return - Netherlands: Available as a VATX1007 BI Publisher report.

  • VAT Return - Luxembourg: Available as a VATX1008 BI Publisher report.