Update 19C

Revision History

This document will continue to evolve as existing sections change and new information is added. All updates appear in the following table:

Overview

This guide outlines the information you need to know about new or improved functionality in this update.

DISCLAIMER

The information contained in this document may include statements about Oracle’s product development plans. Many factors can materially affect Oracle’s product development plans and the nature and timing of future product releases. Accordingly, this Information is provided to you solely for information only, is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle.

This information may not be incorporated into any contractual agreement with Oracle or its subsidiaries or affiliates. Oracle specifically disclaims any liability with respect to this information. Refer to the Legal Notices and Terms of Use for further information.

Common Technology and User Experience

Common Financials Features

Enhanced List of Values User Experience

Enjoy a faster and more consistent user experience when selecting an item from a list of values. Select from a short list of suggestions via a quick auto-suggest search, or search by a single character across multiple attributes. The updated business objects include Business Unit, Ledger, Legal Entity, Currency Conversion Type, and Currency.

Manage Personally Identifiable Information in Financials

Remove the personally identifiable information of an individual in accordance to the 'right to be forgotten' compliance with the European Union’s General Data Protection Regulation (GDPR) policy.

Workflow Transactions Listing Report

View the pending and rejected transactions of the Payables Invoice Account Coding and Invoice Approval workflows.

Intercompany

Assign Conversion Rate Types to Each Intercompany Transaction Type

Default the conversion rate type for each intercompany transaction type to control the currency rate that will be used by transaction type.

REST APIs for Financials

General Ledger

REST APIs for Journals

The Journals REST API resource has been enhanced to let you mark journals for reversal.

REST APIs for Ledger Balances

The Ledger Balances REST API resource has been enhanced to support inquiry of detail account balances, and budget and encumbrance balances; and support for ledger sets.

Payables

REST APIs for Supplier Invoices

View and update scanned supplier invoice information. For example, add or delete invoice lines, add or delete attachments, delete an invoice. You can also calculate taxes or create distributions for invoices.

Payments

REST APIs for External Bank Accounts

Create, update and read bank accounts assigned to employees and customers.

Receivables

REST APIs for Receivables Invoices

Create and query customer invoice distributions through the enhanced customer invoice REST service.

Financials

Assets

Streamline Copy of Fixed Asset Adjustments and Transfers to Tax Book

Select the transaction convention at the asset category level for adjustment to allow transfer transactions to be defaulted into the tax book. For backdated addition and adjustment transactions, choose the first day of the current tax book period as the transaction date when these transactions are copied from the corporate book to the tax book.

Budgetary Control

Additional Budgetary Control Liquidation Validation

Add additional budgetary control validation to enforce the liquidation of a transaction in the same control budget as it was originally reserved.

Enable Control Budget Definition Security

Add data security to the control budget definitions on the Manage Control Budget page by enabling control budget definition security.

Cash Management

Assign User Exchange Rate for Cash External Transactions

When creating external transactions in Cash Management, provide a user conversion rate and rate type to override the conversion rate that is set at the bank account level. The user rate will be used to determine the accounting amount and reconciling amount for the external transaction.

Automatic Reconciliation of Rejected Payments

Automatically reconcile rejected payments based on the transaction code and reversal indicator that is reported through the loaded bank statement.

Security Improvements in Bank Account Transfers and Ad Hoc Payments

Security enhancements have been added to Bank Account Transfers and Ad Hoc Payments. These enhancements include hiding "Transfer Funds" and "Make a Payment" buttons for non-authorized users. 

Segregate the Privilege to Manage Bank Account Security

Restrict users that can modify the management of users and roles that access bank account information by a special privilege delivered with the Cash Manager job role.

Expenses

Reimbursable Amount Entry for Foreign Currency Receipts in Expenses Mobile Application

You can enter the receipt amount and the reimbursable amount for foreign currency receipts. If you don't enter a reimbursable amount, the application calculates the amount using the default conversion rate.

Simplified Configuration for MasterCard CDF3 File Upload

For MasterCard CDF3 file upload, you can configure your company account without a company number, Interbank Card Association (ICA) number, or processor identification number. This simplified configuration supports corporate card transaction files that are produced for multiple entities in your company under a single corporate account number.

General Ledger

Allocation Rule Name as Reconciliation Reference

Reconcile all journal lines generated from an allocation rule as a group based on the allocation rule name, available as the reconciliation reference attribute.

Date Effectivity for Allocation Rules and Rule Sets

Prevent recurring journals from being erroneously created outside of specific dates by entering effective start and end dates on allocation rules and rule sets. The effective dates are enforced based on the period for which the recurring journals are generated.

Performance Enhancements in Period Close Work Area

Experience faster performance in the Period Close work area by selecting a source subledger application when viewing outstanding subledger transactions. 

Performance Improvements in General Accounting Dashboard and Journals Work Area

View approval tasks more quickly by accessing the Manage Approval task from the general ledger dashboard and work area.

Retain Batch Creator as Approval Submitter in AutoPost Journals Process

Retain the journal batch creator as the submitter during the approval process of AutoPost journals, by selecting the Use Batch Creator as Approval Submitter option on the Create AutoPost Criteria Set page.

