oracle business intelligence for financials guide outlines the information you need to know about...

Oracle Business Intelligence for Financials

What’s New in Release 10

June 2015

. 2

TABLE OF CONTENTS

OVERVIEW ............................................................................................................................................................. 4

GIve Us Feedback ............................................................................................................................................................... 4

ORACLE BUSINESS INTELLIGENCE CATALOG ........................................................................................................... 5

Simplified Security of Business Intelligence Catalog Folders (for Report Content Developers) ......................................... 5 Simplified Security of Business Intelligence Catalog Folders (for End-Users) .................................................................... 5

ORACLE TRANSACTIONAL BUSINESS INTELLIGENCE ............................................................................................... 6

ASSETS ........................................................................................................................................................................ 6 Fixed Assets – Asset Transactions Real Time ..................................................................................................................... 6

BUDGETARY CONTROL .................................................................................................................................................... 7 Budgetary Control - Transactions Real Time ...................................................................................................................... 7

CASH MANAGEMENT ..................................................................................................................................................... 7 Cash Management – External Cash Transactions Real Time .............................................................................................. 7

GENERAL LEDGER .......................................................................................................................................................... 7 General Ledger – Balances Real Time ................................................................................................................................ 7 General Ledger – Journals Real Time ................................................................................................................................. 8

PAYABLES .................................................................................................................................................................... 8 Payables Invoices – Holds Real Time .................................................................................................................................. 8 Payables Invoices – Installments Real Time ....................................................................................................................... 9 Payables Invoices – Prepayment Applications Real Time .................................................................................................. 9 Payables Invoices – Transactions Real Time .................................................................................................................... 17 Payables Invoices – Trial Balance Real Time .................................................................................................................... 19 Payables Payments – Disbursements Real Time .............................................................................................................. 19

RECEIVABLES .............................................................................................................................................................. 20 Receivables - Adjustments Real Time .............................................................................................................................. 20 Receivables – Bills Receivable Real Time ......................................................................................................................... 21 Receivables – Credit Memo Applications Real Time ........................................................................................................ 21 Receivables – Miscellaneous Receipts Real Time ............................................................................................................ 22 Receivables – Payment Schedules Real Time ................................................................................................................... 23 Receivables – Receipt Details Real Time .......................................................................................................................... 24 Receivables – Revenue Adjustments Real Time ............................................................................................................... 25 Receivables – Standard Receipts Application Details Real Time ...................................................................................... 26 Receivables – Transactions Real Time .............................................................................................................................. 27 Receivables – Customer Real Time .................................................................................................................................. 28

REVENUE MANAGEMENT .............................................................................................................................................. 29 Revenue Management – Revenue Compliance Fair Market Value Real Time ................................................................. 29 Revenue Management – Revenue Compliance MEA Carve-out Real Time ..................................................................... 30 Revenue Management – Revenue Recognition Real Time .............................................................................................. 32 Revenue Management – Source Documents Real Time .................................................................................................. 34

SUBLEDGER ACCOUNTING ............................................................................................................................................. 34 Subledger Accounting – Journals Real Time .................................................................................................................... 35 Subledger Accounting – Supporting References Real Time ............................................................................................. 35

PRE-UPGRADE PREPARATION .............................................................................................................................. 37

Preserve Customized Reports .......................................................................................................................................... 37

POST-UPGRADE CONSIDERATIONS ...................................................................................................................... 39

. 3

REVISION HISTORY ............................................................................................................................................... 40

. 4

OVERVIEW

This guide outlines the information you need to know about new or changed functionality in Oracle Business Intelligence for Financials in Release 10. There are no additional steps you need to take to enable or begin using these new features and content in your Oracle Business Intelligence analysis and reporting.

GIVE US FEEDBACK

We welcome your comments and suggestions to improve the content. Please send us your feedback at [email protected]

. 5

ORACLE BUSINESS INTELLIGENCE CATALOG

The Oracle Business Intelligence catalog stores the objects, such as reports, data models, and style templates, that you create using Oracle BI reporting tools. Users have their own personal folders (My Folders) where they can store their objects. The objects that are stored in personal folders can only be accessed by the user who created and saved the content into the folder. Users can add subfolders to their My Folders to organize their content in the way that is the most logical to them.

Users can also access objects in shared folders. This includes the preconfigured dashboards, reports and analyses that are distributed with Oracle Financials Cloud. User permissions determine which folders are available to which users.

SIMPLIFIED SECURITY OF BUSINESS INTELLIGENCE CATALOG FOLDERS (FOR REPORT CONTENT DEVELOPERS)

Oracle Fusion Applications has simplified the security structure of Business Intelligence Catalog folders containing BI Publisher reports supplied by Oracle. Oracle secures such folders using grants to only two roles:

1. one grant to the BI Administrator role which has Full access to such folders (this is the same as in previous releases), and

2. one grant to the BI Consumer role which provides Read and Traverse permissions only.

Content designers without the BI Administrator role may see more folders when viewing the Catalog in the Business Intelligence Enterprise Edition work areas than they may have seen in previous releases. This has no effect on the reports to which a designer may access in the Catalog.

