OTBI
Discussion List
-
How to "decode" Notice Period UOMSummary: How do one decode Notice_Period_UOM in SQL/Query Builder Content (required): How do one decode Notice_Period_UOM in SQL, so that the output display e.g. days, m… -
OTBI Concat FormulaSummary: Concat formula Content (required): I need to create a field in OTBI to show last name, first initial. Is there concat formula I can use to show this? Version (i…User_2025-02-06-00-25-02-334 31 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Learning bi publisher report How to display learner activity's status and grade?Hello , How can we implement BI publisher report ,which displays the status and grade of activity of learners in a course. A course can have few offerings - and we would… -
Date Parameters in Headcount AnalysesSummary: I am just starting in OTBI Development and trying to understand how I achieve the desired analytic with results based on comparative dates. Content (required): …
-
Supplier Portal "Requiring Attention" - easy way to identify types of transactions that appear?Summary: Content (required): Is there an easy way to identify (or any existing documentation of) all the different types of transactions that can appear in the Requiring…
-
Authorizations Report (Expense Module)Summary: Authorizations Report (Expense Module) Content (required): Do we have any subject area analysis for Authorization? Business is asking out of box reports instead… -
Asset Area ( Work center) - in OTBI reportSummary: How to select the Asset area ( Related with Work center) in OTBI reports, unable to find this information in many subject areas. Is there any solution available… -
OTBI Report (Count Distinct - Accomplishments)Summary: Hello, I'm running an OTBI report. Is there a way to use count distinct in Accomplishments? Subject Area: Workforce Profiles - Person Profile Real Time But the …Hazel De Castro 351 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Having an issue while opening Analysis with HR Specialist roleSummary: I have an issue when I'm trying to open an OTBI analysis from the user account with Human Ressource Specialist role. But no issues occurred when I open it from …Evgeniya Repnina 21 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Compensation Zones in OTBISummary Is it possible to report on compensation zone configuration in OTBIContent Is it possible to pull compensation zone information into an OTBI analysis? Based on t…Anton Rzhanov 72 views 8 comments 0 points Most recent by Anton Rzhanov Reporting and Analytics for HCM
-
Learning assignment and Due dates updated with some datesSummary: A few learning records with the status of 'No Offering Selected' got updated with the assignment date of Dec 17, 2021 and Due date of Jan 16, 2022 with time sta… -
How to use current system date as a prompt and bring current year value as a column in OTBISummary: Hi Team, I have a requirement to use current system date as a prompt in an OTBI and bring current year as a static value in a OTBI. Please suggest solutions. Th…
-
Remove Historical rows from TM OTBI analysisSummary Remove Historical rows from TM OTBI analysisContent Hi team, We have an OTBI analysis for listing out recent talent ratings for all the of the employees created …User_2025-02-10-15-30-45-495 32 views 13 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Attendance Register Report for LearnSummary Attendance Register Report for LearnContent Does anyone have an Attendance Register Report for Learn? To list delegates within a specific ILT Offering / Activity…Ruzwan Akram 72 views 2 comments 0 points Most recent by Esther Hess Reporting and Analytics for HCM
-
Reporting Knowledge Article Deep LinksSummary: Accessing Knowledge Article Deep links via OTBI Content (required): I haven't been able to find a way, or the correct Subject Area/Folder, to possibly report on…JA1 31 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Is there a way to export a list of all courses within a Topic Community?Summary: Is there a way to export a list of all courses within a Topic Community? Content (required): Version (include the version you are using, if applicable): 21D Cod… -
OTBI Report - GL JournalsSummary: OTBI report for GL Journals - I would like to create a report to allows me to see the Legal Entity relationship between a Balancing Entity and a Related Party? …AVorster-Oracle 21 views 1 comment 0 points Most recent by Anca A-Oracle General Ledger & Intercompany -
Max Effective Date for Each ElementSummary: How to retrieve the max effective date for each Element. Content (required): I am trying to find the max effective date for each of the three Elements (differen…JA1 31 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Trying to create a calculated item using fields from two subject areasI have created a report using balances and calculation cards. The report will run and return data from both areas but when i try to create a new field using a formula th…Sharon Harper 31 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Subject Areas not fetching data properlySummary: "Workforce Management - Worker Assignment Real Time" subject area not fetching the data properly. Content (required): I am working in internal test instance, it…Raghavendra M 201 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Trial Balance complete in ErrorSummary: Trial Balance complete in Error Content (required): Trial Balance complete in Error when submitted by a user. Seems as if BI publisher is not link to the user. …