Spreadsheet-Based Clearing Accounts Reconciliation

Use a spreadsheet to efficiently reconcile clearing accounts and reversals by utilizing the spreadsheet's native sort, filter, and search capabilities. Mark related lines as reviewed but not yet reconciled, and include more journal lines in the reviewed set to quickly complete the reconciliation.

Synchronize Journal Reversal Approvals Between Primary and Secondary Ledgers

Automatically approve reversal journals in a secondary ledger when the corresponding reversal journal in the primary ledger is approved, by configuring both ledgers to require journal approval and enable the synchronization option.

Payables

Enable Descriptive Flexfields Update on Existing Payments

Updates to descriptive and global flexfields on saved payments is enabled. Previously, you were allowed to enter information in them only when creating a payment.

Payments

Enhanced Delivery Option for Separate Remittance Advice and Payer Notification

Deliver separate remittance advice and payer notification reports as PDF attachments to emails. Select the delivery method option "Email with PDF attachment" at the supplier and customer site levels

Positive Pay File Enhancements

Transmit the Positive Pay file separately from the payment process using the transmission configuration setup at the payment process profile. Optionally specify dynamic naming attributes for the positive pay files that are transmitted.

Retrieve Funds Capture Acknowledgment Files Using a Wildcard Search

Retrieve multiple funds capture acknowledgment files at the same time using a wildcard search. Create a transmission configuration with the Secure File Transmission Retrieval Protocol for Static File Names and enter a wildcard in the Remote File Name parameter. This will both retrieve and process multiple acknowledgment files from your bank.

Receivables

Deliver Balance Forward Bills Using Email

Deliver balance forward bills by email as PDF attachments to customer account or site level contacts.

Subledger Accounting

Export and Import Subledger Accounting Setup Data in Batches

Export and import high volume Subledger Accounting setup data with improved scalability and performance.

Use a Formula in Another User-Defined Formula in Accounting Setup

You can now define a formula by using an existing user-defined formula to derive a value for a subledger accounting entry. This enables you to define the commonly used formulas and reuse them in other formulas for consistency and ease of maintenance.

Transactional Business Intelligence for Financials

Drill Down from OTBI Receivables Reports to Transaction, Receipt and Collection Details

You can now drill down from OTBI Receivables ad hoc reports to transaction, receipt, collection promise and pay details.

Drill Down from OTBI Subledger Accounting Reports to Subledger Journal Entry Details

You can now drill down from OTBI Subledger Accounting reports to subledger journal entry details.

Enhancements to General Ledger Journals Real Time Subject Area

The General Ledger - Journals Real Time subject area now includes the Reconciliation Type and Parent Journal Header ID columns to help you with reconciliation.

Enhancements to Payables Subject Areas

The Oracle Transactional Business Intelligence (OTBI) Payables subject areas have been enhanced to include folder Supplier Site Address information: Supplier Site Location Details and Supplier Site Contact Details subfolders.

Enhancements to Receivables Subject Areas

Oracle Transactional Business Intelligence Receivables subject areas have been enhanced with additional reporting attributes including batch identifier, status, payment type code, order amount limit and credit analyst.

Regional and Country-Specific Features

Financials for the Americas

Argentina

Enable 2018 Legislative Updates for Document Sequencing for Argentina

Enable 2018 legislative mandate for Argentina for document sequencing with five-digit point of sale number support for Receivables transaction numbers.

Financials for Asia/Pacific

India

Copy Tax Compliance Attributes to Payables Invoices for India

Experience improved accuracy and processing efficiency in claiming the input tax credit for India GST. The key tax determinants such as tax registration numbers, tax invoice date, and tax invoice number, required to claim input tax credit are defaulted from purchase orders or receipts to Payables invoices avoiding manual updates.

Default First-Party Tax Registration Number for India

 Review, accept, or modify the defaulted value for the first-party tax registration number on requisitions and purchase orders to improve accuracy and compliance for India GST.

Deferred Tax Recovery for India

Process the recovery of deferred recoverable taxes for India GST.

Integrate with E-Way Bill Framework for India

Eliminate manual steps to process and record E-Way bills by leveraging the integration of India GST E-Way Bill systems with ERP Cloud.

Financials for EMEA

Russia

Generate Customer Balance Reconciliation Report for Russia

Generate the Customer Balance Reconciliation Report for Russia to periodically reconcile settlements with customers.

Generate Receivables and Payables Audit Report for Russia

Generate Receivables and Payables Audit Report for Russia.

Generate VAT Reports for Russia

Generate purchase and sales ledger report with additional sheet for adjustments, and a tax invoice register report containing invoices issued and received.

Prepare VAT on Export Report for Russia

Generate a listing of export sales invoices and the status of the related confirmation documentation. Any related VAT invoices and VAT refunds are also reported.

Russia Asset Reporting for Asset Repair and Maintenance

Comply with Russia Asset Reporting requirements by recording your asset repair, modernization, and reconstruction expense details. Use the Maintenance Order spreadsheet to capture the work and job order details (including freight) for each asset under repair or modernization and its expected return to production date after the repair or modernization.

Tax Agent Invoice for Russia

Select supplier payments to create tax agent invoices for Russia using a spreadsheet.