18Oracle Fusion Financials for Asia/Pacific Reports

This chapter contains the following:

Oracle Fusion Financials for Asia/Pacific Predefined Reports

Oracle Fusion Financials for Asia/Pacific provides predefined reports that are used to meet reporting and reconciliation requirements for specific countries.

Scheduled Processes work area

Reports can be scheduled and run from the Scheduled Processes work area found from the Tools on the Navigator.

Reports and Analytics work area

In some cases, reports are also:

  • Accessed from the Reports and Analytics work area found from the Tools on the Navigator or from other work areas.

  • Opened using links that launch the business intelligence (BI) catalog.

The following tables are the predefined reports.

Reports for Asia/Pacific

Display Name Description

Transactions Transfer Report for China

Lists the transfer results of Receivables transactions to the Golden Tax Adaptor.

Golden Tax Transaction Consolidation Detail Report for China

Lists detailed consolidated information on parent Golden Tax transactions and related child Golden Tax transactions.

Import VAT Invoices for China

Imports VAT invoices from the VAT invoicing software and maps the invoice data to the corresponding Golden Tax transactions at both the header level and the line level.

VAT Invoices Mapping Report for China

Lists the mapping relationship between the original Receivables transactions and completed VAT invoices from the VAT invoicing software .

Golden Tax Discrepancy Report for China

Lists all header and line level discrepancies between the original Receivables transactions, the Golden Tax transactions created during the transfer process, and the completed VAT invoices imported from the VAT invoicing software.

Payment Register with Bank Charges for Japan

Lists payments with calculated bank charges. Used to review the amount of bank charges deducted from a payment.

Input Tax Gain/Loss Report for Singapore

Produces the details on tax gain or loss on transactions for Singapore entered in foreign currencies in Oracle Fusion Payables. The report lists data for a specific supplier or all suppliers. The report data is grouped by tax rate code and supplier.

Output Tax Gain/Loss Report for Singapore

Produces the details on tax gain/loss on transactions for Singapore entered in foreign currencies in Oracle Fusion Receivables. The report lists data for a specific customer or all customers. The report data is grouped by tax rate code and customer.

Withholding Tax Certificate for Thailand

Produces reports on the tax withheld by companies in Thailand while making payments to suppliers.

Subledger Reports

Display Name Description

General Ledger Journal to Subledger Transaction Mapping Report

Lists the General Ledger journal details and the corresponding subledger transaction details in each row for the selected data access set, ledger, and accounting period range. Details include account combination, accounted and entered amounts, source, category, journal batch, journal names, supplier or customer names, voucher, document, intercompany batch, payment, PO, and receipt numbers.

General Ledger Journal and Subledger Transaction Mapping Report

List the mapping relationship between the General Ledger Journals and source subledger transactions details.

To run predefined reports, navigate to the Scheduled Processes work area and follow these steps:

  1. Click the Schedule New Process button.

  2. Search for your process name.

  3. Enter your parameters.

  4. Enter your process options and schedule.

  5. Click Submit.

General Ledger Journal and Subledger Transaction Mapping Report

This topic includes details about the General Ledger Journal and Subledger Transaction Mapping Report.

Overview

Use the General Ledger Journal and Subledger Transaction Mapping Report to display the mapping relationship details between general ledger journals and the corresponding source subledger transactions for a specific data access set, ledger, and accounting period.

The following figure shows an example of the General Ledger Journal and Subledger Transaction Report. Some of the columns included on the report are period, account, currency, rate, entered amount, accounted amount, source, category, and journal batch name.

This figure shows the General Ledger Journal and
Subledger Transaction Mapping Report.

Key Insights

The following table lists the sources for which subledger information is reported, along with the information that is displayed.

Source Subledger Information

Oracle Payables

  • Supplier name

  • Invoice number

  • Document number

Oracle Receivables

  • Customer name

  • Transaction number

  • Receipt number

Oracle Cost Management

  • Supplier name

  • Purchase order number

  • Receipt number

Oracle Intercompany

Original intercompany batch number

Note: For other sources, the report displays only general ledger information.

For secondary ledgers, when the data conversion level is subledger, only subledger information is displayed. You can define the data conversion level during account setup. Otherwise, only general ledger information is reported.

When the subledger accounting options in the accounting setup, and the transfer to general ledger options in the journal line type setup is summary, the subledger journal lines are summarized and transferred to general ledger. In such cases, one general ledger journal line may be summarized from multiple subledger journal lines. The report displays multiple lines for every subledger journal line and the amount displayed is from the corresponding subledger journal line.

Report Parameters

The following table lists selected parameters of the report.

Parameters Description

Data Access Set

Specify the data access set that is associated with your data role.

