Single Source of Truth Example for Rank Display Method

This example shows how the Single Source of Truth setup for some party profile attributes affect the functionality in Oracle applications. Some of these attributes are primary attributes that belong to attribute groups, but the example treats the primary attributes as if on their own. For an example of attribute group setup, see: Attribute Groups Example for Rank Display Method.

Display Rules

For the Organization Profile entity, you set up display rules with the Rank method for the attributes shown in this table. This table also shows the available records for a specific party and the values that populate the Single Source of Truth record based on the setup.

Attribute Data Source Ranking User-Entered Value D&B Value SST Value
Organization Name 1. D&B
2. User Entered 		Company A Company A Company A
Year Established 1. D&B
2. User Entered 		1992 1990 1990
CEO Name 1. D&B
2. User Entered 		Joe Lee <Not Available> Joe Lee
Total Employees 1. User Entered
2. D&B 		<Not Available> 100 100
SIC Code 1. User Entered
2. D&B 		2520 2521 2520
User Overwrite Rule

This table shows a user overwrite rule for the five attributes.

Attribute Source Systems That Users Can Overwrite
Organization Name <None.>
Year Established D&B.
CEO Name D&B.
Total Employees <None. The rule cannot be defined because D&B is not ranked higher than User Entered.>
SIC Code <None. The rule cannot be defined because D&B is not ranked higher than User Entered.>
User Enters Data

This table describes what happens when a user, who is assigned the above user overwrite rule, tries to enter data. The table shows the SST values from above, the data sources of each value, the highest ranked data sources, as well as the new user-entered values and the new SST values, whether the user updated them or not.

Attribute Highest Ranked Data Source Current SST Data Source Current SST Value New User Entered Value New SST Value
Organization Name D&B D&B Company A Company B Company A
Year Established D&B D&B 1990 1992 1992
CEO Name D&B User Entered Joe Lee Joey Lee Joey Lee
Total Employees User Entered D&B 100 1000 1000
SIC Code User Entered User Entered 2520 2522 2522

The user overwrite rule applies only to attribute values that have D&B as the current SST and highest ranked data source. This table describes which attributes the rule applies to.

Attribute Rule Definition Rule Is Applied Description
Organization Name Prevent Overwrite Yes The user overwrite rule prevents the user-entered value from overwriting the highest ranked D&B value in SST record.
Year Established Allow Overwrite of D&B Yes The user overwrite rule allows the user-entered value to overwrite the highest ranked D&B value.
CEO Name Allow Overwrite of D&B No The current SST data source is already user entered, and data still does not exist for the highest ranked D&B source, so the user can modify the user-entered record and accordingly update the SST record, regardless of the user overwrite rule.
Total Employees Prevent Overwrite No, D&B is not ranked higher than User Entered, so the rule is not defined Even though the current SST value is from D&B, the user can overwrite it because user entered is the highest ranked source.
SIC Code Allow Overwrite of D&B No, D&B is not ranked higher than User Entered, so the rule is not defined The current SST data source is already user entered, and the highest ranked source is user entered, so the user can definitely update the SST value.
Source System Overwrite Rule

This table shows the source system overwrite rule for the five attributes.

Attribute Source Systems That Can Overwrite User-Entered Data
Organization Name <None>
Year Established D&B
CEO Name <None>
Total Employees <None. The rule cannot be defined because D&B is not ranked higher than User Entered.>
SIC Code <None. The rule cannot be defined because D&B is not ranked higher than User Entered.>
New D&B Data is Acquired

This table shows what happens when D&B data is subsequently acquired. The table shows the SST values from above, the data sources of each value, the previous data sources, the highest ranked data sources, as well as the new D&B values and the new SST values, whether D&B updated them or not.

Attribute Highest Ranked Data Source Previous Data Source Current SST Data Source Current SST Value New D&B Value New SST Value
Organization Name D&B D&B D&B Company A Company AA Company AA
Year Established D&B D&B User Entered 1992 1991 1991
CEO Name D&B User Entered User Entered Joey Lee Joseph Lee Joseph Lee
Total Employees User Entered D&B User Entered 1000 2000 1000
SIC Code User Entered User Entered User Entered 2522 2520 2522

The third party overwrite rule applies only to attributes that have a current user-entered value that previously overwrote a highest ranked D&B value. This table describes which attributes the rule applies to.

Attribute Rule Definition Rule Applies Description
Organization Name Prevent Overwrite No The SST record always had a D&B value, which is highest ranked, so the new D&B value updates the SST record.
Year Established Allow D&B to Overwrite Yes The current user-entered value previously overwrote a highest ranked D&B value in the SST record. The rule allows the new D&B value to overwrite the user-entered value.
CEO Name Prevent Overwrite No Even though the current SST value is user entered and the highest ranked source is D&B, the current SST value did not previously overwrite a D&B value. The new D&B value can overwrite the user-entered value because D&B is the highest ranked source.
Total Employees Prevent Overwrite No, D&B is not ranked higher than User Entered, so the rule is not defined Even though the current SST value is user entered and previously overwrote a D&B value, D&B is not the highest ranked source. The new D&B value cannot overwrite the user-entered value because the highest ranked source is user entered.
SIC Code Prevent Overwrite D&B is not ranked higher than User Entered, so the rule is not defined The SST record always had a user-entered value, which is highest ranked, so the new D&B value cannot update the SST record.