SIMPLIFIED SECURITY OF BUSINESS INTELLIGENCE CATALOG FOLDERS (FOR END-USERS)

Oracle Fusion Applications has simplified the security structure of Business Intelligence Catalog folders containing BI Publisher reports supplied by Oracle. As a result, an end user may see more folders when viewing the Catalog in the Reporting and Analytics Work Area. This has no effect on which reports an end-user may run.

. 6

ORACLE TRANSACTIONAL BUSINESS INTELLIGENCE

Oracle Transactional Business Intelligence is a real time, self service analysis and reporting solution offered to Oracle Financials Cloud application users to create ad hoc analyses and analyze them for daily decision-making. Oracle Transactional Business Intelligence reports are constructed queries and reports executed in real time against the transactional schema supported by a layer of view objects. These are configured and deployed during provisioning.

Each of the following sections includes a brief introduction to the subject area and a table listing the changes that have been made in this release.

ASSETS

FIXED ASSETS – ASSET TRANSACTIONS REAL TIME

This subject area contains real time information on asset transactions such as Additions, Transfers, Adjustments, Reinstatements, Retirements, and so on. Accounting information on the transactions is also provided.

The following table gives details of the changes to subject areas and columns in this release.

Subject Area Name Folder Name Presentation Column Name Change Fixed Assets - Asset Transactions Real Time

Overridden Balancing Segment

GL Overridden Balancing Segment Code Added


GL Overridden Balancing Segment Description Added


GL Overridden Balancing Segment Tree Filter Added

Overridden Balancing Segment Overridden Balancing Segment Added

Overridden Cost Center GL Overridden Cost Center Code Added

Overridden Cost Center GL Overridden Cost Center Description Added

Overridden Cost Center GL Overridden Cost Center Tree Filter Added

Overridden Cost Center GL Overridden Cost Center Added

Overridden Natural Account GL Overridden Natural Account Code Added

Overridden Natural Account

GL Overridden Natural Account Description Added


GL Overridden Natural Account Tree Filter Added

. 7

BUDGETARY CONTROL

BUDGETARY CONTROL - TRANSACTIONS REAL TIME

This subject area contains real time budgetary control and source transaction attributes for ad hoc reporting.


Subject Area Name Folder Name Presentation Column Name Change Budgetary Control - Transactions Real Time

Budgetary Control Transaction Details Transaction Line Data SetID Deleted

CASH MANAGEMENT

CASH MANAGEMENT – EXTERNAL CASH TRANSACTIONS REAL TIME

This subject area contains real time information on external transactions generated from the Bank Statement, Statement Reconciliation or Manual Entry.


Subject Area Name Folder Name Presentation Column Name Change Cash Management - External Cash Transactions Real Time Business Unit Financial Business Unit Name Deleted

GENERAL LEDGER

GENERAL LEDGER – BALANCES REAL TIME

This subject area contains real time information on general ledger balances.


Subject Area Name Folder Name Presentation Column Name Change General Ledger - Balances Scenario Added

. 8

Balances Real Time Balances Sub Scenario Added Balances Scenario Hierarchy Added

GENERAL LEDGER – JOURNALS REAL TIME

This subject area contains real time information on general ledger journals.


Subject Area Name Folder Name Presentation Column Name Change General Ledger - Journals Real Time Header Details

Accounting Sequence Version Header Name Added

Header Details Accounting Sequence Version Name Added Header Details Journal Legal Entity Added

Header Details Reporting Sequence Version Header Name Added

Header Details Reporting Sequence Version Name Added

PAYABLES

PAYABLES INVOICES – HOLDS REAL TIME

This subject area contains real time information on holds applied to an invoice.


Subject Area Name Folder Name Presentation Column Name Change

Payables Invoices - Holds Real Time

Invoice Line Details - Purchase Order Information Consumption Advice Line Number Added

Invoice Line Details - Purchase Order Information Consumption Advice Number Added

Invoice Line Details - Tax Information Location of Final Discharge Added

Invoice Line Details - Tax Information Ship-from Location Added

Invoice Details First-Party Tax Registration Number Added Invoice Details Supplier Tax Registration Number Added

. 9

PAYABLES INVOICES – INSTALLMENTS REAL TIME

This subject area contains real time information on invoice payment installment information.


Subject Area Name Folder Name Presentation Column Name Change Payables Invoices - Installments Real Time Invoice Details First-Party Tax Registration Number Added Invoice Details Supplier Tax Registration Number Added

PAYABLES INVOICES – PREPAYMENT APPLICATIONS REAL TIME

This subject area contains real time distribution information for prepayments that were applied against standard invoices.


Subject Area Name Folder Name Subfolder Name Presentation Column Name Change Payables Invoices - Prepayment Applications Real Time Business Unit Financials Business Unit Deleted

Distributions Distribution Accounting Date Deleted

Distributions

Distribution Accounting Date Fiscal Calendar Deleted

Distributions Distribution Balancing Segment Value Deleted

Distributions Distribution Combination Deleted

Distributions Distribution Cost Center Segment Value Deleted

Distributions

Distribution Natural Account Segment Value Deleted

