Reference Data Set overview in Fusion Applications

This training article will helps to understand all about Reference Data Sets in oracle Fusion Application along with important definitions.

Reference Data set is a new concept available in Oracle Fusion Application and are logical groups which provides the enterprise to decide which business unit access the reference data groups, such as grades, locations, Tax Classification codes,  AR & AP payment terms, departments, and jobs. 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.

Below are the tasks involved to define Common Application Configuration under defining Enterprise structure for Reference Data Set-

1.    Define Reference Data Sharing

a.    Manage Reference Data Sets

b.    Manage Set Assignments for Set Determinant Type

Main advantage of using Reference Data Sharing is to helps 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.

Reference data sharing helps to:

• Create reference sets across tables or lookup types.

• Share information and data processing options among the determinant types, such as business unit or asset book.

• Create separate sets and subsets for each business unit depending upon its business requirement.

• Create common sets or subsets to enable sharing reference data between several business units, without the need for duplicating the reference data.

Define Reference Data Sharing

Manage Reference Data Sets: We can use this page to create the Set Code, Set Name, and Description that can then be assigned to reference data.

Search for Reference Data Sharing in Set --> Got to Task

Click on Create button to define new Reference Data Set-

 Enter Set code in upper case & set name with brief description & click on Save 

Manage Set Assignments for Set Determinant Type:

Assign the reference data sets to reference objects. For multiple assignments, we can classify different types of reference data sets into groups and assign them to reference entity objects. The assignment takes into consideration the determinant type, determinant, and reference group.

Naigate to Manage set Assignments for set Determinant type

Click on Goto Task-

Manage Reference Data Partitions

Define reference data and divide the data into partitions called reference data sets. Assign the reference data sets based on business needs across organizational entities. Oracle Fusion Applications contain two predefined sets: Common and Enterprise. We can create more reference data sets based on your business and data sharing requirements.

Common: Used globally across the organization as a common set.

Shared:Used by a few business units, that work with similar data and therefore share the sets.

Enterprise specific:Unique to that business unit and not shared by any other business unit within that organization. Add the Enterprise Set to the Receivables Payment Term,Prepayment, defined by line of business and used only by that line of business irrespective of the country or region where it operates.

Determinant and Determinant Types

We can share the partitioned reference data based on a business context setting called the determinant type. It is the point of reference used in the data assignment process. The available determinant types used in the reference data assignment are:

Asset Book: A book that records information about assets including their acquisition, depreciation, and retirement. An Asset Book is tied to a ledger.

Business Unit: A department or organization within an enterprise.

Cost Organization: An organization used for cost accounting and reporting on various inventory and cost centers within an enterprise.

Project Unit: A logical organization within an enterprise that is responsible for enforcing consistent project management practices.

Determinant -

A determinant is the value that qualifies the selected determinant type. For example, when managing set assignments for the set determinant type, if we select Business Unit as the determinant type, then we would provide the name of the Business Unit as the corresponding determinant.

Reference Data Set Assignments

We can assign reference data to the relevant reference data sets depending upon the required level of sharing the data. If we want to share it across the organization, we can assign it to the predefined Common set. Other types of reference data may be specific to certain business units. Therefore, we would restrict the use of that data to those business units. In that case, we can create sets specifically for this type of data, and assign the sets to the business units.

Add comment