Update 21A

Revision History

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

Date	Product	Feature	Notes
16 MAR 2022	Payables	Modifications to Employee Bank Account Creation	Updated document. Revised feature information.
24 SEP 2021	Budgetary Control	Connected and Integrated Budget Revisions with EPM Planning Financials	Updated document. Added information to Tips and Considerations.
30 APR 2021	Budgetary Control	Connected and Integrated Budget Revisions with EPM Planning Financials	Updated document. Added information to Tips and Considerations.
02 FEB 2021	General Ledger	Option to Publish Hierarchies for All Value Sets	Updated document. Delivered backported feature in update 21A.
29 JAN 2021	Assets	Manage Leases Page Enhancements	Updated document. Delivered feature in update 21A.
29 JAN 2021	Budgetary Control	Connected and Integrated Budget Revisions with EPM Planning Financials	Updated document. Delivered feature in update 21A.
29 JAN 2021	Payables	Electronic Filing of Forms 1099-MISC and 1099-NEC for Tax Year 2020	Updated document. Delivered feature in update 21A.
14 DEC 2020	IMPORTANT Actions and Considerations		Updated document. Added information on Reporting Web Studio.
04 DEC 2020			Created initial document.

Overview

This guide outlines the information you need to know about new or improved functionality in this update, and describes any tasks you might need to perform for the update. Each section includes a brief description of the feature, the steps you need to take to enable or begin using the feature, any tips or considerations that you should keep in mind, and the resources available to help you.

Join Oracle Cloud Customer Connect

Please take a moment to join the Cloud Customer Connect forums for Financials Cloud. Oracle Cloud Customer Connect is a community gathering place for members to interact and collaborate on common goals and objectives. This is where you will find the latest release information, upcoming events, or answers to use-case questions. Joining takes just a few minutes. Join now!

https://cloud.oracle.com/community

Security and New Features