Distributions Invoice Distributions Added Distributions Invoice Distributions Accounted Amount Added

Distributions Invoice Distributions Amount Subject to Withholding Tax Added

Distributions Invoice Distributions Distributions Total Amount Added Distributions Invoice Distributions Invoice Distribution Amount Added

Distributions Invoice Distributions Invoice Distribution Amount Variance Added

Distributions Invoice Distributions

Invoice Distribution Amount at Prepayment Conversion Rate Added

Distributions Invoice Distributions Invoice Distribution Amount at Prepayment Payment Added

. 10

Conversion Rate

Distributions Invoice Distributions Invoice Distribution Final Application Rounding Added

Distributions Invoice Distributions Invoice Distribution Final Payment Rounding Added

Distributions Invoice Distributions Invoice Distribution Ledger Amount Variance Added


Invoice Distribution Prepayment Amount Remaining Added


Invoice Distribution Prepayment Tax Difference Amount Added

Distributions Invoice Distributions Invoice Distribution Rounding Amount Added

Distributions Invoice Distributions Invoice Distribution Taxable Amount Added

Distributions Invoice Distributions Invoice Distribution Taxable Ledger Amount Added

Distributions Invoice Distributions Invoice Distribution Total Distribution Ledger Amount Added

Distributions Invoice Distributions Project Quantity Added Distributions Invoice Distributions Currency Code Added Distributions Invoice Distributions Ledger Currency Added Distributions Liability Account Deleted

Distributions Liability Balancing Segment Value Deleted

Distributions Liability Cost Center Segment Value Deleted

Distributions

Liability Natural Account Segment Value Deleted

Invoice Lines Invoice Line Amounts Added Invoice Lines Invoice Line Amounts Accounted Amount Added

Invoice Lines Invoice Line Amounts Applied Prepayments In Entered Currency Added

Invoice Lines Invoice Line Amounts Applied Prepayments In Ledger Currency Added

Invoice Lines Invoice Line Amounts Included Tax Amount Added Invoice Lines Invoice Line Amounts Invoice Line Amount Added Invoice Lines Invoice Line Amounts Original Accounted Amount Added Invoice Lines Invoice Line Amounts Original Amount Added Invoice Lines Invoice Line Amounts Original Rounding Amount Added Invoice Lines Invoice Line Amounts Rounding Amount Added

Invoice Lines Invoice Line Amounts Withheld Amount In Entered Currency Added

Invoice Lines Invoice Line Amounts Withheld Amount In Ledger Currency Added

Invoice Lines Invoice Line Amounts Invoice Currency Added Invoice Lines Invoice Line Amounts Ledger Currency Added Invoices Details Invoice Amounts Added Invoices Details Invoice Amounts Canceled Amount Added

. 11

Invoices Details Invoice Amounts Control Amount Added Invoices Details Invoice Amounts Discount Taken Added Invoices Details Invoice Amounts Discountable Amount Added Invoices Details Invoice Amounts Invoice Amount Added Invoices Details Invoice Amounts Invoice Amount Paid Added

Invoices Details Invoice Amounts Invoice Amount in Ledger Currency Added

Invoices Details Invoice Amounts Invoice Self-Assessed Tax Amount Added

Invoices Details Invoice Amounts Total Tax Charged Added Invoices Details Invoice Amounts Currency Code Added Invoices Details Invoice Amounts Ledger Currency Added

Prepayment Application Accounting

Subledger Accounting Journals Details Added


Subledger Accounting Journals Details Accounting Sequence Number Added


Subledger Accounting Journals Details

Intercompany Completion Accounting Sequence Version Name Added

Prepayment Applications Application Amounts Added

Prepayment Applications Application Amounts Amount Variance Added

Prepayment Applications Application Amounts

Invoice Variance Amount Ledger Currency Added


Ledger Amount at Prepayment Clearing Conversion Rate Added


Ledger Amount at Prepayment Conversion Rate Added


Ledger Amount at Prepayment Payment Conversion Rate Added


Prepayment Application Amount Added


Prepayment Application Distribution Ledger Amount Added


Prepayment Application Line Accounted Amount Added


Prepayment Application Line Amount Added


Prepayment Included Tax Amount Added

Prepayment Applications Application Amounts Rounding Amount Added


Rounding Amount at Prepayment Clearing Conversion Rate Added


Rounding Amount at Prepayment Creation Added

. 12

Conversion Rate


Rounding Amount at Prepayment Payment Conversion Rate Added

Prepayment Applications Application Amounts Currency Code Added

Prepayment Applications Application Amounts Ledger Currency Added

Prepayment Applications

Distribution Details: Distribution Cost Center Segment Value Added


Distribution Details: Distribution Cost Center Segment Value Cost Center Code Added


Distribution Details: Distribution Cost Center Segment Value Cost Center Description Added


Distribution Details: Distribution Cost Center Segment Value Cost Center Tree Filter Added


Distribution Details: Distribution Cost Center Segment Value Cost Center Added


Distribution Details: Distribution Accounting Date Fiscal Calendar Added


Distribution Details: Distribution Accounting Date Fiscal Calendar Accounting Date Added


