Posts

Posts

  • Juan Miguel Isip
    "Failed - IO Error" when Customizing Disbursement...Answered2
    Topic posted August 19, 2018 by Juan Miguel IsipBronze Medal: 1,250+ Points, tagged BI Publisher, Business Intelligence in Business Analytics > Business Intelligence public
    Title:
    "Failed - IO Error" when Customizing Disbursement Payment File Formats
    Summary:
    Can't Customize Disbursement Payment File Formats
    Content:

    I am trying to set up a new Payment Format called "MT9" which is specifically used by New Zealand Banks. According to Oracle Documentation (http://docs.oracle.com/cd/E51367_01/financialsop_gs/OCCAR/F1560030AN107C4.htm#F1192364AN1232D), it is recommended to Customize the seeded reports instead of manually uploading a Layout. However, when I click "Customize" on the report /Shared Folders/Financials/Payments/Disbursement Payment File Formats, I get the message "Failed - IO Error".

    Also, when try to go into the report and manually upload an RTF layout, i get an error: "Failed To Save Report". According to Doc ID 1937608.1 ('Failed To Save Report' Error in Disbursement Payment Files Report), the "Customize" option should be used, but that isn't working for me as well.

    Any clue on how I can resolve this? is this related to Roles? I believe I already have the BI Admin role.

    Image:
  • Ramesh Radhakrishnan
    "Update Supplier Keyword Search Index and Source to...4
    Topic posted June 9, 2019 by Ramesh RadhakrishnanBlack Diamond: 60,000+ Points, tagged Audit, Business Intelligence, FAQ, How-To, Sourcing Programs, Supplier Creation, Tip in Procurement > Supplier Management public
    Title:
    "Update Supplier Keyword Search Index and Source to Settle Counts Runs In every 30 Minutes and Errors
    Content:

    "Update Supplier Keyword Search Index and Source to Settle Counts Runs In every 30 Minutes  and Errors and it is not generating any error log. Any pointers about this program how to troubleshoot this program. Also I see below note relevant to this program

    "Update Supplier Keyword Search Index and Source to Settle Counts Runs In every 30 Minutes (Doc ID 2474423.1)
    Version:
    R13-19B
  • Brian Hall
    (OAC) Pie/Donut Chart Legend
    Topic posted September 19, 2018 by Brian HallSilver Medal: 2,000+ Points, tagged BI Publisher, Business Intelligence in Business Analytics > Business Intelligence public
    Title:
    (OAC) Pie/Donut Chart Legend
    Summary:
    Looking for a way to show the Leger value/Text/Titles overtop of the Value
    Content:

    I am looking for a way to show the Leger value/Text/Titles overtop of the Value  (Example: 90% "failed", 10% "OK")

    Version:
    12
  • Joe Jesky
    Ability to use AD Groups in Traditional BICS Environment?1
    Topic posted August 7, 2018 by Joe Jesky, tagged Answers, Business Intelligence, OBI in Business Analytics > Business Intelligence public
    Title:
    Ability to use AD Groups in Traditional BICS Environment?
    Summary:
    Using SSO to get users and groups
    Content:

    Has anyone successfully been able to setup the SSO in BICS and also grab the groups from AD in a Traditional BICS? Is this possible?

     

     

  • BHARAT VUTUKURI
    Accesing Data from OAAC (Oracle Autonomous Analytics...1
    Topic posted November 9, 2018 by BHARAT VUTUKURIRed Ribbon: 250+ Points, tagged Autonomous, BI Publisher, Business Intelligence, Data Sync in Business Analytics > Business Intelligence public
    Title:
    Accesing Data from OAAC (Oracle Autonomous Analytics Cloud) Object Storage
    Summary:
    Accesing Data from OAAC (Oracle Autonomous Analytics Cloud) Object Storage
  • Hong Gao
    Access to Supplier BI Reports45.0
    Topic posted September 25, 2018 by Hong GaoGold Medal: 3,500+ Points, tagged Business Intelligence, Security, Tip in Procurement > Supplier Management public
    Title:
    Access to Supplier BI Reports
    Summary:
    Function security for accessing supplier related OTBI reports
    Content:

    As part of supplier administration and management, internal users want to leverage Oracle Transactional Business Intelligence (OTBI) to review seeded reports as well as construct ad-hoc reports to meet business requirements. Seeded job roles like Supplier Administrator or Supplier Manager has all the function security set up out of the box to satisfy the reporting needs for managing suppliers. However, from time to time, you may want to grant other functional users the ability to review and build reports related to supplier data.

    To achieve that, here are a couple of function security considerations.

    1) there are currently four BI subject areas that are dedicated to supplier and supplier profile data: Supplier - Supplier Real Time, Supplier Registration - Supplier Real Time, Supplier - Profile Change Request Real Time, and Supplier Import - Supplier Real Time.  Content in these subject areas are all secured by duty role Supplier Master Data Transaction Analysis Duty. If your reporting need requires information from these subject areas, this duty role is necessary to access the content.

    2) apart from the duty role above, to have the ability to build an ad-hoc report, the user would also need to have the BI Author role.  

    Within the four supplier content subject areas, there are a few seeded reports:

    a) Supplier Export Reports (catalog path: /Shared Folders/Procurement/Embedded Content/): this folder contains seeded reports that can be used to extract data to populate the import supplier FBDI templates for mass update:

    •  
    • Export supplier data for import template
    • Export supplier addresses data for import template
    • Export supplier business classifications data for import template
    • Export supplier contacts data for import template
    • Export supplier contact addresses data for import template
    • Export supplier products and services category data for import template
    • Export supplier site assignments data for import template
    • Export supplier sites data for import template
    • Export supplier site third-party relationships data for import template

    b) Listing of Supplier Profile Change Requests (catalog path: /Shared Folders/Procurement/Supplier Profile Change Request/Transactional Analysis Samples/): this report allows users to search and report on profile change requests across the supply base.

    User can access the seeded reports by browsing through Catalog.  However, to properly view the data in these reports, user will also need to have the Supplier Master Data Transaction Analysis Duty.

    A special note for supplier portal users:

    • While collaborating with suppliers through Supplier Portal, it's important to note that supplier portal user does not have a navigation path to Report and Analytics work area to build ad-hoc reports.  On Supplier Portal landing page, there is an infolet for Transaction Reports.  From there, user can drill down to an OTBI dashboard with seeded reports on their transactions.
  • Overaj K
    Action required in BI publisher 11g ? when database upgrade...
    Topic posted October 23, 2018 by Overaj KRed Ribbon: 250+ Points, tagged BI Publisher, Business Intelligence in Business Analytics > Business Intelligence public
    Title:
    Action required in BI publisher 11g ? when database upgrade from 11g to 12c
    Content:

    Hi,

    Currently we have the oracle BI publisher 11.1.1.9 which is using database 11.2.0.3 for RCU creation and business related data's.

    Now our DBA team planned to upgrade the database from 11.2.0.3 to 11.2.0.4 or 12.1.0.2.0.

    My question is , Do we need to upgrade our RCU schema's once database upgrade or no changes required?.Any task we need to do before pre upgrade?

    Also Do we need to change anything in BI publisher side?  I can't able to find any doc related to this question.

    Please share your thoughts.

     

    Regrads,

    Ove

    Version:
    11.1.1.9
  • Jose Casquero
    add working days to a DateAnswered11
    Topic posted July 1, 2019 by Jose CasqueroGreen Ribbon: 100+ Points, tagged Business Intelligence, OBI in Business Analytics > Business Intelligence public
    Title:
    add working days to a Date
    Content:

    Hi there

    i need to calculate final dates as result of adding working dates to previous dates in OBIEE

    is there any way how to do this in OBIEE when defining a new variable (date data type) using a formula in the edit column formula of the variable?

     

    Regards

     

    Version:
    Oracle® Business Intelligence Enterprise Edition 11g Release 1 (11.1.1)
  • 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
  • Greg
    Analysis measure keeps automatically rounding percentages
    Topic posted April 12, 2019 by Greg, tagged Business Intelligence, OAC Enterprise Edition in Business Analytics > Business Intelligence public
    Title:
    Analysis measure keeps automatically rounding percentages
    Summary:
    .4768594% on the database is displayed as 4.80%. How do I change it?
    Content:

    ".4764594%" on the database side is displayed as 4.80% in an OAC Analysis. How do I change it to show 4.76%? On the application side, I tried modifying the Column Properties > Data Format > Override Default Data Format. Then I chose Treat Number as Percentage and Decimal Places 2 but nogo. I checked that the data format is a DOUBLE in the BI Admin Tool. I do see an option to change the data type the BI Admin Tool to one of the following: "DATE, INT, LONGVARCHAR,UNKNOWN, VARCHAR". Not sure if that would resolve the issue.

     

    Thanks

    G

     

    Version:
    OAC Classic