Auditing Custom Object Data
You can use Oracle Fusion Applications auditing features to configure auditing for user-defined business object attributes generated by your intake forms.
This topic describes how to:
Configure business object attribute auditing for specific transaction types.
Run an audit report for specific transaction types.
You use the Oracle Fusion Applications auditing features to set up auditing for Public Sector Licensing and Permitting business objects.
Transaction-Specific Auditing Scope
A specific transaction type, such as a permit or a planning application are the business objects you can audit. Each transaction type, such as a permit, contains a limited set of fields that you can audit, which include:
User-defined fields. These are the fields you added manually to your intake form.
Fields from the base view object for that transaction type. These fields are the same for all transaction types, and they appear in the attributes list regardless if they appear in the intake form or not.
The transaction types included for custom object auditing are:
Permits
Planning and Zoning
Business Licenses
You can audit other aspects of transaction data, such as changes to fee schedules and fee items, which is discussed in another topic. For more information, see Auditing Public Sector Licensing and Permitting Data.
To determine what fields in a specific transaction are able to be audited, you can use any REST client to submit a describe for that transaction type. For example, you can send a GET request using the following URL:
https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/LNPFENCEPERMIT_c/describe
Where FENCEPERMT is the name of the transaction type. LNP is prepended and _c is appended automatically by the Intake Form Designer.
The attributes appearing in the returned payload of the describe that can’t be audited appear within the FieldGroups section. For example:
“FieldGroups” : {
“discrColumnType” : false,
“title” : “Permit Details”,
“attributes” : [ {
...
Configuring Business Object Attribute Auditing for a Specific Transaction Type
To configure auditing for a specific transaction type:
Access Functional Setup Manager.
Open your licensed offering from the Setup list, such as Public Sector Permits or Public Sector Planning and Zoning.
Select the Application Extensions functional area, and click the Manage Audit Policies task.
Note: You can use the Search Tasks feature as well to navigate to the Manage Audit Policies task.On the Manage Audit Policies page, locate the Oracle Fusion Applications group box.
To enable auditing, set Audit Level to Auditing.
Click Configure Business Object Attributes.
On the Configure Business Object Attributes page, select Supply Chain Management Common Components from the Product drop-down list, and expand the FscmCustomReferenceAuditAM node.
Note: The Public Sector Compliance and Regulation offering resides in the Oracle Fusion Applications Financials and Supply Chain (FSCM) database. When searching for Public Sector Licensing and Permitting custom business objects, you will find them within the Supply Chain Management Common Components section. If you are also an Oracle FSCM customer, you will see FSCM business objects mixed with your Public Sector Licensing and Permitting products within the FscmCustomReferenceAuditAM node.Click the business object for which you want to configure auditing.
The business object name is the same as your transaction type code, such as the Permit Type value on the Permit Type page.
With the business object selected, select Actions > Create in the Attribute column on the right.
In the Select and Add Audit Attributes dialog box, select the attributes you want to audit.
Note: The attributes available are limited to the base view object values and the custom fields you have added to your form.Click OK.
Save your changes.
Running an Audit Report
To run an audit report:
-
Select
-
For Date, specify a date or date range for your audit report.
-
Select Supply Chain Management Common Components from the Product drop-down list.
-
From the Business Object Type drop-down list, select the permit type name for which you enabled auditing.
-
Use the Date, User, and Event Type criteria to refine your search, as needed.
-
Click Search.
For more information on Fusion Applications auditing, see Oracle Applications Cloud documentation for Implementing Applications, Audit Policies.