Procurementpublic

Supplier Management

Get Involved. Join the Conversation.

This is a public Forum  public

Posts

  • Joe Marino
    Supplier Audit History Report10
    Topic posted January 15, 2019 by Joe Marino, tagged Audit 
    Title:
    Supplier Audit History Report
    Summary:
    Require bank account changes
    Content:

    Hi

    Does anyone have or know an audit report that details bank account changes by supplier?

    Version:
    Fusion
  • Soumya Parhi
    How to track Supplier Logins , that are through the supplier...Answered105.0
    Topic posted August 8, 2018 by Soumya ParhiGold Trophy: 10,000+ Points, tagged Audit, Fusion, Security, Supplier User Account, Tip 
    Title:
    How to track Supplier Logins , that are through the supplier portal ?
    Summary:
    Supplier Portal Login Audit
    Content:

    Good People,

    How to track the supplier logins form supplier portals ?

    Thanks,

    Soumya

    Document:
    How to Generate Fusion Application User Login Audit Report Using BI Publisher # 2190558.1.pdf (1001KB)
    Document:
    Instructions.pdf (1001KB)
    Document:
    Security_Reports.xdrz (12KB)
    Document:
    User_Login_Audit_Report.pdf (2KB)
  • Madhu G
    Need Audit tables list in Oracle cloud8
    Topic posted June 17, 2019 by Madhu GRed Ribbon: 250+ Points, tagged Approvals/Notifications, Audit, Financials, Fusion, Payables, Security, Setup, Supplier Creation, Supplier Profile Management, Supplier Registration, White Paper 
    Title:
    Need Audit tables list in Oracle cloud
    Summary:
    Enabled Audit feature for Supplier header and supplier sites
    Content:

    Hi,

    Need help in Audit tables list for Oracle cloud, as per the requirement we enabled the audit feature for supplier model for few columns like Supplier name, Supplier site, IBAN etc.

     

    We need to see in which table these history will be saved, I am unable to get the Audit table names, Please help.

  • Aishwarya Pawar
    Enabling Supplier Audit HistoryAnswered75.0
    Topic posted February 22, 2018 by Aishwarya PawarGold Medal: 3,500+ Points, tagged Audit, How-To, Tip 
    Title:
    Enabling Supplier Audit History
    Summary:
    Tips for enabling Supplier Audit History
    Content:

    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.

    image2018-2-20%2016%3A0%3A19.png?version=1&modificationDate=1519171219000&api=v2

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

    1. Access the Setup and Maintenance workarea and look for the Manage Audit Policies task.
    2. On the Mange Audit Policies page, set the Audit Level as Auditing and take the Configure Business Object Attributes action.
    3. On the Configure Business Object Attributes page, select Procurement as the product.
    4. 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.
    5. 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.
    6. Select the attributes that need to be audited. This will allow any changes made to these attributes to be tracked and reported.
    7. Take the Save the Close action.

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

     

  • Ramesh Radhakrishnan
    "Update Supplier Keyword Search Index and Source to...6
    Topic posted June 9, 2019 by Ramesh RadhakrishnanBlack Diamond: 60,000+ Points, tagged Audit, Business Intelligence, FAQ, How-To, Sourcing Programs, Supplier Creation, Tip 
    Title:
    "Update Supplier Keyword Search Index and Source to Settle Counts Runs In every 30 Minutes and Errors
    Content:

    "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

    "Update Supplier Keyword Search Index and Source to Settle Counts Runs In every 30 Minutes (Doc ID 2474423.1)
    Version:
    R13-19B
  • Mohammad Alhindawi
    Approval cycle for the suppliers master data creation6
    Topic posted March 11, 2019 by Mohammad AlhindawiRed Ribbon: 250+ Points, tagged Approvals/Notifications, Audit, Business Intelligence, Create Requisition, Customization, FAQ, Financials, Fusion, How-To, Import, Orders, Payables, Public Sector, Requisition Processing, Security, Setup, Sourcing Programs, Supplier Communication, Supplier Creation, Supplier Merge, Supplier Profile Management, Supplier Registration, Supplier User Account, Tip, Web Services, White Paper 
    Title:
    Approval cycle for the suppliers master data creation
    Summary:
    Approval cycle for the suppliers master data creation
    Content:

    Is there an approval cycle for the suppliers master data creation in the app?

    Version:
    Oracle Fusion Procurement Cloud
  • Shivani Roy
    How to Get Supplier Audit History Using REST API45.0
    Topic posted December 26, 2018 by Shivani RoyBronze Medal: 1,250+ Points, tagged Audit, How-To, Web Services 
    Title:
    How to Get Supplier Audit History Using REST API
    Summary:
    Oracle Applications Cloud provide public REST APIs you can use to support integration requirements for the common features like roles, users, user requests etc. One of them is the audit report resourc
    Content:

    How to get audit report using the REST API

    REST Service Name: Get Audit Report

    • Rest method: POST

              The user will have to use the REST POST method to post a request to retrieve audit reports response.

    • Path:
      The request path to be added in REST should be in the below format.

               https://<hostname>:<port>/fscmRestApi/fndAuditRESTService/audittrail/getaudithistory

    • Content Type: application/json

               The content type of request and response is in the json format

    • 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.

    core.view.AuditSupplierVO"

    eventType

    String

    A comma-separated list of events you want to search. Valid values are : Object Data Insert, Object Data Update, Object Data Delete, All

    fromDate

    String

    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.

                {

                   "fromDate":"2018-10-15 00:00:00",

                   "toDate":"2018-10-15 23:59:59",

                   "product":"procurement",

                  "businessObjectType":"oracle.apps.prc.poz.suppliers.protectedModel.core.view.AuditSupplierVO",  

                  "includeChildObjects":"true",

                   "includeAttributes":"true",

                   "eventType":"All",

                   "attributeDetailMode":"true",

                   "timeZone":"UTC"

                   }

    • Response Parameters:
      Following table explains each of the response properties returned as part of the REST response. These correspond to the actual attributes in the audit search results table.

    Response property

    Data Type

    Title

    Description

    actionName

    string

    Action Name

    The request method name for which the response is retrieved. Since we are retrieving audit history it will be ‘getAuditHistory’

    auditData

    array

    Audit Data

    The audit data retrieved for the specified criteria. This section contains results similar to the ones fetched in audit reports.

    status

    string

    Status

    The status of the audit report. The valid values are 200-success, 400-Bad request, 401-Authentication error, 403-Authorization error, and 500-Internal server error.

    pageSize

    string

    Page Size

    The number of records displayed per page in the audit report.

    pageNumber

    string

    Page Number

    The number of records displayed per page in the audit report.

    Sample response payload with audit report results for Supplier: Automotive Supplier.

    Updates were made to attributes: Federal reportable and TaxVerificationDate.
    {
        "auditData": [
            {
                "date": "2018-10-15 12:29:00",
                "descriptionInternal": "Supplier:949",
                "userInternalName": "CVBUYER01",
                "attributeDetails": [
                    {
                        "oldValueId": "N",
                        "newValueId": "Y",
                        "attribute": "Federal reportable",
                        "attributeInternalName": "FederalReportableFlag",
                        "newValue": "Yes",
                        "oldValue": "No"
                    },
                    {
                        "attribute": "Verification Date",
                        "attributeInternalName": "TaxVerificationDate",
                        "newValue": "2018-08-02"
                    },
                ],
                "businessObject": "Supplier",
                "qualifiedBusinessObject":
                "oracle.apps.prc.poz.suppliers.protectedModel.core.view.AuditSupplierVO",
                "userName": "Clare Furey",
                "eventType": "Object Data Update",
                "description": "Supplier:Automotive Supplier"
            }
        ],
        "pageSize": "1",
        "status": "SUCCESS",
        "actionName": "getAuditHistory"
    }

     

    You can refer the following document for further details: Common Features in Oracle Applications Cloud R13

  • Hamish Gifford-Moore
    Approve supplier bank account changes4
    Topic posted March 27, 2018 by Hamish Gifford-MooreRed Ribbon: 250+ Points, tagged Approvals/Notifications, Audit, Security, Setup, Supplier Creation, Supplier Profile Management, Supplier Registration, Supplier User Account 
    Title:
    Approve supplier bank account changes
    Summary:
    Approve supplier bank account changes
    Content:

    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?

    Any ideas welcome

    We are on R12 but moving to R13.

  • Sivaraj Shanmugham
    Scheduling Supplier Audit report3
    Topic posted October 21, 2019 by Sivaraj ShanmughamRed Ribbon: 250+ Points, tagged Audit, Supplier Creation, Supplier Profile Management 
    Title:
    Scheduling Supplier Audit report
    Summary:
    Looking for an automated way to send the Supplier Audit report to Finance
    Content:

    Currently users are running the audit report from Tools menu. Team is asking if there is a way to schedule this report to run on a weekly basis and deliver the report output to one or more users. 

    Thanks, Siva

     

  • MerriH
    Supplier Site Report3
    Topic posted September 2, 2019 by MerriHRed Ribbon: 250+ Points, tagged Audit, Financials, Fusion, How-To, Supplier Communication 
    Title:
    Supplier Site Report
    Summary:
    Is there a report/query available for Supplier Sites
    Content:

    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.  

    Is this available?

    Version:
    19B (11.13.19.04.0

Filter by Tag

Change View

Sort

community forum