Distribution Details: Distribution Accounting Date Fiscal Calendar Accounting Period End Date Added


Distribution Details: Distribution Accounting Date Fiscal Calendar Accounting Period Name Added


Distribution Details: Distribution Accounting Date Fiscal Calendar Accounting Period Number Added


Distribution Details: Distribution Accounting Date Fiscal Calendar Accounting Period Start Date Added


Distribution Details: Distribution Accounting Date Fiscal Calendar Accounting Quarter End Date Added


Distribution Details: Distribution Accounting Quarter Number Added

. 13

Accounting Date Fiscal Calendar


Distribution Details: Distribution Accounting Date Fiscal Calendar Accounting Quarter Start Date Added


Distribution Details: Distribution Accounting Date Fiscal Calendar Accounting Year Added


Distribution Details: Distribution Accounting Date Fiscal Calendar Accounting Year End Date Added


Distribution Details: Distribution Accounting Date Fiscal Calendar Accounting Year Start Date Added


Distribution Details: Distribution Accounting Date Fiscal Calendar Fiscal Day Name Added


Distribution Details: Distribution Accounting Date Fiscal Calendar Fiscal Quarter Added


Distribution Details: Distribution Accounting Date Fiscal Calendar Name Added


Distribution Details: Distribution Accounting Date Fiscal Calendar

AP Accounting Date Fiscal Calendar Added


Distribution Details: Distribution Accounting Date Calendar Month Code Added


Distribution Details: Distribution Accounting Date Calendar Month End Date Added


Distribution Details: Distribution Accounting Date Calendar Month Start Date Added


Distribution Details: Distribution Accounting Date Calendar Quarter Code Added


Distribution Details: Distribution Accounting Date Calendar Quarter End Date Added


Distribution Details: Distribution Accounting Date Calendar Quarter Start Date Added

Prepayment Distribution Details: Calendar Week Code Added

. 14

Applications Distribution Accounting Date


Distribution Details: Distribution Accounting Date Calendar Week End Date Added


Distribution Details: Distribution Accounting Date Calendar Week Start Date Added


Distribution Details: Distribution Accounting Date Calendar Year End Date Added


Distribution Details: Distribution Accounting Date Calendar Year Start Date Added


Distribution Details: Distribution Accounting Date Day Name Added


Distribution Details: Distribution Accounting Date Report Date Added


Distribution Details: Distribution Accounting Date Year Added


Distribution Details: Distribution Accounting Date

AP Accounting Date - Week To Year Added


Distribution Details: Distribution Accounting Date AP Accounting Date - Year Added


Distribution Details: Distribution Balancing Segment Value Added


Distribution Details: Distribution Balancing Segment Value Balancing Segment Code Added


Distribution Details: Distribution Balancing Segment Value

Balancing Segment Description Added


Distribution Details: Distribution Balancing Segment Value Balancing Segment Tree Filter Added


Distribution Details: Distribution Balancing Segment Value Balancing Segment Added


Distribution Details: Distribution Combination Added


Distribution Details: Distribution Combination Account Description Added


Distribution Details: Distribution Combination Account Type Added

. 15


Distribution Details: Distribution Combination Chart of Accounts Added


Distribution Details: Distribution Combination Code Combination Summary Added


Distribution Details: Distribution Combination Concatenated Segments Added


Distribution Details: Distribution Combination Concatenated Segments Added


Distribution Details: Distribution Combination Enabled Added


Distribution Details: Distribution Combination From Date Added


Distribution Details: Distribution Combination Key Flex Field Enabled Added


Distribution Details: Distribution Combination Summary Account Added


Distribution Details: Distribution Combination To Date Added


Distribution Details: Distribution Natural Account Segment Value Added


Distribution Details: Distribution Natural Account Segment Value Account Code Added


Distribution Details: Distribution Natural Account Segment Value Account Description Added


Distribution Details: Distribution Natural Account Segment Value Account Tree Filter Added


Distribution Details: Distribution Natural Account Segment Value Natural Account Segment Added


Distribution Details: Liability Account Added


Distribution Details: Liability Account Account Description Added


Distribution Details: Liability Account Account Type Added

. 16


Distribution Details: Liability Account Chart of Accounts Added


Distribution Details: Liability Account Code Combination Summary Added


Distribution Details: Liability Account Concatenated Segments Added


Distribution Details: Liability Account Enabled Added


Distribution Details: Liability Account From Date Added


Distribution Details: Liability Account Key Flex Field Enabled Added


Distribution Details: Liability Account Summary Account Added


Distribution Details: Liability Account To Date Added


Distribution Details: Liability Balancing Segment Value

Added


Distribution Details: Liability Balancing Segment Value Balancing Segment Code Added


Distribution Details: Liability Balancing Segment Value

Balancing Segment Description Added


Distribution Details: Liability Balancing Segment Value Balancing Segment Tree Filter Added


Distribution Details: Liability Balancing Segment Value Balancing Segment Added


Distribution Details: Liability Cost Center Segment Value Added


Distribution Details: Liability Cost Center Segment Value Cost Center Code Added


Distribution Details: Liability Cost Center Segment Value Cost Center Description Added


Distribution Details: Liability Cost Center Segment Value Cost Center Tree Filter Added


Distribution Details: Liability Cost Center Segment Value Cost Center Added


Distribution Details: Liability Natural Account Segment Value Added


Distribution Details: Liability Natural Account Segment Account Code Added

. 17

Value


Distribution Details: Liability Natural Account Segment Value Account Description Added


Distribution Details: Liability Natural Account Segment Value Account Tree Filter Added


Distribution Details: Liability Natural Account Segment Value Natural Account Segment Added

Prepayment Applications Invoice Details Added

Prepayment Applications Invoice Details Applied to Invoice Number Added

Prepayment Applications Invoice Details

Applied to Invoice Supplier Site Added

Prepayment Applications Invoice Details Related Purchase Order Added

Prepayment Applications Line Details Added

Prepayment Applications Line Details

Applied to Invoice Line Number Added

Prepayment Applications Line Details

Prepayment Included on Invoice Indicator Added

PAYABLES INVOICES – TRANSACTIONS REAL TIME

This subject area contains real time information on invoices.


Subject Area Name Folder Name Subfolder Name Presentation Column Name Change Payables Invoices - Transactions Real Time Accounting



Accounting Overridden Balancing Segment





Overridden Balancing Segment Added

Accounting Overridden Cost Center

GL Overridden Cost Center Code Added


GL Overridden Cost Center Description Added


GL Overridden Cost Center Tree Filter Added

. 18

Accounting Overridden Cost Center GL Overridden Cost Center Added

Accounting Overridden Natural Account

GL Overridden Natural Account Code Added






GL Overridden Natural Accounting Segment Added

Invoice Lines Invoice Line Details - Approval Information" Line Approval Action Code Added

Invoice Lines Invoice Line Details - Approval Information" Line Approval Action Date Added

Invoice Lines Invoice Line Details - Approval Information" Line Approval Action Added

Invoice Lines Invoice Line Details - Approval Information" Line Approval Action Context Added

Invoice Lines Invoice Line Details - Approval Information" Line Approval Status Code Added

Invoice Lines Invoice Line Details - Approval Information" Line Approval Status Added

Invoice Lines Invoice Line Details - Approval Information" Line Approver Added

Invoice Lines Invoice Line Details - Approval Information" Line Reviewed Amount Added

Invoice Lines

Invoice Line Details - Purchase Order Information

Consumption Advice Line Number Added

Invoice Lines

Invoice Line Details - Purchase Order Information Consumption Advice Number Added

Invoice Lines Invoice Line Details - Tax Information Location of Final Discharge Added

Invoice Lines Invoice Line Details - Tax Information Ship-from Location Added

Invoice Details Reference Information First-Party Tax Registration Number Added

Invoice Details Reference Information Supplier Tax Registration Number Added

Accounting Subledger Accounting Journals Details Accounting Sequence Name Added

Accounting Subledger Accounting Journals Details


. 19

PAYABLES INVOICES – TRIAL BALANCE REAL TIME

This subject area contains real time information on posted invoices and payments so that users can reconcile Payables balances with the General Ledger balance.


Subject Area Name Folder Name Presentation Column Name Change Payables Invoices – Trial Balance Real Time Invoice Details First-Party Tax Registration Number Added Invoice Details Supplier Tax Registration Number Added

PAYABLES PAYMENTS – DISBURSEMENTS REAL TIME

This subject area contains real time information on amounts spent or expensed.


Subject Area Name Folder Name Subfolder Name Presentation Column Name Change Payables Payments - Disbursements Real Time Accounting

Subledger Accounting Journals Details Accounting Sequence Name Added

Accounting Subledger Accounting Journals Details
















Accounting Overridden Cost Center GL Overridden Cost Center Added









. 20

RECEIVABLES

RECEIVABLES - ADJUSTMENTS REAL TIME

This subject area contains real time information on transaction adjustments.


Subject Area Name Folder Name Subfolder Name Presentation Column Name Change

Receivables - Adjustments Real Time

Receivables Adjustments Accounting



Subledger Accounting Journals Details Accounting Sequence Version Added














Overridden Cost Center
















Receivables Adjustments



. 21

Accounting




Adjustments Details Created By Added

Adjustments Details Creation Date Added

Adjustments Details Last Updated By Added

Adjustments Details Last Updated Date Added

RECEIVABLES – BILLS RECEIVABLE REAL TIME

This subject area contains real time information on bills receivable transactions.


Subject Area Name Folder Name Subfolder Name Presentation Column Name Change Receivables - Bills Receivable Real Time

Bills Receivable Accounting


Bills Receivable Accounting


RECEIVABLES – CREDIT MEMO APPLICATIONS REAL TIME

This subject area contains real time information on application of credit memos to both debit items and receipts.


Subject Area Name Folder Name Subfolder Name Presentation Column Name Change Receivables - Credit Memo Applications Real Time

Receivables Credit Memo Applications Accounting










Receivables Credit Memo Applications



. 22

Accounting



























RECEIVABLES – MISCELLANEOUS RECEIPTS REAL TIME

This subject area contains real time information on miscellaneous receipts, such as interest earned, and non-customer related receipts.



Receivables - Miscellaneous Receipts Real Time

Miscellaneous Receipt Accounting










. 23






























Miscellaneous Receipts Details Created By Added

Miscellaneous Receipts Details Creation Date Added

Miscellaneous Receipts Details Last Updated By Added

Miscellaneous Receipts Details Last Updated Date Added

Miscellaneous Receipts Details Receipt State Code Added

Miscellaneous Receipts Details Receipt State Added

RECEIVABLES – PAYMENT SCHEDULES REAL TIME

This subject area contains real time information on payment schedules for transactions including installment information.


. 24

Subject Area Name Folder Name Presentation Column Name Change Receivables - Payment Schedules Real Time

Payment Schedules Details Installment Closed Accounting Date Added

Payment Schedules Details Installment Closed Date Added

RECEIVABLES – RECEIPT DETAILS REAL TIME

This subject area contains real time information on customer receipts, including manual receipts, receipts entered from a spreadsheet and receipts imported through the lockbox.


Subject Area Name Folder Name Subfolder Name Presentation Column Name Change Receivables - Receipts Details Real Time Receipt Details Created By Added Receipt Details Creation Date Added Receipt Details Last Updated By Added Receipt Details Last Updated Date Added Receipt Details Receipt Status Code Added Receipt Details Receipt Status Added Receipt Details Maturity Date Added Receipt Details Receipt Number Added

Receipt Accounting



Receipt Accounting



Receipt Accounting



Receipt Accounting



Receipt Accounting



Receipt Accounting



Receipt Accounting



Receipt Accounting


Receipt Accounting



Receipt Accounting



Receipt Accounting



Receipt Accounting



. 25

RECEIVABLES – REVENUE ADJUSTMENTS REAL TIME

This subject area contains real time information on revenue adjustments, including associated distributions and accounting treatments.



Receivables - Revenue Adjustments Real Time

Receivables Revenue Adjustments Accounting






























. 26










RECEIVABLES – STANDARD RECEIPTS APPLICATION DETAILS REAL TIME

This subject area contains real time information on the details of receipt application attributes including application status. The following table gives details of the changes to subject areas and columns in this release.

Subject Area Name Folder Name Subfolder Name Presentation Column Name Change Receivables - Standard Receipts Application Details Real Time

Standard Receipts Accounting




Standard Receipts Accounting Added



















Standard Overridden Cost GL Overridden Cost Center Added

. 27

Receipts Accounting

Center Tree Filter















Standard Receipts Application details

Related Customer Account Number Added

Standard Receipts details Created By Added

Standard Receipts details Created Date Added

Standard Receipts details Debit Memo Reversal Number Added

Standard Receipts details Last Updated By Added

Standard Receipts details Last Updated Date Added

Standard Receipts details Receipt State Code Added

Standard Receipts details Receipt State Added

RECEIVABLES – TRANSACTIONS REAL TIME

This subject area contains real time information on transaction header and transaction lines for invoices, credit memos, and debit memos (it does not include tax and freight attributes). The following table gives details of the changes to subject areas and columns in this release.

Subject Area Name Folder Name Subfolder Name Presentation Column Name Change Receivables - Transactions Real Time

Transactions Details General Information Transaction Source Added

Transactions Details Reference Information Created By Added

Transactions Reference Information Created Date Added

. 28

Details

Receivables Transactions Accounting




































RECEIVABLES – CUSTOMER REAL TIME

This subject area contains real time transactional analysis on customers with their respective attributes.


Receivables - Customer Real Time Subject Area New Subject Area Added

. 29

REVENUE MANAGEMENT

REVENUE MANAGEMENT – REVENUE COMPLIANCE FAIR MARKET VALUE REAL TIME

This subject area contains real time information on fair market values, the underlying standalone sales, as well as the system suggested status, review status and the established status of each FMV.


Subject Area Name Folder Name Subfolder Name Presentation Column Name Change Revenue Management - Revenue Compliance Fair Market Value Real Time Fair Market Value VSOE Information

Deleted

Fair Market Value Compliance Details Comments Added Fair Market Value Compliance Details Coverage End Date Added Fair Market Value Compliance Details Coverage Start Date Added Fair Market Value Compliance Details Created By Added Fair Market Value Compliance Details Creation Date Added Fair Market Value Compliance Details Data Set Type Added Fair Market Value Compliance Details Element Type Added Fair Market Value Compliance Details Element Type Code Added Fair Market Value Compliance Details Exception Comment Added Fair Market Value Compliance Details Exchange Date Added Fair Market Value Compliance Details Exchange Rate Added Fair Market Value Compliance Details Exchange Rate Type Added Fair Market Value Compliance Details Last Updated By Added Fair Market Value Compliance Details Last Updated Date Added Fair Market Value Compliance Details Line Excluded By Added Fair Market Value Compliance Details Line Exclusion Reason Added Fair Market Value Compliance Details Line Exclusion Reason Code Added Fair Market Value Compliance Details Line Exclusion Status Added Fair Market Value Compliance Details Review Reason Added Fair Market Value Compliance Details Review Reason Code Added Fair Market Value Compliance Details Review Status Added Fair Market Value Compliance Details Review Status Code Added

