OTBI
Discussion List
-
How to Get Response Text for Performance Document QuestionnaireSummary: Have a report I pulled from Shared Reports as it gets me closer to what I am trying to pull, but it still leaves a blank in the Response Text section. I am tryi…Aaron Reynolds 32 views 2 comments 0 points Most recent by Maciej Kozakiewicz Reporting and Analytics for HCM -
Counting Questionnaire Responses from Performance DocumentSummary: Trying to count the responses to a question within a performance document. Performance is very slow and it's hard to validate the results. Content (please ensur…Rob F 42 views 3 comments 0 points Most recent by Maciej Kozakiewicz Reporting and Analytics for HCM -
Query for Business Units and Legal Entities mapping for Payables.Summary Need query to fetch Business Units and associated Legal Entities mapping for Payables.Content Hi All, I am having requirement to fetch all the Legal Entities ava…User_SJJQT 6.9K views 5 comments 0 points Most recent by Tejeswar J E Reporting and Analytics for ERP -
OTBI complex query assembler. UPDATE - now with 10 subject areas.https://us.v-cdn.net/6034893/uploads/IUFR0AQN0NRH/logical-sql-assembler-v5.xlsx UPDATE: V5 can now assemble up to 10 queries, with up to 15 inner joins. SummaryCombine u… -
Field Created on in OTBISummary: In which subject area of OTBI HCM can the field created on of an action be found?
-
A SQL query of privileged resources in the role FSD sectionSummary: Hi All, Can anyone share a SQL query on how to retrieve privileged resources? inside the role of the FSD section oracle provides information about the privilege…Eliran Hadad 41 views 7 comments 0 points Most recent by Eliran Hadad Reporting and Analytics for ERP
-
How to filter out Contg Worker in Analysis | Workforce Management-Absence Calendar Details Real TimeSummary: Subject Area: Workforce Management - Absence Calendar Details Real Time Question: How can I filter out/ not include Contingent Workers in Analysis ? System Pers… -
Getting error when running OTBISummary: Getting error when running OTBI analysis using Benefits - Person Information Real time Content (please ensure you mask any confidential information): Hi, Gettin…
-
How to remove access to Approval Group in BPM worklistContent We need to remove the access to Approval Group in BPM worklist for edit/update for all business users and only IT team should have access. Which role/previlege c…DPM 48 views 4 comments 2 points Most recent by SyedMustafaArshad Payables, Payments & Cash Management
-
How to report recognized revenue by Item Code in Oracle Fusion AR with Revenue Recognition enabledSummary: We need to report recognized revenue amounts by Item Code in Oracle Fusion Accounts Receivable. However, since Revenue Recognition (Unearned/Earned Revenue) is …
-
Learning Initiative not assigning course to all learners from analysis report criteriaSummary: Learning Initiative not assigning course to all learners from analysis report criteria Content (please ensure you mask any confidential information): We have cr…
-
Is it possible to create a DFF on Inventory Balance (On-Hand)?The goal is to tag an inventory with Project Details. The business doesn't want to utilize the 'Project Transfer' transaction, as it would create an additional charge to… -
Virus scanner not reachable error when unarchive reportSummary: Virus scanner not reachable error when unarchive report Content (please ensure you mask any confidential information): My Client Groups > Reports and Analytics …Junade_Shujaat 110 views 2 comments 0 points Most recent by Junade_Shujaat Reporting and Analytics for HCM
-
Unable to extract OTBI Italian Collective agreements information for WorkersSummary: Content (required): Hi team, We are unable to extract standard fields on contracts for Italian Employees related to collective Agreements with OTBI. Do you have…Gabriele Falso-Oracle 11 views 10 comments 0 points Most recent by Luca Trabucco Reporting and Analytics for HCM -
Common Question: How to Ask for HelpSummary: How to ask for help in Reporting and Analytics for HCM Content: 1-Start by naming your subject area. If you don't know that, see: Common Question: In what parti…Gail Langendorf-Oracle 82 views 2 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Common Question: How to Create a Table Style PromptSummary: The attached video shows how you can create a table style prompt. This is useful when you can't have a dashboard, but table prompts don't offer multi-select. Co…Gail Langendorf-Oracle 32 views 0 comments 0 points Started by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Common Question: How to paste or copy an XMLSummaryExplains how to paste an XML ContentOften you may see sample reports in this forum, and this how you copy and paste the XML. 1-select new analysis 2-select a subj…Gail Langendorf-Oracle 129 views 2 comments 4 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Common Question: How to Edit an Analysis in a DashboardSummary: Explains how to edit an existing analysis in a delivered dashboard. Content: In the relevant section on the xyz properties button, select Edit Analysis. Use Sav…Gail Langendorf-Oracle 11 views 0 comments 0 points Started by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI result to show in one lineDear Team How to show the OTBI result in one line, instead of showing them in multiple lines?Surendar 1 view 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Need some practical examples or scenarios where we should have negotiation outcome as BPA/CPASummary Need some practical examples or scenarios where we should have negotiation outcome as BPA/CPAContent We have to give demo to your client on basic understanding o… -
Performance Document Acknowledgement Task Status and Completion DateSummary: We're using the Oracle Cloud HCM Talent Management > Performance Management performance document to manage and document performance improvement plans (PIPs) and…Angie Elliott 53 views 1 comment 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM -
Is there any way to display the dashboard in inventory management by sub inventory instead of orgThe customer is requesting to display infolets from the Inventory Management page grouped by subinventory, rather than organization-wide data. Can you please confirm if …Manojj Basetti-Oracle 21 views 2 comments 0 points Most recent by Adnan Siddiqui-Oracle Inventory Management
-
Common Dimensions between Subject Areas in OTBIanyone has a list of Common Dimensions between Subject Areas in OTBI? at least 2 or 3 different Subject Areas?
-
Issue with OTBI – General Ledger Journal Real Time DashboardWe are currently experiencing an issue with the OTBI – General Ledger Journal Real Time Dashboard. Specifically, some of the accounting segments are not visible in the d…Kinjal Patel-Oracle 91 views 2 comments 3 points Most recent by Rashmitkumar Dodiya-Oracle Reporting & Analytics for Fusion Service
-
I am looking for a way to report scheduled hours for each employee for each pay periodSummary: I need to compare reported hours vs. scheduled hours Content (please ensure you mask any confidential information): Version (include the version you are using, …Jennifer Johnson 11 views 0 comments 0 points Started by Jennifer Johnson Reporting and Analytics for HCM
-
Expected Effort values not populatingHi team, We are experiencing an issue where we receive really inconsistent results for the 'Workforce Learning - Learning Records Real Time' Expected Effort value. Some …
-
report /audit to track any changes done to auto provisioning rules(HCM role provisioning rules)Summary: We need to get a report /audit for any changes done to auto provisioning rules(HCM role provisioning rules). Please help us on how to achieve this requirement. …Jagadesh S 91 views 5 comments 2 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Latest data changes are not reflecting in the OTBI report immediatelySummary: Hello All, We have an AOR drill-down OTBI report, but the latest changes to data are not reflecting immediately. For example, when we assign an AOR to an employ…Nusrat Shaheen 93 views 8 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
Blank Specialization Sections and Activities from Workforce Learning - Learning Records Real Time.Summary: When using the Workforce Learning - Learning Records Real Time Subject Area we are getting Blank values for the Specialization Sections and Activities. We are u…David Bean - BW 91 views 7 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM