• Manavalan Ethirajan
    Build your own report using new Procure to Pay Subject Area15.0
    Topic posted January 18, 2018 by Manavalan EthirajanSilver Medal: 2,000+ Points, tagged Business Intelligence in Procurement > Purchasing public
    Build your own report using new Procure to Pay Subject Area

    A new subject area called “Procure to Pay Real Time” has been added to Procurement’s Oracle Transactional Business Intelligence or OTBI. You can use this subject area to create your own ad-hoc report. You can review the brief summary of the feature here.

    You can review the feature description in the following release readiness materials and documentation.

    Please feel free to post any questions or comments here.

  • Sanjay Shah
    Changing date format from 2018-07 to Jul-20172
    Topic posted December 4, 2018 by Sanjay ShahGreen Ribbon: 100+ Points, tagged Business Intelligence, OBIEE Answers, OTBI, Procurement in Reporting and Analytics for SCM public
    Changing date format from 2018-07 to Jul-2017
    Changing date format from 2018-07 to Jul-2017

      What is the syntax to change from Time Dimension Month Code from 2018-07 to Jul-2017.  When I try to change in column properties it does not like it.

    Thanks for your help.

  • Murali Gangidi
    Contract Notes in 'Enterprise Contracts-Contracts Real...25.0
    Topic posted October 25, 2018 by Murali GangidiBronze Medal: 1,250+ Points, tagged Agreements, BI Publisher Reports, Business Intelligence, Fusion in Procurement > Purchasing public
    Contract Notes in 'Enterprise Contracts-Contracts Real Time' Subject Area for OTBI Analysis
    Contract Notes in 'Enterprise Contracts-Contracts Real Time' Subject Area for OTBI Analysis

    Hi All,

    Is there any folder/dimension where can we find the Notes that is entered on the Enterprise Contracts at Header level in n OTBI Subject Area 'Enterprise Contracts-Contracts Real Time'.

      Which tables that this notes section refers to in Contracts Module. Attached screenshot for reference.


  • Atul Kumar
    Create Pick Wave is not releasing all the lines for Transfer...3
    Topic posted November 14, 2018 by Atul KumarBronze Medal: 1,250+ Points, tagged Approvals, Approvals/Notification, BI Publisher Reports, Business Intelligence, Business Intelligence - BI, FAQ, How-To, Internal Material Transfer, Intrastat, Inventory & Cost Management Analytics Cloud, Inventory Cloud, Public Sector, SCM, Setup, Supply Chain Financial Orchestration, Supply Chain Orchestration, Tip, White Paper in Inventory and Logistics > Inventory public
    Create Pick Wave is not releasing all the lines for Transfer Order after 18c upgrade
    Create Pick Wave is not releasing all the lines for Transfer Order

    Recently we have 18c upgrade and post upgrade, we have noticed that Create Pick Wave is just releasing the first line in the transfer order and backorder all other lines of the same transfer order even if there is enough inventory on-hand to fulfill the order line.  We can continue to execute the Create Pick Wave process using the “Backordered” status until all order lines are released. We are facing this issue after 18C upgrade. 

    Please let us know if anyone faced this issue and got resolution or workaround?

  • Nishanth B Jain
    Custom text in notification SQMAnswered9
    Topic posted February 5, 2019 by Nishanth B JainBronze Crown: 15,000+ Points, tagged Business Intelligence, FAQ, How-To, Qualification, Qualification Model, Questionnaire, Questionnaire Response, Tip, White Paper in Procurement > Supplier Qualification Management public
    Custom text in notification SQM
    You Are Invited to Respond to Questionnaire

    Hi All,

    Can we edit this notification's text?



  • Mohammad Alhindawi
    Customization on the AP invoice14.0
    Topic posted March 11, 2019 by Mohammad AlhindawiRed Ribbon: 250+ Points, tagged Asset Tracking, BI Publisher, BI Publisher Reports, BICS, Business Intelligence, Configure to Order-CTO, Costing, Dashboards, DVCS, Geneology, Innovation Management, Installed Base, Inventory, Maintenance, Manufacturing, OBIEE Answers, Order Management, OTBI, Procurement, Product Development, Product Information Management-PIM, Public Sector, Quality – Inspections, Quality – Issues and Actions, Report Scheduling, Reporting and Analytics, Sample Reports, SCM, Setup/Administration, SQL in Reporting and Analytics for SCM public
    Customization on the AP invoice
    Customization on the AP invoice

    Is it possible to do a customization on the AP invoice to validate certain fields and making some fields required based on filling of other fields?

    Oracle Fusion
  • Mehnaz Rahman
    Customizing PDF Reports Using BI Publisher5.0
    Topic posted July 24, 2019 by Mehnaz RahmanRed Ribbon: 250+ Points, tagged Business Intelligence, FAQ, How-To, Questionnaire, Tip in Procurement > Supplier Qualification Management public
    Customizing PDF Reports Using BI Publisher

    Supplier Qualification’s seeded BIP reports like Supplier Qualification Questionnaire PDF, Supplier Registration Questionnaire PDF can be customized using the BI publisher by using the customization feature. Upon selecting the option for a report, BI Publisher creates a copy of the report in the "Custom" folder. This custom copy is linked internally to the original report with the same underlying data model. User can customize the custom copy of the report and select it as default report, leaving the original report intact. When a request to run the report is initiated, whether from the BI Publisher catalog or through an application process, BI Publisher detects the customized version and runs it. Refer to the attachment for steps to customize a report.

    Important Notes:

    1. To use customize feature a folder named "Custom" must exist directly under Shared Folders. If the Custom folder is not seeded in application, an Administrator can create it.
    2. To customize the report user must be granted BI Author role (or a role that includes the permission
    3. To read the report in custom folder, user must be granted BI Consumer role.
    4. The Customize option is not available through the /analytics URL used to access Oracle BI Enterprise Edition (for example:
    5. To view Customize option you must access BI Publisher through the /xmlpserver URL (for example:
    6. It’s not recommended to modify the original reports because any modifications are overwritten with a patch that updates the original report. Follow the Customization Feature for more details.
  • John Klinke
    December Release Update for Oracle Cloud Platform5.0
    Announcement posted January 4, 2019 by John KlinkeBronze Medal: 1,250+ Points, tagged Analytics, API Management, Big Data, Business Intelligence, CASB, Content and Experience, Data Integration, Data Visualization, Database, Database Backup, Developer, Identity, Integration, Internet of Things, Java, Management, Mobile Analytics, Mobile and Intelligent Bots, Process Automation, Visual Builder in Platform Members > Oracle Cloud Infrastructure and Platform Announcements public
    December Release Update for Oracle Cloud Platform

    We are pleased to announce new updates and enhancements to our comprehensive portfolio of PaaS solutions. A summary of Oracle Cloud Platform release updates for December 2018 are listed below. See Oracle Cloud Platform Documentation for more details.


    Big Data Cloud

    • Now includes Sparkline SNAP, a terabyte-scale OLAP option on Spark
    • Invalid REST request URLs now return 404 error


    Big Data Cloud Service

    • The system software has been updated to release 4.13.1. This includes Cloudera Distribution with Hadoop (CDH) 5.14.1
    • The Notebook tools are now built on Apache Zeppelin 0.8.0, upgraded from Apache Zeppelin 0.7.2
    • The spark interpreter has replaced the spark2 interpreter. Now the interpreters can be scoped per user and/or per note
    • Time-out based interpreter life-cycle management is available now
    • You can now upload directories from your local computer to HDFS
    • 2 new job types are available: ODHI Query (for generic queries against Hive) and ODHI Import (for loading data into Hive)
    • Data Explorer page allows you to right-click an HDFS file and see partial content of the file with syntax highlighting
    • When creating a new job, you can now select to execute it immediately or to specify its schedule


    Blockchain Cloud

    • You can now use longer channel names with a limit of 128 characters in the channel name
    • When a peer is removed from the network, it is automatically removed from any REST proxy configuration that includes it
    • When you deploy a chaincode, you can now select to enable it in multiple REST proxies
    • You can now go to the console's About menu to find your instance's creation date and time


    CASB Cloud

    • You can now create policy alerts for identity compartment and identity federation objects
    • Now the threshold risk level can be set for OCI and IDCS security controls
    • You can now register Azure without Azure AD monitoring, which requires only an E3 license. See Adding an Azure Instance
    • You can now register a SuccessFactors instance to be monitored by Oracle CASB Cloud Service
    • Policy alerts are now generated automatically, based on tags assigned to discovered applications
    • You can create custom policy alerts, based on tags assigned to discovered applications
    • The new "irrelevant" tag is available for you to assign to discovered applications
    • Now you can sort on tags assigned to discovered applications
    • You can now collect logs from an external account for an AWS instance that you register with CASB


    Content and Experience Cloud

    • Web client and mobile apps now have a Home option in the navigation menu
    • Now you can manage translation jobs through the Translation Jobs page
    • You can now associate conversations with assets, content items, and sites
    • Now the toolbar in the rich-text editor in content types can be customized
    • You can now use VBCS and DevCS to develop forms for CEC sites, and use the forms on CEC sites
    • There are changes in administrator roles. See Content Metrics, Web Analytics Tracking Snippets, and Integrate the Service
    • Developers can now expand macros in content list queries for marketers to use
    • You can now pass the layout category value to a content layout
    • Developers can create section layouts that support lazy load
    • The Documents Usage Log report now includes the parent path of the file or folder and the GUID of the file or folder
    • Preconfigured content connectors for Google Drive, Microsoft OneDrive, and Dropbox can be enabled by an administrator
    • Integration user can now be given access to all sites and templates


    Database Cloud

    • Notices of future deprecations and removals have been updated. More details here
    • Cloud tooling update is available for deployments hosting Oracle RAC databases
    • October 2018 PSU, BP and RU patches are available to be applied to existing deployments


    Event Hub Cloud

    • Now Apache Kafka Release 2.0.0 support is provided in addition to Kafka Release 1.1.0 support


    Identity Cloud

    • In addition to third-party risk providers, you can now activate and deactivate the default risk provider
    • You can now use the slider to set the weighting for events to determine risk-based activity for IDCS users
    • Enhancements have been made to SAML Application Configuration. See Adding a SAML Application
    • You can now allow clients to access OPC resources using hierarchical scope matching
    • IDCS now checks whether verification is done to the email address appearing in the From Email field for all notifications
    • Now you can migrate from traditional Cloud accounts to Cloud accounts with IDCS. More details here
    • You can now configure customized disclaimers and acceptable use policies for users on an application basis
    • Now multiple instances of the same social identity provider can be added
    • New endpoints have been added to IDCS REST APIs. More details here
    • You can now set Permissions for Microsoft Active Directory Bridge
    • Oracle Identity Cloud Service now supports CSV, JSON, and PDF report generation


    Infrastructure Monitoring (part of Oracle Management Cloud)

    • Support for new entities and enhanced entity association UI has been added in this release


    Integration Cloud

    New Common Features

    • You can change the BYOL metering option of an already existing instance


    New Integration Features

    • Support has been provided for Oracle Field Service Adapter to filter expressions to be added to the event subscription


    New Process Features

    • Now you can easily insert and configure integration activities in dynamic processes using the new Integration activity
    • User experience has been streamlined to make it easier to build expressions in web forms
    • Now you can use dynamic data to trigger the Change Presentation action
    • New performance management QuickStart App has been added
    • A new simple forms editor is available to quickly build your form
    • Now creating process applications and decision models is faster and more intuitive
    • You can now use RPA tools in your structured and dynamic processes to extend process automation
    • Process Owner and Process Reviewer roles now have better visibility into the task history of process instances
    • Dynamic process components are now available for iFrame integration using embeddable components
    • The Date Time control has been enhanced to adjust to users' time zones
    • You can now update external business objects being used in a process application by uploading a new WSDL file


    New Visual Builder Features

    • The Visual Builder generated applications now use Oracle JET 6.0 libraries and components
    • Additional release details are mentioned in the separate Visual Builder section below


    Internet of Things Cloud

    • Connector Framework lets you directly connect devices and services without using IoTCS Client Software Libraries
    • Now the new Users dashboard lets you create and manage user accounts
    • New and updated documents are now available in the Oracle Help Center


    Java Cloud

    • You can now associate ATP or OCI database as the infrastructure schema database when you provision your JCS instance
    • Oracle Documaker Enterprise Edition is now certified on Oracle Java Cloud Service
    • The QuickStart is unsupported for accounts with Oracle Cloud Infrastructure regions
    • New patch set updates (PSUs) are available for Oracle WebLogic Server and Java Development Kit (JDK)


    Log Analytics (part of Oracle Management Cloud)

    • Oracle Log Analytics now supports epoch seconds and milliseconds for the timestamp fields
    • You can use the On Demand Upload (ODU) client to upload your log files to Log Analytics through a command-line interface
    • Link feature gives you the ability to analyze user sessions, extract various parameters to help you get business insights


    Security Monitoring and Analytics (part of Oracle Management Cloud)

    • Now you can perform security analysis around two subsets of categories known as suspicious and malicious
    • Support for collecting security logs from monitoring sources in your IT environment has been added. More details here


    Self-Service Integration Cloud

    • Now you can create recipe actions against Oracle Configure Price Quote Cloud Service


    SOA Cloud

    • Bare Metal database support has been added for Oracle SOA Cloud Service instances on OCI in the Provisioning Wizard


    Visual Builder Cloud

    • Visual Builder now supports nested flows with additional features
    • iPad has been added as a deployment target option when building mobile apps
    • Additional support has been introduced for integrations
    • Improvements have been made to Page Designer, Property Inspector, Quick Starts, Action Chain editor and Event Listeners
    • Improved support has been added for installing components
    • New notifications have been added to indicate invalid or missing details for variables and types
    • The application's Settings are now displayed in an editor tab in the designer instead of a modal window
    • Support for child business objects in business rules editor has been added
    • Support for Visual Builder add-in for Excel plugin has been introduced
    • You can now specify a vanity URL for an application in the Application tab of the visual application's Settings editor


    See Oracle Cloud Platform Documentation for more details

  • Ramesh Radhakrishnan
    Enable Requested Delivery date feild in OTBI reports3
    Topic posted May 9, 2018 by Ramesh RadhakrishnanBlack Diamond: 60,000+ Points, tagged Business Intelligence, How-To in Procurement > Purchasing public
    Enable Requested Delivery date feild in OTBI reports
    Enable Requested Delivery date feild in OTBI reports

    How to Enable Requested Delivery date feild in OTBI reports?



  • Mehnaz Rahman
    Evaluated Suppliers and Qualifications Report54.7
    Topic posted September 6, 2018 by Mehnaz RahmanRed Ribbon: 250+ Points, tagged Business Intelligence, How-To, Qualification, Tip in Procurement > Supplier Qualification Management public
    Evaluated Suppliers and Qualifications Report
    Dashboard displaying the list of evaluated suppliers and qualifications with outcome for same questionnaire

    The dashboard allows you to retrieve the list of evaluated suppliers and qualifications and you can filter the results by Qualification Area and Qualification Outcome. This report also displays the response information in a single report so you can review and analyze the qualification details.

    You can specify a particular qualification area in the filter and find out all the evaluated suppliers and qualifications.  This will help you to quickly identify suppliers that are qualified for that area. You can also select a supplier of your choice and display all the available qualifications along with the response details. This will give you a summary on the qualification status across different areas for that supplier.  Besides, the Qualification Outcome and Qualification Score are color-coded based on the outcome so you can easily find the desired suppliers.

    The attached Deployment_Instructions.pdf contains steps for importing the dashboard to your instance.  Also attached is the Evaluated Suppliers and Qualifications.catalog file to import the dashboard to your instance.