Fair Market Value Compliance Details Source Document Line Identifier Added

Fair Market Value Compliance Details User Comments Added Fair Market Value Compliance Details VSOE Value Status Added Fair Market Value Compliance Details VSOE Value Status Code Added Fair Market Value Compliance Details Value Reason Added Fair Market Value Compliance Details Value Reason Code Added Fair Market Value Compliance Values Base Price Added Fair Market Value Compliance Values Net Discount Amount Added Fair Market Value Compliance Values Net Line Amount Added Fair Market Value Compliance Values Net Quantity Added Fair Market Value Compliance Values Net Unit Sales Percentage of Added

. 30

Base Price Fair Market Value Compliance Values Net Unit Sales Price Added Fair Market Value Compliance Values Revised Cost Added Fair Market Value Compliance Values Net Discount Percentage Added

Fair Market Value Compliance Values Revised Gross Margin Percentage Added

Fair Market Value Compliance Values Unit of Measure Added

FMV Source Document

Source Document Line Details

Source Document Line Identifier Added

FMV Source Document

Source Document Line References Amounts

Percentage of Base Selling Price Added

FMV Source Document

Source Document Line References Amounts Quantity Added

FMV Source Document

Source Document Line References Amounts Revised Cost Added

FMV Source Document

Source Document Line References Amounts Revised Gross Margin Added

FMV Source Document

Source Document Line References Amounts Selling Amount Added

FMV Source Document

Source Document Line References Amounts Unit List Price Added

FMV Source Document

Source Document Line References Amounts Unit Selling Price Added

FMV Source Document


Unit List Price Discount Percentage Added

FMV Source Document

Source Document Line References Details Line Reference Date Added

FMV Source Document

Source Document Line References Details

Line Reference Version Number Added

REVENUE MANAGEMENT – REVENUE COMPLIANCE MEA CARVE-OUT REAL TIME

This subject area contains real time information on Multiple Element Arrangements including the applicable compliance adjustments and their status.


Subject Area Name Folder Name Subfolder Name Presentation Column Name Change Revenue Management - Revenue Compliance MEA Carve-out Real Time MEA Document

Carve-out Adjustment Header Details Suggested Carve-out Method Added

MEA Document

Carve-out Adjustment Header Details Activity Indicator Added

MEA Document

Carve-out Adjustment Header Details Latest Record Indicator Added

MEA Document Carve-out Added

. 31

Lines Adjustment Line Amounts

MEA Document Lines

Carve-out Adjustment Line Amounts

Adjusted Revenue Entered Amount Added

MEA Document Lines


Adjusted Unit List Price Discount Percentage Added

MEA Document Lines

Carve-out Adjustment Line Amounts Carve-out Unit Selling Price Added

MEA Document Lines


Percentage of Base Price After Adjustment Added

MEA Document Lines


Recommended Revenue Carve-out Entered Amount Added

MEA Document Lines


Revenue Carve-out Line Entered Amount Added

MEA Document Lines


Revenue Carve-out Line Percentage Added

MEA Document Lines


Total FMV Entered Amount for MEA Line Added

MEA Document Lines


Total Line Entered Amount for MEA Line Added

MEA Document Lines


Adjusted Gross Margin Percentage Added

MEA Document Lines


Recommended Percentage of Total MEA Carve- Added

MEA Document Lines

Carve-out Adjustment Line Details Delivery Status Code Added

MEA Document Lines

Carve-out Adjustment Line Details Activity Indicator Added

MEA Document Lines

Carve-out Adjustment Line Details Delivery Status Added

MEA Document Lines

Carve-out Adjustment Line Details Fulfillment Date Added

MEA Document MEA Document Details

Total Entered Amount Requiring Attention Added

MEA Document Lines

MEA Document Line Amounts Unit Revenue Price Added

MEA Document Lines

MEA Document Line Amounts


. 32

MEA Document Lines

MEA Document Line Details Adjustment Action Code Added

MEA Source Document



MEA Source Document



MEA Source Document


MEA Source Document


MEA Source Document


MEA Source Document

Source Document Line References Details Added

MEA Source Document


MEA Source Document



REVENUE MANAGEMENT – REVENUE RECOGNITION REAL TIME

This subject area contains real time information on Revenue Documents and their associated revenue schedules, contingencies, splits and more.


Subject Area Name Folder Name Subfolder Name Presentation Column Name Change Revenue Management - Revenue Recognition Real Time Accounting


Accounting Overridden Cost Center Added

Accounting Overridden Natural Account Added

Revenue Activities

Carve-out Adjustment Line Amounts Added

Revenue Activities


Adjusted Revenue Entered Amount Added

Revenue Activities


Adjusted Unit List Price Discount Percentage Added

. 33

Revenue Activities

Carve-out Adjustment Line Amounts Carve-out Unit Selling Price Added

Revenue Activities


Percentage of Base Price After Adjustment Added

Revenue Activities


Recommended Revenue Carve-out Entered Amount Added

Revenue Activities


Revenue Carve-out Line Entered Amount Added

Revenue Activities


