Posts

Posts

  • Ling Xiang
    R13.18A OTBI BI Catalog Lockdown5.0
    Topic posted June 15, 2018 by Ling XiangGold Trophy: 10,000+ Points, tagged BI Publisher, BI Publisher Reports, OTBI, Reporting and Analytics, Sample Reports in Reporting and Analytics for SCM public
    Title:
    R13.18A OTBI BI Catalog Lockdown
    Summary:
    With 13.18A release customers will no longer be able to modify the shipped BI catalog content.
    Content:

    R13.18A OTBI Product Alert

    This product alert is published by Oracle OTBI Product Development.

    Release 13.18A Factory BI Catalog Lockdown

    To minimize upgrade regression, an enhancement has been introduced in the 13.18A release to permanently make the shipped BI catalog content read-only.  If users attempt to modify the shipped BI catalog content including folder permissions, they will receive an alert "You are not allowed to modify factory content. Save your own content in /Shared/Custom."  Customers that upgrade from R12 to R13 will no longer be able to make changes to the delivered BI catalog even with BI Administrator role. Starting with R13.18A, BI catalog folders will behave as follows:

    • Customers must save all custom content in /Shared/Custom folder or create new sub-folders under /Shared to maintain custom content.
    • Except for /Shared/Custom folder, customers can no longer make any modifications to the delivered BI catalog. If a user attempts to add, change or remove any object including permission list in the delivered catalog folder, he/she will get an error "You are not allowed to modify factory content. Save your own content in /Shared/Custom."
    • Customers are permitted to retain EXISTING custom top-level folders under Shared. All existing content in those top-level custom folders will be preserved.
    • Customers cannot add, remove or change permissions on the shipped folders, e.g. /Shared/ Human Capital Management
    • Customers cannot modify the folder permissions to 'hide' the shipped factory catalog folder, e.g. hide /Shared/Marketing.
    Impact on R12 upgrade customers:
    • For customers upgrading from R12, all existing custom content in /Shared/Custom or custom folders under /Shared and their sub-folders will remain as they are.  However, if customers have modified the content in the delivered BI catalog folders, e.g. added custom reports, modified delivered reports, modified folder or report permission, all changes to this content will be lost after the R13 upgrade.  Customers are advised to archive their custom BI catalog to a file prior to R13 upgrade; and after R13 upgrade customers can unarchive the custom projects in the /Shared/Custom folder.  

     

    • Fusion application users are auto-provisioned with BI Consumer role, which allows them to read and traverse the BI catalog folders. This access is for folder viewing and navigation only and doesn't give the user the privilege to view, open, edit and execute BI reports, for which the user has no security authorization. An enhancement is in development to restrict access to BI catalog folders such that a user will no longer be able to see and traverse BI catalog folders that he or she has no security authorization to access.
  • Piyush Bihany
    Access to Procurement/Purchasing Subject Area & Purchasing...45.0
    Topic posted July 30, 2019 by Piyush BihanyGold Medal: 3,500+ Points, tagged BI Publisher Reports, Fusion, How-To, Orders, OTBI in Procurement > Purchasing public
    Title:
    Access to Procurement/Purchasing Subject Area & Purchasing Related Reports
    Summary:
    User without Buyer role are unable to Access Procurement Subject Area and Procurement Related Reports, Also they are unable to Create New Analysis
    Content:

    Client is live with Oracle Purchasing cloud and users have been creating PO on the Prod Instance.

    However there are few users who doesn't have the Buyer License (Buyer Role is not assigned) and don't have access to create and manage Purchase Order but still wants to review (view only access) for the Purchase order Data via Reports. 
     

    Client has additionally procured license for B84576 - Oracle Fusion Transactional Business Intelligence Cloud Service - Hosted Name, with an understanding that this will grant access to the users for BI Reports. 

    We have created a custom BI Role, and have added the following Privileges to the same: 
    BI Consumer Role 
    And have assigned the custom role to above listed users. 

    These users are unable to create a New Analysis (OTBI report) under the BI Page.

     
    Also for any existing OTBI Report, when the open the same, they are getting error as: 
    No Results 
    The specified criteria didn't result in any data. 

    However the same report is fetch data for other users, who are having Buyer role assigned. 

    Please advice, if in addition to creation of Custom Role for Oracle Fusion Transactional Business Intelligence Cloud Service, any other steps needs to be performed. 

    --

    PB

    Image:
  • Sridhar Tumati
    ADFService11G - JBO-25096: Accessor ItemEFFBIFlattenedVO Was...15.0
    Topic posted November 19, 2018 by Sridhar TumatiBronze Medal: 1,250+ Points, tagged BI Publisher Reports, Business Intelligence, Create Requisition, FAQ, Financials, Fusion, Manage Procurement Catalog, Orders, Requisition Processing, Setup, Tip, White Paper in Procurement > Purchasing public
    Title:
    ADFService11G - JBO-25096: Accessor ItemEFFBIFlattenedVO Was Not Correctly Resolved;
    Summary:
    Procurement Custom Reports: ADFService11G - JBO-25096: Accessor ItemEFFBIFlattenedVO Was Not Correctly Resolved;
    Content:

     Hi All,

    After Upgrading to Release 13 18C, All the custom Reports developed using Procurement Purchasing Real time subject area having item Description. field results error as below:

    State: HY000. Code: 77031. [nQSError: 77031] Error occurs while calling remote service ADFService11G. Details: Runtime error for service -- ADFService11G - JBO-25096: Accessor ItemEFFBIFlattenedVO was not correctly resolved in view def InventoryItemRefPVO. Locate the resolution error and address the issue. (HY000)

    We raised  SR and Oracle Support Provided the solution as per below docment:

    FA OTBI - After 18C Patch Errors on OTBI SCM, Produrement Subject areas erroring out ItemEFFBIFlattenedVO; FulfillLineDetailBIEffEFFBIFlattened (Doc ID 2470931.1) 

    Bug 28895661 : FA OTBI ANALYSIS FAILING AFTER 18C UPDATE - ACCESSOR ITEMEFFBIFLATTENEDVO WAS NOT CORRECTLY RESOLVED

    EGO_ITEM_EFF:
    To deploy Item extensible flexfields, do the following:

    1. In the Setup and Maintenance work area, open the task panel and click Search.
    2. Search for and select the Manage Extensible Flexfields task.
    3. On the Manage Extensible Flexfields page, search for the Item Extended Attributes flexfield (flexfield code EGO_ITEM_EFF).
    4. Select the Item Extended Attributes row. From the Actions menu, select ‘Refresh & Deploy Offline’

    This action starts the Item extensible flexfield deployment process.
    5. Monitor the Offline Status column, which shows the status of the deployment process.
    DOO EFF
    Doc 26739757 - BI EFF DOCUMENTATION[This section is not visible to customers.]
    Steps:
    1. Please run the ESS program: Publish Extensible Flexfield Attributes.
    2. In the Manage Extensible Flexfield UI, force deploy the doo header, fulfill line, fulfill line details EFF regardless of whether the customer uses these EFFs or not by invoke Actions->Refresh & Deploy Offline
    3. After deployment, in the same EFF UI, invoke Actions->Download Flexfield
    Archive to download the artifacts, and make sure the directory structure is like: oracle.apps.publicFlex.scm.doo.fulfillLineCategories.analytics
    4. Bounce SCM’s UI and Service Server (Open SR for the bounce)

    Regards,

    Sridhar Tumati

     

    Version:
    Release 13 18C
  • Murali Gangidi
    Approval Aging Report including all approvers and timestamp...35.0
    Topic posted November 19, 2018 by Murali GangidiBronze Medal: 1,250+ Points, tagged Approvals, BI Publisher Reports, Business Intelligence, Fusion in Procurement > Purchasing public
    Title:
    Approval Aging Report including all approvers and timestamp (PO, Contract, Invoice).
    Summary:
    Approval Aging Report including all approvers and timestamp (PO, Contract, Invoice)
    Content:

    Hello Gurus,

     

    Is there seeded report or any OTBI Subject Area's to join or BIP Query which will get the Approval details of  all approvers and timestamp  for Purchase Order , Contracts and Invoices. Need custom report  to pull all Open and Pending Approval PO's, Contract's and Invoices in one report. Trying to explore the options and if any one can help on this.

  • Annette Massie
    Approved requisitions not generating PO'sAnswered8
    Topic posted July 26, 2019 by Annette MassieRed Ribbon: 250+ Points, tagged BI Publisher Reports, Business Intelligence, Public Sector in Procurement > Purchasing public
    Title:
    Approved requisitions not generating PO's
    Content:

    We are finding that some of our requisitions are still in process status because it requires a negotiation to turn into a PO. Oracle support supplied a sql query to create a BI report, however I can't seem to make it work. Has anyone created an analysis to help with this that they would be willing to share? The query that was supplied looked like this:

    SELECT prh.requisition_number
    ,prl.line_number
    ,prl.line_status
    ,prl.req_po_instance_id
    ,prl.reqs_in_pool_flag
    ,ph.segment1 AS po_number
    ,prh.emergency_po_number
    ,prl.reqtopo_automation_failed
    ,prl.reqtopo_auto_failed_reason
    ,msg.context AS failed_reason_text
    ,DECODE(NVL2(prh.EMERGENCY_PO_NUMBER, 1, - 1), 1, prh.SOLDTO_LE_ID, - 1,
    NULL) AS SOLDTO_LE_ID
    ,prh.pcard_id
    ,prl.line_type_id
    ,prl.pcard_flag
    ,prl.requisition_header_id
    ,prl.requisition_line_id
    ,prl.prc_bu_id AS req_line_prc_bu
    ,prh.prc_bu_id AS req_header_prc_bu
    ,prl.req_bu_id
    ,prl.assigned_buyer_id
    ,prl.negotiated_by_preparer_flag
    ,prl.negotiation_required_flag
    ,prl.source_document_type
    ,prl.source_doc_header_id
    ,prl.vendor_id
    ,prl.vendor_site_id
    ,prl.line_location_id
    ,prl.item_id
    ,prl.category_id
    ,prl.amount
    ,prl.quantity
    ,prl.unit_price
    ,ph.document_creation_method
    ,ph.prc_bu_id AS po_prc_bu
    ,ph.document_status
    ,ph.po_header_id
    FROM po_headers_all ph
    ,po_lines_draft_all pl
    ,por_requisition_lines_all prl
    ,por_requisition_headers_all prh
    ,fnd_messages_b msg
    WHERE ph.po_header_id(+) = pl.po_header_id
    AND prl.po_line_id = pl.po_line_id(+)
    AND prl.requisition_header_id = prh.requisition_header_id
    AND prh.requisition_number IN ('RQ17135')
    AND prl.reqtopo_auto_failed_reason = msg.message_name(+)
    ORDER BY prl.requisition_header_id, prl.line_number; 

    Version:
    19B
  • Balakrishna Chaturvedula
    Audit Report for Purchase Order ApprovalsAnswered5
    Topic posted December 16, 2017 by Balakrishna ChaturvedulaBronze Trophy: 5,000+ Points, tagged Approvals, BI Publisher Reports, How-To, Orders in Procurement > Purchasing public
    Title:
    Audit Report for Purchase Order Approvals
    Summary:
    We are looking for a report which would show approval history for purchase orders
    Content:

    Hi All,

    We have built approval rules which span 2 to 10 levels. As part of audit, we need a report that would display approvers for every purchase order. I am looking for a standard report or a subject area which would fetch such details. Appreciate any pointers / suggestions. Thanks.

    Regards, Bala.

  • Nishanth B Jain
    Award Negotiation Export3
    Topic posted February 13, 2019 by Nishanth B JainBronze Crown: 15,000+ Points, tagged BI Publisher Reports, Business Intelligence, Customization, FAQ, How-To, Negotiation Award, Negotiation Creation, Setup, Sourcing Programs, Spreadsheet Related in Procurement > Sourcing public
    Title:
    Award Negotiation Export
    Content:

    Hello,

    Can we edit Award By Spreadsheet. Is there any report for this?

    If yes, where we can find the data model for this export.

    Thanks,

    Nishanth

    Image:
  • Ashish Gupta
    BI Publisher: Parameters not getting passed from custom ESS...1
    Topic posted November 6, 2019 by Ashish Gupta, tagged BI Publisher, BI Publisher Reports in Reporting and Analytics for SCM public
    Title:
    BI Publisher: Parameters not getting passed from custom ESS job to BIP report
    Summary:
    BI Publisher: Parameters not getting passed from custom ESS job to BIP report
    Content:

    Hi

     

    We have a requirement to create a custom BIP report with From and To date parameters. In addition to this, they want ESS job to be created for this BIP report to be run. We have created ESS job with 2 parameters but when we are running the job, parameters are not getting passed to BIP report. In xml and output, it shows blank for from and to date parameter.

     

    We also tried to deselect "Enable submission from Scheduled Processes" flag but in this case it passes only one parameter i.e. to date.

    Please advise how can we achieve this.

     

    Regards

    Ashish

    Version:
    19c
  • Dev Thota
    BPM Worklist: How long will the Approval History store in...2
    Topic posted August 29, 2018 by Dev ThotaGold Trophy: 10,000+ Points, tagged Approvals, Approvals/Notification, Approved Supplier List, BI Publisher Reports, Business Intelligence, Public Sector, Requisition Processing, Security, Setup in Procurement > Purchasing public
    Title:
    BPM Worklist: How long will the Approval History store in the system?
    Summary:
    BPM Worklist: How long will the Approval History store in the system?
    Content:

    BPM Worklist: How long will the Approval History store in the system?

  • Niamath Jeddy
    Can a SaaS BI Report fetch data from PaaS datastore?24.5
    Topic posted February 18, 2019 by Niamath JeddyGold Trophy: 10,000+ Points, tagged BI Publisher, BI Publisher Reports, Procurement in Reporting and Analytics for SCM public
    Title:
    Can a SaaS BI Report fetch data from PaaS datastore?
    Summary:
    Can a SaaS BI Report fetch data from PaaS datastore?
    Content:

    Hi,

    We have a custom screen in VBCS which stores data in a table. We intend to customize the PO Print on SaaS (standard BI Publisher report), to fetch data from the PaaS table (via  a REST get call). 

    Is this feasible?

    Regards,

    Niamath