Removing Spend Classification Integration Metadata

If you are not implementing Oracle Spend Classification, Oracle recommends that you remove or hide the Oracle Spend Classification integration metadata that is included in the Presentation layer of the BI repository. Hiding or deleting this metadata avoids potential confusion among business end users.

To remove or hide Oracle Spend Classification Integration Metadata:

1. In Oracle BI EE Administration Tool, edit the BI metadata repository (for example, OracleBIAnalyticsApps.rpd).

   Deployed RPD files are located in ORACLE_HOME\bifoundation\OracleBIServerComponent\coreapplication_obis<n>\repository.

2. In the Presentation layer pane, expand the folder 'Procurement and Spend - Invoice Lines'.

   The Oracle Spend Classification metadata in the Physical layer consists of the following objects:

   • Data Classification

   • Auto UNSPSC

   • Auto Purchasing Category

   • Auto Custom Category 1

3. To remove the metadata objects listed above, right-click on the objects and select Delete.

   If you decide later to implement Oracle Spend Classification, in the Business Model and Mapping layer, drag and drop the following dimensions from a copy of the 'Procurement and Spend - Invoice Lines' folder into the Presentation layer in the BI metadata repository (that is, the RPD file):

   • Dim - Auto UNSPSC

   • Dim - Auto Purchasing Category

   • Dim - Auto Custom Category1

4. To hide the objects listed above from end users, right-click and select Properties, then Permissions, and clear the Read permission check box for the appropriate user or group.

   If you decide later to implement Oracle Spend Classification and display the following objects to end users, right-click and select Properties, then Permissions, and select the Read permission check box for the appropriate user or group:

   • Data Classification

   • Auto UNSPSC

   • Auto Purchasing Category

   • Auto Custom Category 1

5. Save and close the BI metadata repository (that is, the RPD file).