Found 412 results.

Oracle ERP Cloud – 22A Update

Oracle ERP Cloud introduced a new feature! In the recent upgrade 22A, Oracle ERP cloud users can create, edit and delete Cross-validation rules with FBDI.

  • Blog
  • Oracle ERP Cloud – 22A Update
Oracle-ERP-Cloud-22A-Update

Oracle ERP Cloud – 22A Update

Oracle ERP Cloud enhances and introduces new features with each update. In the recent upgrade 22A, Oracle ERP cloud users can create, edit and delete Cross validation rules with FBDI.

FILE-BASED DATA IMPORT is an efficient way to import data for Financials and PPM from external sources. FBDI can be used to manage cross-validation rules from external sources. The template can be downloaded from either the File-Based Data Import (FBDI) for Financials guide or the application.

 

To access the template from the FBDI guide:

  • In http://docs.oracle.com, search for File-Based Data Import (FBDI) for Financials Cloud guide.
  • In the table of contents, click General Ledger.
  • Select Cross-Validation Rules Import.
  • In the File Links section, click the link to the Excel template.

 

TEST_CODE chart of accounts is taken as an example.

oracle-erp-cloud-22a-update-2

 

TEST_CODE COA

To access the template from the application:

  • Navigate to Setup and Maintenance work area,
  • Search for Manage Cross-Validation Rules
  • On the Manage Cross-Validation Rules page, search for your chart of accounts.
  • In the Actions menu, click Download Rules.

oracle-erp-cloud-22a-update-3

 

Manage Cross Validation Rules

Cross Validation Rules

  • Navigate to the Manage Cross Validation Rules page
  • Select Actions -> Upload Rules to upload the cross-validation rules from the prepared spreadsheet file to the interface tables.

oracle-erp-cloud-22a-update-4

 

  • Choose a file
  • Navigate to the Manage Cross Validation Rules page and select Actions >
  • Download Unprocessed Rules to view the cross-validation rules which are yet to be processed.
  • Navigate to the Manage Cross Validation Rules page and select Actions -> Manage Rules.
  • Select Validation type -Cross-validation rules,

Action: Import

Mode: Increment (when we upload delta or incremental cross-validation rules)

Replace (when we completely replace the existing cross-validation rules with all new cross-validation rules.)

oracle-erp-cloud-22a-update-5

  • Manage Rules
  • Submit the flow.
  • Download the cross-validation rules
  • Select Actions > Download Rules.

In the Cross-Validation rules window Enter the cross-validation rules to be downloaded in the Name field. Name field can be left blank to download all the rules for a given chart of accounts. Use the Starts with, Ends with, and Contains operators to select a range of cross-validation rules

 

Business Benefits

  • Records can be uploaded in bulk to create, update, and delete cross-validation rules.
  • To bring cross-validation rules into General Ledger with external integration using REST services
  • The user can experience with an integrated Actions in the UI for file upload, file download, and process submission.

 

Points to Consider:

  • The existing cross-validation can be updated or deleted using rules by downloading the rules from the UI.
  • File should be in the FBDI format, where you can view all the rules and select the update or delete action to update the rules.
  • If there are any validation errors for even a single cross-validation rules, none of the Chart of Accounts will be processed.
  • Manage Cross-Validation Rule Violations process can be submitted from Navigation: Actions -> Manage Rules and selecting the Review Violations action.
  • Replace mode enables you to replace the rules in the application from external data source systems

 

Pre-requisite:

  • Either of the following roles to access Cross Validation rules:
  • Application Implementation Consultant
  • Financial Application Administrator

 

Author
Manojkrishnan Kumaraswamy
Oracle ERP Cloud Consultant

Oracle ERP Cloud Partner

Simplify Processes, Improve Productivity, Gain Agility, and Increase ROI with the future-proof and AI-driven Oracle ERP Cloud.

Read More

Categories