Supplier Management

Get Involved. Join the Conversation.

Posts

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

  • 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
  • Madhu G
    Need the list of Oracle cloud Audit tables for Suppliers and...1
    Topic posted May 2, 2019 by Madhu GRed Ribbon: 250+ Points, tagged Approvals/Notifications, Audit, Customization, FAQ, Financials, Fusion, Payables, Security, Setup, Supplier Communication, Supplier Creation, Supplier Merge, Supplier Profile Management, White Paper 
    Title:
    Need the list of Oracle cloud Audit tables for Suppliers and Banks
    Summary:
    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.

     

    Thanks,

    Madhu.

    Version:
    Oracle Cloud Application 19A (11.13.19.01.0)
  • 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
  • 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
  • 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

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