The Role section of each feature identifies the security privilege and job role required to use the feature. If feature setup is required, then the Application Implementation Consultant job role is required to perform the setup, unless otherwise indicated. (If a feature doesn't include a Role section, then no security changes are required to use the feature.)

If you have created job roles, then you can use this information to add new privileges to those roles as needed.

Give Us Feedback

We welcome your comments and suggestions to improve the content. Please send us your feedback at oracle_fusion_applications_help_ww_grp@oracle.com.

Optional Uptake of New Features (Opt In)

Oracle Cloud Applications delivers new updates every quarter. This means every three months you'll receive new functionality to help you efficiently and effectively manage your business. Some features are delivered Enabled meaning they are immediately available to end users. Other features are delivered Disabled meaning you have to take action to make available. Features delivered Disabled can be activated for end users by stepping through the following instructions using the following privileges:

• Review Applications Offering (ASM_REVIEW_APPLICATIONS_OFFERINGS_PRIV)
• Configure Oracle Fusion Applications Offering (ASM_CONFIGURE_OFFERING_PRIV)

Here’s how you opt in to new features:

1. Click Navigator > My Enterprise > New Features.
2. On the Features Overview page, select your offering to review new features specific to it. Or, you can leave the default selection All Enabled Offerings to review new features for all offerings.
3. On the New Features tab, review the new features and check the opt-in status of the feature in the Enabled column. If a feature has already been enabled, you will see a check mark. Otherwise, you will see an icon to enable the feature.
4. Click the icon in the Enabled column and complete the steps to enable the feature.

For more information and detailed instructions on opting in to new features for your offering, see Offering Configuration.

Opt In Expiration

Occasionally, features delivered Disabled via Opt In may be enabled automatically in a future update. This is known as an Opt In Expiration. If your cloud service has any Opt In Expirations in this update, you will see a related tab in this document. Click on that tab to see when the feature was originally delivered Disabled, and when the Opt In will expire, potentially automatically enabling the feature. You can also click here to see features with current Opt In Expirations across all Oracle Cloud Applications. Beyond the current update, the Financials forums on Cloud Customer Connect have details of Opt In Expirations upcoming in future updates.

Feature Summary

Common Technology and User Experience

Common Financials Features

Service Excellence Continuing Investments

Our ongoing investment in service excellence has a focus on overall usability, resiliency, performance, and security. This work is based on monitoring performance trends, reviewing common use patterns, analyzing service requests, and participating in many discussions with customers.

In this update, our on-going investment in service excellence includes improvements in the following areas:

• Messages: Improved error and warning messages for Payables invoice processing.

• Usability: Instructions and sample data for the Mass Additions File-Based Data Import templates; enhanced type ahead suggestions for lists of values in key business areas in Budgetary Control, Payables, and Receivables; improved Service Request logging process for Budgetary Control issues.

• Performance: Resiliency improvements for Customer and Supplier Balance Netting; improved search selection for payment processing.

Steps to Enable

You don't need to do anything to enable this feature.

Simplified Workflow Rules Configuration

The Simplified Workflow Rules Configuration feature provides spreadsheet-based templates to define workflow rules for the Payables Invoice Approval and General Ledger Journal Approval workflows. Workflow administrators can download any of the available templates for each workflow, enter the rule information and upload the rules using the Manage Workflow Rules in Spreadsheet task.

The templates provide an easy-to-use layout to capture all the information required to define workflow rules. In update 21A, you can specify a rule priority for the rules defined using these templates.

Rule Priority

Each of the templates available for the Payables Invoice Approval and General Ledger Journal Approval workflows contain sample rules for typical use cases for these workflows. In update 21A, additional sample rules have been added to the following templates to demonstrate different rule scenarios:

• Invoice Approval Sample Template 1
• Invoice Approval Sample Template 2
• Invoice Approval Sample Template 3

The rule priority column in the Approvers section of the templates allows you to define the order in which the rules within a block are executed when transactions are being processed through the workflow.

Workflow administrators can use the additional sample rules added in the Payables Invoice Approval workflow templates as examples of how to translate their approval policy into rules using the templates.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

• Review the 'Manage Workflow Rules Using a Spreadsheet' topic in Oracle Help Center to get familiar with the Simplified Workflow Rules Configuration feature.

• When entering the rules information in the template, all rules are assigned a default rule priority of 'Medium'. If required, you can choose a different rule priority using the available list of values.

• Refer to the Sample Rules section in the Instructions sheet of the Payables Invoice Approval workflow templates to view details of the additional use cases for which sample rules have been added in templates.

Key Resources

• 'Manage Workflow Rules Using a Spreadsheet' topic in Oracle Help Center.

Workflow Rules Report

Use the Workflow Rules Report to review the workflow rules configured in Oracle Business Process Management (BPM) for Payables Invoice Approval, General Ledger Journal Approval, and Expense Report Approval workflows. This report was first introduced in update 18C. In update 21A, you can also use the report to validate the workflow rules against recommended best practices. Wherever the rules deviate from best practices, you can use the suggested recommendations to make the necessary corrections.

Workflow administrators can use this report to ensure that any rules defined or modified in Oracle Business Process Management (BPM) for Payables Invoice Approval, General Ledger Journal Approval, and Expense Report Approval workflows adhere to recommended best practices.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

For additional details about this feature, please click here.

Role Information

• Financial Application Administrator

Workflow Transaction Console Security by Product or Workflow

Secure the Workflow Transaction Console by restricting the workflow administrator or business user view of transactions either by product or workflow.

Currently, the Workflow Transaction Console displays the transactions related to all the financials workflows (Invoice, Journals, and Expense Reports). This feature lets you restrict the workflow administrator to view only the transactions related to specific product or workflow.

Steps to Enable

The following steps describe how to modify the security policies assigned to the predefined duty role and to create a transaction security profile to secure transactions by product or workflow.

1. Log in to Security Console and navigate to the Roles page.
2. Create a custom duty role. Search for the predefined duty role Financial Transaction Approval Reviewing and select Copy Role from Search Result drop down. Then select "Copy top role" to create the new role.

Copy Duty Role

3. In the Edit Data Security Policy window, select Access the HCM pending transaction header for table HRC_TXN_HEADER for transactions initiated by persons in their person security profile from the Condition Name field drop-down and click OK.

Edit Data Security Policy

4. In the Edit Data Security Policy window, select Access the HCM pending transaction header for table HRC_TXN_HEADER for transactions initiated by persons in their person security profile from the Condition Name field drop-down and click OK.

Edit Data Security Policy

5. Select Grant on HCM Approval Process Definition security policy. In the Edit Data Security Policy window, Select Access the HCM approval process definition for table HRC_ARM_PROCESS_B for transactions in their transactions security profile from the Condition Name field drop-down and click OK.

Edit Data Security Policy

6. Select Summary tab and click the Submit and Close button.
7. Search for the job role Financial Application Administrator and Copy Role. Assign the modified duty role which was created in step1 and remove the predefined duty role Financial Transaction Approval Reviewing from the newly created job role.
8. Create Transaction Security Profile in HCM. 

Create Transaction Security Profile

9. Enter Name and Description for the Security Profile.  Click the Create icon. Select FIN in Family LOV, Accounts Payables in Category LOV, Invoice Approval in Sub Category LOV.  Click Save and Close.

Create Transaction Security Profile

10. Create a data role and assign job role to the security profile. Select Organization Security Profile value as View All Organizations, Person Security Profile under Person as View All People, Person Security Profile under Public Person as View All People, Transaction Security Profile as Payables Transaction Console Security Profile. Click Review > Submit.

Create Data Role

11. Assign Data Role to the user.

Role Information

Users with Financials Application Administrator role can access the workflow transaction console. 

Financials

Assets

Allow Expense Type Account as Asset Clearing Account for GASB 34

Public sector entities complying with GASB 34 can set up a unique expense type clearing account for each asset category assigned to an asset book and automatically assign the asset category by default to the invoice lines from Payables.

Select an expense type account as an asset clearing account in the category setup. You can specify a unique expense type asset clearing account (natural segment) for each asset category and automatically default the asset category to invoice lines transferred from Payables using this account as the Payables Clearing account.

If you do not have a unique clearing account for each category, then Payables transfers the invoice lines to Assets either without an asset category or an asset category that has the least Category Identifier. You can update the asset clearing account in category setup before adding any assets to the category in the asset book.

This feature allows you to automatically default the asset category to invoice lines transferred from Payables for GASB 34 asset books.

Steps to Enable

Use the Opt In UI to enable this feature. For instructions, refer to the Optional Uptake of New Features section of this document.

Offering: Financials  No Longer Optional From: Update 21D

1. To enable the feature, complete the following steps.

2. Enable the ORA_FA_ENABLE GASB 34 (Asset Additions for Assets) profile option to control the Create Mass Additions process from the Invoice work area. You can select one of the profile levels to replace the standard program.

• Site: All users
• User:Only the assigned user
• Product:Assets

Key Resources

• GASB 34 Asset Accounting white paper published on My Oracle Support.

Asset Setup Page Enhancements

The Create Book page now includes two additional options: Prevent prior period amortized adjustments and Copy group asset changes.

PREVENT PRIOR PERIOD AMORTIZED ADJUSTMENTS

This option applies to both corporate and tax books. When you enable this option the amortized start date for any adjustment transactions must fall only within the current open period.

When you enable this option for the tax book but not for the corporate book, the amortized adjustments in the corporate book aren’t copied to the tax book if the amortization start date of the adjustment falls in any closed tax book periods.

COPY GROUP ASSET CHANGES

This option applies only to tax books. When you enable this option, the following member asset assignment changes are copied from the corporate book to the tax book.

• Transferring a member asset from one group to another.
• Changing a member asset to a standalone asset or a standalone asset to a member

This feature allows you to prevent prior period amortized adjustments in corporate and tax books, and to copy changes to the membership of group assets in tax books.

Steps to Enable

1. The options are displayed using lookup.
   1. In Setup and Maintenance, go to the task Manage Fixed Assets Lookups.
   2. Search for the lookup type ORA_FA_ALLOW_GROUP.
   3. Enter your asset book name as the lookup code.

2. In the Create Book page, when creating a tax book, enable the Copy group asset changes option.

3. In the Edit Assets page in the Advanced Rules Tab, enable the Prevent prior period amortized adjustments option.

Employee Search and Select LOV Enhancement

You can now search for employees with at least one of the following attributes. Previously you could search for an employee only by name only.

• Person Number
• Name
• Email

Employee detail changes apply to the following pages:

• Edit Source Line page
• Add Assets page
• Adjust Assets page
• Transfer Assets page
• Retire Assets page
• Perform What-if Analysis page
• Create Distribution Set page
• Transfer Source Line page
• Mass Adjustments page
• Mass Transfer page
• Mass Retirements page

 Employee Search and Select List of Values:

You can search for employees by Employee Name, Employee Number, and Email ID.

Steps to Enable

You don't need to do anything to enable this feature.

Manage Leases Page Enhancements

In the Manage Leases page, you can view up to 10,000 leases in a spreadsheet after exporting leases to Excel. By default, the leases are sorted by creation date, from newest to oldest.

You can process asset leases more efficiently by viewing up to 10,000 leases in a spreadsheet after exporting leases to Excel. 

Steps to Enable

You don't need to do anything to enable this feature.

Transfer of Accrue at Receipt Invoices for GASB 34 Primary Ledger

The Update Asset Tracking process within the Create Mass Additions job set now checks whether the Accrue at receipt option is enabled in the purchase order when enabling the Track as Asset option in Payables.

The Track as Asset option is enabled when the expense account you provide when running the job matches:

• Purchase Order charge account for invoice lines that accrue at receipt (Accrue at receipt option is enabled).
• Invoice distribution account for invoice lines that accrue at period end (Accrue at receipt option is not enabled).

Before this enhancement the Update Asset Tracking process updated the Track as Asset option by matching the provided expense account with the invoice distribution account. As a result, invoices lines with the Accrue at receipt option enabled were charged to the expense account in the receipt transaction accounting and customers used either the Accrue at period option or a unique AP Accrual Liability account for capital asset purchases.

After running the job set when the Track as Asset option is enabled for Payables invoice lines, invoices are transferred to Assets as follows:

• Invoices Matched to Accrue at Receipt of Yes: The expense account entered as a parameter matches with the PO distribution account (in PO_DISTRIBUTIONS_ALL) of the invoice line distribution.

• Invoices Matched to Accrue at Receipt of No: The expense account entered as a parameter matches with the distribution account (in AP_INVOICE_DISTRIBUTIONS_ALL) of the invoice line distribution.

• Unmatched invoices: The expense account entered as a parameter matches with the distribution account (in AP_INVOICE_DISTRIBUTIONS_ALL) of the invoice line distribution.

This feature allows you to transfer all types of invoices, including invoices that accrue at receipt from Payables to Assets.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

1. Create Mass Additions Job in the Scheduled Processes page

2. Accrue at receipt option enabled and PO Charge Account in the Create Purchase Order page

3. Enable Track as Asset option in the Create Invoices page

Budgetary Control

Additional Budgetary Control Transaction Information

Gain more understanding of budgetary balances with additional budgetary control validation transaction attributes on the Review Budgetary Control Transactions page. This includes an indicator when transactions are overridden due to insufficient funds.

Review Budgetary Control Transactions

The new columns on the Review Budgetary Control Transactions page help you understand the budgetary control validation details for reserved transactions. Here are some scenarios:

• The reason why a transaction passed validation with a warning:
  • Passed with insufficient funds advisory
  • Insufficient funds ignored
  • Passed with override period
  • Passed with override insufficient funds
  • Overrider and override justification when passed with override
  • Passed with tolerance
  • Tolerance allowed when passed with tolerance

• Control level applied during validation

• Related transaction type

• Transaction action

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

The new budgetary control validation columns are not displayed by default.  To add them to your personal view, click View > Columns and select the columns.

Role Information

Budget Manager role is needed to access the Review Budgetary Control Balances page.

Budget Hierarchy Updates While Control Budget Is Active

Use the Refresh Tree for Budgetary Control process to add values to a budget account hierarchy while the control budget is in use. You must still close the control budget before running the process for all other tree changes. The log and output file has been enhanced to include additional error messages for common configuration issues.

Control budgets can stay in use when adding to the budget account hierarchy.  You can make these changes without closing the control budget:

• New detail values to an existing branch
• New parent and details values to an existing branch
• New branch with new parent and detail values

Refresh Tree for Budgetary Control processing errors is enhanced with improved messaging in the log and output files to list tree change errors that prevent it from being used for budgetary control.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

You must close control budgets for these types of tree changes:

• Replacing an existing parent value with a new parent value
• Moving a detail value to a new parent value
• Removing a parent value
• Removing a detail value
• Removing a branch

Key Resources

• Managing Tree Hierarchies in Oracle Fusion Budgetary Control support note 2014771.1

Role Information

• Financial Application Administrator role is needed to run the Refresh Tree for Budgetary Control process.
• Budget Manager role is needed to access the Manage Control Budget page.

Carry Forward Open Purchase Orders for Budgetary Controlled Non-Sponsored Projects

Use the Carry Forward Open Purchase Orders process to move purchase orders associated with budgetary controlled non-sponsored projects from one budget year to another. The process automatically updates the budget date to the corresponding budget year for these purchase orders.

Budget year-end processing has been simplified for purchase orders that impact non-sponsored project control budgets.  A non-sponsored project control budget is a project control budget without an award.  The Carry Forward Open Purchase Order process will automatically move these purchase orders to the new budget year.  Run the process in draft mode to review which purchase orders will be carried forward automatically and choose to let the system process them or manually update the purchase orders that need additional attention.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

• Purchase orders that impact sponsored project control budgets will not be processed automatically.  A sponsored project control budget is a project control budget with an award.

• There is no impact on burden amounts as the expenditure item date isn’t changed. The Carry Forward Open Purchase Orders process updates only the purchase order budget date. When the expenditure item date also needs to be updated, the purchase order should be reviewed and updated manually.

• Project control budget changes are centralized in Project Portfolio Management. Budget adjustments created automatically for chart of accounts based control budgets will not be done automatically for projects control budgets.

• If a budget adjustment is required for a project, use the following report information to update the budget balance for the project control budget by creating and baselining a new project budget version in Project Portfolio Management:·        
  • Not Attempted Budget Entries Details layout of the Carry Forward Purchase Order

Key Resources

• Managing Budgetary Control Carry Forward support note 2705986.1

Role Information

Budget Manager role is needed to run the Carry Forward Open Purchase Order process.

Connected and Integrated Budget Revisions with EPM Planning Financials

Prepare draft revisions to an approved EPM Planning Financials budget and verify against the funds available before the budget change is submitted.  You can either approve or reject budget revisions before control budget balances are updated. You can drill down from EPM Planning Financials budget balances to view budget revision details on the Review Budget Entries page.

Meet legislative requirements in the US state and local public sector market with integration of management and operational budget tasks across Budgetary Control and EPM Planning Financials.

• Accurately manage budget revisions by simultaneously validating against operational budget and consumption balances.
• Maintain control and visibility with approvals and budget revision versions.
• Ensure compliance by validating budget changes against budgetary control policies.
• Improve insight into budget management with access to planning data and tools.

Steps to Enable

Steps are required in EPM Planning Financials and Data Integration to enable this feature.

Tips And Considerations

• The Budget Revisions feature is in the Financials module of EPM Planning.

• Additional configuration is required in EPM Cloud Planning and Data Management to set up the budget revisions feature and to map the budget data from EPM Planning Financials to Budgetary Control.  Refer to the Key Resources section for references and additional details.

• A new control budget with Source Budget Type of EPM Financials module (Not Hyperion Planning) is needed for integration with EPM Planning Financials.  In the 21B update, existing control budgets can be converted to EPM Planning Financials module when the source budget type is Other or Hyperion Planning.

• The control budget currency and calendar period names must align with the ledger. Control budget segments must include all chart of accounts segments. In 21C, you can use different period names and not all chart of account segments are required for the control budget. See the Budgetary Control Budget Balance Synchronization to Different Period Names and Non Budgeted Segments feature in the 21C What’s New for more details.

• You can continue to use source budget type Hyperion Planning for new or existing control budgets. Budgetary control validation is performed during the submission of budget import.

• Create a budget scenario with the same name as the control budget with the EPM Financials module to avoid errors in budget synchronization.

• Additional header and line level attributes for EPM Budget Revisions can be added using descriptive flexfields.

Key Resources

EPM Planning

• Setting Up Budget Revisions and Integration with Budgetary Control in Administering Planning Modules
• Integrating Budget Revisions with Budgetary Control in Administering Data Integration
• Working with Budget Revisions and Integrating with Budgetary Control in Working with Planning Modules

Budgetary Control

• Enterprise Performance Management Financials Module in Using Financials for the Public Sector

General Ledger

• Define Scenario Dimension Members in Implementing Enterprise Structures and General Ledger

Role Information

• Budget Manager role is needed to manage Budgetary Control.
• EPM Planning Administrator to enable budget revisions and set up data mapping.

Enterprise-Level Budgetary Control Options

The Enterprise Options section in the Manage Budgetary Control and Encumbrance Accounting page is used to enable enterprise-level budgetary control options. The expiring Opt In for these three features will be moved permanently to this page in 21C:

• Enable Additional Budgetary Control Liquidation Validation 19C
• Enable Control Budget Security 19C
• Synchronize Hierarchy Maintenance across Budgetary Control and General Ledger 20C

View and maintain the Budgetary Control system options in one common place.  This new region is displayed above the Ledger and Business Unit Options in the Manage Budgetary Control and Encumbrance Accounting page.

Manage Budgetary Control - Enterprise Options

Uses these system options to enable Budgetary Control functions.

Budgetary Control System Options	Enable System Option to do:
Budget to summary accounts in General Ledger	Budget to the same summary account in General Ledger as in Budgetary Control.
Synchronize hierarchy maintenance	Automate the maintenance of account hierarchies to ensure they remain the same in General Ledger and Budgetary Control.
Additional budgetary control liquidation validation	Fail budgetary control validation when the liquidation of a transaction doesn't impact the same control budget as originally reserved.
Secure control budget definitions	Limit users who can update control budget definitions on the Manage Control Budget page.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

• Your enterprise feature setting values default to a corresponding budgetary control system option in Manage Budgetary Control.  In update 21A and 21B, all system options are maintained in the My Enterprise Feature page, except for the Budget to summary accounts available in the General Ledger system option.  This option is maintained in the Manage Budgetary Control page.

  Enterprise Feature	Budgetary Control System Options	21A and 21B Update Feature in Enterprise Feature page	21C Update System Options in Manage Budgetary Control
  Enable control budget security	Secure control budget definitions	Yes	Yes
  Enable additional budgetary control liquidation validation	Additional budgetary control liquidation validation	Yes	No update allowed, unless this feature is not enabled
  Synchronize hierarchy maintenance across Budgetary Control and General Ledger	Synchronize hierarchy maintenance	Yes	Yes
  	Budget to summary accounts in General Ledger	No, update in Manage Budgetary Control	Yes

• In update 21C, the Enterprise Offerings features will expire and system options will be maintained in the Manage Budgetary Control.

Key Resources

• Using Financials for the Public Sector Book, Enterprise Options chapter

Role Information

The Budget Manager role is needed to access the Manage Budgetary Control page.

Cash Management

Automatic Reconciliation of Bank Accounts for a Bank, Bank Branch or Legal Entity

Use the additional options available on the Autoreconcile Bank Statements process to submit the reconciliation of bank statements belonging to a bank, a bank branch, or a legal entity. You can also use a wildcard character to submit the reconciliation process.

The bank statements of all the bank accounts of the selected bank, branch, or legal entity will be automatically reconciled.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

Scheduled automatic reconciliation processes won't get updated with the new parameters. The new parameters need to be selected as per the business requirements before rescheduling the process.

Role Information

You don't need any new role or privilege to set up and use this feature.

Notional and Physical Cash Pools

Review the consolidated cash balance and cash positioning for the cash pool. 

Use the cash leveling proposals in the cash positioning to Initiate bank transfers from the subsidiary account to the concentration account for zero balancing. You can also initiate the bank tranfers from concentration account to subsidiary accounts for maintaining the target balances.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

You must clear the existing cash position data & resubmit the cash position data extraction process to review the updated cash position after initiating the bank transfers using the cash leveling proposals.

Key Resources

• Related Help:  Cash Positioning and Forecasting in the Oracle Financials Cloud Using Payables Invoice to Pay, or Oracle Financials Cloud Using Receivables Credit to Cash guides

Role Information

To use this feature, you need this privilege or one of the roles:

• Privilege Name and Code:
  • Manage Cash Pool - ORA_CE_MANAGE_CASH_POOL_PRIV 
  • View Cash Pool - ORA_CE_VIEW_CASH_POOL_PRIV

These privileges are already attached to the Cash Manager job role (ORA_CE_CASH_MANAGER_JOB).

Reconciliation of Third-Party Rollup Payments

Reconcile consolidated third-party rollup payments transferred from Payroll and reported in bank statements.

Third-party payments can be rolled-up using the Run Third-Party Payment Rollup process. As part of the roll payments, multiple payments from different employees are grouped together and paid to the third-party with single payment transaction. These payment transactions are transferred to Cash Management using the Transfer Payments Information to Cash Management process.

Cash managers can review and reconcile third-party rollup payment transactions both automatically or manually. These payment transactions are included in the reports: Cash to General Ledger Reconciliation; Cash in Transit; Cash Forecasting.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

• Submit the Transfer Payments Information to Cash Management process to transfer all payments from Payroll to Cash Management, including the third-party rollup payments.

• After receiving the bank statement file from the bank, reconcile payroll payments automatically.

Key Resources

Related Help:

• Third-Party Rollup Payments in the Administering Global Payroll guide
• Submit Cash Management Reports in the Oracle Financials Cloud Using Payables Invoice to Pay, or Oracle Financials Cloud Using Receivables Credit to Cash guides
• Manage Reconciliation in the Oracle Financials Cloud Using Payables Invoice to Pay, or Oracle Financials Cloud Using Receivables Credit to Cash guides
• Cash Positioning and Forecasting in the Oracle Financials Cloud Using Payables Invoice to Pay, or Oracle Financials Cloud Using Receivables Credit to Cash guides

Role Information

You don't need any new role or privilege access to set up and use this feature.

Expenses

Configurable Spend Authorization Workflow Rules Using Additional Project Attributes

Use project-related attributes to configure approval rules in the Spend Authorization Workflow. These attributes let you route spend authorization approval notifications to project team members, project task manager, and the hierarchy of the project task manager.

Here’s a list of project-related attributes that workflow administrators can use to configure spend authorization workflow rules:

Folder	Attributes
Project Classification	Project Class Category Project Class Code Class Code Percentage Project ID
Project Team Member	Project ID Project Party ID Projects Track Time Team Member Start Date Team Member End Date Team Member Email Address Team Member Person ID Team Member Role ID Team Member Role Name Team Member User Name
Project Task	Business Unit ID Business Unit Name Legal Entity ID Legal Entity Name Project Currency Code Project ID Project Ledger Currency Project Manager Project Name Project Number Project Organization Name Project Task ID Project Type Name Project Unit ID Project Unit Name Carrying Out OrganizationId Project Type ID Sponsored Flag Task Manager Task Name Task Number Task Organization Work Type ID Work Type Name

 

Four New Folders in Spend Authorization Approval

Project related attributes enable companies to route spend authorization approval to additional project team members who oversee funds management.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

Click Start Synchronization on the BPM Rules Configuration page to synchronize project-related descriptive flexfield information with the BPM workflow configuration. This operation lets you configure workflow rules using project and task descriptive flexfield details.

Role Information

You don't need a new role or privilege access to use this feature.

Digest Email Updates to Display Predefined Number of Expenses

To improve usability, limit the number of expenses displayed under each section in the digest email to three when there are more than three expenses that require the employee's attention. Employees can access additional expenses by clicking the link in each section to review the expenses in the Travel and Expenses work area.

The concise email notification allows employees to quickly preview the items that require attention or are ready for submission.

Digest Notification

Steps to Enable

You don't need to do anything to enable this feature.

Role Information

You don't need a new role or privilege access to use this feature.

Keyword Audit for Expense Reports

Identify expense reports containing specific keywords and route them for audit. Administrators can create the list of keywords that meet their company's auditing needs.

Keyword audit is a new audit rule included in the set of expense report audit selection rules. You can define a score percentage to include exact matches and similar matches. When enabled, all expense reports containing the keywords in any of the following fields are selected for audit:

Expense Report

• Purpose
• Expense report level descriptive flexfields of Character type, such as ATTRIBUTE_CHAR_1 through ATTRIBUTE_CHAR_15

Expense Items

• Description
• Justification
• Merchant Name
• Expense item level descriptive flexfields of Character type, such as ATTRIBUTE_CHAR_1 through ATTRIBUTE_CHAR_15

A 100% score percentage selects all reports that exactly match one or more keywords. A score percentage less than 100% selects reports that contain words similar to the keywords that you defined. Expense reports are selected for audit at the time of submission. A new audit reason, Keyword Violation, is added to identify reports selected for audit based on keyword match.

Keyword audit enables companies to identify noncompliant expenses that require additional review by auditors. Keyword audit provides these benefits: identify expenses, such as purchases and subscriptions, from merchants excluded by a company; identify expenses from conferences and events that a company wants to review for compliance; and monitor expenses involving specific organizations.

Steps to Enable

There are two tasks to enable keyword audit.

• Add keywords to the preconfigured keyword lookup or create a new lookup and add keywords.
• Create an audit selection rule and activate the rule.

To add keywords to the keyword lookup, perform the following steps:

1. Sign in as an expense manager.
2. From the Setup and Maintenance work area, navigate to the Manage Standard Lookups page.
3. Search for the ORA_EXM_KEYWORD_AUDIT lookup.
4. Add each keyword that you want to audit as a lookup meaning. For example, if you have three keywords that you want to audit, then create three lookup meanings.
5. Click Save and Close.

Create Keywords

To create an audit selection rule, perform the following steps:

1. Sign in as an expense manager.
2. From the Setup and Maintenance work area, navigate to the Manage Expense Report Audit Selection Rules page.
3. Select the Create icon to create a new Expense Report Audit Selection Rule page.
4. On the Create Expense Report Audit Selection Rule page, select applicable audit rules.
5. Select the Audit expense reports with keywords option.
6. Then, select an audit lookup and enter the score percentage.
7. Click Save and Close.
8. From the Setup and Maintenance work area, navigate to the Manage Expense Report Audit and Receipt Rule Assignments page to assign the rule to a business unit.
9. Select the business unit.
10. In the Expense Report Audit Selection Rule section, assign the new rule, start date, and end date.
11. Click Save and Close.

Tips And Considerations

• Create an audit keyword lookup specific to each business unit to support requirements specific to that business unit. In an audit keyword lookup for a business unit, include generic keywords and business unit specific keywords.

• All disabled lookup values are not included in the audit selection.

• If you have an active audit selection rule and you want to add the keyword audit rule, then you must create a new audit selection rule, select existing criteria and the keyword audit rule and assign the rule to corresponding business units.  

Key Resources

• Watch Keyword Audit for Expense Reports Readiness Training.

Role Information

To enable keyword audit, you need the Expense Manager role.

Number of Attendees Capture When Expense Is Above Designated Limits

Capture the number of attendees when meals and entertainment expenses surpass the designated limits specified by the company policy. Auditors can view the cost per attendee when auditing the expense.

For ease of entry, the Number of Attendees field is available in the Expenses work area and on the Create Expense page. While employees are entering expenses, the Number of Attendees field is blank. If the expense amount is above the designated limit, the Number of Attendees field is enabled and required. However, if the expense amount is within the designated limit, the Number of Attendees field is set to 1 when the expense is saved.

An entertainment policy that captures number of attendees can be assigned to any expense type.

Companies can improve the expense entry experience, by requiring its employees to enter the number of attendees only when an expense is over the limit.

Steps to Enable

To capture of number of attendees for expenses, perform the following steps:

1. Sign in as an application implementation consultant.
2. From the Setup and Maintenance work area, navigate to the Manage Policies by Expense Category page.
3. In the Manage Policies by Expense Category page, select the Entertainment option from the Create Policy button.
4. Select the Capture number of attendees for expense lines above the specified amount option
5. Enter the limit above which you want to require employees to enter the number of attendees.
6. Click Save and Close.
7. In the Manage Policies by Expense Category page, select the newly created policy and click the Activate button.
8. Navigate to the Manage Expense Report Template page and select the template of the expense type.
9. Drill down to the expense type.
10. In the Policies tab, click the Add Row icon in the Attendees Policy region to assign the newly created policy.
11. Select the policy from the Policy Name drop down.
12. Select the start and end date.
13. Click Save and Close.

Number of Attendees Policy

Number of Attendees Entry in Expenses Work Area

Tips And Considerations

If an expense type is assigned an entertainment policy that captures number of attendees and a rate policy is also associated with that expense type, then the amount limit specified for requiring the number of attendees must be less than or equal to the daily and the single instance rate limits.

Key Resources

• Watch Number of Attendees Capture When Expense is Above Designated Limits Readiness Training.

Role Information

To enable number of attendees, you need one of these roles:

• Expense Manager
• Application Implementation Consultant
• Financials Administrator

Travel Provider Integration Using Expense Travel Itineraries REST API

Create trips, travel itineraries, and reservations, such as air, hotel, and car rental, using the Expense Travel Itineraries REST API. Travel providers other than Getthere can integrate with Expenses using the Expense Travel Itineraries REST API.

When integrated, companies create the travel itineraries in Expenses application using the Expense Travel Itineraries REST API and run the Import Travel Itineraries process at scheduled intervals in validate mode to publish the itineraries to employee's Travel and Expenses work area.

Companies can integrate with their existing travel providers to allow employees to view their itineraries in the Expenses application and create expense reports from travel itineraries thereby simplifying expense reporting for employees.

Steps to Enable

Review the REST service definition in the REST API guides, available from the Oracle Help Center > your apps service area of interest > REST API. If you're new to Oracle's REST services you may want to begin with the Quick Start section.

To enable the REST integration with travel providers, perform the following:

1. Create the details of the travel partner in the Manage Travel Partner Integrations page. You must use the travel partner name as defined in this page when invoking the REST API.
2. Set the Enable Travel option to Yes for the specific business unit or the customer site in the Manage Expenses System Options page.
3. Create a user with the Travel Administrator role. Invoke the REST API using this user's credentials.
4. Create your own code to invoke the REST API. This code contains the following components:
   • Invoke the travel provider's API to retrieve the itineraries for a specific time period.
   • Transform the itinerary data to match the payload format of the Expense Travel Itineraries REST API if needed.
   • Post the itinerary data to the Expenses application by invoking the Expense Travel Itineraries REST API. You can create and update travel itineraries.
   • Review the itineraries rejected by the Expense Travel Itineraries REST API if any and take action.
5. Run the Import Travel Itineraries process at scheduled intervals in validate mode to publish the itineraries to Employee's Travel and Expenses work area.

To create the travel provider in the Expenses application, perform the following steps:

1. Sign in as a travel administrator.
2. From the Setup and Maintenance work area, navigate to the Manage Travel Partner Integrations page.
3. Click the Create icon to create a travel partner integration.
4. Select Third party from the Corporate Online Booking Provider drop down list.
5. Enter the travel partner name. Note that you also provide this name in the Expense Travel Itineraries REST API.
6. Enter the default booking site URL if you allow employees to access the travel partner's booking tool directly from the Expenses work area. Additionally, you can configure booking sites and booking site URLs that are specific to each country.
7. Click Save and Close.

Travel Partner Creation

To enable employees to view travel itineraries, perform the following steps:

1. Sign in as an application implementation consultant.
2. From the Setup and Maintenance work area, navigate to the Manage Expenses System Options page.
3. Set the Enable Travel option to Yes.
4. Click Save and Close.

You can set this option at the implementation level on the Manage Expenses System Options page, which applies to all business units. Alternatively, you can specify exceptions for specific business units on the Create System Options:Specific Business Unit dialog box.

Key Resources

• Watch Travel Provider Integration Using Expense Travel Itineraries REST API Readiness Training.
• Expense Travel Itineraries REST API section in the REST API for Oracle Financials Cloud guide.

Role Information

To integrate with a travel provider using the Expense Travel Itineraries REST API, you need the Travel Administrator role.

Expenses Mobile Application

Flight Class Policy Enforcement in Expenses Mobile Application

Enforce flight class policies for airfare, such as whether an employee is eligible for business class, in Expenses Mobile Application. If company policy permits expense report submission with policy violations, employees are prompted to provide a justification. If not, employees must correct the expense items that contain policy violations.

The mobile application validates airfare expenses for policy violations and requires a justification if the company allows submission with policy violation. The application displays an error message on the View screen if the company does not permit the flight class of the purchased ticket.

Flight Class Policy Validation

Enforcing airfare policies on the Expenses mobile application enables employees to fully complete entry of airfare expenses and submit them directly from the mobile application.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

To use this feature, ensure that you have downloaded the latest Expenses mobile application.

Key Resources

• Watch Improved Policy Enforcement and Location Entry in Mobile Application Readiness Training.
• Refer to the Set Up an Airfare Policy topic in the Oracle Financials Cloud Implementing Expenses guide to learn how to set up an airfare policy.

Role Information

You don't need a new role or privilege access to use this feature.

Location List of Values in Expenses Mobile Application

Select expense location from a list of values in the Add Expense and Add Mileage screens in Expenses mobile application. The list of values varies depending on the location list configuration for the business unit. Employees can select the correct location instead of manually entering the location.

When employees navigate to the Add Expense screen and the Add Mileage screen, the GPS location of the employee appears by default. Employees can select the expense location from the list of values. The location list of values depends on the setting for the Enable Expense Location Level option on the Manage Expenses System Options page. When the Enable Expense Location Level option is set to Country, the location list of values displays all countries. When the Enable Expense Location Level option is set to Country and State or Province or All Locations, the location list of values displays all countries and all states or provinces in each country.

The location list of values has three sections: GPS location; Recent Locations, consisting of the three most recently used locations; and All Locations, consisting of all locations in alphabetical order. Additionally, the list of values provides a search bar at the top of the list. Employees can manually enter a location if needed.

Location Level Setting

Selection of expense location from a list of values ensures accuracy and enforcement of the correct policy when expense policies are based on location.

Steps to Enable

You don't need to do anything to enable this feature.

Key Resources

• Watch Improved Policy Enforcement and Location Entry in Mobile Application Readiness Training.

Role Information

You don't need a new role or privilege access to use this feature.

Mandatory Fields Highlighted in Expenses Mobile Application

View all mandatory fields for an expense in the Add Expense, Add Mileage, and Submit Expense Report screens in the Expenses Mobile Application. The mandatory fields vary depending on the expense type configuration. Employees have a clear understanding of what is mandatory before submitting an expense.

Earlier, the application alerted employees about the missing information only when they saved their expenses. Employees can now easily identify these mandatory fields as soon as they navigate to the tasks:

• Date
• Type
• Amount
• Attachment
• Description
• Justification
• Project and task
• Category-specific mandatory fields:
  • Accommodations: Merchant, Checkout date
  • Airfare: Merchant, Flight Type, Flight Class, Ticket Number, Departure City, Arrival City
  • Car Rental: Merchant
  • Entertainment: Merchant
  • Mileage:  Starting Location, Destination, License Plate Number, Start Odometer Reading, End Odometer Reading
  • Miscellaneous: Merchant

Steps to Enable

You don't need to do anything to enable this feature.

Role Information

You don't need a new role or privilege access to use this feature.

Oracle Maps Cloud Service for Expenses Android Application

Calculate trip distance in mileage expense entry in the Expenses Android application using Oracle Maps Cloud Service. Additionally, use mileage tracker to track the commute distance and automatically create a mileage expense.

When Oracle Maps Cloud Service is enabled for your business unit, the Expenses Android application displays Oracle Maps when an employee selects a mileage expense type and taps the Departure Location field or the Arrival Location field. As the employee starts typing, the Location list displays suggestions when applicable. Employees can select a location from the list or enter the locations manually. When departure and arrival locations are entered, the map calculates the distance. When the employee returns to the Add Mileage screen, the distance field is populated with the calculated mileage.

The Mileage Tracker option in the springboard allows you to track your trip from the beginning to the end and create a mileage expense. From the Mileage Tracker option, click the Start button to start tracking. When you reach the destination, click the Stop button. The application automatically creates a mileage expense and then prompts you to confirm the expense.

Oracle Maps in Add Mileage Screen

Add Mileage Screen

Oracle Maps Cloud Service is not available to you if you have subscribed to Fusion Expenses Cloud Service and one or more of the following services: Fusion for United States Government Cloud Service with part number B87366, Fusion for United Kingdom Government Cloud Service with part number B87368, Fusion for European Union Restricted Access with part number B91905.

Enabling maps for mileage expenses and mileage tracker in the Expenses Android application improves usability, reduces errors, and provides Android users the same capabilities as the Expenses iOS application.

Steps to Enable

You don't need to do anything to enable this feature.

Role Information

You don't need a new role or privilege access to use this feature.

Expenses Digital Assistant

Automatic Synchronization of Expense Types and Synonyms to Oracle Digital Assistant

Automatically download expense types for all business units to Oracle Digital Assistant and associate preconfigured synonyms to expense types to improve expense type prediction.

When employees create expenses using conversations, Oracle Digital Assistant automatically predicts expense types from the information provided in the conversation using natural language processing. To facilitate expense type prediction, the Digital Assistant stores all expense types and their preconfigured synonyms for these expense types. You can add synonyms in the Synonyms for Expense Types section of the Manage Auto Submission and Matching Options page to improve the prediction. When you add a new expense type in an expense template or add a synonym to an existing expense type, the Expenses application syncs the new expense types and synonyms to the Digital Assistant.

Expense Type Prediction Based on Synonyms

Companies can improve the conversational experience and eliminate additional questions from the Digital Assistant by adding commonly used terms as synonyms for expense types and syncing the synonyms to the Digital Assistant.

Steps to Enable

To automatically sync expense types and synonyms, perform the following steps:

1. Sign in as an application implementation consultant.
2. From the Setup and Maintenance work area, navigate to the Manage Auto Submission and Matching Options page.
3. In the Synonyms for Expense Types section, select the desired expense type and enter more synonyms in the Synonyms field.
4. Select No from the Turn Off Auto Sync drop-down list.
5. Click Save and Close.
6. Sign in as a travel administrator.
7. From the Scheduled Processes work area, schedule the Automatically Submit Expense Reports process to run at a desired interval.

Synonyms for Expense Types

Tips And Considerations

If you have already scheduled the Automatically Submit Expense Reports process, you don't need to schedule it again.  Based on the options that you enabled in the Manage Auto Submission and Matching Options page, the process can perform these actions:

• Automatically submit reports
• Send digest emails
• Sync expense types and synonyms

Role Information

To enable automatic sync, you need one of these roles:

• Expense Manager
• Application Implementation Consultant
• Financials Administrator

Manual Submission of Expense Reports from Oracle Digital Assistant

Manually submit all available expenses directly from the Oracle Digital Assistant and enter a purpose for the expense report for faster submission of manually created expense reports.

Employees can control the timing of the submission of expenses created using Oracle Digital Assistant by manually submitting expenses directly from the Digital Assistant when they are ready. If the company has enabled automatic expense report submission, employees must first turn off the automatic submission for themselves using conversations such as "Manual submit", "Let me decide when to submit", "Don't submit yet", or "Stop auto submit". When the automatic submission is turned off, employees can submit expense reports using conversations such as "Submit expense" or "Submit my report". The Digital Assistant identifies all expenses that are ready for submission, tells you the total number of expenses and the amount, and asks you for a report name. The Digital Assistant then submits the report. If you say "I don't have a name" or "I don't care", then the Digital Assistant assigns a name and submits the report. You can cancel a manual submission that is in progress by saying "Cancel".

Employees can turn on automatic submission again by using conversation such as "Turn on auto submit", "Auto Submit", "Submit for me", or "Switch to auto". Employees can manually submit all expenses from the Expenses work area at any time.

Manual Submission of an Expense Report

Companies can allow employees to control their own expense submission schedule by allowing them to turn on and off the automatic expense report submission. This is especially useful when employees to want to submit all charges for a trip in a single report.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

To use this feature, ensure that you have downloaded the latest Expenses skill from the Digital Assistant store. Refer to the Upgrade Digital Assistant section in the Getting Started with Oracle Digital Assistant for Cloud Applications guide to learn more about upgrading the Expenses skill.

Key Resources

• Getting Started with Oracle Digital Assistant for Cloud Applications guide
• Expense Assistant section in the Oracle Financials Cloud Implementing Expenses guide

Role Information

You don't need a new role or privilege access to use this feature.

View Expenses Requiring Attention in Oracle Digital Assistant

View details of expenses that require attention using conversation in Oracle Digital Assistant for a simple, easy-to-use experience.

Oracle Digital Assistant informs employees about items that require attention when they inquire the status of expenses or expense reports using conversation, such as "Status of my expenses" and "Where is my last expense report". The Digital Assistant responds back with a list of pending expense reports, the total number of expenses that are ready for submission and the total amount, and the total number of expenses that require correction. Employees can ask for detailed information. The Digital Assistant breaks down the expenses that require attention into the following four categories:

• Missing information or expense is outside of policy
• Pending match to a corporate card charge
• Potential duplicate
• Charges that must be manually submitted

Employees must correct these issues in the Expenses Web application.

Expenses Requiring Attention

Employees can easily identify expenses that require attention, using channels such as SMS, thereby eliminating the need to sign into the Expenses web application.

Steps to Enable

You don't need to do anything to enable this feature.

Role Information

You don't need a new role or privilege access to use this feature.

Withdrawal of Automatically Submitted Expense Reports from the Expense Report Approval FYI Notifications

Withdraw an automatically submitted expense report from the Expense Report Approval FYI Notification.  This allows employees to update and resubmit the expense report.

When Oracle Digital Assistant Expenses skill and automatic expense report submission are enabled for your business unit, expense items that you create using the Digital Assistant are automatically submitted for approval. The FYI notification informs the employees that expenses were submitted on their behalf and allows them to withdraw the reports if needed.

The ability to withdraw an automatically submitted expense report from the approval queue enables employees to quickly take the corrective action if an inaccurate expense was submitted.

Steps to Enable

You don't need to do anything to enable this feature.

Role Information

You don't need a new role or privilege access to use this feature.

Federal Financials

U.S. Federal Financials is a configurable and flexible solution that enables U.S. Federal agencies to meet Federal financial management system requirements. It supplements Financials and Procurement functionality by providing U.S. Federal specific functionality. The initial release of U.S. Federal Financials will include the features described below. Additional functionality to fully meet mandatory Federal financial management requirements will be provided in upcoming releases.

U.S. Federal Accounting

U.S. Federal Financials accounting provides predefined accounting rules used to created budgetary accounting to comply with Federal accounting requirements in the U.S. Standard General Ledgers.

A predefined accounting method called US Federal will be provided for these Federal accounting rules. There are also predefined mapping codes available for defining mapping sets for U.S. Federal Financials. A natural account code must be chosen for each mapping code based on its description. These natural account codes are used by the Subledger Accounting rules.

Before accounting can be created the following prerequisite configuration must be defined:

• Federal Account Symbols
• Treasury Account Symbols
• Fund Attributes

KEY RESOURCES

• For more information on mapping codes and prerequisite configuration, refer to the Implementing U.S. Federal Financials guide.
• For more information on how to update accounting rules for a subledger application, refer to the Implementing Subledger Accounting guide.

U.S. Federal Invoice Accounting

Generate Federal budgetary accounting for invoices that comply with the U.S. Standard General Ledger requirements. Federal agencies can use predefined accounting rules to meet common accounting needs and configure new accounting rules to meet Federal agency specific needs.

These predefined journal entry rule sets are defined under the US Federal accounting method:

Event Class	Event Type	Rule Set
Prepayments	All	U.S. Federal Prepayments
Credit Memos	All	U.S. Federal Credit Memos
Debit Memos	All	U.S. Federal Debit Memos
Invoices	All	U.S. Federal Invoices
Prepayment Application	All	U.S. Federal Prepayment Application

This feature provides these business benefits:

• Supports compliance with U.S. Standard General Ledger requirements
• Includes predefined Federal accounting rules
• Provides the ability to customize predefined rules to meet agency specific needs

Steps to Enable

To complete the setup for invoice accounting, you must ensure:

• Federal Account Symbols are defined
• Treasury Account Symbols are defined
• Fund Attributes are defined
• Natural account values are assigned to predefined U.S. Federal Financials mapping sets.

Key Resources

• Watch Introduction to U.S. Federal Financials Readiness Training.
• For more information on how to update accounting rules for a subledger application, refer to the Implementing Subledger Accounting guide.

Role Information

You don't need any new role or privilege to set up and use this feature.

U.S. Federal Payment Accounting

Generate Federal budgetary accounting for payments that comply with the U.S. Standard General Ledger requirements. Federal agencies can use predefined accounting rules to meet common accounting needs and configure new accounting rules to meet Federal agency specific needs.

These predefined journal entry rule sets are defined under the US Federal accounting method:

Event Class	Event Type	Rule Set
Payments	All	U.S. Federal Payments
Refunds	All	U.S. Federal Refunds

This feature provides these business benefits:

• Supports compliance with U.S. Standard General Ledger requirements
• Includes predefined Federal accounting rules
• Provides the ability to customize predefined rules to meet agency specific needs

Steps to Enable

To complete the setup for payment accounting, you must ensure:

• Federal Account Symbols are defined
• Treasury Account Symbols are defined
• Fund Attributes are defined
• Natural account values are assigned to predefined U.S. Federal Financials mapping sets.

Key Resources

• Watch Introduction to U.S. Federal Financials Readiness Training.
• For more information on how to update accounting rules for a subledger application, refer to the Implementing Subledger Accounting guide.

Role Information

You don't need any new role or privilege to set up and use this feature.

U.S. Federal Purchase Order Accounting

Generate Federal budgetary accounting for purchase orders that comply with the U.S. Standard General Ledger requirements. Federal agencies can use predefined accounting rules to meet common accounting needs and configure new accounting rules to meet Federal agency specific needs.

These predefined journal entry rule sets are defined under the US Federal accounting method:

Event Class	Event Type	Rule Set
Purchase Orders	All	U.S. Federal Purchase Orders

This feature provides these business benefits:

• Supports compliance with U.S. Standard General Ledger requirements
• Includes predefined Federal accounting rules
• Provides the ability to customize predefined rules to meet agency specific needs

Steps to Enable

To complete the setup for purchase order accounting, you must ensure:

• Federal Account Symbols are defined
• Treasury Account Symbols are defined
• Fund Attributes are defined
• Natural account values are assigned to predefined U.S. Federal Financials mapping sets.

Key Resources

• Watch Introduction to U.S. Federal Financials Readiness Training.
• For more information on how to update accounting rules for a subledger application, refer to the Implementing Subledger Accounting guide.

Role Information

You don't need any new role or privilege to set up and use this feature.

U.S. Federal Requisition Accounting

Generate Federal budgetary accounting for requisitions that comply with the U.S. Standard General Ledger requirements. Federal agencies can use predefined accounting rules to meet common accounting needs and configure new accounting rules to meet Federal agency specific needs.

These predefined journal entry rule sets are defined under the US Federal accounting method:

Event Class	Event Type	Rule Set
Requisitions	All	U.S. Federal Requisitions

This feature provides these business benefits:

• Supports compliance with U.S. Standard General Ledger requirements
• Includes predefined Federal accounting rules
• Provides the ability to customize predefined rules to meet agency specific needs

Steps to Enable

To complete the setup for requisition accounting, you must ensure:

• Federal Account Symbols are defined
• Treasury Account Symbols are defined
• Fund Attributes are defined
• Natural account values are assigned to predefined U.S. Federal Financials mapping sets.

Tips And Considerations

For more information on how to update accounting rules for a subledger application, refer to the Implementing Subledger Accounting guide.

Key Resources

• Watch Introduction to U.S. Federal Financials Readiness Training.

• For more information on subledger accounting, refer to documentation on Implementing Subledger Accounting for further information on how to update accounting rules for a subledger application.

Role Information

You don't need any new role or privilege to set up and use this feature.

U.S. Federal Payment Processing

U.S. Federal Financials Payment Processing features include capabilities to meet U.S. Federal Prompt Payment requirements and creating U.S. Federal Payment File Formats.

U.S. Federal Payment File Formats

To meet Federal payment file standards, create Payment Automation Manager (PAM) and Secure Payment System (SPS) payment file formats.

These payment formats are supported for Treasury payments:

• US Federal SPS ACH
• US Federal SPS Check
• US Federal SPS Same Day Payments
• US Federal PAM ACH
• US Federal PAM Check

The business benefit of this feature is that it supports creation of Federal payment files that comply with U.S. Treasury standards.

Steps to Enable

To set up federal payment processing:

• Ensure that the Agency Location Codes (ALCs) for the internal bank accounts are already defined.
• Ensure that the federal options for each business unit are already defined.
• To setup SPS payment formats, you must perform these steps:

1. Map pay groups to payment types and appropriate check and electronic types on the Manage Payment Type Mapping page.
2. Ensure that internal bank accounts are defined with ALCs and Payables Documents with these payment formats:

• U.S. Federal SPS ACH Format
• U.S. Federal SPS Check Format
• U.S. Federal SPS Same Day Payment Format

• To setup PAM payment formats, you must perform these steps:

1. Map pay groups to payment types and appropriate check and electronic types on the Manage Payment Type Mapping page.
2. Ensure that internal bank accounts are defined with ALCs and Payables Documents with these payment formats:

• U.S. Federal PAM ACH Format
• U.S. Federal PAM Check Format

Tips And Considerations

When submitting a Payment Process Request for a SPS or PAM payment file, ensure it includes the following:

• Only one Pay Group
• A payment method of either Check, Electronic, or Wire (SPS)
• Only one Invoice Business Unit
• One of the following Payment Process Profiles:
  • US Federal PAM ACH
  • US Federal PAM Check
  • US Federal SPS ACH
  • US Federal SPS Check
  • US Federal SPS Wire Same Day Payment

Key Resources

• Watch Introduction to U.S. Federal Financials Readiness Training.
• For more information on Federal payment file formats, refer to the Implementing U.S. Federal Financials and Using U.S. Federal Financials guides.
• For more information on the payment process, refer to the Implementing Payables Invoice to Pay and Using Payables Invoice to Pay guides. 

Role Information

You don't need any new role or privilege to set up and use this feature.

U.S. Federal Prompt Payment

Calculate invoice due dates and discount dates, generate interest payments, and take discounts when economically feasible to comply with U.S. Federal Prompt Payment requirements based on configurable rules.

Prompt Payment features include these processes:

• Prompt Payment Date Calculation Process.  This is a scheduled process that updates the due date and discount date on open invoices in accordance with Prompt Payment rules.  These dates are only updated for invoices with payment terms defined with Prompt Payment enabled. This process optionally generates a Prompt Payment Date Calculation Report.

• Discount Calculation process.   This process is automatically invoked for invoices selected by the payment process that are eligible for discounts and have payment terms that are Prompt Payment enabled.  The process only takes discounts that are economically beneficial based on Prompt Payment rules.

• Interest Calculation process.  This process is automatically invoked for invoices that are paid late by the payment process and have payment terms that are Prompt Payment enabled.  The process creates interest invoices with interest amounts in accordance with Prompt Payment interest calculation rules. 

The business benefit of this feature is that it supports compliance with the U.S. Federal Prompt Payment Act.

Steps to Enable

To complete the setup for Prompt Payment, you must ensure that these conditions are met:

• A Treasury Current Value of Fund Rate (CVFR) is defined on the Manage Interest Rates page
• Payment terms are defined with the correct Prompt Payment attributes on the Payment Terms page
• A transaction calendar for Prompt Payment is defined to identify non-working days

Tips And Considerations

The Prompt Payment Date Calculation Process should be scheduled immediately before submitting payment process requests.

Key Resources

• Watch Introduction to U.S. Federal Financials Readiness Training.
• For more information on Federal Prompt Payment, refer to the Implementing U.S. Federal Financials and Using U.S. Federal Financials guides.
• For more information on the invoice to pay process, refer to the Implementing Payables Invoice to Pay and Using Payables Invoice to Pay guides.

Role Information

• Manage Prompt Payment Duty

General Ledger

Definition and Maintenance of Chart of Accounts and Related Configurations

You can now define and maintain your chart of accounts and hierarchies using a guided process to ensure that the setup adheres to the required standards.

The improved user experience centralizes all related elements of managing a chart of accounts and provides efficient tools for loading account values and hierarchies.

Navigation to the new user interface is through the Setup and Maintenance work area:

• Offering: Financials 
• Functional Area: Financial Reporting Structures 
• Task: Manage Chart of Accounts Configurations

The centralized user interface allows you to:    

• Create new chart of accounts using the Rapid Implementation for General Ledger workbook template and upload the setup.
• Monitor the progress of the upload request using the Process Monitor.
• Deploy all chart of accounts and view the deployment status.
• Manage account combinations.
• Manage shorthand aliases.
• Manage cross-validation rules.

  

The Manage Chart of Accounts Configurations Page

Edit chart of accounts configurations:

• Manage chart of account details such as name, description, dynamic account combination creation, and shorthand aliases.
• Manage segments details such as name, label, value set, and default hierarchy. 

The Edit Chart of Accounts Configurations Page

• Manage value set details such as values and data security.

The Value Set Tab on the Manage Chart of Accounts Configurations Page

A spreadsheet interface is available for creating and editing values for the value set.

Spreadsheet to Manage Values

A new spreadsheet interface is available for creating and editing segment value security rules for value sets being enabled for segment value security enforcement for the very first time.

• Enable security for the value set and provide it a data security resource name.

• Once you have saved your changes, the Manage Data Security button will be enabled and can be used to launch the spreadsheet.

• Once you have used the spreadsheet to manage the security rules for a value set that has been enabled for security enforcement for the first time, you must exclusively use the spreadsheet from that point forward to manage segment value security rules for that value set.   

Spreadsheet to Manage Segment Value Security

• Manage hierarchies and hierarchy versions.

The Hierarchies Tab on the Manage Chart of Accounts Configurations Page

A spreadsheet interface is available for creating and editing hierarchies and version for the value set.

Spreadsheet to Manage Hierarchies

This guided process gives you a set of simplified and centralized user interfaces for managing chart of accounts configurations.

Steps to Enable

You don't need to do anything to enable this feature.

Role Information

• Financial Application Administrator

Entered and Converted Currency Balances Side by Side in Financial Reporting

View entered currency balances and converted balances side by side in Smart View and Financial Reporting. Accountants can now easily compare the balances.

Use the Converted All dimension member in conjunction with the Entered dimension member in General Ledger balances cube-based reports that display the Currency Type columns and Currency rows, such as Smart View and Financial Reporting Studio reports. These reports can compare entered currency amounts with the equivalent converted ledger currency amounts

The Converted All currency dimension member for the Currency Type dimension displays the converted amount for each entered currency. Your reports can display entered currency amounts and converted amounts side by side in the currency rows as shown in the following example.

A Smart View Report Displaying Standard Actual Balances

A Smart View Report Displaying End of Day (EOD) Balances in a Ledger Enabled for Average Daily Balances

You can select this currency type for any primary or secondary ledger or any journal level or subledger-level reporting currency. You can also select this currency type for a ledger set, provided the ledgers in the set have the same ledger currency.

This feature provides the following business benefit:

You can display entered currency amounts and their equivalent converted currency amounts side by side in your reports for comparative analysis.

Steps to Enable

If you are a new customer, this feature is automatically enabled.

If you are updating to this release and want to enable this feature, refer to General Ledger Entered and Converted Currency Balances Side by Side in Financial Reporting  (Doc ID 2723429.1) in My Oracle Support for the setup steps.

Key Resources

For more information, refer to:

•  Implementing Enterprise Structures and General Ledger guide
•  Using General Ledger guide

Role Information

No new privileges or roles are required to use this feature.

Option to Publish Hierarchies for All Value Sets

Select the All Value Sets option when submitting the Process Account Hierarchies process or the Publish Chart of Accounts Dimension Members and Hierarchies to Balances Cubes process.  

This enables publishing hierarchies for all value sets to all GL balances cubes without having to submit the processes separately for each value set.

Steps to Enable

You don't need to do anything to enable this feature.

Prevent General Ledger Period Closure When Open Subledger Periods Exist

Prevent the closure of a General Ledger accounting period if the accounting period for any of the corresponding subledgers is still open, or if incomplete accounting entries or transactions exist for the period.  This ensures an effective period close process by validating that all transactions are complete and that incomplete transactions aren't held up during the close.

Assets is now included in the list of subledgers along with the existing Cost Management, Payables, Project Foundation, Receivables and Revenue Management subledgers.

The prevention of period closure applies to the primary ledger. The period close process prevents the corresponding General Ledger accounting period from closing if any of the following exceptions exist:

1. Period Status exception

• Subledger accounting periods are not closed 

2. Transaction exception

• Unprocessed and untransferred subledger transactions
• Pending Intercompany transactions
• Pending transactions in the General Ledger interface
• Unposted transactions in General Ledger

By including the Assets subledger, the period statuses of the asset books are also checked, and the General Ledger period close is prevented if any of the asset books enabled for posting to the primary ledger have not been closed.

You can also exclude one or more subledgers listed as lookup codes for the ORA_GL_INCLD_STRICT_PRD_CLOSE lookup type. The General Ledger period close process will skip the period status exception encountered within the context of the subledgers that you have excluded.

This feature provides the following business benefits:

• Brings the General Ledger period close process in line with your corporate-wide business policy.

Comply with the general business practice of not allowing a closed General Ledger period to be reopened, unless there are material changes. In general, companies follow this practice unless there are strong justifications and related approvals. By using this feature, you might not need to reopen a closed accounting period because you already ensured all unprocessed transactions and exceptions were duly resolved before the General Ledger period was closed.

• Provides more meaningful and accurate financial reporting because all exceptions would have been duly resolved and accounted for, before reporting.

• Helps comply with audit requirements.

Steps to Enable

To enable the feature for a primary ledger, perform the following steps:

1. In the Setup and Maintenance Work area, use the Specify Ledger Options task:

• Offerings: Financials
• Functional Area: General Ledger
• Task: Specify Ledger Options, with the ledger scope set

2. On the Specify Ledger Options page, select the Prevent General Ledger Period Closure When Open Subledger Periods Exist option in the Period Close section.  
3. Save and close the page.

To exclude one or more subledgers so the General Ledger period close process skips the period status exceptions encountered in the context of those subledgers, perform the following steps:

1. In the Setup and Maintenance work area, use the Manage General Ledger Lookup Values task:

• Offerings: Financials
• Functional Area: General Ledger
• Task: Manage General Ledger Lookup Values

2. Enter ORA_GL_INCLD_STRICT_PRD_CLOSE in the Lookup Type field and click Search.
3. For each subledger that you want to exclude, click the Enabled field to deselect it.
4.  Save and close the page.

Tips And Considerations

• Currently, the primary ledgers use this feature.

• You can revert back to the pre-existing functionality by deselecting the Prevent General Ledger Period Closure When Open Subledger Periods Exist option in the Period Close section on the Specify Ledger Options page of a primary ledger.

• By default, the General Ledger accounting period close process considers period status exception, if any, within the context of the included subledgers. You can optionally exclude one or more subledgers, so the General Ledger period close process skips the period status exception encountered in the context of those subledgers. The Assets subledger is excluded by default. The transaction exceptions previously listed will still be checked and period close prevented if the process encounters such exceptions. 

• You need to set up the subledger exclusions and reinclusions only once to apply to every primary ledger for which the Prevent General Ledger Period Closure When Open Subledger Periods Exist option is enabled. The Assets subledger is excluded by default.

• The Close period action initiated using the application pages will display an error message when the subledger periods are not yet closed. When encountering any other exception, and in all cases when the Close period action was initiated using the Enterprise Scheduler Service processes, the error messages are rendered in the log files. 

• Unlike the other subledgers, Assets can use a calendar that is different from the General Ledger accounting calendar. Therefore, if the Assets subledger is included as a part of the period status exceptions check, then you must first also close those Assets periods that contain overlapping dates compared to the corresponding general ledger period before closing the General Ledger period.

• By default, the Assets subledger is already excluded for the ORA_GL_INCLD_STRICT_PRD_CLOSE lookup type. If you decide to include the Assets subledger, so the General Ledger accounting period close process considers the period status exception, you have to enable the Assets subledger by selecting the Enabled check box on the Manage General Ledger Lookup Values page.

• You also have the option of excluding certain asset books from being subjected to the period status exception during the General Ledger period close process. List those books in the lookup code section of the Manage Fixed Assets Lookups page for lookup type ORA_FA_DISABLE_STRICT_GL_CLOSE.

Key Resources

• Watch Prevent General Ledger Period Closure When Open Subledger Periods Exist Readiness Training (update 20A).

• Related Help:
  • Period Close chapter in the Implementing Enterprise Structures and General Ledger guide
  • Accounting Period Close chapter in the Using General Ledger guide

Role Information

You don't need any new role or privilege access to set up and use this feature.

Rapid Implementation Improvement to Create Separate Value Sets for Primary Balancing and Intercompany Segments

The Rapid Implementation for General Ledger workbook template now creates separate value sets for primary balancing and intercompany segments.

If you assign the Intercompany segment label to a segment, a new Intercompany sheet is automatically added to the workbook when you select the Add Segment Sheets button. Use the sheet to enter your intercompany values and hierarchies.

When you upload the chart of accounts file, the application creates a new value set for the Intercompany segment with the values that you entered. If you want to assign the Intercompany segment the same values as the Primary Balancing segment, copy all the parent and child values from the Companies and Legal Entities sheet to the Intercompany sheet.

• If you enable segment value security on the primary balancing value set, the security enforcement won't conflict with the Intercompany segment because the value sets for the two segments will be different. The same holds true if you enable segment value security on the intercompany value set. Security enforcement won't conflict with the Primary Balancing segment.

• If you plan to use the Related Value sets feature, and create a relationship between the segments that involves your primary balancing segment or intercompany segments, there will be no conflict of values because the value sets are different.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

• You can download the workbook using the Download Setup Template button in the Manage Chart of Accounts Configurations page or from the Create Chart of Accounts, Ledger, Legal Entities, and Business Units in Spreadsheet task.

• If you want to move the data from an earlier version of the workbook to the latest workbook, you can copy the data and paste it as values into the new workbook, so that the lists of values in the new workbook are not lost. If you have more rows of data to copy to the new workbook, disable the macros, copy the data, and then re-enable macros. 

• If you want to assign the Intercompany segment the same value set as the Primary Balancing segment, you can change the value set assignment from the Manage Chart of Accounts Configurations page after you upload the chart of accounts configuration and before you upload the financial structures for the chart of accounts. If you decide to go with the same value set for both segments, you will not be able to change the value set association later on, once the ledger is assigned to the chart of accounts.

Key Resources

For more information on chart of accounts and value sets, refer to the Oracle Financials Cloud Implementing Enterprise Structures and General Ledger guide, Rapid Implementation chapter.

Validations of Date and Number Values Captured Using Descriptive Flexfields

You can now define date and number validations while setting up descriptive flexfields in General Ledger. These validations ensure more accuracy and consistency of the information that is captured using these additional fields.

The following General Ledger descriptive flexfields now support both the date and number data types.

Flexfield Code	Name	Description
GL_JE_LINES	Journal Lines	Fields for journal line details on the Journal Entry page.
GL_CAPTURED_INFO	Journals Captured Information	Fields for captured information details on the Journal Entry page.
GL_CODE_COMBINATIONS	General Ledger Accounts	Fields for account combination details on the Account Combinations page.
GL_DAILY_RATES	Daily Rates	Fields for daily rate details in the Currency Rate Manager.
GL_ACCESS_SETS	Access Sets	Fields for access set details on the Data Access Sets page.
GL_JE_SOURCES	Journal Sources	Fields for source details on the Journal Sources page.
GL_JE_CATEGORIES	Journal Categories	Fields for category details on the Journal Categories page.
GL_PERIOD_STATUSES	Open and Close Periods	Fields for period status details on the Period Statuses page.
GL_TRANSACTION_DATES	Transaction Dates	Fields for calendar date details on the Transaction Calendars page.

You can now define validations on up to five date and five number columns. The column names for the Date data type are ATTRIBUTE_DATE1 through ATTRIBUTE_DATE5 and for the Number data type, the column names are ATTRIBUTE_NUMBER1 through ATTRIBUTE_NUMBER5.  For the Journals Captured Information descriptive flexfield, the Date data type column names are ATTRIBUTE_DATE6 through ATTRIBUTE_DATE10 and for the Number data type, the column names are ATTRIBUTE_NUMBER6 though ATTRIBUTE_NUMBER10.

The following File-Based Data Import templates and the desktop integrated workbook can use both the date and number fields as additional validations.

Name	Type	Related Descriptive Flexfield
Import and Calculate Daily Rates	File-Based Data Import	Daily Rates
Import Account Combinations	File-Based Data Import	General Ledger Accounts
Journal Import	File-Based Data Import	Journal Lines, Journals Captured Information
Create Journal	ADF Desktop Integration	Journal Lines, Journals Captured Information

This feature provides the following business benefits:

• Validates the additional information at the source of data capture.
• Ensures more accuracy and consistency in reporting and analyses.

Steps to Enable

You don't need to do anything to enable this feature.

Key Resources

For more information, refer to these guides:

• Implementing Enterprise Structures and General Ledger
• File-Based Data Import for Financials

Role Information

No new roles or privileges are required to set up and use this feature.

Joint Venture Management

Data Security for Joint Venture Management

Data Security for Joint Venture Management enables companies to add data security throughout the Joint Venture Management system.

Joint venture data is secured by business units. Users that are granted data access to a business unit can view and manage the joint ventures associated with that business unit.

Data Security for Joint Venture Management enables joint venture companies to protect information assets from insider threats and prevent fraud.

Steps to Enable

Use the Opt In UI to enable this feature. For instructions, refer to the Optional Uptake of New Features section of this document.

Offering: Financials

To use data security for Joint Venture Management, an administrator with the Application Implementation Consultant role must perform the following tasks:

1. Opt in to Joint Venture Management.      
2. Opt in to Data Security for Joint Venture Management. By default, this feature is disabled and all users have access to all the joint ventures. 
3. Configure business unit access to users and roles.      
4. Ensure that the appropriate security roles are associated with your users.

Tips And Considerations

Data Security for Joint Venture Management is disabled by default. Once enabled, the joint venture predefined roles are configured with data security on business units, limiting the joint ventures that users can access and the actions they can perform on the joint venture data. The joint venture application administrator and joint venture accountant roles are set up with the ability to view and manage the joint ventures associated with the business units they have access. However, users with the joint venture accounting manager role are set up with the ability to only view the joint ventures they have access. The administrator can use this predefined setup or update as required.

Key Resources

• Watch Data Security for Joint Venture Management Readiness Training.
• For more information, refer to the Implementing Joint Venture Management guide.

Role Information

• Application Implementation Consultant

Joint Venture Additional Information in Receivables Invoice

Use the Print Receivables Transactions process to display joint venture transaction details on the Receivables invoice sent to the joint venture partners to recoup the partner’s share in a joint venture.

Minimize disputes of joint venture Receivables invoices with joint venture specific information available on each invoice.

Continue to manage your business without the need to change your existing business processes

Less or no impact to your existing business processes with the addition of Joint Venture Management

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

Implementation considerations:

• Change the data model for the Receivables Print Data Model.
• Configure the Invoice Print and Credit Memo Print BI Publisher templates to add joint venture attributes to the Receivables invoices sent to customers.

Key Resources

• Watch Joint Venture Additional Information in Receivables Invoice Readiness Training.
• For more information, refer to the Implementing Joint Venture Management guide.

Role Information

• Application Implementation Consultant
• Joint Venture Accountant/Manage Billing Activities/View Receivables Invoice

Joint Venture and Project Management Enhanced Data

The existing Joint Venture Management and Project Costing integration enables customers to automatically adjust project costing to facilitate accurate project capitalization and gross to net reporting. This enhancement allows the project costing adjustments to be sent into Project Costing in accounted mode allowing customers to reconcile costs in Project Costing with General Ledger and the ability to budget by net costs.

BUDGETING

The budgeting functionality takes into account the gross costs that are imported into Project Costing as well as the project costing adjustments that Joint Venture Management sends to Project Costing. As a result budgeting and forecasting is based on the net costs (gross minus project costing adjustments).

G/L RECONCILIATION

With this enhancement, Joint Venture Management sends the project costing adjustments in accounted mode. This facilitates easier Projects to G/L reconciliation process by ensuring that the correct partner offset (cost recovery) account is passed in with the project costing adjustments.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

If Project Capitalization and Progress Management is enabled and the corresponding configuration is completed in Joint Venture Management, any subsequent and new joint venture transactions created in 21A will reflect the enabled integration with projects. Project costing adjustments created by Joint Venture Management for the new joint venture transactions and distributions will be sent to Project Costing in "accounted” mode. 

Preexisting transactions, distributions and project costing adjustments created by Joint Venture Management before 21A will be processed through their lifecycle as they did in 20D.

Key Resources

• Watch Joint Venture and Project Management Enhanced Data Readiness Training.
• Watch Project Capitalization and Progress Management Readiness Training.
• For more information, refer to the Implementing Joint Venture Management guide.

Role Information

• Joint Venture Accountant

Joint Venture Definition Improvements

Simplify setting up Joint Venture Definitions with:

• Ability to select a supplier that belongs to the same business unit as the business unit of the joint venture invoicing partner
• Additional validations in the invoicing partner definition to prevent users from moving active invoicing partners back to pending status
• Ability to choose a party for a stakeholder from a list of available parties

Improve productivity with the ability to choose the correct supplier for an invoicing partner from a list of available suppliers that belong to the same business unit.

Avoid data errors by preventing an invoicing partner set back to Pending status from an Active status.

Remove the dependency of requiring a license for Sales module in order to create joint venture stakeholders.

Steps to Enable

You don't need to do anything to enable this feature.

Key Resources

• Watch Joint Venture Usability and Configurability Readiness Training.
• For more information, refer to the Implementing Joint Venture Management guide.

Role Information

• Joint Venture Application Administrator

Transactions Identified by Specified Segment

Identify billable joint venture transactions by a segment other than the segment with the cost center segment label in the chart of accounts.

Currently, joint venture transactions are anchored by the cost center segment as labeled by FA_COST_CENTER. This enhancement enables customers to specify which segment is the anchor by choosing a segment label other than FA_COST_CENTER.

Increased flexibility with alternate ways of associating Financials with Joint Venture(s) other than a segment value related to the segment with the cost center segment label.

Eliminate the need to change the chart of accounts or associated reporting with the flexibility to specify a different segment for billable transactions.

Steps to Enable

You don't need to do anything to enable this feature.

Key Resources

• Watch Joint Venture Usability and Configurability Readiness Training.
• For more information, refer to the Implementing Joint Venture Management guide.

Role Information

• Joint Venture Application Administrator

Usability and Navigation Improvements for Joint Venture Management

Continued improvements to the Joint Venture applications that increase productivity through reducing the number of clicks, reducing scrolling and simplifying navigation.

Leverage the Oracle Visual Builder Add-in for Excel utility to:

• Easily export joint venture transactions and distributions into spreadsheets to modify values for processing, and then import the updated records back into Joint Venture Management.

Improve the productivity of the joint venture accountant on a day-to-day basis by significantly reducing the time required to perform updates to joint venture transactions and joint venture distributions with the use of spreadsheets.

Steps to Enable

You don't need to do anything to enable this feature.

Key Resources

• Watch Joint Venture Usability and Configurability Readiness Training.
• For more information, refer to the Implementing Joint Venture Management guide.

Role Information

• Joint Venture Accountant

Lease Accounting

Complex Payment and Options Structures

Manage contracts with non-level payments and options by capturing structures such as step payments, skips, and stubs.  This provides the lease administrator the ability to enter one payment or renewal option record that contains multiple payment escalations, payment decreases, and rent-free periods.

Payment Entry Page with Non-Level Payments

The business benefits of this feature include support for complex payment structures such as escalations and rent-free periods.

Steps to Enable

You don't need to do anything to enable this feature.

Role Information

You do not need any new role or privilege access to set up and use this feature.

Lease Amendments for Scope Increases

Perform amendments on a lease to add payments or assets. Amendments to a contract include creating a new version of the contract, adjusting the accounting balances for the contract, and maintaining an audit of the changes. Additionally, perform non-financial changes to update attributes that do not require re-calculation of balances.

Create Amendment Page

Amendment History Page

The business benefits of this feature include:

• Reduced time and effort to perform a contract amendment
• Improved controls with a complete audit history of lease amendments
• Better usability with access to prior version of the lease
• Automated accounting for adjustment to Right-of-Use and Liability balances

Steps to Enable

Use the Opt In UI to enable this feature. For instructions, refer to the Optional Uptake of New Features section of this document.

Offering: Financials

Tips And Considerations

Currently, amendments is limited to scope increases and non-financial changes.  Scope decreases is not yet supported.

Role Information

You do not need any new role or privilege access to set up and use this feature.

Payables

Additional Tax Drivers in Supplier Portal for Accurate Tax Calculation

Use the additional tax drivers available on invoice lines to calculate tax accurately when submitting invoices through the Supplier Portal. This helps suppliers reconcile the tax calculated on the invoice lines with the tax entered on the physical invoice.

Following new tax drivers are available in the supplier portal invoice pages

• Tax Control Amount (Header)
• Transaction Business Category
• Intended Use
• Product Fiscal Classification
• User Defined Fiscal Classification
• Product Type
• Product Category
• Assessable Value
• Tax Control Amount (Lines)

The nine additional tax drivers provides additional flexiblity in configuring comprehensive tax rules. Supplier users can avoid overwriting application calculated taxes because they can see a more accurate tax calculation from the application. This will help and avoid disputes with the AP department when the invoice has been submitted for review and approval.

Steps to Enable

Use the Opt In UI to enable this feature. For instructions, refer to the Optional Uptake of New Features section of this document.

Offering: Financials  No Longer Optional From: Update 21D

Tips And Considerations

• The additional tax driver columns on the invoice lines are hidden by default.
• The values on the tax drivers are defaulted when the new lines are created. User can override them as required.
• Tax drivers for matched invoices are defaulted from the purchase order lines/schedules.

Role Information

There are no additional security privileges required to access this feature. The standard job role "Supplier Accounts Receivable Specialist" which inherits the duty role "Self Service Payables Invoice Entry" provides the necessary security access to the new feature.

Creation and Management of Supplier Invoices with Retainage Payment Terms

Create and manage supplier invoices matched to purchase orders with retainage payment terms. Hold back retainage on purchase orders matched invoices and only release the retained amount once the contract is completed.

SUPPLIER INVOICES MATCHED TO PURCHASE ORDERS HAVING RETAINAGE PAYMENT TERMS

Create and manage supplier invoices matched to purchase orders with retainage payment terms. You can now match a Payables invoice to a purchase order which has a retainage rate specified on the purchase order schedule. When you create an invoice line by matching to a purchase order schedule that has a retainage rate, Payables automatically calculates the retainage amount and creates a retainage distribution. Application also ensures that the retainage amount computed is not greater than the maximum retainage amount specified on the purchase order line. This retainage amount withheld is reduced from the amount that is payable to the supplier.

The following updates were made to the Create Invoice page for supplier invoices matched to purchase order schedules with retainage payment terms:

• Matching Window – You can see the retainage rate specified on the purchase order schedule

• Totals Region – You can see the total retainage deducted on the invoice

• Invoice Lines – You can see the details of retainage on the invoice line and also the retainage that is remaining to be released.

RETAINAGE RELEASE INVOICES

There is a new invoice type of retainage release which can be used to release the retained amount previously withheld. Retainage release invoices can be created either through the create Payables invoice user interface or suppliers can also request for retainage amount withheld from the supplier portal user interface.

User can create retainage release invoice by using the following 2 matching windows:

• Retainage Release by PO Schedule – Using this interface, user can query for the purchase order schedule and release the withheld amount at schedule level.

• Retainage Release by Invoices – Using this interface, user can query for all the invoices that withheld the retainage amount for a purchase order schedule and release the withheld amount based on the individual invoices.

Following are the changes done on the create invoice user interface for retainage release invoice flow:

• New invoice type of retainage release

• Retainage Release by Schedule – You can release the retained/withheld amount at the Purchase order schedule level.

• Retainage Release by invoices - You can release the retained/withheld amount at the individual invoice level.

• Invoice Lines - You can see the details of retained invoice number and the retained invoice line that was released as part of this retainage release invoice

Business Benefits:

1. Enables companies to record invoices for purchase orders with retainage payment terms.
2. Allows for release of the retainage amount after satisfactory completion of work and approval from the appropriate personnel.
3. Provides ability to configure custom reports using Oracle Transaction Business Intelligence with detailed information about retained amounts and corresponding release amounts.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

• The Net of Retainage option is displayed in Show More mode. Enable this option to enter the total amount sent by the supplier when the supplier invoice amount is net of retainage.

• Transaction taxes and invoice time withholding taxes are calculated on the net of retainage amount. When the retainage release invoice is created, the balance of transaction taxes and invoice time withholding taxes are calculated. Payment time withholding is calculated on the payment amount. Since the payment amount is net of retainage, the withholding calculated on the standard invoice is also net of retainage. The balance withholding will be deducted when the retainage release invoice is paid.

• You can configure approval rules based on the retainage attributes like 'Net of Retainage', 'Retainage' and new invoice type of 'Retainage Release'.

• You can use the custom BIP approval notification model to customize the approval notification to display the retainage details of the invoice.

• Retainage attributes like retainage, retainage amount remaining, and retainage invoice are exposed in Payables Invoices Real Time subject area and can be used for configuring custom OTBI reports.

• The approval status of retainage release invoices is always set to 'Required', regardless of the Invoice Options approval setup. Approval rules need to be configured to send the retainage release invoices to the appropriate approver.

• Release Amount Net of Tax." You use this field to enter the difference between the total retained amount that you expect to release minus the tax amount specified on the retainage release invoice. Payables allows you to release to the extent of the release amount net of tax in the matching window of the Retainage Release by Schedule or Retainage Release by Invoice for every match cycle.

Role Information

No additional roles are required to work on this feature.

Electronic Filing of Forms 1099-MISC and 1099-NEC for Tax Year 2020

Generate electronic files for Forms 1099-MISC and 1099-NEC in accordance with the new specifications for tax year 2020 published by the US Internal Revenue Service. Starting from tax year 2020, non-employee compensation is reported in Form 1099-NEC. The US 1099 Electronic Media Report generates now generates Form 1099-MISC as well as Form 1099-NEC as two separate files.

The process for entering invoices for 1099 reportable suppliers remains unchanged. You can continue using the same codes as before. The amounts will be reported in the new positions as per the revised specifications.

You can run the US 1099 Electronic Media Report from the Scheduled Processes work area. After the process is completed, click on Republish. You can then select the Form 1099-MISC or 1099-NEC for submission. Select the output format as RTF and then copy the contents of the file into a text file for uploading on IRS FIRE website. Note that combined filing is not applicable for Form 1099-NEC. So, no K records will be generated for 1099-NEC.

If you are filing prior year returns (2019 or earlier), Non-Employee Compensation must be reported in 1099-MISC, so you must select Form 1099-MISC from the report output. Non-Employee Compensation will be reported with Amount code G.

Starting from tax year 2020, IRS requires non-employee compensation to be reported in Form 1099-NEC. The separation of non-employee compensation into a new form allows taxpayers to adhere to the separate deadlines for Form 1099-NEC and Form 1099-MISC. Form 1099-NEC must be submitted before end of January while Form 1099-MISC can be submitted by end of March.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

Before running this report, you must run the US 1099 Invoice Exceptions Report and US 1099 Supplier Exceptions Report and fix the exceptions.

Key Resources

• For details about electronic filing, refer to IRS Publication 1220.

Modifications to Employee Bank Account Creation

Some data fields are no longer required for creating bank accounts for employees in France, Italy, Ireland, Portugal, and Spain. As IBAN contains the required details, these fields have either been removed or made optional when CE_USE_EXISTING_BANK_BRANCH profile option is No.

This table describes the fields that were removed or made optional in each applicable country:

Country	Fields removed from UI	Fields converted as Optional
France	Bank Name, Branch Name	Bank Number, Branch Number
Italy	Bank Name	Bank Number, Branch Number
Ireland	Bank Name, Branch Name, Branch Number
Spain	Bank Name	Branch Number
Portugal		Bank Number, Branch Number

NOTE: If you set the CE_USE_EXISTING_BANK_BRANCH profile option as Yes, the bank and branch numbers become mandatory fields. This is irrespective of the country UI rules.

Removal of non-essential fields from the user interface lets users create the bank account with minimal information. This improves the overall user experience by reducing the time taken to create a bank account.

Steps to Enable

You don't need to do anything to enable this feature.

Performance Improvements in Manage Invoices Page

The Manage Invoices page search function includes a date range parameter for Supplier Name and Number or Party Name searches.

The date range parameter provides more focused supplier and party searches.

Steps to Enable

You don't need to do anything to enable this feature.

Role Information

No additional role is required.

Supplier Invoice Import with Remittance Bank Account Details

Specify remittance bank account details when creating supplier invoices using the Import Payables Invoices process. This reduces the need to update the default remittance bank account on the imported invoice with the correct one.

You can provide a supplier remittance account and IBAN account using the Remit-to Bank Account Number and Supplier IBAN attributes available through the FBDI and ADFdi spreadsheets and REST services.

The Payables Invoice REST service supports the Remit-to Bank Account Number and Supplier IBAN attributes in POST and GET modes.

If a supplier has multiple remittance bank accounts, you can use these attributes to assign a specific bank account to each supplier invoice, instead of populating every invoice with the default bank account configured in the supplier setup.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

1. To assign the supplier remittance bank account on the invoice you can provide values either in Remit-to Bank Account Number or Supplier IBAN. Payables will continue to assign default bank account from the supplier setup, if available, when you do not provide a value in either of these attributes.
2. When invoices are created through FBDI spreadsheet you can enter #NULL value in either of the two attributes or both of them to avoid Payables assign the default bank account from the supplier setup. However the invoice will be rejected, if you assign #NULL for one attribute and non null value for the other attribute.

Role Information

Users need not require additional security to access this feature. Create Payables Invoice privilege which provides access to create invoices is sufficient to work work on this feature.

Supplier Search Using Tax Registration Number During Supplier Invoice Creation

An additional search parameter has been added in the supplier search, to search and select suppliers based on the tax registration number. You can search for suppliers using this new parameter when creating, editing or managing supplier invoices.

Tax Registration Number - Search parameter

The tax registration number is a unique identifier for each supplier and helps to distinguish between similarly named suppliers. The tax registration number can also identify suppliers where invoices are centrally processed and contain information in non-local languages.

Steps to Enable

You don't need to do anything to enable this feature.

Payments

Inclusion of Transaction Tax Amount in Payment File Extract

Capture transaction tax payment amount separately in the standard payment file extract, to meet country-specific legal requirements, for example in Poland. Transaction tax amounts are credited to a separate bank account maintained by the supplier.

The total transaction tax amount of all invoices in a payment can be calculated and reported in the payment file. In some countries, such as Poland, it is a legal requirement to report the total tax amount separately. This is a generic solution that anyone can use in any country to report the tax amount separately.

Steps to Enable

To enable this feature, you must create the following lookup code with value as ‘Y’.

Lookup type – ORA_IBY_FETCH_TRX_TAX_DETAILS

Meaning – Fetch Transaction Tax Details

Description – Fetch transaction tax details in the ledger currency in standard XML extract of the payment file.

Tips And Considerations

The payment file XML extract includes transaction tax amount tags. To generate the total tax amount, you must update the BI Publisher template

Retrieval of Funds Capture Acknowledgment Files Using a Wildcard

Retrieve multiple funds capture acknowledgment files using the Universal Content Management Reader Protocol with wildcard. Enter a wildcard in the file name parameter to download multiple files at once without having to specify each file name.

You can retrieve funds capture acknowledgment files from your bank using either static file names, dynamic file names with asterisks, or both. Contact your bank to check if they support dynamic file names.

Create a transmission configuration using the Universal Content Management Reader Protocol. Then, on the Create Transmission Configuration page, enter an asterisk (*) as a wildcard character in the Value field for the Remote File Name parameter. This lets you retrieve multiple acknowledgment files from your bank in a single attempt. For example, consider these two file names:

• pay_ack_01012019.xml
• pay_ack_02012019.xml

To retrieve both the files in one attempt, enter pay_ack*.xml in the Value field of the Remote File Name parameter on the Create Transmission Configuration page.

The capability to retrieve files using a wildcard reduces the manual effort of downloading files individually. You can retrieve multiple funds capture acknowledgment files and bank statements (that match the wildcard pattern) at once, instead of individually retrieving each file.

Prior to this update, only the SFTP protocol was supported for downloading funds capture acknowledgment files. Support for Universal Content Management Reader (UCM) protocol improves your integration capability with banks using this protocol.

Steps to Enable

You don't need to do anything to enable this feature.

Receivables

Balance Forward Billing in Advance of the Billing Cycle End Date

Generate balance forward bills earlier than regularly scheduled billing cycle dates. Use this flexibility in managing your balance forward billing activity impacted by holidays and unscheduled interruptions.

Select the ‘Print draft future balance forward bills’ option from the Generate Bill parameter of the Create Balance Forward Bills process.

Create Balance Forward Bills

Use this option to:

• Automatically generate draft balance forward bills for the next available billing cycle date that is later than or equal to the system date. The Create Balance Forward Bills process identifies and generates the bill according to the next available billing cycle end date. The process maintains the billing cycle due dates of the balance forward billing payment terms assigned to the customer profile.

• Generate draft future balance forward bills at the customer account or site level.

• Include prior outstanding unbilled and future-dated transactions up to the next available billing cycle end date.  

• Avoid unexpected billing errors by previewing a draft balance forward bill prior to confirming and sending the bill to the customer. This helps ensure that the bill reflects the expected current and future-dated transactions.

• Provide additional control by requiring future draft bills to be confirmed using the Execute the Confirm Balance Forward Bills process prior to sending the bills to the customers.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

When the ‘Print draft future date balance forward bills’ option is selected:

• Any date entered in the billing date parameter is ignored
  • Balance forward bill is generated for the next available billing cycle end date later than the system date.
  • A message is passed to the Create Balance Forward Bills processing log stating that the date entered in the Billing Date parameter was ignored.

• If a printed balance forward bill already exists for the next balance forward billing cycle end date that is later than the system date, the Create Balance Forward Bills process generates the balance forward bill for the next available billing cycle end date.

• Any balance forward billing eligible transactions created with a transaction date prior to the printed balance forward bill, will be included in the next balance forward bill.

Role Information

You do not need a new role access to use this feature.

Cash Pooling for Receivables Multifund Accounting

Record the multifund accounting entries on cash receipts to represent a cash pooling model. Cash pooling in multifund accounting provides efficient management of cash flows by notionally combining the debit and credit positions of various bank accounts into a pooled account.

Cash pooling for multifund accounting provides the flexibility to represent cash pool accounting in either of two different methods, depending on an organization's fund management requirements and the organization's local accounting conventions. The two methods are:

• Method-1: Receipt fund representation as a direct split of cash account entries as per the source transaction allocation (i.e. Invoice or Miscellaneous receipt).

• Method-2: Receipt fund representation as off-setting treasurer's equity and cash owed to the affiliate.

To implement Method-1, you enable the Pooled Account option in the Cash Management Controls tab for the bank account assigned to the receipt. To implement Method-2, do not enable the Cash Management Pooled Account option on the bank account; instead, configure the Treasurer's Equity and Cash to Affiliates accounts as intercompany balancing accounts.

Example

Steps to Enable

Use the Opt In UI to enable this feature. For instructions, refer to the Optional Uptake of New Features section of this document.

Offering: Financials  No Longer Optional From: Update 21C

1. To implement Method-1, navigate to the Cash Management Controls tabbed section of the Bank Account Setup, and under Payables and Receivables Controls enable the Pooled Account option.

(Navigation: Setup and Maintenance > Manage Bank Accounts)

2. To implement Method-2, do not enable the Pooled Account option. Instead, navigate to the Manage Intercompany Balancing Rules page and map the Equity Pool and Treasurer's Equity accounts to Intercompany Balancing Rules.

(Navigation: Setup and Maintenance > Manage Intercompany Balancing Rules)

NOTE: Create additional Intercompany Balancing and Clearing Options to complete the Intercompany balancing configuration if more than one balancing segment is used (Navigation: Setup and Maintenance > Manage Additional Intercompany Balancing and Clearing Options). 

3. After implementing Method-1 or Method-2, navigate to the Manage Standard Lookups page and create the lookup code AR_CASHPOOLING under the lookup type AR_FEATURES.

(Navigation: Setup and Maintenance > Manage Standard Lookups)

Tips And Considerations

• Fund representation described according to Method-1 (as indicated above) is available with the Multifund Accounting base feature. No separate uptake steps are required to use Method-1. You only need to implement this feature either for Method-2 cash pooling representation or a combination of Method-1 and Method-2 on different bank accounts.

• Cash Pool accounting is an add-on feature to Multifund Accounting. You must ensure completion of the base setup for Multifund Accounting before configuring Cash Pool accounting. Refer to the key resources section for more information on implementing Multifund Accounting in Receivables.

• The lookup for 'AR_CASHPOOLING' is a product opt-in.  Create this lookup after completing all the other steps, including the enabling of Opt-in on Functional Setup Manager.

• The 'Pooled Cash' option on a bank account is commonly used by Payables and Receivables products to drive the required fund representation.  Analyze the impact on both the products before deciding on the pooling method to be used for the funds received or expensed through that bank account.

• The cash account in Method-2 is expected to use a balancing segment value representing the treasurer's pool.  Configure it accordingly in the Remittance Bank Accounts region of the Receipt Method.

• Cash pool accounting is represented on a cash account with account class 'Cleared Cash'.  Other off-set cash accounts reflecting an interim status of a receipt like 'Confirmed Cash', 'Remitted Cash' do not use the cash pooling model.

• In the case of miscellaneous receipts, the distribution split becomes the basis for cash pooling representation.

Key Resources

• Detailed Receivables Distributions

Role Information

You do not need a new role access to use this feature.

Open Receivables Search Enhancements for Manual Receipt Application

Use improved search and select attributes in the Add Open Receivables window in the Edit Receipt page to select customer transactions for manual receipt application. The receipt customer is now populated by default when you open the window. Additional columns in the search results table for customer bill-to site, transaction receipt method, and transaction date help improve decision-making in selecting transactions for receipt application. Transaction installments marked as internal are excluded by default from the search results, but you can include them by enabling the Include Internal Transactions Excluded from Collections option.

Users have additional tools for searching and selecting transactions for manual receipt application. Populating the receipt customer saves time, and the additional search attributes improve the precision of transaction searches.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

You have the option to replace the default receipt customer details with another customer. 

Oracle Channel Revenue Management Integration with Oracle Receivables for Claim Creation and Settlement for Lockbox Receipts

Initiate claims in Channel Revenue Management from lockbox receipts when Receivables customers make invoice-related and non-invoice related underpayments and overpayments. Accelerate claim processing to quickly settle underpayments and overpayments, including processing all settlement-related financial transactions.

The feature provides the following functionality for creation of invoice-related and non-invoice related underpayments and overpayments:

• Ability for the customer reason and customer reference to be optionally provided for each of the remit references provided in the Record 6 - Payment and Record 4 - Overflow Payment of the Receivables Standard Receipt Import of the lockbox process as below:
  • Newly added columns Customer Reason 1 to Customer Reason 8 : Stores the customer reason for deductions and overpayments to Transaction Reference 1 to Transaction Reference 8.
  • Existing columns Customer Reference 1 to Customer Reference 8: Stores the customer reference for deductions and overpayments to Transaction Reference 1 to Transaction Reference 8.

• Enhancements to the existing predefined setups to control how Lockbox creates claims:
  • Manage Receipt Application Exception Rules to create invoice-related Channel Revenue Claim.
  • Manage AutoCash Rule Set and Remainder Rule Set to create non-invoice related Claim Investigation.
  • Post Receipt with Invalid Transaction Reference as Unapplied parameter of Process Receipts Through Lockbox process has a new value called 'Yes with Claim' to process invalid remittances with applied remittance amount to be created as non-invoice related Claim Investigation.

• Enhancements to the existing Process Receipts Through Lockbox process to create Channel Revenue Claim for invoice-related underpayments and overpayments for the following:
  • Matched Remittances with applied amount that either over or underpays the transaction’s outstanding balance.
  • Manage Receipt Application Exception Rules is set to have exception rules, where the action is set to Transaction Claim.
  • Channel Revenue Claim will take the business unit and currency of the invoice and the outstanding amount due on the invoice as the claim amount.

• Enhancements to the existing Process Receipts Through Lockbox process to create Claim Investigation for non-invoice related overpayment for the following:
  • Remaining unapplied amount on the receipt post applications.
  • Remainder Rule Set has the Remaining Remittance Amount set to Claim Investigation.
  • Claim investigation overpayment claim will take the business unit and currency of the receipt and the remaining unapplied amount on the receipt post applications as the claim amount.
  • The claim investigation activity defined at the lockbox receipt method's remittance bank account is used as the default activity for the claim investigation application to the imported receipt.

• Enhancements to the existing Process Receipts Through Lockbox process to create Claim Investigation for the following:
  • Invalid remit references provided along with remittance applied amount to the lockbox data file for import.
  • Process Receipts Through Lockbox process has been submitted with the ESS parameter for Post Receipt with Invalid Transaction Reference as Unapplied as Yes with Claim.
  • The claim investigation activity defined at the lockbox receipt method’s remittance bank account is used as the default activity for the claim investigation application to the imported receipt.

• Below are the other considerations to this feature:
  • Details of the claim created by the Lockbox process can be viewed in the Application and Activity tab under Receipt Details of the Edit Receipt page.
  • All Match By values supported by lockbox will be supported for the Channel Revenue Management Integration as long as the underlying transaction class is an invoice.
  • Remittance references with recommendations for receipt application are not supported under automatic claim creation. Users can manually create the claim in the Edit Receipt page.
  • The functionality related to the resolution and settlement of lockbox-created claims in Channel Revenue Management is the same as for claims created using the Edit Receipt page.

Business benefits include:

• Automatic claim creation via the Lockbox process.
• Reduce revenue leakage from invalid deductions.
• Fast and accurate cash processing capability with accountability.
• Complete deductions settlement solution with automated integration between Channel Revenue Management and Receivables

Steps to Enable

Use the Opt In UI to enable this feature. For instructions, refer to the Optional Uptake of New Features section of this document.

Offering: Order Management

1. You must opt in to the functional area named: Channel Revenue Management.  Then opt in to the feature named: Deductions and Settlement.
2. Under the offering named: Financials and functional area named: Receivables, go to a task named: Manage Receivables System Options.  Search for and select your business unit.  Click the 'Cash Processing' tab.  Select the 'Enable channel revenue management integration' check box, and click Save.
3. Under the offering named: Financials and functional area named: Receivables, go to a task named: Manage Lockboxes. Search for and select your lockbox. You must enable the ‘Create claims’ check box, and save.
4. Under the offering named: Financials and functional area named: Receivables, go to a task named: Manage Receipt Classes and Methods. Search for and select your receipt class and receipt method. Click on Remittance Bank Accounts. Search for and edit your remittance bank account to select the ‘Claim Investigation’ activity.
5. Under the offering named: Financials and functional area named: Receivables, go to a task named: Manage Receipt Application Exception Rules. Search for and select your Receipt Application Exception Rules. Create or extend exception rules with condition whose action is ‘Transaction Claim’ to automatically create Channel Revenue Claim for invoice-related underpayments and overpayments.
6. Under the offering named: Financials and functional area named: Receivables, go to a task named: Manage AutoCash Rule Sets. Search for and select your AutoCash Rule Set. Create or extend the Remaining Remittance Amount to be set as ‘Claim Investigation’ to automatically create Claim Investigation for non-invoice related underpayments and overpayments.
7. Under the offering named: Financials and functional area named: Receivables, go to a task named: Manage Receivables System Options. Search for and select your business unit. Click the 'Cash Processing' tab. Set the Receipt Application Exception Rule Set and AutoCash Rule Set.
8. Set the Reminder Rule Set along with the optional setup of the Application Exception Rule Set and AutoCash Rule Set at the customer account and/or site profile.

The following setups are predefined for this feature:

• Predefined Channel Revenue Management transaction source to assign to Receivables credit memos and invoices created upon settlement of a claim.

• Predefined Claim Investigation activity type under Receivables Activities. Edit this predefined activity type to include the business unit and the valid GL Code Combination Flexfield.

• Predefined Subledger Journal Entry Rule for the Event Class Receipt and Accounting Class Claim Investigation.

• Refer to the Channel Revenue Management's Deductions and Overpayments feature documentation for the Channel Revenue Management related setups.

Tips And Considerations

• Manage Receipt Application Exception Rules should not have exception rules with overlapping or duplicate conditions.

• User review required of Manage Receipt Application Exception Rules is not supported for Channel Revenue Management Integration scenarios and hence should not be enabled for rules, which have Transaction Claim as an action.

Key Resources

• For more information on Channel Revenue Management, refer to the Oracle Cloud Readiness content for Order Management.
• For more information on the Create Claims for Deductions and Overpayments feature, click here.

Role Information

No additional role is required.

Oracle Channel Revenue Management Integration with Oracle Receivables for Invoice-Related Claim Creation and Settlement

Initiate claims in Channel Revenue Management using the Edit Receipt page when Receivables customers make invoice-related underpayments and overpayments. Accelerate claim processing to quickly settle underpayments and overpayments, including processing all settlement-related financial transactions.

The feature provides the following functionality for creation of invoice-related channel revenue claims:

• Initiate a channel revenue claim for invoice-related underpayments or overpayments on an invoice application to a receipt by creating a channel revenue claim against the invoice using the Edit Receipt page.

• To initiate a channel revenue claim, select Create Channel Revenue Claim from the Actions menu to open the Create Channel Revenue Claim window for an invoice application line.

• Complete the fields in the Create Channel Revenue Claim window, then click OK and save the receipt:
  • Transaction Business Unit: The field is populated by default with the business unit of the invoice.
  • Claim Amount: The field is populated by default with the amount outstanding on the invoice. This amount cannot be edited.
  • Application Reference Reason: Select from the reference reasons configured in Channel Revenue Management for a claim.
  • Customer Reason: Enter the customer reason for the claim.
  • Customer Reference: Enter any additional reference information related to the claim.

• A channel revenue claim on an invoice application against a receipt automatically creates a deduction or overpayment claim in Oracle Channel Revenue Management.

• The claim number is displayed as the Application Reference Number in the Application tab of the Receipt Details section of the Edit Receipt page.

• The details of the Channel Revenue Management deduction or overpayment claim are displayed in the Activity tab of the Receipt Details section of the Edit Receipt page.

• Invoice-related claims take the currency and business unit of the invoice.

• The dispute amount is updated in Receivables against the invoice for the claim amount, which is also the amount outstanding on the invoice.

• Only invoice applications to the receipt are eligible for invoice-based channel revenue claim.

The feature provides the following functionality for resolving the invoice-related channel revenue claim from Channel Revenue Management:

• After investigation on a claim is completed and validated, the claim will be settled in Oracle Channel Revenue Management.

• The user chooses to settle the claim for the entire or partial claim amount using one or more of the settlement documents to resolve the channel revenue claim underpayment or overpayment of the invoice application on the receipt.

• Deductions can be settled using the following settlement methods:
  • Credit Memo - On Account as a settlement method creates on-account credit memo in Receivables.
  • Credit Memo - On Invoice as a settlement method creates standard credit memo crediting the invoice in Receivables.
  • Open Credit Memo method uses existing unapplied on-account credit memo to apply to the receipt.
  • Open Overpayment method selects existing open overpayment claims to which this claim can be netted.

• Automatic Write-off creates adjustments to the invoice if any remaining amount on the claim after taxes is below the write-off threshold.

• Overpayments can be settled by creating invoices against the claim or by applying to existing deductions.

The feature provides the following functionality on settlement of a resolved invoice-related channel revenue claim from Channel Revenue Management:

• The Settle Customer Claims process settles the claims for a business unit.

• The process performs the following:
  • Creates the Receivables credit memo or invoice as per the settlement method chosen on resolution of the claim.
  • During credit memo or invoice creation, Receivables calculates taxes according to the Oracle Tax setup on the amount passed from Channel Revenue Management as the settlement amount of the claim.
  • If the claim was settled with a settlement method other than Credit Memo - On Invoice, the following are performed:
    • Unapplies the invoice application on the receipt and reapplies the invoice application on the receipt for the original application amount plus the amount settled.
    • Applies the Receivables transaction created as the settlement document to the receipt.
  • The dispute on the invoice is removed to the extent of the settlement amount.

• If this is only a partial settlement, a child claim is created for the open claim amount. The claim investigation continues in Channel Revenue Management.

Business benefits include:

• Complete deductions settlement solution with automated integration between Channel Revenue Management and Receivables.
• Reduce revenue leakage from invalid deductions.
• Fast and accurate cash processing capability with accountability.
• Flexibility to process multiple settlement-related financial transactions.

Steps to Enable

Use the Opt In UI to enable this feature. For instructions, refer to the Optional Uptake of New Features section of this document.

Offering: Order Management

1. You must opt in to the functional area named: Channel Revenue Management.  Then opt in to the feature named: Deductions and Settlement.
2. Under the offering named: Financials and functional area named: Receivables, go to a task named: Manage Receivables System Options.  Search for and select your business unit.  Click the 'Cash Processing' tab.  Select the 'Enable channel revenue management integration' check box, and click Save.

The following setups are predefined for this feature:

• Predefined Channel Revenue Management transaction source to assign to Receivables credit memos and invoices created upon settlement of a claim.
• Refer to the Channel Revenue Management's Deductions and Overpayments feature documentation for the Channel Revenue Management related setups.

Tips And Considerations

Transaction types assigned to the original invoices applied to receipts that have invoice-related claim against them must have the Allow Overapplication option enabled.

Key Resources

• For more information on Channel Revenue Management, refer to the Oracle Cloud Readiness content for Order Management.

• For more information on Channel Revenue Management, refer to the features:
  • Create Claims for Deductions and Overpayments Originating from an Invoice
  • Settle Claims for Deductions and Overpayments Originating from an Invoice

• Watch Invoice Deduction and Overpayment, Lockbox, Manual Claim, Write-offs Readiness Training.

Role Information

No additional role is required.

Receivables Customer Account Activities REST API

View the activities on a customer account using the Receivables Customer Account Activities REST API. Review the open receivable balances, transactions due, credits pending application, and the account activity history.

You can use the Receivables Customer Account Activities REST API to build tools and external user interfaces related to customer account activity information according to your business requirements.

Steps to Enable

Review the REST service definition in the REST API guides, available from the Oracle Help Center > your apps service area of interest > REST API. If you're new to Oracle's REST services you may want to begin with the Quick Start section.

This feature is automatically opted in through the release update.

Tips And Considerations

The purpose and usage of this REST API is similar to the Receivables Customer Account Site Activities REST API.  Refer to the Use Cases section in the Oracle Help Center for more details.

Role Information

You don't need a new role or privilege to use this feature.

Subledger Accounting

Multiple Supporting Reference Selection Using a Simplified User Interface

Assign supporting references across journal line rules at the same time.

Use the new Assignments tab on the Manage Supporting References page to create new supporting reference assignments, view existing assignments, and delete assignments.

Use the Assignments tab on the Manage Supporting References page to select supporting references and journal line rules for assignment.

Complete and save the assignment for all relevant journal line rules.

You can also use the Assignments tab to delete existing supporting reference assignments across different journal entry rule sets.

The simplification of supporting reference management lets implementers review supporting reference assignments across subledger applications, add new assignments, and delete existing assignments from the same page.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

• This feature is for managing supporting reference assignments for user-defined journal entry rule sets only.

• The page can only display up to 1000 assignments. Use additional criteria in the Search section to narrow down your search results especially when you need to add or delete assignments.

Revenue Management

Contract Freeze Override for Revenue Accounting Contracts

Override the freeze date of open contracts in bulk within a single request. You can update the freeze date to either the current date or a future date.

The freeze date is the date on which a revenue accounting contract is assumed to have all the performance obligations included and is ready for transaction price determination.  The freeze date on a contract defaults from the contract identification rule from which the contract was created..  The number of freeze days is defined in the contract identification rules. The transaction price is determined and the contract is allocated only after the contract is frozen. The contract is processed where the transaction price is determined and contract is allocated only if the freeze date is on or before the current date.

The search results of Manage Customer Contracts page lets you select records individually or or select / deselect all records. This region also has a checkbox in the header using which the Revenue Manager can either select all the records or deselect all the records of the search results region.

UPDATE THE FREEZE DATE OF CONTRACTS IN BULK

Prior to this feature, to freeze a contract earlier than the freeze date or to update the freeze date to a future date, you could update the freeze date only through the Edit Customer Contract page one contract at a time.  You could update the freeze date with current date so that the contract is frozen and processed to determine the transaction price and transaction price is allocated among the performance obligations.  You can also update the freeze date to any future date depending on when you are expecting all the performance obligations into Revenue Management.

To update the freeze date of contracts in bulk, complete these steps:

1. Navigate to the Manage Customer Contracts page.
2. Query the contracts that are pending allocation and that have the allocation pending reason Awaiting Contract Freeze.  You an further refine the search results using the various search criteria available in the Manage Customer Contracts page.
3. Use the Select All check box and individual check boxes to select the contracts you want.
4. In the Actions menu, select Freeze.
5. The Freeze Contracts window appears.
6. Select the date with which you want to update the freeze date of the selected contracts
   • Select current date to freeze the selected contracts immediately and process them further to determine the transaction price, allocate the transaction price across the performance obligations, recognize revenue and perform accounting.
   • Select future date to update the freeze date to a future date.  The selected contracts will be frozen on the chosen future date.
7. You can see the statistics of the contracts selected, the contracts that are eligible for update of freeze date, and the contracts that are not eligible for update of freeze date.
8. Click on Ok to continue with the update of freeze date.

OTHER ACTIONS ON THE MANAGE CUSTOMER CONTRACT PAGE

You can perform the other actions on the Manage Customer Contracts page—Mark as Reviewed, Hold, Exempt, View Contract Activities—by enabling the Select All check box and individual check boxes instead of the keyboard strokes. The actions Mark as Reviewed, Hold and Exempt will give the statistics of the total number of contracts selected, number of contracts eligible for the action, number of contracts not eligible for the action along with the reasons for being not eligible.

• With this feature, you can now update the freeze date of open contracts of up to 1000 contracts in a single request.

• You can freeze open contracts in bulk and process them during period end processing where huge number of contracts are closed prior to the contract freeze date.

• This feature provides you efficient and quick way of freezing the contracts in a single request

Steps to Enable

You don't need to do anything to enable this feature.

Transactional Business Intelligence for Financials

Enhancements to Payables Invoices Transactions Real Time Subject Area

Report on Complex Work Purchase Order in the Oracle Transactional Business Intelligence subject area Payables Invoices - Transactions Real Time. The subject area is enhanced with the following new attributes in the existing folders:

• Within Invoice Details folder: 
  • General Information subfolder:
    • Net of Retainage Account checkbox
  • Invoice Amounts subfolder:
    • Release Amount Net of Tax  

• Within Invoice Lines folder:
  • Invoice Line Details - Purchase Order Information subfolder:
    • Retained Invoice Number
    • Retained Invoice Line
  • Invoice Line Amounts subfolder:
    • Invoice Line Retained Amount
    • Invoice Line Retained Amount Remaining  

• Within Distributions folder:
  • Invoice Distribution Details - Purchase Order Information subfolder :
    • Related Retainage Distribution
    • Retained Invoice Distribution
  • Invoice Distributions subfolder:
    • Distribution Retained Amount Remaining

The subject area is enhanced with the new attributes in the existing folders to report on Complex Work Purchase Order in the Oracle Transactional Business Intelligence subject area Payables Invoices - Transactions Real Time.

Steps to Enable

Leverage new subject area(s) by adding to existing reports or using in new reports. For details about creating and editing reports, see the Creating and Administering Analytics and Reports book (available from the Oracle Help Center > your apps service area of interest > Books > Administration).

The features are already enabled. User needs to drag the columns to the OTBI report from the above mentioned folders.

Role Information

You don't need any new role or privilege to set up and use this feature.

Regional and Country-Specific Features

Financials for the Americas

Alphanumeric Prefix for Transaction Numbering in Receivables

Include alphanumeric prefixes in Receivables transaction numbers to comply with legal requirements related to invoice numbering in countries including Colombia, Ecuador and El Salvador.

The required format for transaction numbers varies by country. In some countries the format is numbers only, while in other countries it is a combination of letters and numbers. Some countries also require a prefix or suffix in addition to the actual transaction number. You can configure Receivables transaction numbering to accommodate these country-specific requirements by using the localization document numbering feature. You can add one or more of the following attributes:

• Prefix
• Suffix
• Minimum Digits
• Separator

NOTE:  This feature is currently available for use in the following countries: Colombia, Ecuador, El Salvador.

Steps to Enable

To use the localization document numbering feature for Receivables transaction numbering, you first need to enable the regional localization and then set up the localization system options for the applicable country and business units. Once these setups are completed, you can set up the localization document numbering using the Create Document Numbering spreadsheet.

ENABLE REGIONAL LOCALIZATION 

1. Click Navigator > Others > Setup and Maintenance work area.
2. On the Setup page, select Financials offering then click Change Feature Opt In.
3. On the Opt In page, search Financials then click the Features icon in the Features column.
4. On the Edit Features page, search for Regional Localization and select the checkbox in the Enable column.
5. Select the country for which you want to enable localization document numbering.
6. Click Save and Close.

ENABLE LOCALIZATION SYSTEM OPTIONS 

Perform these steps to enable the localization system options for the relevant business unit:

1. Click Navigator > Others > Setup and Maintenance work area > Tasks > Search > Manage Localization System Options.
2. On the Manage Localization System Options page, click the Create icon to add the business unit where you want to implement the localization document numbering.
3. On the Create Localization System Options page, select the business unit then select the country to show the following options:
   • Enable Document Numbering - This enables configuration of the Receivables transaction numbering format using the Create Document Numbering spreadsheet. Set this option as Yes.
   • Enforce Document Numbering - This enables the system to validate that the localization document sequence has been assigned to a transaction type to ensure that the Receivables transaction number is in the desired format. If you set this option as Yes, you will not be able to create a Receivables transaction using a transaction type that has not been assigned a localization document sequence. This is an optional configuration.
4. Click Save and Close.

SET UP LOCALIZATION DOCUMENT NUMBERING

Set up the localization document numbering for the relevant business unit to define the applicable attributes to the Receivables transaction number. You must create document sequence categories and document sequences before defining the Receivables transaction numbering format in Create Document Numbering spreadsheet.

To create Document Sequence Categories and Document Sequences:

1. Create a standalone document sequence category to assign to the Receivables document sequence name for the localization document numbering setup. This standalone document sequence category must not be associated to any transaction type. This step is required to make the Receivables document sequence name available in the Create Document Numbering spreadsheet and to ensure gapless sequence numbers if the Accounting and Document Sequencing feature is enabled.
   • Click Navigator > Others > Setup and Maintenance > Tasks > Search > Manage Document Sequence Categories.
   • On the Manage Document Sequence Categories page, click the New icon to define the document sequence category.
   • Ensure that the following columns are set as:
     • Application - Receivables
     • Module – Receivables
     • Table - RA_CUSTOMER_TRX_ALL
   • Click Save and Close.

2. Create the Receivables document sequence that you will use in the Create Document Numbering spreadsheet.
   • Click Navigator > Others > Setup and Maintenance > Tasks > Search > Manage Receivables Document Sequences.
   • On the Manage Receivables Document Sequences page, click the New icon to define the document sequence.
     • Select Gapless as the sequencing mode.
     • Enter the first number of the sequence on the Initial Value field. If you don't provide an initial value, the default initial value that will be used is 1.
   • Assign the document sequence to the document sequence category from step #1.
   • On the Assignment section, add the document sequence category.
   • Click Save.

To set up the Receivables transaction number format:

1. Download the Create Document Numbering spreadsheet to set up the Receivables transaction number format.
   • Click Navigator > Others > Setup and Maintenance > Tasks > Search > Manage Localization Document Numbering.
   • On the Search For field of the Manage Fiscal Document Sequences, select the country for which you must set up the localization document numbering.
   • On the Create Document Numbering in Spreadsheet window, select the business unit then click OK to download the spreadsheet (DocumentNumberingTemplate.xlsx).
2. Define the Receivables transaction number format.
   • Open the spreadsheet, DocumentNumberingTemplate.xlsx, and log in to the application.
   • In the Create Document Numbering spreadsheet, enter the required information and click Upload to save the changes.

NOTE: The localization document numbering setup must be within 20 characters, which is the maximum limit for the Receivables transaction number.

COLUMN	DETAILS
Transaction Type	Enter the transaction type. The transaction type must not have an active Receivables document sequence assignment. You can also create a new transaction type for this setup. This is required information.
Sequence Name	Enter the Receivables document sequence name to be used on the transaction type. This is required information.
Prefix	Enter the alphanumeric characters to be added before the sequence number.
Suffix	Enter the alphanumeric characters to be added after the sequence number.
Minimum Digits	Enter the minimum digits required  for the sequence number without a prefix or suffix.
Separator	Enter the character to separate each attribute of the Receivables transaction number.
Start Date	Enter the effective start date of the localization document numbering setup. This is required information.
End Date	Enter the effective end date of the localization document numbering setup.

Create Document Numbering Spreadsheet

Tips And Considerations

• The localization document numbering setup must be unique for each combination of transaction type, document sequence, and date range.

• When creating a Receivables transaction, the transaction date cannot be earlier than the date of the last transaction that was numbered.

• Do not update an existing localization document numbering setup once you generate Receivable transaction numbers using the setup. Updating an existing localization document numbering setup after generating Receivables transaction number can cause inconsistencies in your transaction numbering.

• If you have enabled Accounting and Document Sequencing in Specify Ledger Options, you must follow these setups to ensure gapless sequencing:
  • The transaction type that you use in the localization document numbering setup must not be assigned to any active Receivables document sequences.
  • The document sequence that you use in the localization document numbering setup must not have an assigned transaction type. It must only have an assigned standalone document sequence category (document sequence category not associated to a transaction type).

Key Resources

• Related Help: Localization Document Numbering for Receivables Topical Essay in My Oracle Support.

Financials for Asia/Pacific

Invoice Reference Numbers (IRN) Generated by India GST E-Invoicing System to Allow Input Tax Credit

Record the Invoice Reference Numbers (IRN) generated by the India GST E-Invoicing system on Receivables and Inventory Cloud transactions. Transmit transaction data to the invoicing system using any of the available modes. Recipients of the sales transaction invoices can claim input tax credit based on the IRN reported in the sales return.

Organizations, registered under GST regime, having turnover more than one hundred crores rupees, are required to register their invoice details electronically at Invoice Registration Portal (IRP) for reporting of Business to Business (B2B) and Business to Government (B2G) supplies to GST System and get Invoice Reference Number (IRN), along with QR code and digital signature on real time basis which need to be incorporated in the tax invoice for supply of goods or services. An invoice issued by a supplier without IRN and QR Code that is generated/validated by the IRP will be considered as null and void.

ERP Cloud provides the enabling capabilities required for integration with IRP for generation of IRN. The partners will need to leverage the data extracted by an Outbound process to communicate with IRP for IRN generation and will need to push back to ERP through an Inbound process.

The feature enables you to:

• Run/Schedule the Einvoice Outbound ESS job which will extract bulk data eligible for Einvoicing from Shipping (Inventory) and Receivables modules, as per the GSTN prescribed data points, based on the Einvoice schema specifications and will upload into UCM folder.

• Associate the Partners (GSPs) who have direct access to IRP portals and platform to invoke the IRP API for IRN generation. The Partners will pull the Einvoice outbound file from UCM folder, split the file per invoice and invoke the IRP Rest API for IRN generation.

• Consume the IRP Response (IRN, QR Code, Error details etc.) in ERP through the Einvoice Inbound webservice. Once IRN and QR code details are received by partners, they will produce a CSV file in Oracle prescribed format and invoke the Inbound process to send back the IRN and QR code to ERP.

• Access IRN and QR code within ERP Cloud captured against the Tax invoices based on the Einvoice inbound process; can be used for QR code printing in the Tax invoice document.

• The Einvoice data extraction conforms to the latest Einvoice schema specifications published by CBIC.

• The Einvoice bulk data extract can be leveraged by the Partners for IRP API invocation for one invoice at a time to generate IRN and QR code as well as it can be massaged further to be used for Bulk upload utility directly in IRP portal.

• Eway Bill data will be extracted if provided, at shipment, along with Einvoice payload, for successful Eway Bill generation with IRN.

• The Einvoice outbound process will self-analyze the eligibility of transactions for Einvoice based on the one time configurations done in ERP.

• Einvoice inbound process also captures other attributes of IRP response in ERP, along with IRN and QR code like acknowledgement number and date, Eway Bill details etc.

• The feature is capable of handling any Error, if notified by IRP portal upon invoking API for IRN generation.

Steps to Enable

• To enable this feature, associate the Taxes defined in the Setup and Maintenance work area into India Taxes Types so that these taxes are segregated from the Non GST taxes and relevant information against each tax type can be extracted while filing the monthly GST reports.

1. Application Implementation Consultant. role/privilege is required to do the setup.
2. In the Setup and Maintenance work area, go to the Manage Taxes task:

               Offering:  Financials Functional area:  Transaction Tax:  Manage Taxes

3. Search for the required Transaction tax.
4. Go to Tax Reporting Codes and Click on Add Row.
5. Enter any of the following values to classify the Tax.

   Tax Reporting Type Code	Data Type	Tax Reporting Code	Description	Effective Start Date	Effective End Date
   ORA_IN_TRANS_TAX_TYPE	Text	IGST	Integrated goods and services tax	7/1/2017
   ORA_IN_TRANS_TAX_TYPE	Text	CGST	Central goods and services tax	7/1/2017
   ORA_IN_TRANS_TAX_TYPE	Text	SGST	State goods and services tax	7/1/2017
   ORA_IN_TRANS_TAX_TYPE	Text	CESS	Tax on tax levied by the government for a specific purpose	7/1/2017
   ORA_IN_TRANS_TAX_TYPE	Text	UTGST	Union Territory Goods and Services Tax	7/1/2017

6. Click Save and Close.

To enable this feature:

• Enable Tax Reporting Type setup against the LRU in Party Tax Profile setup for eligibility of the E-invoice for the India GST Registration

1. Application Implementation Consultant. role/privilege is required to do the setup.
2. In the Setup and Maintenance work area, go to the Manage Party Tax Profile task:

                Offering:  Financials Functional area:  Transaction Tax:  Manage Party Tax Profile

3. Search for the required "Legal Reporting Unit Tax Profiles".
4. Go to Tax Reporting Codes and Click on Add Row.
5. Enter the following value to enable E-invoice eligibility for the GST Registration 

   Tax Reporting Type Code	Data Type	Tax Reporting Code	Description	Effective Start Date	Effective End Date
   ORA_JA_IN_EINV_REGN_TYPE	Yes or no indicator	Y	Yes	7/1/2017

6. Click Save and Close.

PROCESS STEPS:

• E-Invoice Outbound Process

1. Tax Manager role/privilege is required to run the Process.
2. In the Navigator work area, Go to Tools - Scheduled Processes - Schedule New Process.

3. Search for the Job: Record Inward and Outward Taxes for India. Run the Process. 

Parameters:

• Track the E-invoice extraction file in UCM folder

In the Navigator work area, Tools: File Import and Export: Search for Account: fin/tax/export 

• India Inbound Process:

The web service that can be used to automate the E-invoice Inbound process is the ERP Integration Service

Provides external operations for ERP integration scenarios to execute end-to-end inbound and outbound data flows. It also tracks the status of inbound and outbound data processes.

Life Cycle Status: Active

QName: {http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/}ErpIntegrationService

Service WSDL URL: https://(FADomain,FSCMServices)/fscmService/ErpIntegrationService?WSDL

Operation: importBulkData

JobName: /oracle/apps/ess/financials/apacLocalizations/financialReports,IndiaGSTInboundReport

ParameterList: EINVOICE

jobOptions: interfaceDetails=128

Tips And Considerations

The E-invoice process in ERP Cloud will work correctly if all of the below conditions are met:

1. India Tax Invoice feature is being deployed and used for generation of Tax invoices in Shipments and Receivables transactions.
2. To interface the IRP response to ERP, one needs to run both the Outbound and Inbound processes for the relevant Tax Invoices to be picked up for processing. Only running the Einvoice Inbound service to push the IRN details to ERP won't serve the purpose.
3. Associate the Taxes defined in the Functional Setup Manager into India Taxes Types (Tax Reporting Codes: ORA_IN_TRANS_TAX_TYPE).
4. Enable Reporting Type setup against the LRU in Party Tax Profile setup for eligibility of the E-invoice for the GST Registration.
5. Supplier Tax Invoice number and Date in ERP should exactly match with the Tax Invoice Number and Tax Invoice date of the inbound CSV file uploaded into the Einvoice inbound webservice for pushing the IRN details against the transactions in ERP.
6. The file format should be CSV which the ERP Integration web service for E-Invoice Inbound process accepts for interfacing the IRN details against the transactions in ERP.
7. IRN details are captured in ERP at line level GDF for Receivables invoices and in FDG screen for Ship and Bill flows. QR Code passed in Inbound CSV file is further captured in a database table: JG_TAX_INVOICE_REFERENCES. This table is a BIP enabled table and can be leveraged for Tax Invoice printing solution.
8. Cancellation of IRN is not supported out of the box in the E-invoice feature; however, the cancellation can be managed through workarounds.

Key Resources

• For an overview of REST APIs and the technical details, see the REST API for Oracle Financials Cloud guide in the Oracle Help Center. 
• Oracle® Applications Financials Implementation Guide, Release 13.

Role Information

You need the below Roles to use this India GST E-Invoice feature:

• Financial Application Administrator
• Application Implementation Consultant
• Tax Administrator

Financials for EMEA

E-Filing Extract for Payables Invoices for Italy

Extract Payables invoice data, such as intra-EU purchases, imports, self-issued invoices, and free supplies, for e-Filing to the tax authorities. This helps you comply with the new legal requirement for reporting supplier invoices in Italy.

From the 1st of January 2021, you must report certain Payables invoices to the Italian Tax Authority in the predefined e-Filing format.

These are the types of Payables invoices that you must submit to the Italian Tax Authority:

• Domestic purchases subject to reverse charge
• Intra-EU  purchases of goods
• Import of goods
• Purchases of services abroad
• Self-invoice
• Purchases of goods delivered from VAT Warehouse
• Self-invoice for exceeding the VAT limit amount for purchases without VAT
• Free supplies

To generate the e-Filing file, follow these steps:

1. Create a Payables invoice and select a Document Fiscal Classification code on the invoice header to mark specific types of Payables invoices that must be extracted.
2. Create accounting for this invoice.
3. Submit the Electronic Payables Invoice Extract process. Automatically, Electronic Payables Invoice E-Filing child processes are submitted and e-Filing files are generated. The files are generated as one file per invoice or one file per supplier, depending on the program parameter. The submitted Electronic Payables Invoice Extract process generates an InvoiceEFiling.zip file. This zip file contains all the generated files from the child processes.  
4. You can review the generated InvoiceEFiling.zip file in the Electronic Payables Invoice Extract process log file
5. The generated file contains all the mandatory and conditionally mandatory tags that are reported in the blocks:

• File header information (FatturaElettronicaHeader)
• Invoice detail information (FatturaElettronicaBody)

This feature helps you to comply with the new legal requirement for reporting supplier invoices in Italy.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

• When you enter Payables transactions, you must define the Document Fiscal Classification code on the invoice header. If this standard invoice header field is not updatable, you can define the document fiscal classification in the Document Type global descriptive field.

• The e-Filing file is generated only for accounted Payables invoices with the Document Fiscal Classification code entered on the invoice header. The Types of Invoices Included for E-Filing, which is a standard lookup, contains all invoice types for which e-Filing file will be generated.

• To see if an e-Filing file was generated, you can check the E-Filing Invoice Status and E-Filing Transmission Number global descriptive fields on the invoice header. All invoices with generated files will be in status Submitted.

• If the Italian Tax Authority rejects the file, you can update manually the submission status to On hold. After correcting the invoice data, you can change the status from On hold to Ready and a new file for this invoice will be generated.

Key Resources

• Related Help:  E-Filing Extract for Payables Invoices for Italy Topical Essay

Role Information

To use this feature, you need this existing privilege:

• Privilege Name and Code:
  • Create Turnover Reporting for Italy privilege (JE_CREATE_TURNOVER_REPORTING_FOR_ITALY_PRIV).

SAF-T Audit File in XML Format for Norway

Generate the SAF-T data extract in the specific XML format used in Norway to comply with the legal requirement. This extract includes accounting, customer, supplier, and tax information.

The output files include all the mandatory elements indicated by the Norway Tax Authority and also the optional ones if you entered them in the application. Depending on the volume of data extracted, the output may be more than a single XML file. All output XML files are automatically compressed as a Norway_SAFT_Audit_files.zip file, for your convenience. The zip file is attached to the initial process request, Generate SAF-T Data Extract.

The child processes created for the additional XML files are called Generate Standard Audit File. The XML files in the zipped output are named with the Request ID of the corresponding child process.

The SAF-T audit file in XML format for Norway feature allows you to comply with the legal requirements in Norway.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

The SAF-T Audit File in XML Format for Norway is based on the Generate SAF-T Data Extract.  These two lookups are used to process the Generic Extract for Norway.

• ORA_JG_SAFT_FORMAT lookup: This is a predefined lookup that contains the values Norway and Generic values as options for the Format Type parameter. When you select the value as Norway for Format Type parameter, the Extract Type parameter is set to Accounting Journals, the Selection Date Type is set to Accounting Date, and the Asset Book parameter is ignored because the report for Norway is based on GL Journals only.

• ORA_JG_GL_SEGMENTS lookup: You need to set this lookup during the implementation phase to identify which Chart of Accounts' segments will be shown in the Analysis section of the master files and the GL Journals. In the lookup code, you must enter the Short Prompt of the segment you want to be depicted in the Analysis section as the lookup code value. Then you enter the Structure-code of the Chart of Accounts structure in the tag value for each segment selected.

An Example of the ORA_JG_GL_SEGMENTS Lookup for 2 Segments of the Accounting Flexfield

Role Information

The Generate SAFT Data Extract is automatically available after completing the Generate SAFT Extract security setup.

To use this feature, you need this privilege:

• Privilege name and Code:
  •  Generic SAFT (GENERATE_SAFT_DATA_EXTRACT_PRIV).

IMPORTANT Actions and Considerations

TRANSITION TO REPORTING WEB STUDIO

Reporting Web Studio is a web-based report authoring solution that has a similar look and feel to the current Windows-based Financial Reporting Studio. Reporting Web Studio has been available to General Ledger users since Update 20A. Beginning with Update 21B, Windows Financial Reporting Studio will no longer be available for use.

You should transition to using Reporting Web Studio for all of your General Ledger financial reports as soon as possible.  All reports created with Windows-based Financial Reporting Studio are compatible with Reporting Web Studio.

For information about Reporting Web Studio, refer to the Overview of Reporting Web Studio topic in the Implementing Enterprise Structures and General Ledger guide