Customer has a number of suppliers sites with the communication method set to None. They would like to report on supplier sites with communication method set to NONE so that they can update the method to email.

"Update Supplier Keyword Search Index and Source to Settle Counts Runs In every 30 Minutes and Errors and it is not generating any error log. Any pointers about this program how to troubleshoot this program. Also I see below note relevant to this program

There is a requirement where we need to enable the Cloud Audit tables related to Suppliers and Banks

Content:

As per the requirement, I did checked in many ways but unable to see the supplier, bank related audit tables. Please provide the list of tables and steps to enable them accordingly. This is for Oracle Cloud.

Request Parameters:
Following table explains each of the query parameters which can be used in the request payload. These correspond to the actual search criteria available on the audit reports page.

Query Parameter

Data Type

Description

attributeDetailMode

boolean

Indicates whether the old and new attribute values are returned. If true, the old and new values are retrieved. If false, the response contains only attribute names, and not old and new values. The default value is false.

On the audit reports UI this corresponds to ‘Show Attribute Details’ check box.

businessObjectType

String

The fully qualified view object name. In this case it will be "oracle.apps.prc.poz.suppliers.protectedModel.

The date from which the audit history is to be retrieved. The format of the date can be yyyy-MM-dd or yyyy-MM-dd HH:mm:ss. You can retrieve audit history for up to one month.

toDate

String

The date up to which the audit report data is to be retrieved. The format of the date can be yyyy-MM-dd or yyyy-MM-dd HH:mm:ss.

includeChildObjects

boolean

Indicates whether to include the child objects in the audit report. The default value is false. The child objects for Supplier will be address, contact, sites, business classifications, product and services, bank accounts.

includeImpersonator

boolean

Indicates whether to include the impersonator name in the audit report. The default value is false.

product

String

A predefined product value provided in the request. It will be ‘Procurement’ in this context.

user

String

The display name of the user who has created or updated the supplier.

includeAttributes

boolean

Indicates whether the audit report includes attribute details that were changed in the specified time period. The default value is true. On the audit reports UI this corresponds to ‘Show Attribute Details’ check box.

includeExtendedObjectIdentiferColumns

boolean

Indicates whether to include the context information for the business objects. The default value is false. This corresponds to ‘Show additional object identifier columns’ checkbox in the Audit Reports UI

timeZone

String

The timezone to be used for the specified period of the audit report.

pageSize

number

The number of records displayed in a page, in the audit report.

pageNumber

number

The page number in the audit report you want to view.

Sample request payload to retrieve all the supplier records which was inserted, updated or deleted in the given date range.

Is it possible to place a supplier on payment hold when any changes to nominated fileds have been made. These might be bank account details, payee name, payment method etc.

If a hold is not possible can we utilise the audit facilities to perhaps drive mesaging to manage this. Perhapos by using API's thought ICS to set a hold flag on the supplier after a trigger from teh audit table?

Supplier Audit History allows tracking and reporting of changes made to supplier profile information to support internal audit controls and governance as well as external regulatory compliance such as SOX.

Here are some tips that will allow you to set up this feature correctly and leverage everything it has to offer:

Ensure attributes that need to be audited have been enabled for audit tracking using the Manage Audit Policies task as shown in the screenshot below. Changes to an attribute will be tracked only if it is enabled for audit. Refer to the steps listed below explaining how attributes can be enabled for audit.

Ensure that the business object to be audited is selected in addition to its individual attributes.

Payments information i.e. Payment Methods, Bank Accounts and Payment Attributes can be specified for a supplier, its addresses and sites. Corresponding attributes can be enabled for audit using one of the three business objects available: Supplier Payment Methods, Supplier Bank Accounts and Supplier Payment Attributes. Enabling an attribute that belongs to these business objects will track changes made to the attribute at all three levels: supplier, address and site.

Changes made to audit setup are prospective and not retrospective. Consequently, for an attribute which has not been previously enabled for audit, any changes made to it prior to enabling it for audit will not be tracked. To optimize performance only enable attributes that need to be tracked.

Following steps will guide you to setup audit tracking on the list of supplier profile attributes:

Access the Setup and Maintenance workarea and look for the Manage Audit Policies task.

On the Mange Audit Policies page, set the Audit Level as Auditing and take the Configure Business Object Attributes action.

On the Configure Business Object Attributes page, select Procurement as the product.

Select the appropriate object in the Objects tree table. This corresponds to the object to which the attribute you want audited belongs. For example, if you want to track changes to Alternate Name of a supplier, you should select the Supplier object. Likewise if you want to audit the Address Name, you should select the Supplier Addresses object.

After selecting the object, take the Create action available under the Audited Attributes section on the right. A list of attributes that can be tracked using audit will be made available to you.

Select the attributes that need to be audited. This will allow any changes made to these attributes to be tracked and reported.

Take the Save the Close action.

Refer to the following for more details on what the Supplier Audit feature offers: