Supplier Management

Get Involved. Join the Conversation.

Comments

  • Elizabeth Hurley

    Hello,

    Is there more recent documentation on implementing this feature?  I only have Implementing Supplier Audit History 11.1.7.0.0 from July 2013.  I haven't been able to find anything else in online documentation.

     

    Also, two of the links in the original post are broken.  Could you please provide links to these docs?

    Thank you.

  • Joshua Martinez-Perez

    You should post this as an idea. We would definitely be interested in this.

  • Maarten van der Burg

    Hi Hong,

    We tried the OTBI way, but the most crucial part of information was missing: The bank account details / IBAN data.

    Ended up writing an SQL query. Posting it here for future reference. It pulls all requests pending approval:

    SELECT
     psv.VENDOR_NAME "Supplier Name"
    ,psav.PARTY_SITE_NAME "Supplier Address Name"
    ,iteba.IBAN "IBAN"
    ,cbbv.BANK_NAME "Bank Name"
    ,cbbv.BANK_BRANCH_NAME "Bank Branch Name"
    ,iteba.CURRENCY_CODE "Bank Account Currency"
    ,iteba.BANK_ACCOUNT_NAME "Bank Account Name"
    ,psr.CHANGE_REQ_NUMBER "Request Number"
    ,psr.LAST_UPDATED_BY "Last Updated By"
    ,psr.LAST_UPDATE_DATE "Last Update Date"
     
    FROM
    POZ_SUPP_REQUESTS psr,
    POZ_SUPP_BANK_ACCT_REQUESTS psbar,
    IBY_TEMP_EXT_BANK_ACCTS iteba,
    CE_BANK_BRANCHES_V cbbv,
    POZ_SUPPLIERS_V psv,
    POZ_SUPPLIER_ADDRESS_V psav
     
    WHERE
    1=1
    AND psr.SUPP_REQUEST_ID = psbar.SUPP_REQUEST_ID
    AND psbar.TEMP_EXT_BANK_ACCT_ID = iteba.TEMP_EXT_BANK_ACCT_ID
    AND iteba.BRANCH_ID = cbbv.BRANCH_PARTY_ID
    AND psr.VENDOR_ID = psv.VENDOR_ID
    AND psv.PARTY_ID = psav.PARTY_ID
     
    AND psr.REQUEST_STATUS_CODE = 'PENDING_APPROVAL'
    Kind regards,
    Maarten
  • Piyush Singh

    Hi Sivaraj,

    This is not a supported functionality.

    Thanks,

    Piyush

  • ALEXANDER JOSEPH

    Hi,

    Requirement is more from an integration perspective , client wanted to extract supplier details including tax code from Oracle purchasing and wanted a webservice to do that

    Thanks

    Alex

  • santhy Mohan

    Hi, 

     

    Are you specifically looking for webservice ? FBDI can be used to update Tax codes. did you validate that option?

     

    Thanks

    Santhy

  • s k

    Hi Faye,

    Please explain your experience in how you managed to do 1042-S Reporting.

    Thank you

  • Harshith Eshwar Shaila

    Hi Niamath,

    I had raised an SR for this and they provided the below query, hope it helps you as reference

    select a.po_header_id,a.segment1 as "PO NUMBER" ,a.creation_date,a.approved_date,a.closed_date,a.document_status,b.communicated_date,b.communicated_to_supplier
    from fusion.po_headers_all a, fusion.po_versions b
    where a.po_header_id=b.po_header_id 
    and b.po_header_id in (select po_header_id from po_headers_all c ) 

    Regards,

    Harshith E S

     

     

  • Catherine Hull

    I have updated knowledge from an SR with a Sales Cloud specialist.

    I was searching for Procurement Cloud-specific data, thinking this setup task was unique to Procurement Cloud. The task 'Manage Enterprise Data Quality Matching Configurations' is shared with Sales Cloud. Therefore some features I see are still not available in supplier management flows.

    As directed in the Oracle Doc implementing-procurement.pdf, my route of navigation was always: Setup and Maintenance > Define Supplier Matching > Manage Enterprise Data Quality Matching Configurations. This led me to falsely believe that Manage Enterprise Data Quality Matching Configurations was related only to supplier management lows in Procurement Cloud.

    It'd be helpful for the Oracle documentation implementing-procurement.pdf, to include insight on the fact that 'Manage Enterprise Data Quality Matching Configurations' is a shared task. It is not clear in any of the documentation and I completed a thorough search, asked other Oracle implementation experts before coming to this conclusion.

     

    Thanks, Catherine

  • Catherine Hull

    I have updated knowledge from an SR with a Sales Cloud specialist.

    I was searching for Procurement Cloud-specific data, thinking this setup task was unique to Procurement Cloud. The task 'Manage Enterprise Data Quality Matching Configurations' is shared with Sales Cloud. Therefore some features I see are still not available in supplier management flows.

    As directed in the Oracle Doc implementing-procurement.pdf, my route of navigation was always: Setup and Maintenance > Define Supplier Matching > Manage Enterprise Data Quality Matching Configurations. This led me to falsely believe that Manage Enterprise Data Quality Matching Configurations was related only to supplier management lows in Procurement Cloud.

    It'd be helpful for the Oracle documentation, implementing-procurement, to include insight on the fact that 'Manage Enterprise Data Quality Matching Configurations' is a shared task. It is not clear in any of the documentation and I completed a thorough search, asked other Oracle implementation experts before coming to this conclusion.

     

    Thanks, Catherine

  • Carlos Urtubia

    After using that content type that you mentioned, worked!

    Thank you,

     

    Carlos

  • Carlos Urtubia

    Yup, Content-Type:  application/vnd.oracle.adf.action+json and still I get the 403 Forbidden

    I'm using POSTMAN.

    Regards,

    Carlos

  • Hong Gao

    Can you share what is the value used for Content-Type? Try with: application/vnd.oracle.adf.resourceitem+json.

    Please also reference the following:

    https://docs.oracle.com/en/cloud/saas/procurement/19d/fapra/Work_with_your_REST_API_Client.html

  • Ivan Pena
    Moved from the Purchasing forum. Ivan
  • santhy Mohan

    Yes, it is possible by customizing seeded portal roles. Delete or add privileges as per requirement to remove or add task under this task list. 

     

    for eg: if you want to remove create Invoice without PO, then customize role Supplier Accounts Receivable Specialist and delete privilege "Enter Unmatched Payables Invoice As Supplier" from the role. Attach the custom role to supplier user.

     

    Thanks,

    Santhy