Posts

Posts

  • Prateek Parasar
    Enabled BIP Notification for Supplier Registration approval...Answered55.0
    Topic posted 8:39 AM by Prateek ParasarGold Crown: 30,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 Yesterday 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 Yesterday 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...2
    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 RoyBlue Ribbon: 750+ 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 KannanBlue Ribbon: 750+ 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

  • Eren Göktepe
    Edit Purchase Order Email Approval Notification2
    Topic posted October 16, 2019 by Eren GöktepeRed Ribbon: 250+ Points, tagged Approvals/Notification, Business Intelligence, Notifications in Procurement > Purchasing public
    Title:
    Edit Purchase Order Email Approval Notification
    Summary:
    I try to edit PO template but .rtf validation failed in Word
    Content:

    Hi,

    I downloaded .rtf document for editing template. I clicked 'validation template' button. 

    I faced error in the below

     

    RTF Validation Failed

    Run XDO Start
    Oct 16, 2019 12:10:56 PM
    oracle.xdo.XDOException: 1 >= 1
    at oracle.xdo.template.rtf.RTFParser.generate(RTFParser.java:165)
    at oracle.xdo.template.rtf.RTF2XSLParser.generateXSL(RTF2XSLParser.java:343)
    at oracle.xdo.template.RTFProcessor.process(RTFProcessor.java:347)
    at RTFValidation.runRTFValidation(RTFValidation.java:121)
    at RTFValidation.main(RTFValidation.java:88)
    Version:
    Oracle Cloud Application 19C
    Image:
  • Srekan
    Date with timestamp parameter in BI publisher report 12c
    Topic posted October 11, 2019 by Srekan Red Ribbon: 250+ Points, tagged BI Publisher, Business Intelligence in Business Analytics > Business Intelligence public
    Title:
    Date with timestamp parameter in BI publisher report 12c
    Summary:
    datetime parameters passing in BI publisher report
    Content:

    Hi All,

    i am creating datewithtime parameterized report.

    i have database time column(xx_time) and the data as in the format of  10-OCT-19 09.45.22.846000000 AM  -------------> it is in (CST) format. But i have to show in EST format. For that i have used CAST(FROM_TZ(CAST(xx_ba.xx_time AS TIMESTAMP), 'CST') at TIME zone 'America/New_York' AS DATE) AS TIMEST. its working here.

    now i have to fetch records on TIMEST (which is calcualted column)  between start date and enddate parameters. whereas parameters datetime format as 10/13/2019 10:30:15 AM (MM/dd/yyyy hh:mi:ss AM).

    i have used query as

    SELECT xx_id,
        xx_time,
        TIMEST
        
      FROM
        (SELECT xx_ba.xx_id,
          xx_ba.xx_time,
      CAST(FROM_TZ(CAST(xx_ba.xx_time AS TIMESTAMP), 'CST') at TIME zone 'America/New_York' AS DATE) AS TIMEST
          
        FROM xx_ba xx_ba
        )
      WHERE TIMEST >= to_date(to_char(:startDate, 'MM/dd/yyyy hh:mi:ss AM'),'MM/dd/yyyy hh:mi:ss AM')
      AND TIMEST <= to_date(to_char(:endDate, 'MM/dd/yyyy hh:mi:ss AM'), 'MM/dd/yyyy hh:mi:ss AM')

    throwing error

    ORA-01722: invalid number
    01722. 00000 -  "invalid number"
    *Cause:    
    *Action:

     

    tried different options but no luck, Any help on this really appreciated.

    Regards,

    Joes

  • Koteswararao Yenikepalli
    Need EL Expression for the Requisition ID from the...
    Topic posted October 10, 2019 by Koteswararao YenikepalliSilver Medal: 2,000+ Points, tagged Asset Tracking, BI Publisher, BI Publisher Reports, BICS, Business Intelligence, Dashboards, Installed Base, Maintenance, Procurement, Reporting and Analytics, Sample Reports, SCM, Setup/Administration, SQL, Supply Chain Collaboration, Supply Chain Common Components, Supply Chain Financial Orchestration-SFO, Supply Chain Planning, Tip, Upgrades, White Paper in Reporting and Analytics for SCM public
    Title:
    Need EL Expression for the Requisition ID from the Purchasing Screen
    Summary:
    Need EL Expression for the Requisition ID from the Purchasing Screen
    Content:

    Need EL Expression for the Requisition ID from the Purchasing Screen

    Version:
    19c
  • Sabarish Ganda
    Can Subject of a Negotiation Award Approval Bell...
    Topic posted October 9, 2019 by Sabarish GandaGold Medal: 3,500+ Points, tagged Approvals, BI Publisher Reports, Business Intelligence, Customization, How-To, Negotiation Award, Negotiation Management, Notifications, Setup in Procurement > Sourcing public
    Title:
    Can Subject of a Negotiation Award Approval Bell notification be customized?
    Content:

    Can Subject of a Negotiation Award Approval Bell notification be customized? Like have supplier name and description?

     

    Version:
    Oracle Fusion 13, 19C