Ledger

Specify the ledger from which you want to export data. The ledger must be associated with the selected data access set.

Legal Entity

When the selected ledger is a primary ledger, specify the legal entities assigned to it.

When the selected ledger is a secondary ledger, specify the legal entities that are assigned to the corresponding primary ledger.

Source

Specify the name of the journal source as defined in the Manage Journal Source page.

When you specify the source, the general ledger journal lines from that source are extracted. All the general ledger journal lines are exported if you do not specify any source.

Batch Name

Specify the general ledger batch name to be included for exporting data.

From Document Number and To Document Number

Specify the range of general ledger sequence number to be included for exporting data.

From Period and To Period

Specify the range of general ledger periods to be included for reporting data. Only general ledger journal lines during the specified period are exported.

Frequently Asked Questions

The following table lists frequently asked questions about the General Ledger Journal and Subledger Transaction Mapping Report.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

  • Financial Manager

  • Financial Accountant

When do I use this report?

Use the report to list the general ledger journal details and the corresponding subledger transaction details in each row for the selected data access set, ledger, and accounting period range.

Details include account combination, accounted and entered amounts, source, category, journal batch, journal names, supplier or customer names, voucher, document, intercompany batch, payment, purchase order, and receipt numbers.

What type of reports are these?

Oracle Business Intelligence Publisher

Details of the Payment Register with Bank Charges for Japan

This topic includes details about the Payment Register with Bank Charges for Japan.

Overview

The Payment Register with Bank Charges for Japan lists payments with calculated bank charges.

The following figure is an example of the report.

Payment Register with Bank Charges for Japan

Key Insights

The report lists payments and the bank charges that were deducted from a supplier payment.

Frequently Asked Questions

The following table lists frequently asked questions about the Payment Register with Bank Charges for Japan

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

  • Financial Manager

  • Financial Specialist

When do I use this report?

When you want to review the amount of bank charges deducted from a payment.

What can I do with this report?

You can run this report for a specific business unit, payment date range, and currency.

What type of report is this?

Oracle Business Intelligence Publisher

Assets Reports for Japan

This topic includes details about Assets reports for Japan.

Overview

Japanese Assets reports include:

Report Name Description

Japanese Addition or All Asset Detail by Asset Type Report 132 Characters

Lists depreciable assets for Japan in detail by asset type in a 132 character-wide format.

Japanese Addition or All Asset Detail by Asset Type Report 180 Characters

Lists depreciable assets for Japan in detail by asset type in a 180 character-wide format.

Japanese Corporate Tax Reports Schedule 16 (1) Report

Lists the summary of depreciable assets for Japan in accordance with Corporate Tax Reports Schedule 16 for Japan.

Japanese Corporate Tax Reports Schedule 16 (2) Report

Lists the summary of depreciable assets for Japan in accordance with Corporate Tax Reports Schedule 16 for Japan.

Japanese Corporate Tax Reports Schedule 16 (4) Report

Lists the summary of depreciable assets for Japan in accordance with Corporate Tax Reports Schedule 16 for Japan.

Japanese Corporate Tax Reports Schedule 16 (6) Report

Lists the summary of depreciable assets for Japan in accordance with Corporate Tax Reports Schedule 16 for Japan.

Japanese Corporate Tax Reports Schedule 16 (8) Report

Lists the summary of depreciable assets for Japan in accordance with Corporate Tax Reports Schedule 16 for Japan.

Japanese Depreciable Assets Tax Summary Report

Lists a summary of depreciable assets for Japan by location as of January 1 for the selected fiscal year.

The following table describes selected report parameters:

Name Description

Book

Use this parameter to specify the book to be included for reports.

Currency

Use this parameter to specify the currency to be included for reports.

From Asset Number and To Asset Number

Use these parameters to enter the asset number range for which you want to run the report.

Frequently Asked Questions

The following table lists frequently asked questions about Assets reports for Japan.

FAQ Answer

How do I find these reports?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

When do I use these reports?

Use these reports to:

  • Review information for property tax forms.

  • Review and analyze depreciation projection for your current depreciation parameters.

  • Review and analyze the details of your asset impairment transactions.

How do I change the default report format?

To change from Oracle Business Intelligence Publisher (BI Publisher), edit the fixed asset catalog and choose the output format from the layout table in the view list.

Input and Output Tax Gain/Loss Reports for Singapore

This topic includes details of the input and output tax gain/loss reports for Singapore.

Overview

The input and output tax gain/loss reports display the difference in both tax amounts and taxable amounts on foreign invoices for different conversion rates.

The input and output tax gain/loss reports include:

  • Input Tax Gain/Loss Report for Singapore: Produces the details on tax gain or loss on transactions for Singapore entered in foreign currencies in Oracle Fusion Payables. The report lists data for a specific supplier or all suppliers. The report data is grouped by tax rate code and supplier.

    The following figure is an example of the report.

    Input Tax Gain/Loss Report for Singapore
  • Output Tax Gain/Loss Report for Singapore: Produces the details on tax gain/loss on transactions for Singapore entered in foreign currencies in Oracle Fusion Receivables. The report lists data for a specific customer or all customers. The report data is grouped by tax rate code and customer.

    The following figure is an example of the report.

    Output Tax Gain/Loss Report for Singapore
Note: Manual tax transactions created in the tax repository are not reported.

Key Insights

Before running the reports:

  • Set up legal entities and legal reporting units for each company site that is responsible for reporting taxes to the tax authority.

  • Set up tax regimes and taxes for your transactions.

  • Set up supplier and customer conversion rates to calculate the tax amount and invoice taxable amount for foreign currency invoices.

For the Input Tax Gain/Loss Report for Singapore, enter the supplier tax invoice conversion rate on the invoice and run the Input Tax Gain and Loss Report for Singapore process.

For the Output Tax Gain/Loss Report for Singapore, enter the general ledger daily rate to represent the spot rate and run the Output Tax Gain and Loss Report for Singapore process.

The gain/loss in the:

  • Tax amount for foreign currency invoices is the difference between the:

    • In-house tax amount using the in-house conversion rate, and

    • Supplier or customer tax amount using the supplier or customer conversion rate (spot rate) you enter.

  • Taxable amount is the difference between the:

    • In-house taxable amount using the in-house conversion rate, and

    • Supplier or customer taxable amount using the supplier or customer conversion rate.

A manual journal entry is posted to the general ledger to incorporate the gain/loss.

Note: For transactions that are not in SGD currency and with incomplete conversion rate information, the following occurs:
  • For the Input Tax Gain/Loss Report for Singapore, the report indicates that the information is missing by displaying:

    • Unspecified for the supplier conversion rate

    • Undetermined for the tax amounts in SGD currency

  • For the Output Tax Gain/Loss Report for Singapore, the report indicates that the information is missing by displaying:

    • Unspecified for the spot conversion rate

    • Undetermined for the tax amounts in SGD currency

Report Parameters

The following table describes selected report parameters:

Parameter Name Description

Reporting Level

Gives you the option to run reports on three different levels, Ledger, Legal Entity, and Tax Registration Number.

Reporting Context

Specify the context for the report. The list of values for this parameter depends on the reporting level you selected.

  • If you select the reporting level of Legal Entity, you select the legal entity on which to report, and then select the tax registration number associated with the legal entity.

  • If you select Ledger as the reporting level, you can report on legal entities associated with ledgers defined in the ledger set or data access set within your security profile. Run tax reports by ledger when you want to review your tax activity as it aligns with your accounting. Run tax reports by ledger when you need to view tax activity in a currency other than the currency of the ledger or the currencies of the transactions.

Tax Registration Number

Specify a tax registration number assigned to the tax registrations of the legal entity if the reporting level is Legal Entity.

Note: To prepare your tax returns, the recommended approach is to run tax reporting by legal entity and tax registration number. Your legal entities and their associated tax registration numbers are aligned with how your businesses are legally recognized by government authorities. Preparing reports by tax registration number provides all reportable activity for a given legal entity regardless of how your internal business units are organized.

From Tax Point Period and To Tax Point Period

Print all transactions based on the selected tax point date range.

Tax

Lists invoice and tax information for a specified tax.

Supplier Name or Customer Name

Generates the report for a specified supplier or customer name.

Frequently Asked Questions

The following table lists frequently asked questions about the Input Tax Gain/Loss Report for Singapore and the Output Tax Gain/Loss Report for Singapore.

FAQ Answer

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

  • Tax Manager

  • Tax Accountant

When do I use this report?

Use these reports to review the difference in both tax amounts and taxable amounts on foreign invoices for different conversion rates.

The reports display different information, depending on whether the ledger currency is Singapore Dollar (SGD) or another currency.

When the ledger currency is:

  • SGD, the tax gain or loss is displayed together with transaction information in SGD currency.

  • Not SGD, the tax information is displayed in SGD currency for reporting to the tax authorities, and in the accounted currency. The report includes:

    • In-house conversion rate and the supplier conversion rate for the Input Tax Gain/Loss report.

    • In-house conversion rate and the general ledger daily rate for the Output Tax Gain/Loss report. The report only displays invoices that are approved and posted to the general ledger.

What type of reports are these?

Oracle Business Intelligence Publisher