Financials Reports R12-1
Financials Reports R12-1
Financials Reports R12-1
Document Overview
This workbook provides details for all of the Financials Cloud reports and analyses, each
of which you can customize to meet your company's requirements. Whatever role you
play in your organization, there are reports and analyses designed to help make your job
easier.
Oracle Financials Cloud
View Financials Reports and Analyses
Release 12
/Financials/Payables/Income Tax and Prints the Business and General Withholding Tax Report
Business and General Withholding Tax Report for Korea Report Report Layout
Withholding/Korea/NRBGWhtFormForKorea.xdo for non-resident suppliers for Korea.
Page 2 of 81
Oracle Financials Cloud
View Financials Reports and Analyses
Release 12
/Financials/General Ledger/Journals/Data
Journals Extract Data Model Report Data Model Data model to extract journal details.
Models/JournalsExtractDm.xdm
/Financials/Payables/Payments/Data Data model is used for the Payments Extract. The data
Payments Extract Data Model Report Data Model
Models/PaymentsExtractDm.xdm model extracts payment information related to invoices.
Page 3 of 81
Oracle Financials Cloud
View Financials Reports and Analyses
Release 12
Page 4 of 81
Oracle Financials Cloud
View Financials Reports and Analyses
Release 12
Page 5 of 81
Oracle Financials Cloud
View Financials Reports and Analyses
Release 12
Page 6 of 81
Oracle Financials Cloud
View Financials Reports and Analyses
Release 12
Page 7 of 81
Oracle Financials Cloud
View Financials Reports and Analyses
Release 12
Page 8 of 81
Oracle Financials Cloud
View Financials Reports and Analyses
Release 12
Data model used for the Bad Debt Provision Report. The
data model extracts data for customers and transactions
with open balance amounts and filters the data by
collectable percentage less than 100. The data is
Bad Debt Provision Data Model Report Data Model /Financials/Receivables/Accounting/Data Models grouped by customer account status, collectable
percentage, customer name, and customer account
number, and is sorted by customer name, customer
account status, collectable percentage, and customer
account number.
Page 9 of 81
Oracle Financials Cloud
View Financials Reports and Analyses
Release 12
Page 10 of 81
Oracle Financials Cloud
View Financials Reports and Analyses
Release 12
Data model is used for the CIP Detail Report. The data
model extracts the details of the assets including
/Financials/Fixed Assets/Asset Balances/Data balancing segment, cost accounts, cost center, and
CIP Detail Data Model Report Data Model
Models asset number. The transaction information is extracted
from Oracle Assets and the accounting information is
extracted from Oracle Subledger Accounting.
Page 11 of 81
Oracle Financials Cloud
View Financials Reports and Analyses
Release 12
Page 12 of 81
Oracle Financials Cloud
View Financials Reports and Analyses
Release 12
Data model is used for the Cost Detail Report. The data
model extracts the details of the assets including asset
/Financials/Fixed Assets/Asset Balances/Data cost, balancing segment, cost accounts, cost center, and
Cost Detail Data Model Report Data Model
Models asset number. The transaction information is extracted
from Oracle Assets and the accounting information is
extracted from Oracle Subledger Accounting.
Page 13 of 81
Oracle Financials Cloud
View Financials Reports and Analyses
Release 12
Page 14 of 81
Oracle Financials Cloud
View Financials Reports and Analyses
Release 12
Page 15 of 81
Oracle Financials Cloud
View Financials Reports and Analyses
Release 12
Page 16 of 81
Oracle Financials Cloud
View Financials Reports and Analyses
Release 12
Disbursement Accompanying Letter Formats Report Report Layout /Financials/Payments Creates an accompanying letter for a payment file.
Disbursement Payment Process Request Status Report Creates a report that displays the contents and status of
Report Report Layout /Financials/Payments
Formats a payment process request.
Page 17 of 81
Oracle Financials Cloud
View Financials Reports and Analyses
Release 12
Funds Capture Accompanying Letter Formats Report Report Layout /Financials/Payments Creates an accompanying letter for a settlement batch.
Page 18 of 81
Oracle Financials Cloud
View Financials Reports and Analyses
Release 12
General Ledger Journal and Subledger Transaction Mapping List the mapping relationship between the general ledger
Report Report Layout /Financials/General Ledger/Account Analysis
Report journals and source subledger transactions details.
General Ledger Journal and Subledger Transaction Mapping /Financials/General Ledger/Account Analysis/Data Data model used for the General Ledger Journal and
Report Data Model
Report Data Model Models Subledger Transaction Mapping Report.
Page 19 of 81
Oracle Financials Cloud
View Financials Reports and Analyses
Release 12
Lists the group and its member asset balances for the
specified fiscal year and is used to comply with Indian
Group Asset Detail Report Report Report Layout /Financials/Fixed Assets/Asset Balances
income tax requirements. The report is sorted by and
groups totals for each fiscal year and asset category.
Data model is used for the Group Asset Listing. The data
/Financials/Fixed Assets/Asset Balances/Data model extracts the descriptive information, method
Group Asset Listing Data Model Report Data Model
Models information and net book values for all the group assets
from Oracle Assets.
Page 20 of 81
Oracle Financials Cloud
View Financials Reports and Analyses
Release 12
Data model used for the Import VAT Invoices for China
program. The data model imports VAT invoices from the
/Financials/Receivables/Bill Presentment/Data
Import VAT Invoices for China Data Model Report Data Model Aisino Golden Tax System and maps the invoice data to
Models
the corresponding Golden Tax transactions at both the
header level and the line level.
Page 21 of 81
Oracle Financials Cloud
View Financials Reports and Analyses
Release 12
Page 22 of 81
Oracle Financials Cloud
View Financials Reports and Analyses
Release 12
Page 23 of 81
Oracle Financials Cloud
View Financials Reports and Analyses
Release 12
Page 24 of 81
Oracle Financials Cloud
View Financials Reports and Analyses
Release 12
Payables Cash Requirement Report Report Report Layout /Financials/Payables/Payments Forecasts immediate cash needs for invoice payments.
Payables Invoice Register Report Report Layout /Financials/Payables/Invoices Provides detailed information about invoices.
Payables Invoice Register Dashboard /Financials/Payables/Invoices Provides detailed information about invoices.
Payables Payment Register Report Report Layout /Financials/Payables/Payments Provides detailed information about payments.
Payables Payment Register Dashboard /Financials/Payables/Invoices Provides detailed information about payments.
Page 26 of 81
Oracle Financials Cloud
View Financials Reports and Analyses
Release 12
Prepayment Remittance Notice Report Report Layout /Financials/Payables/Prepayments Lists prepayments that were applied to supplier invoices.
Printable Expense Report Format Report Report Layout /Financials/Expenses Generates the printable page for an expense report.
Page 29 of 81
Oracle Financials Cloud
View Financials Reports and Analyses
Release 12
Page 30 of 81
Oracle Financials Cloud
View Financials Reports and Analyses
Release 12
Page 31 of 81
Oracle Financials Cloud
View Financials Reports and Analyses
Release 12
Page 32 of 81
Oracle Financials Cloud
View Financials Reports and Analyses
Release 12
Page 33 of 81
Oracle Financials Cloud
View Financials Reports and Analyses
Release 12
Page 35 of 81
Oracle Financials Cloud
View Financials Reports and Analyses
Release 12
Page 36 of 81
Oracle Financials Cloud
View Financials Reports and Analyses
Release 12
Page 37 of 81
Oracle Financials Cloud
View Financials Reports and Analyses
Release 12
Page 39 of 81
Oracle Financials Cloud
View Financials Reports and Analyses
Release 12
Page 40 of 81
Oracle Financials Cloud
View Financials Reports and Analyses
Release 12
Page 41 of 81
Report Output Sample Product Module Related Subject Area Run Type
Page 42 of 81
Report Output Sample Product Module Related Subject Area Run Type
Page 43 of 81
Report Output Sample Product Module Related Subject Area Run Type
Financials
JA/Resident General Income Withholding Form for for Asia/Pacific
Korea.pdf None. Submitted/Batch
Page 44 of 81
Report Output Sample Product Module Related Subject Area Run Type
JE/Account Analysis by Legal Entity Report.pdf Financials for EMEA None. Not Applicable
Page 45 of 81
Report Output Sample Product Module Related Subject Area Run Type
XLA/Activate_Journal_Entry_Rule_Set_Assignments_Report.pdf
Accounting Hub None. Process Report
Page 46 of 81
Report Output Sample Product Module Related Subject Area Run Type
FA/Asset Transaction History Report.pdf Assets Fixed Assets - Asset Transactions Real Time Submitted/Batch
Page 47 of 81
Report Output Sample Product Module Related Subject Area Run Type
FA/Asset Transfers Report.pdf Assets Fixed Assets - Asset Transfer Real Time Submitted/Batch
Receivables
AR/Automatic Receipts Remittances Execution Report.pdf None. Not Applicable
Page 48 of 81
Report Output Sample Product Module Related Subject Area Run Type
Page 49 of 81
Report Output Sample Product Module Related Subject Area Run Type
XCC/BudgetaryControlAnalysis_Account Activities.pdf
Budgetary Control Budgetary Control - Transactions Real Time Submitted/Batch
XCC/BudgetaryControlAnalysis_Funds AvailableBudgetary
Trend.pdf Control Budgetary Control - Transactions Real Time Submitted/Batch
Page 50 of 81
Report Output Sample Product Module Related Subject Area Run Type
Page 51 of 81
Report Output Sample Product Module Related Subject Area Run Type
AR/Automatic_Clearing_For_Receipts_Report.pdf
Receivables None. Process Report
Page 52 of 81
Report Output Sample Product Module Related Subject Area Run Type
Page 53 of 81
Report Output Sample Product Module Related Subject Area Run Type
Page 54 of 81
Report Output Sample Product Module Related Subject Area Run Type
AR/Customer General Information Report.pdf Receivables Receivables - Customer Real Time On-Demand
Page 55 of 81
Report Output Sample Product Module Related Subject Area Run Type
JE/DAS2 Updates Report for France.pdf Financials for EMEA None. Submitted/Batch
JE/DAS2 Verification Report for France.pdf Financials for EMEA None. Submitted/Batch
JE/Declarable Input VAT Register for Italy.pdf Financials for EMEA None. Submitted/Batch
JE/Declarable Output Vat Register for Italy.pdf Financials for EMEA None. Submitted/Batch
Page 56 of 81
Report Output Sample Product Module Related Subject Area Run Type
Page 57 of 81
Report Output Sample Product Module Related Subject Area Run Type
Page 58 of 81
Report Output Sample Product Module Related Subject Area Run Type
JA/General Ledger Journal and Subledger Transaction Mapping Report.xls None. Process Report
Financials for Asia/Pacific
JE/General Ledger Journal Entry Report.pdf General Ledger None. Not Applicable
Page 59 of 81
Report Output Sample Product Module Related Subject Area Run Type
JE/General Ledger Trial Balance Report.pdf General Ledger None. Not Applicable
JA/Golden Tax Transaction Consolidation Detail Report for China.pdf None. Process Report
Financials for Asia/Pacific
Page 60 of 81
Report Output Sample Product Module Related Subject Area Run Type
Assets
FA/Hypothetical What if Depreciation Analysis Report.pdf None. Submitted/Batch
JA/Input Tax Gain and Loss Report for Singapore.pdf None. Submitted/Batch
Financials for Asia/Pacific
JE/Input VAT Journal for Spain.pdf Financials for EMEA None. Submitted/Batch
Page 61 of 81
Report Output Sample Product Module Related Subject Area Run Type
Page 62 of 81
Report Output Sample Product Module Related Subject Area Run Type
JE/Journal Details Report for Germany.pdf Financials for EMEA None. Not Applicable
Page 63 of 81
Report Output Sample Product Module Related Subject Area Run Type
JE/Exemption Letter Report for Italy.pdf Financials for EMEA None. Submitted/Batch
Page 64 of 81
Report Output Sample Product Module Related Subject Area Run Type
JA/Output Tax Gain and Loss Report for Singapore.pdf None. Submitted/Batch
Financials for Asia/Pacific
JE/Output VAT Journal for Spain.pdf Financials for EMEA None. Submitted/Batch
JE/Payable Sales VAT Register for Self Invoices,Financials for EMEAand VAT for Italy.pdf
Inter-EU Invoices, None. Submitted/Batch
AP/Payables Invoice Audit Listing - PDF.pdf Payables Payables Invoices - Transactions Real Time On-Demand
Page 65 of 81
Report Output Sample Product Module Related Subject Area Run Type
AP/Payables Invoice Register.pdf Payables Payables Invoices - Transactions Real Time Submitted/Batch
AP/Invoice Register -PDF.pdf Payables Payables Invoices - Transactions Real Time On-Demand
Page 66 of 81
Report Output Sample Product Module Related Subject Area Run Type
Page 67 of 81
Report Output Sample Product Module Related Subject Area Run Type
AP/Payables Withholding Tax Letter.pdf Payables Payables Invoices - Transactions Real Time Submitted/Batch
Page 68 of 81
Report Output Sample Product Module Related Subject Area Run Type
Receivables
AR/Print Summary Balance Forward Bills Report.pdf None. Submitted/Batch
Page 69 of 81
Report Output Sample Product Module Related Subject Area Run Type
JE/Purchase VAT Register for Italy.pdf Financials for EMEA None. Submitted/Batch
Page 70 of 81
Report Output Sample Product Module Related Subject Area Run Type
Page 71 of 81
Report Output Sample Product Module Related Subject Area Run Type
Receivables
AR/Receivables Open Items Revaluation Report.pdf None. Submitted/Batch
JE/Receivables Sales VAT Register for Italy.pdf Financials for EMEA None. Submitted/Batch
Page 72 of 81
Report Output Sample Product Module Related Subject Area Run Type
Page 73 of 81
Report Output Sample Product Module Related Subject Area Run Type
JE/European Sales Listing Generic Detail.pdf Financials for EMEA None. Submitted/Batch
XLA/Subledger_Accounting_Method_Setups_Report.pdf
Accounting Hub None. Submitted/Batch
Page 74 of 81
Report Output Sample Product Module Related Subject Area Run Type
Accounting Hub
XLA/Subledger_Period_Close_Exceptions_Report.pdf None. Process Report
Page 75 of 81
Report Output Sample Product Module Related Subject Area Run Type
JE/Third Party Detail and Balances Report.pdf Accounting Hub None. Submitted/Batch
XLA/Third_Party_Control_Account_Balances_Report.pdf
Accounting Hub None. Submitted/Batch
Page 76 of 81
Report Output Sample Product Module Related Subject Area Run Type
Page 77 of 81
Report Output Sample Product Module Related Subject Area Run Type
Payables
AP/U.S. 1099 Forms - Comma Delimited Format.pdf None. Submitted/Batch
Page 78 of 81
Report Output Sample Product Module Related Subject Area Run Type
JE/VAT Inter-EU Invoice Format for Spain.pdf Financials for EMEA None. Submitted/Batch
JE/VAT Inter-EU Invoice Journal for Spain.pdf Financials for EMEA None. Submitted/Batch
JE/VAT Liquidation Report for Italy.pdf Financials for EMEA None. Submitted/Batch
Page 79 of 81
Report Output Sample Product Module Related Subject Area Run Type
JE/Withholding Tax Letters for Italy.pdf Financials for EMEA None. Submitted/Batch
JE/Withholding Tax Report for Spain.pdf Financials for EMEA None. Submitted/Batch
JE/Yearly Withholding Tax Report For Italy .pdf Financials for EMEA None. Submitted/Batch
Page 80 of 81
Report Output Sample Product Module Related Subject Area Run Type
Page 81 of 81