OTBI
Discussion List
-
Recruiting Offer > Message Notification OTBI FieldGood Day Experts, Is the 'Message Text' field in recruiting module in fusion available in OTBI Recruiting Real Time subject area? Navigation from fusion is Offer > Actio… -
We need to update the #average headcount, #leavers, period start and period end headcount with OTBIWe need to Modify headcount columns in an Annual Turnover dashboard page. We need to update/review the #average headcount, #leavers, period start headcount, and period e…
-
Task Type in Subject Area Workforce Management - Checklist Real Time - Checklist Task TemplateSummary: 1- Looking for the Task Type in the Subject Area Workforce Management - Checklist Real Time. This is to pull the configured task type for various tasks in the j… -
ESS Jobs DashboardSummary: ESS Jobs Dashboard Content (please ensure you mask any confidential information): Hi Team, Greetings! As you know -we submit/schedule multiple ESS jobs. Is ther…Parag Hiremath 373 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Pricelist FBDI Success and Error SQLSummary: Pricelist FBDI Success and Error SQL Content (please ensure you mask any confidential information): We are using FBDI for Pricelist Upload. Is there a SQL avail…
-
How to show 0 value instead of null value in a calculated formula column in OTBI report?Summary: How to show zero value instead of null value in a calculated formula column in OTBI report Content (required): I have a column 'Variance' which has value that i…Abhishek Shukla 1.2K views 6 comments 0 points Most recent by Pooja_hb-Oracle Reporting and Analytics for ERP -
How do I write a number in full in the report?Summary: I need to write the salary amount in full, for example, R$ 1,000.00 (one thousand dollars). I know it's possible using a PL/SQL function, but I couldn't do it i…Simiao Oliveira 11 views 3 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
How to translate Amount in Words from English to Arabic language in rtf templateSummary: we have a requirement to print Payment amount in Words (English) to Arabic language in check template. The expectation is that, translate below given English te…SireeshaJaladi 566 views 9 comments 0 points Most recent by ArjunReddy88 Reporting and Analytics for ERP
-
How to use Special Handling attributes in OTBI analysis?Summary: As of the 24D update, there is the new feature to use special handling type attributes within the "Procurement - Purchasing Real Time" subject area (https://doc…
-
Subtotal is not calculated correcting for one of the custom calculated measure in the OTBI reportSummary: I have created a custom OTBI report DPO (Days Payables Outstanding) to look at the average days to pay vendor. The last column is a calculated measure based on …
-
How to create an OTBI report to pull information on learning assignment deleted date?Summary: How to create an OTBI report ( or what are the subject areas ) that helps to pull information regarding learning assignment deleted date? As part of 24 C New fe…
-
SQL Link between AP and Projects ?Summary: Report which shows project transaction that have flown through to AP Content (required): Hi Does anyone know the links/joins between AP and Projects, we are try…
-
Embedded OTBI Analysis Refresh IssueHi, I'm using an embedded OTBI Analysis within Fusion HCM on Candidate Submission Profile. I'm running into a cache issue where if the report is viewed before the result… -
How can I track changes on Maintenance Asset Notes?Summary: How can I track changes to Maintenance Asset Notes and add them to the History tab? Content (please ensure you mask any confidential information): Our client wa… -
Unique Learner Record - Learning Records Real TimeSummary: I am needing to produce results that provide a unique set of learner records for each training title in the analysis. I need the formula to produce the record t… -
Getting Error when adding Questionnaire Text and Response Text for Observer Checklist reportsSummary: Getting Error Content (required): Has anyone put together a step by step in creating the Observer Checklist Responses? I can't find all of the options listed in… -
OTBI Report integrated within performance document is not loading first timeSummary: OTBI Report integrated within performance document is not loading first time Content (please ensure you mask any confidential information): I have OTBI report c…Neha Thakre 2023 11 views 2 comments 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM -
Performance OTBI to extract Task Status, Section Names, Rating LevelsDears, we have a requirement to build an Analysis to extract performance document task status and ratings given to each document section. To do so we are crossing "Workf…Domenico P. 194 views 1 comment 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM
-
Search AHCS transactions from UI via search criteria of Supporting Reference ValueSummary: There is a requirement to search AHCS transactions from UI via search criteria of Supporting Reference Value. Please suggest a workaround if current functionali…Himanshu_Parmar827 31 views 1 comment 0 points Most recent by Anca A-Oracle Subledger Accounting & Accounting Hub
-
Fusion HCM - OTBI Report - Can't view other employee's data only my own ?Summary Fusion HCM - OTBI Report - Can't view other employee's data only my own ?Content I have created a OTBI report with the subject area 'Workforce Management - Worke…Ruzwan Akram 299 views 15 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI report returning incorrect row count if certain columns are not in the selected columnsWe have a report that does not return the accurate row count if the Acquisition Date, Internal Segment, and Department Name are not in the Selected Columns. If the Acqui…
-
Access to learning items based on legal employerSummary: We have a requirement where learner should access courses based on their legal entity. Foe example: Learner whose legal employer is XYZ should access courses cr…
-
Fixed Asset - Creating Cross Subject Area without SQLI am creating a cross Subject Area OTBI and having a problem. Fixed Asset- Asset Depreciation Real Time Fixed Asset- Asset Transactions Real Time When adding Asset Tran…Nao-Oracle 11 views 1 comment 0 points Most recent by Louise Gareau - Support - Oracle-Oracle Assets -
for-each OTBIHello everyone, I have the following problem: I have a report that is grouped by several groups and subgroups. I need to be able to total the columns for each subgroup a… -
accounting asset inquirySummary: Hello everyone, I am making a report from which I need to obtain the following value from the box in red. I can't find the table in which I can locate those val…
-
QUERY PURCHASE ORDERS WITH RECEIPTSHello everyone, I require a query for a report in OTBI that allows me to reach those values (those in the red box) when I pass the purchase order number as a parameter.
-
Need to build report between Task and Call Report (created via Task Page)Summary: Created a Task > open Task Detail > Action > Create Call Report. So now we have Task and its linked call report. Now we want to create a BI Report which should …AMIT KUMAR YADAV 41 views 9 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales
-
Report data size exceeds the maximum limit (524288000 bytes). Stopped processing.Summary: We were given a SQL query to pull journal entries for our auditors and it worked successfully for FY22. We tried to run the report again for 2023 and received t…hannah_barry 8.1K views 7 comments 0 points Most recent by Shankar-Oracle Reporting and Analytics for ERP