Monday, July 24, 2023

Reference Data Sets in Fusion

Reference Data set is a new concept available in Oracle Fusion Application and Reference Data Sets allow sharing and partitioning of data elements For eg: Payables Payment Terms. Oracle fusion provides a default Reference Data set which can be used across all Business units. However, we can define our own Reference data sets.

Main advantage of using Reference Data Sharing is to help organizations share common transactional data without unnecessary duplication.

For example, if organization has several business units and each business unit uses different payment terms on a customer invoice. Instead of each business unit creating and maintaining individual payment terms, one can define the payment terms reference data at the organization level and use that data into partitions (create reference data sets) so that the different payment terms can be assigned to each business unit.

Note: There are two default RDS that Oracle provides i.e COMMON and ENTERPRISE

How to create a new RDS?

N: Task: Manage Reference Data Sets à Click on it à Go to Task
Click + to create

Set Code

Set Name

Description

CP_US_BU_Set

CP US BU Set

CP US BU Set

Save and Close.

Saturday, July 22, 2023

What is ADFDI and how to install it?

ADFDI- Application Development Framework Desktop Integrator

ADFDI is an excel based tool which is used to manage a large volume of data from cloud applications by using an Excel Spreadsheet.  

Required Role: Employee

If you don't see "Download Desktop Integration Installer" option under Tools, assign Employee role.

Please follow below steps to install Desktop Integrator Tool

Step1: Download ADFDI Installer

First we need to download this into our machine

N:NavigatoràTools à Download Desktop Integration Installer

Once downloaded Install it. Right click ->Run as administrator -> Install -> once installed click Close


Download it.


Right click, run as administrator. Install it

Step2: Check Add In in excel

Excel Options


Go to Excel options → Add-Ins → Select “COM Add-ins” from drop down list and click on “Go”


Verify whether “Oracle ADF 11g Desktop Integration Add-in for Excel” is enabled or not. If it’s not enabled, then enable it.


Ok

Step3: Update Trust Centre Settings


Trust Center ->Trust Center Settings ->



Macro Settings -> Enable two options as shown above.

OK

That is it. Close excel and try to use ADFDI spreadsheets, it should work.


JS

RC