OTBI
Discussion List
-
"Go Noto" Font Used in PDF OutputRegarding the default "Go Noto" font used in PDF reports generated by BI Publisher or OTBI, could you please let me know whether the font available for download from the… -
Query or the table that contains columns of the Account Analysis ReportSummary: Content (required): Hello everyone, I have a requirement to make a custom report for the Account Analysis Report. I need to pick some of the columns in the seed…Sushan Peiris 572 views 8 comments 0 points Most recent by User_K7YG4 Reporting and Analytics for ERP -
fnd_sessions has rows with last_connect that is after the employee last logged inSummary: We are trying to build a report to show who logged in that day. If a person logged in multiple times, we need to report the last time user logged in. Person 464…
-
Looking for Questionnaire Question / Check-In Questionnaire manager and worker response textI’m currently working on building an OTBI report to extract “Questionnaire Question” responses from the Workforce Performance – Performance Rating Real Time subject area…
-
Create sequential number for each row in OTBIneed help generate a sequential number for each row when we run or open Result in OTBI.Peter Obong 11 views 3 comments 0 points Most recent by Massimo D.-Oracle Reporting and Analytics for SCM
-
Scheduled Work Order Traveler print process causing duplications on shop floorWe currently have an ESS job scheduled to run every hour to print all work orders in the "Released" status. The problem we are having is that it will print duplicates if…
-
OTBI reports for talent review doesn't work with custom objectsSummary: Content (please ensure you mask any confidential information): Hello experts, we created OTBI dashboards for talent review and we enabled filter by talent revie…Valerio Curzi 11 views 1 comment 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
We are trying to obtain a Audit report which captures audit for customer bank account changes.Summary:We are trying to obtain a Audit report which captures audit for customer bank account changes. The business need is to capture the following details for audit: I…
-
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 31 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 41 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 7.3K 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.UPDATE: V5 can now assemble up to 10 queries, with up to 15 inner joins. SummaryCombine up to 10 analyses from 10 different subject areas ContentWhile building a report … -
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 196 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 31 views 0 comments 0 points Most recent 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 Most recent 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 62 views 1 comment 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM