OTBI
Discussion List
-
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 13 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 32 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 1 view 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 81 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… -
Output Manager Hierarchy in OTBI with a column for job title following each Parent Manager nameSummary: Output Manager Hierarchy in OTBI with a column for job title following each Parent Manager name Content (please ensure you mask any confidential information): H… -
Position History ReportingSummary Is it possible to report on changes to positions themselves over a period of timeContent I have a requirement to report on historical changes to positions in OTB… -
Not able to capture failure events on the maintenance work orderSummary: Not able to capture failure events on the maintenance work order Content (please ensure you mask any confidential information): We are trying to add failure eve…Abhishek Kumar Ranjan 1 view 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Maintenance -
Is there any table that stores the IDR invoice scan details in Oracle Fusion ?Summary: I am looking for a query/table name to get the IDR invoice scan details. There is a table AP_IDR_INVOICE_TRACE_DYD but scan details doesn't get persisted for lo…Dipak Das 51 views 3 comments 0 points Most recent by Dipak Das Payables, Payments & Cash Management -
How to develop a BIP / OTBI report to fetch details from VBCS pageSummary: Hi Team, We have a customized VBCS page for Inventory transactions. Our requirement is to develop a BIP / OTBI report to fetch details from the VBCS page. Is it…Dhilip Kumar P. 51 views 6 comments 0 points Most recent by Abdullah Samy-Oracle Reporting and Analytics for SCM -
If anybody worked on ZPL format for label printing can you please share the ZPL formats and outputsSummary: We need to implement zpl format to print the labels using zebra printer. So need any samples of ZPL formats which are already implemented Content (please ensure…