Posts

Posts

  • Isu Sahai
    SQLs for generating Import files for Supplier Creation1
    Topic posted March 7, 2017 by Isu Sahai, tagged Setup, Supplier Creation in Procurement > Supplier Management public
    Title:
    SQLs for generating Import files for Supplier Creation
    Summary:
    Speed up the instance creation tasks for seeding supplier data
    Content:

    Hi

    We have a hybrid ecosystem of SAP and Oracle legacy ERPs. As we plan to review our data quality checks and decide on next steps, I was curious to know if there are prepackaged SQLs that can be run on Oracle eBS to populate the import templated.

    Similarly, are there any extract ABAP scripts for SAP that anyone can be shared.

  • Aaron Leggett
    OTBI Security Help1
    Topic posted March 2, 2017 by Aaron LeggettGold Trophy: 10,000+ Points, tagged Analyses, BI Publisher, OTBI, Public Sector, Reports, Setup, Setup/Administration in General OBIEE public
    Title:
    OTBI Security Help
    Content:

    Hi All, 

    We are deploying some reports to production for the HR team to use. We are confused with the way the security works in regards to the reports. Ideally, we want to be able to assign a custom role to employees so they can view certain reports (e.g HR Level 1 can see an Assignment Change Report, Contact Details Change Report etc. whilst a HR Level 5 role can see All Employee Details, All Salaries etc.). Can this be done? 

    In addition, do the Areas of Responsibility affect what the user can see when they run a report? For example, we have some employees who can only see Sector X information. If they ran a report, would they also be able to see Sector Y and Sector N information? 

    Thank you for reading! 

    Aaron 

  • Mor Amsalem
    Users information in report2
    Topic posted February 28, 2017 by Mor Amsalem, tagged Analyses, OBIEE Answers, Reports, Setup, Setup/Administration in General OBIEE public
    Title:
    Users information in report
    Summary:
    I need to create (or use one that exists) that will give me basic information on the users
    Content:

    Hi,

    I need to create (or use one that exists) that will give me basic information on the users like:

    Name, party ID, User Name, Email, Manager, Status (Active/Inactive), and some custom attribute.

    where can I find such a report or how to create one

    thanks,

    Mor.

  • Andy French
    Link to DashboardAnswered2
    Topic posted January 30, 2017 by Andy FrenchGold Medal: 3,500+ Points, tagged OBI Answers, OBIEE Answers, Reports, Setup, Setup/Administration in General OBIEE public
    Title:
    Link to Dashboard
    Summary:
    Looking to provide a direct link to our Recruiting Dashboard for users not logged in
    Content:

    I'm trying to create a link to our Recruiting Dashboard to be included in our Recruiting kit, which is housed outside of OBI. It's actually just a Word document. Ideally, I'd like the link to take users (who would not be logged in) directly to our Recruiting Dashboard via our SSO. Is anyone else doing this?

  • Jeroen Sprangers
    'Display in Supplier Profile' not showing in Manage...4
    Topic posted December 12, 2016 by Jeroen SprangersBronze Medal: 1,250+ Points, tagged Setup in Procurement > Purchasing public
    Title:
    'Display in Supplier Profile' not showing in Manage Catalogs page
    Summary:
    'Display in Supplier Profile' not showing in Manage Catalogs page
    Content:

    In our test environment we have setup catalogs. 
    In the manage Catalog under configuration we see the checkbox 'Display in Supplier Profile'. 

    When setting up Production we are not seeing this checkbox. 
    See also the attached screenshots of both instances. 

    Question: what is driving the visibility of the checkbox? 

    Image:
    Document:
  • Jeroen Sprangers
    Sourcing Role2
    Topic posted November 30, 2016 by Jeroen SprangersBronze Medal: 1,250+ Points, tagged Negotiation Creation, Setup in Procurement > Sourcing public
    Title:
    Sourcing Role
    Summary:
    Which role is needed to do sourcing
    Content:

    Hi,

     

    We are setting up users and want to restrict the rights as much as possible.

    If we want to give a user only access and rights to create negotiations which role is needed in that case?

    In the documentation i can't find it.

  • Jasper Oskam
    Supplier is approved even if notification of approval is...6
    Topic posted November 23, 2016 by Jasper OskamRed Ribbon: 250+ Points, tagged Approvals/Notifications, Setup, Supplier Creation, Supplier Profile Management, Supplier Registration in Procurement > Supplier Management public
    Title:
    Supplier is approved even if notification of approval is rejected by approver
    Summary:
    Supplier is approved even if notification of approval is rejected by approver
    Content:

    Hi,

    for our internal supplier registration approval flow:  if one of the approvers rejects the approval notification, the system still says that the supplier has been approved. Is this happening due to some option in the BPM worklist?

    See the picture for more information. Outcome = rejected, approval status = approved.

  • Jasper Oskam
    External supplier registration request keeps being rejected18
    Topic posted November 20, 2016 by Jasper OskamRed Ribbon: 250+ Points, tagged Approvals/Notifications, Setup, Supplier Creation, Supplier Profile Management, Supplier Registration, Supplier User Account in Procurement > Supplier Management public
    Title:
    External supplier registration request keeps being rejected
    Summary:
    External supplier registration request keeps being rejected
    Content:

    Hi,

    since a few days, all external supplier registration requests keep beging rejected straight away. I have linked a rule that should automatically approve all registrations, but every supplier I try keeps being rejected. The message just says ' supplier rejected' and I cannot see any additional information why the supplier is rejected. In the supplier data I cannot see any details, it just says error (see attachment).

    Internal supplier registrations do work (similar rules) and also the promote to spend approval flow works properly.

    Can I see somewhere what is the cause of this issue (why is it rejected) and what could be the cause?

    Thank you

    Jasper

    Image:
  • Jeroen Sprangers
    Prospective Supplier Registration Page Roles10
    Topic posted November 17, 2016 by Jeroen SprangersBronze Medal: 1,250+ Points, tagged Setup, Supplier Creation in Procurement > Supplier Management public
    Title:
    Prospective Supplier Registration Page Roles
    Summary:
    Disable Roles in LOV of Prospective Supplier Registration Page
    Content:

    In the Prospective Supplier Registration Page in the section of Roles a supplier can add certain roles.

    We want to adjust the values in the LOV.

     

    We want to keep the roles active but some of them we don't  want to have them appear in this LOV

    Where can we change the setup of the values in this LOV?

     

     

  • Jeroen Sprangers
    Manage Tax Organization Type Lookup25.0
    Topic posted November 17, 2016 by Jeroen SprangersBronze Medal: 1,250+ Points, tagged Setup, Supplier Creation in Procurement > Supplier Management public
    Title:
    Manage Tax Organization Type Lookup
    Summary:
    Manage Tax Organization Type Lookup change seeded values
    Content:

    Hi,

     

    In the task 'Manage Tax Organization Type Lookup' we can adjust the loopup.

    However we want to adjust or end date certain seeded values because these are not used by our clients. 

    But we are not allowed to delete, end date or disable the seeded values.

     

    How can we delete, end date or disable them?