Supplier Management

Get Involved. Join the Conversation.

Comments

  • Arun

    Hello Piyush,

    Attached document provides the screen shots.

    Please review and let me know if you require additional details.

    Thanks,

    Arun

  • Madhu G

    Hi Smruthi,

    Really appreciate your help, Yes all the supplier level tables worked. But the only issue here is  iby_ext_bank_accounts_ is holding only current update value. But for Audit purpose we really need a table where it will store the history of the updates like POZ_SUPPLIER_SITES_ALL_M_ does. It will have all the versions of the updates.

    Please help me in this scenerio if possible. I am lacking Bank Name,Bank Branch Number,Bank Account Number,IBAN Number.

    Meaning if I changed the Bank name from A to B, The expectation is the Audit table should hold both details of A and B. But iby_ext_bank_accounts_ is holding only Latest update details like Bank Name id B now.

    I hope you understood my issue.

    Thanks,

    Madhu.

  • Piyush Singh

    Hi Stacee,

    Is the understanding right that your requirement is exactly the same as that posted here? If so, resolving Arun's case will resolve your issue too, right?

    Thanks,

    Piyush

  • Piyush Singh

    Hi Arun,

    Can you share some screen shots to detail what exactly the user sees? Also, will be good (if possible) if you can share more information on the privileges the user has.

    Thanks,

    Piyush

  • Vineet Gangwar

    There is one more option (If Chooser Login Page is disabled in SSO)-

    * Disable the user creation notification only and keep reset password enabled so once the user is created, supplier admin can click on "Reset Password" in supplier contact which will send an email to supplier with password reset link and account detail.

     

  • Deepika Nathany

    Thanks Jim. 

    I have convinced my customer to use the approach 1. 

    Though its cumbersome - But looks like we are going with the first approach.

  • Stacee Patterson

    Arun - My company is interested in this functionality as well. Thanks for posting the topic. We tried the same as mentioned above, but did not have a successful result.

  • Arun

    Hello Niamath,

    The employee is setup as an agent and manage suppliers is enabled as well. The search list does bring up the Suppliers based on keywords but it does not display.

    Thanks,

    Arun

     

  • Piyush Singh

    Hi Deepika,

    If it is for internal bank account change, you need to author approval rule using setup page: Manage Internal Supplier Profile Change Approvals.

    Thanks,

    Piyush

  • Deepika Nathany

    Hi - Can you pls share where to create this bank accoutn approval rule.

    I had created in the past in the test instnace and it worked -- Now In prod it isnt working.

    I think -- Probably I am missing some setup. - -Can you pls show where in BPM do we configure for bank account approval

  • Smruthi Alladi

    Hi,

    Please find the table/column details for the above fields below.

    Supplier Name                 : hz_organization_profiles_ -> ORGANIZATION_NAME
    Supplier Alternate Name  : hz_addtnl_party_names_ -> party_name where party_name_type='PHONETIC'
    Tax Registration Number  : zx_party_tax_profile_ --> REP_REGISTRATION_NUMBER

    POZ_SUPPLIER_SITES_ALL_M_
    Address Details   : hz_party_sites table has address details

    Bank Name  : iby_ext_bank_accounts_ --> BANK_ID
    to get bank  name - select bank_name from CE_BANKS_V  where bank_party_id=<bank_id>

    Bank Branch Number: iby_ext_bank_accounts_ --> BRANCH_ID
    to get branch name - select bank_branch_name from CE_BANK_BRANCHES_V  where branch_party_id=<branch_id>

    Bank Account Number: iby_ext_bank_accounts_ --> BANK_ACCOUNT_NUM

    IBAN Number: iby_ext_bank_accounts_ --> IBAN

    Please let us know if you need any other details.

    Thanks,

    Smruthi

  • Niamath Jeddy

    You need to define the employee as a procurement agent and select the check box against 'Manage Suppliers'.

    Regards,

    Niamath

  • Jim Van Tongerloo

    Hi,

    We encountered the exact same problem. Due to this and several other issues in the flow of Supplier Portal/Supplier Registration, we chose not to implement this yet.
    We proposed solution 1 as well, but this is very cumbersome, certainly if this Supplier Registration is used in combination with Sourcing, things need to go fast. Solution 2 was not captured as a OK workaround.

    Oracle Support Bug 28917290 (DEFAULT CATEGORY FOR SUPPLIER USER ACCOUNTS) can be found at: https://support.oracle.com/epmos/faces/BugDisplay?id=28917290

    The above ER was created to have a default category for Supplier User Accounts. This would allow you to keep notifications disabled for your DEFAULT (SSO) and turn on notifications for Supplier User Accounts.

    This is, in my view, the most ideal solution for this problem, and I can not imagine it being that hard to add. It is approved for future release but no idea when that will be.

    Jim

  • Niamath Jeddy

    Mirza,

    The documentation is here:

    https://docs.oracle.com/middleware/11119/bip/BIPDV/webservices.htm#T569886

    and a few notes:

    How To Set Parameters To BI Publisher Reports Using Web Service API (Doc ID 2378541.1)
    How To Schedule BI Publisher Report And Download Output Via Web Service? (Doc ID 2543601.1)

     

    Regards,

    Niamath

  • Niamath Jeddy

    Thanks for sharing Aishwarya. This is quite helpful.

    I wish oracle includes such details in the specific REST service documentation itself.

    Regards,

    Niamath