OTBI
Discussion List
-
Need Join Condition column for tablesSummary: Hi team, I have two tables to join hrc_dl_message_lines hdml and HR_ALL_POSITIONS, where i need position code from HR_ALL_POSITIONS table by joining with below … -
How to group by formatted date column AnalysisSummary: Hi, we create analysis to count PO created yearly, so create Analysis include bill-to-location, creation date columns ,we want to group by bill-to-location, cre…
-
table name to fetch 'Write to person profile on completion' In learningSummary: Which table stores information about the Field 'Write to person profile on completion' In learning Navigation :- Course ->Skills and qualification -> manage -> …Shubham Wadekar-Oracle 1 view 0 comments 0 points Started by Shubham Wadekar-Oracle Reporting and Analytics for HCM
-
how to get the Annualized salary of terminated employeesSummary: I just need basic details like thePerson number, Name etc of terminated employees with their annual salary. How do I get this in the OTBI report ? Content (plea…Trupti Khodke 41 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
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 352 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 558 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 13 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. 189 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 297 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…