Posts

Posts

  • Phil Nibert
    Need an OTBI report/ field that shows PO AP Accrual Account
    Topic posted Yesterday by Phil NibertRed Ribbon: 250+ Points, tagged Business Intelligence, Financials, OTBI, Payables in Procurement > Purchasing public
    Title:
    Need an OTBI report/ field that shows PO AP Accrual Account
    Summary:
    Need an OTBI report/ field that shows PO AP Accrual Account
    Content:

    Hi would like to see if any of the OTBI subject areas for Procurement have a field that shows the PO AP liability account for the Purchase Order.  I can find OTBI fields in the Procurement - Procure to Pay Real Time and Procurement - Purchasing Real Time OTBI subject areas for the PO charge account but not the PO liability account.

    Version:
    Oracle Cloud Financials 19C
  • Vitor Lima
    OTBI how to list repeated values3
    Topic posted December 4, 2019 by Vitor Lima, tagged Business Intelligence, Order Management, OTBI, SCM, SQL in Reporting and Analytics for SCM public
    Title:
    OTBI how to list repeated values
    Summary:
    how to use list component to repeat values
    Content:

    Hello, I've created a customized report in OTBI and it i'm using the list component to present the data retrieved from the data model but, the list component is only presenting unique values within the results... much like a "Select Distinct" and for this particular report i need it to show all values regardless if they are repeating or not...

    Thanks a bunch,

    Vitor

     

    in the picture attached the report should show another number 2 in the fourth column 

    Image:
  • Srekan
    case insentive in BI publisher text box parameter3
    Topic posted November 20, 2019 by Srekan Red Ribbon: 250+ Points, tagged BI Publisher, Business Intelligence in Business Analytics > Business Intelligence public
    Title:
    case insentive in BI publisher text box parameter
    Summary:
    how to get data when passing case insentive in BI publisher text box parameter
    Content:

    Hello All,

    i have BI publisher report with parameter "Name" text box. when user enters name for example Tom, it has to pull all Tom records. 

    when user enters any other format / combination in the text box value Tom, it has to pull records.

    possible combinations to enter in name text box are Tom, TOM, ToM, tom, tOM etc.

     

    Regards,

    Joe

    Version:
    BI publisher 12c
  • Ling Xiang
    OTBI Customer Survey
    Topic posted November 18, 2019 by Ling XiangGold Trophy: 10,000+ Points, tagged Business Intelligence, OBIEE Answers, OTBI in Reporting and Analytics for SCM public
    Title:
    OTBI Customer Survey
    Content:

    Oracle BI development is planning OTBI feature improvements.  To better understand SaaS customers’ reporting needs, usage and requirement gaps, we are conducting an OTBI customer survey.  Please take 10-minutes to complete this 10-question survey to share your feedback, thoughts and ideas ->   https://cloudcustomerconnect.oracle.com/pages/d549eddf75

    Thank you for your time!

    Ling Xiang

    Oracle OTBI Product Management

  • Prateek Parasar
    Enabled BIP Notification for Supplier Registration approval...Answered75.0
    Topic posted November 12, 2019 by Prateek ParasarBlack Diamond: 60,000+ Points, tagged Approvals/Notifications, Business Intelligence, Supplier Registration in Procurement > Supplier Management public
    Title:
    Enabled BIP Notification for Supplier Registration approval but still getting classic
    Summary:
    Do I need to do any other setup. I have done the opt in as mentioned in the Document
    Content:

    Attached document shows my steps to enable and the email I received. I am still getting email as well as worklist entry showing the classic notification and not the BIP based notification. Am I missing something.

    Version:
    19D
  • Srekan
    is there any way where i can display more than 10 records...Answered2
    Topic posted November 11, 2019 by Srekan Red Ribbon: 250+ Points, tagged BI Publisher, Business Intelligence, Tip in Business Analytics > Business Intelligence public
    Title:
    is there any way where i can display more than 10 records default in interactive mode.
    Summary:
    is there any way where i can display more than 10 records default in interactive mode.
    Content:

    Hello All,

    i have created report in bi publisher 12c, when viewing report in interactive mode it displaying only 10 records default mode. need to scroll down for further records.

    is there any way where i can display more than 10 records default in interactive mode?

     

    regards

    joes

  • Dev Thota
    Suggestions in Return to Vendor process15.0
    Topic posted November 11, 2019 by Dev ThotaGold Trophy: 10,000+ Points, tagged Approvals, Approvals/Notification, BI Publisher Reports, Business Intelligence, Create Requisition, How-To, Manage Procurement Catalog, OTBI, Public Sector, Requisition Processing, Setup, White Paper in Inventory and Logistics > Inventory public
    Title:
    Suggestions in Return to Vendor process
    Summary:
    Suggestions in Return to Vendor process
    Content:

    Hi All,

     

    While responding to a High-Tech Contract Manufacturer Client RFP, looking for suggestions to provide solution for their major pain point - ‘Return to Vendor’.

     

    For them, this is an issue, since once they receive the goods in Inventory, they may use it only after 3-6 months. While using in Work order, if they find any item is defective, they raise OSP for this item and send to Supplier for repair/replacement.

    They have to raise OSP instead of Return to Vendor, because of the delay in using the items in Work order, and by that time, Purchase Order against which item was received would have been Finally Closed.

     

    We are planning to suggest Oracle Cloud – Return to Vendor with replacement. Kindly suggest :

    1.     How can we address returns for Finally Closed POs ?

    2.     If any better solution to above problem?

     

    Thanks,

    Dev Thota

    Version:
    19D
  • David Wright
    Child fields in request parameter for Get All Suppliers REST...Answered3
    Topic posted November 8, 2019 by David Wright, tagged Business Intelligence, Fusion, How-To in Procurement > Supplier Management public
    Title:
    Child fields in request parameter for Get All Suppliers REST API
    Summary:
    What's the notation for child fields for expanded items in this API
    Content:

    The documentation says "If an indirect child resource is provided (Example: Employees.Managers), the missing children will be processed implicitly. "

    So, if my parameters say 'fields' : 'Alias,AlternateName,Supplier,SupplierId,SupplierNumber,sites.PaymentTerms' then shouldn't sites.PaymentTerms be valid for Suppliers?  However, when I try to use any variation of this (with . or ; or :) it fails with 'URL request parameter fields with value Alias,AlternateName,Supplier,SupplierId,SupplierNumber,sites.PaymentTerms is not valid.'

    Is my notation incorrect, or can I not access child items in such a manner for Supplier?

  • Shivani Roy
    How to configure Supplier Registration Approved Email...25.0
    Topic posted October 30, 2019 by Shivani RoyBronze Medal: 1,250+ Points, tagged Approvals/Notifications, Business Intelligence, Customization, Supplier Registration, Tip in Procurement > Supplier Management public
    Title:
    How to configure Supplier Registration Approved Email notification using Business Intelligence Publisher template
    Summary:
    Steps to configure Supplier Registration Approved Email notification using Business Intelligence Publisher template.
    Content:

    Summary: Steps to configure Supplier Registration Approved Email notification using Business Intelligence Publisher template.

    Description:

    Buying organizations can include additional information to be sent to the supplier by configuring the email notifications using BIP.

    E.g: In the Supplier Registration Approved Email notification, if you want to add a paragraph detailing the organizations quality policies and also want to display additional information dependent upon a supplier registration attribute, then follow the below steps:

    Note:

    1. In order to configure the BIP template the user should have the role: BI Administrator.
    2. This feature is opt in controlled. You need to enable feature Configure Supplier Registration Approval Decision Notifications with Business Intelligence Publisher.

    Step 1: Create a copy of the template

    Sign in to Oracle Business Intelligence Publisher. In the Suppliers Business Intelligence Catalog, locate the External Supplier Registration Approved FYI Email Report template, and then click Customize. This creates a copy of the template in your Custom folder.

    image2019-10-31_11-45-39.png?version=1&modificationDate=1572502540680&api=v2

     

    Step 2: Download and install BI publisher word add-in

    If BI publisher add-in is not installed for word you can download it from the below link:

    https://www.oracle.com/technetwork/middleware/bi-publisher/downloads/index.html

     

    Step 3: Download sample data

    Sample data will be required in order to add additional supplier registration attributes to the template. Sample data contains a list of supplier registration attributes along with sample values for these attributes. This when loaded to the template gives you a list of the supplier registration attributes which can be added to the template. Furthermore the sample data is also useful when you want to preview a report for the configuration done.

    To download the sample data follow the below steps:

    Edit the External Supplier Registration Approved Email Data Model available under the Data Models folder.

    screenshot1.png?version=1&modificationDate=1572501032000&api=v2

    Click on the properties from the panel on the left hand side. Download and save the sample.xml

    2.png?version=1&modificationDate=1572501071000&api=v2

    Note: If the sample data does not contain the required attributes, you can edit the sample.xml file using notepad and manually add the required tag and value combination under the correct mapping set.

    To fetch the correct Tag Name and mapping set, open the data model, Click on the Data Sets from the panel on the left hand side and go to Structure tab. XML Tag Names and their mapping sets are listed here.

    datamodel.png?version=1&modificationDate=1572501102161&api=v2

     

     

    Step 4:  Customizing the copy of the seeded template.

    1. Go to Custom folder> Procurement> Suppliers > External Supplier Registration Approved FYI Email Report template. Click on Edit and download the ExtSuppRegNotifApprovalFYIReport.rtf.
    2. Go to BI publisher tab and load sample.xml saved in Step 3.
       3.png?version=1&modificationDate=1572501122090&api=v2
    3. Adding text content: Go to the Insert tab, expand ‘Quick Parts’ to see available pre-existing layouts which can be used to configure the template.
      To add text choose BIP Paragraph of Text from the list.
      4.png?version=1&modificationDate=1572501145000&api=v2
      Add text which is to be displayed in the email.
      5.png?version=1&modificationDate=1572501165000&api=v2
    4. Adding an attribute from the data model to conditionally display content on the BIP report:
      We can also add conditions on any of the supplier attribute to conditionally display content. Example given below shows how to use DFF attribute to conditionally display content on the email. DFF attribute ATTRIBUTE20 is used in the supplier registration to capture the supplier response to the question on the buying organization’s quality policies.
    • To add a condition click on Conditional Region under BI publisher tab.
    • Under General: Select the required attribute from the Data field list. Select the corresponding data type.
    • Under Condition1: Manually enter the value expected to satisfy the condition.
    • Add the required content to be displayed inside the conditional tags <C><EC> as shown below.
      12.png?version=1&modificationDate=1572501190212&api=v2

     

    Step 5:   Viewing a sample report for the customization.

    Note: Temporarily delete the portion highlighted in yellow before viewing a sample. Paste it back after viewing the sample report.

    These tags are references to other folders in the BI and hence will throw error when we try to view a sample report locally.

    Under BI publisher tab click on any of the formats to view a sample report.

    15.png?version=1&modificationDate=1572501214000&api=v2

    Sample report in the pdf format.

    14.PNG?version=1&modificationDate=1572501238878&api=v2

     

    Step 6: Save the template and upload it back into the BI publisher.

    Under Custom folder> Procurement> Suppliers > External Supplier Registration Approved FYI Email Report, note down the layout name and delete the existing template. Click on Upload to upload the configured template. Please note to use the existing name for layout name. For External Supplier Registration Approved FYI Email Report template the layout name is ExtSuppRegNotifApprovedFyi.

    image2019-10-31_11-47-30.png?version=1&modificationDate=1572502650267&api=v2

     

    Once the upload is complete click on View a list on the top right corner and verify that the Default Layout checkbox is checked.

    11.png?version=1&modificationDate=1572501609000&api=v2

     

    Other references:

     

  • Sathya Kannan
    Procurement - Procure to Pay Real TimeAnswered5
    Topic posted October 16, 2019 by Sathya KannanBronze Medal: 1,250+ Points, tagged Business Intelligence, Create Requisition, How-To, Orders, OTBI, Payables, Requisition Processing, Setup, White Paper in Procurement > Purchasing public
    Title:
    Procurement - Procure to Pay Real Time
    Summary:
    Procurement - Procure to Pay Real Time not displaying the Receipt Numbers created against the POs
    Content:

    Hi,

    We would like to create an OTBI report using the Procurement - Procure to Pay Real Time analysis, but the receipt number (available under Invoice column) created for the Purchase orders is not displayed.

    Does anyone know the solution for this?

     

    Regards,

    Sathya Kannan