Revenue Carve-out Line Percentage Added

Revenue Activities



Revenue Activities



Revenue Activities


Adjusted Gross Margin Percentage Added

Revenue Activities


Recommended Percentage of Total MEA Carve-out Amount Added

Revenue Activities



Revenue Activities



Revenue Activities

MEA Document Line Amounts Unit Revenue Price Added

Revenue Activities

MEA Document Line Details Adjustment Action Added

Revenue Activities

MEA Document Line Details Adjustment Action Code Added

Revenue Activities

Revenue Activity Amounts Carve-out Percentage Deleted

Revenue Activities

Revenue Activity Amounts

Default Carve-Out Adjustment Percentage Added

Revenue Activities

Revenue Activity Details Activity Type Added

Revenue Activities

Revenue Activity Details Activity Type Code Added

Revenue Activities

Revenue Activity Details

Revenue Adjustment Line Selection Criteria Added

Revenue Activities


Revenue Adjustment Line Selection Criteria Code Added

Revenue Activities


Type of Revenue Adjustment Amount Added

Revenue Activities


Type of Revenue Adjustment Amount Code Added

. 34

REVENUE MANAGEMENT – SOURCE DOCUMENTS REAL TIME

This subject area contains real time information on all the source documents imported into Fusion Revenue Management.


Subject Area Name Folder Name Subfolder Name Presentation Column Name Change Revenue Management - Source Documents Real Time Source Document



Source Document



Source Document

Source Document Line References Amounts Quantity Added

Source Document

Source Document Line References Amounts Revised Cost Added

Source Document


Source Document


Source Document

Source Document Line References Amounts Unit List Price Added

Source Document


Source Document


Unit List Price Discount Percentage Added

Source Document


Source Document



SUBLEDGER ACCOUNTING

. 35

SUBLEDGER ACCOUNTING – JOURNALS REAL TIME

This subject area contains real time information on subledger transaction level journals.


Subject Area Name Folder Name Presentation Column Name Change Subledger Accounting - Journals Real Time

Journal Details Intercompany Completion Accounting Sequence Version Name

Added


GL Overridden Balancing Segment Tree Filter

Added


GL Overridden Balancing Segment Code

Added


GL Overridden Balancing Segment Description

Added




GL Overridden Natural Account Tree Filter

Added


GL Overridden Natural Account Code

Added


GL Overridden Natural Account Description

Added


GL Overridden Natural Accounting Segment

Added

Overridden Cost Center GL Overridden Cost Center Tree Filter

Added

Overridden Cost Center GL Overridden Cost Center Code Added Overridden Cost Center GL Overridden Cost Center

Description Added


SUBLEDGER ACCOUNTING – SUPPORTING REFERENCES REAL TIME

This subject area contains real time information on Subledger Accounting supporting reference details.


Subject Area Name Folder Name Presentation Column Name Change Subledger Accounting - Supporting References Real Time

Supporting Reference Balances

Entered Currency Opening Balance CR

Added


Entered Currency Opening Balance DR

Added


Entered Currency Period Balance CR Added


Entered Currency Period Balance DR Added

Supporting Reference Document Currency Added

. 36

Balances Supporting Reference

Balances Ledger Currency Added

. 37

PRE-UPGRADE PREPARATION

Please review the following pre-upgrade considerations for Oracle Transactional Business Intelligence for Financials Release 10:

• Ensure that any custom BI reports or templates (Oracle Fusion Transactional BI or BI Publisher), or delivered reports you have modified, are stored in the folder labeled Shared Folders > Custom. Alternatively you may download BI content to local storage and reload it once the upgrade is complete, using the Archive / Unarchive feature. For more details, see Guidance for Managing Customizations in Oracle Cloud Application Services: Business Intelligence Migration (Doc ID 1510577.1)

PRESERVE CUSTOMIZED REPORTS

During the upgrade, any reports that you have changed will get overwritten. To preserve your customized reports, do one of the following:

• Move all your customized reports to one of these folders: o “Custom” folder under “Shared Folders” if you want the report to be available to

others. o “My Folders” if you are not sharing the report.

Important: The changes to reports in other folders will be overwritten.

• Archive your reports on your local machine to back them up. And upload (unarchive) them in the upgraded environment.

https://support.oracle.com/epmos/faces/DocumentDisplay?id=1510577.1

https://support.oracle.com/epmos/faces/DocumentDisplay?id=1510577.1

. 39

POST-UPGRADE CONSIDERATIONS

After your upgrade is complete, you should perform the following steps for Oracle Financials Cloud:

• Restore and verify any custom Oracle Fusion Transactional BI and BI Publisher content and Financial Reporting Studio reports.

• Conduct a thorough test of your upgraded environment as soon as possible.

. 40

REVISION HISTORY

This document will continue to evolve as existing sections change and new information is added. All updates are logged below, with the most recent updates at the top.

Date What’s Changed Notes

Copyright © 2015, Oracle and/or its affiliates. All rights reserved.

This document is provided for information purposes only, and the contents hereof are subject to change without notice. This document is not warranted to be error-free, nor subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this document, and no contractual obligations are formed either directly or indirectly by this document. This document may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.