OTBI
Discussion List
-
Country of Origin values are not appearing on the OTBI pageHi Community Need help on below - @Yann Consolin-Oracle @Lynn Warneka-Oracle @Adnan Siddiqui-Oracle@Shyam Patel @Victor Martin In the Country of Origin field, the values… -
Physical Inventory Adjustment ReportSummary: Physical Inventory Adjustment Report Content (please ensure you mask any confidential information): Is there any Seeded report to view the adjustment made durin… -
We are unable to create OTBI report for "Physical Inventory Adjustments" Pending Adjustment statusSummary: As per the user’s request, they require a report for “Approve Physical Inventory Adjustments” that identifies the items that were rejected. User reviewed OTBI (… -
Derived Standard Working Hours - SQLHi all, we're looking to add the following field to a SQL built report using BIP. 'Derived Standard Working Hours' (we can see this in Work Relationship - Assignment Det…MikeW 1.6K views 12 comments 0 points Most recent by Kuldipsinh Rajput Reporting and Analytics for HCM -
Why are expenses in my OTBI report multiplied?Summary: I'm trying to build a report in OTBI that details the status of corporate card transactions. We would like to see what transactions have not been placed on an e… -
Process Imported Shifts log file SQL queryHi Team, We are using the REST API to load shift data and running the Process Imported Shifts job to process the imported records. We would like to understand which data…Nalsoft Pvt Ltd 31 views 2 comments 0 points Most recent by Nalsoft Pvt Ltd Reporting and Analytics for HCM -
Customize the Organization Chart ReportSummary: Hi All, Can you please helps us with any Sample BI or OTBI Report for Employee Organization Chart Content (please ensure you mask any confidential information):…Vamsi Jeela 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Please help to locate the fields in the Subject Area "Inventory - Inventory Transactions Real Time"Please below screenshot, I found there exist a column ‘Transaction Value’ in Subject Area ‘Inventory – Inventory Transactions Real Time’ , I suggest it is the Inventory … -
where can we find the PDF document OTBI_Cross_Subject_Area_Reporting_Guidelines ?Summary: this document is mentioned in few conversations but the link is broken ; Please provide a valid link to the PDF Content (please ensure you mask any confidential…Carmen Marinescu 11 views 2 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP -
Conditional Syntax or IfElse Syntax for excel template in Oracle Fusion Cloud SCMSummary: How to include condition on any attribute to generate the output in xls template? need correct syntax for Content (please ensure you mask any confidential info… -
ZATCA verified XML embedded inside PDF/A3Summary: We have a requirement to generate the invoice output in PDF/A-3 format. Specifically, we need to embed a ZATCA verified XML file (generated from another report)…Shatha Bin-Nooh 21 views 0 comments 0 points Most recent by Shatha Bin-Nooh Receivables & Collections -
Learning records - courses without any enrollmentsSummary: I have just found out that the learning management real time subject area will be deprecated so we need to rebuild our report using the learning records subject… -
Department Hierarchy data in the "Workforce Learning - Learning Records Real Time" subject areaSummary: we are combining the "Workforce Learning - Learning Records Real Time" and "Workforce Management - Worker Assignment Real Time" subject area's to get the count …Sreekantha M 2 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Are the Infolets available in the Analytics section be available by default?Summary: Are the Infolets available in the Analytics section of the Oracle Fusion application be available by default or are we required to do configuration to make it a… -
What is table of Supplier Address Transaction Tax?Content Hi all. I need to know what is name of table that stores datas of Supplier Address Transaction Tax. Manage Supplier - Address Details - Transaction Tax. See atta…
-
Purchase Order Report through View PDF ButtonCreate a custom report for PO including PO status, when run it through View PDF button after it is approved the po not updated untill a change order is created and appro… -
What are the limitations for BI Published reports?Summary: What are the limitations for BI Published reports? Content (please ensure you mask any confidential information): What is the maximum number of rows I can expor…Max Prestes 1 view 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
For recording External Learning, we intend to create a BI Publisher (BIP) reportSummary: Hi Team, For recording External Learning, we intend to create a BI Publisher (BIP) report that displays employee details along with the approver information and… -
Proposed User and System Person Types in the Recruiting Real Time Subject AreaSummary: I'm building a custom version of the delivered Recruit to Hire dashboard. For the prompts, I want to be able to pull in the proposed User Person Type and System…Jessica D 1 view 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Participant Feedback Report including feedback from 360 performance - need helpSummary: Hi there, hoping someone could help me out: This report using Subject Area: Workforce Performance - Requested Feedback Real Time does not include the participan…Marilyn O 21 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Issue: Barcode generated in BI Publisher Report but Not Scannable in OTMSummary: We are attempting to generate a barcode in a BI Publisher report. In our RTF template, we tested several barcode fonts—including Code 128, Libre Barcode 39 Exte…Mikhil Bhan 72 views 4 comments 0 points Most recent by Vasanthakumar Karuppannan Transportation Management -
Participant feedback questionnaire reportContent Hi, I am not able to pull a report for participant feedback questionnaire. Can someone help? Regards, Nivya Version 19C -
SQL to retrieve Supplier, sites and Sites assignments BUSummary: Hi, Can any one share the script for retrieving list of active suppliers and their sites and site assignement BUs. Many thanks for your help Content (please ens… -
Relative URLs for BI Publisher Reports After Migration from OAS to OACSummary: Relative URLs for BI Publisher Reports After Migration from OAS to OAC Content (please ensure you mask any confidential information): Following the migration fr… -
Can you please investigate why we cannot use the permissions against folders in OTBI ?Summary Why we cannot use the permissions against folders in OTBI ? what happens now is: when we got enough access, we can set up a specific permission at a certain leve… -
How to display amounts for different Forecast Plan Types in OTBISummary: Content (please ensure you mask any confidential information): Hi, I am trying to display Forecast cost amounts for different Forecast Plan Types (e.g. Year 2, … -
Where can we get the History of the Position for a report.Summary: I am trying to do a report for Position Details and trying to find the 'History' changes which can be found in the Position "Details" page just below the "Grade…