OTBI
Discussion List
-
Report on Active/Inactive UsersWe have a list of users (not employees, these are users created in the security console; our implementation partner) and I want to report on these users and whether or n…Alex Cardenas 735 views 9 comments 1 point Most recent by Girish Bhatia Reporting and Analytics for HCM -
Email Notification Report for NudgesSummary: Email Notification Report for Nudges Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there a way to get the list of email …Parag Hiremath 11 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to limit prompt values to values displayed on analysis - OTBISummary: I'm building an analysis using the "Incentive Compensation - Attainments Real Time" subject area. One of the prompts in the dashboard that includes this analysi…Vitor Nakamura 115 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Report course. where we receive reports without information about who made them?Summary: Content (please ensure you mask any confidential information): regarding the reporting functionality in courses, where we receive reports without information ab… -
Need to pull in Seniority Date using SQL and add to an analysisSummary Adding Seniority Date to my Logical SQLContent Hi All, I hope someone is able to help me out. We currently have an Analysis that we were using to produce a repor…User_2025-02-04-08-51-08-912 850 views 3 comments 0 points Most recent by Kammarapalli Venkatesh-Oracle Reporting and Analytics for HCM -
Access run history & older report outputs of OTBI scheduled reportsHi! We have end users who sometimes request previous run versions of scheduled reports. Wondering if there is a way to access run history along with report data output o…Ameya_J 38 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need to build an analysis report of all pay periods that exist to dateSummary: I'm trying to build an analysis in OTBI that brings me all of the pay period names and dates for all Consolidation Groups in a Legislative Data Group. This is t…sarah_1000 22 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Link Produce Costing Setup Details with Assignment DataSummary: I am trying to link data from the following two subject areas:- "Payroll - Payroll Costing Setup Details Real Time" "Workforce Management - Worker Assignment Re…Mark Stoker 4 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Headcount is not being populated in Work Measure tableSummary Some employees have rows for HEAD others don'tContent Hi There, Does anyone know why HEAD information is populating for some employees but it is not for others? … -
What are the OOTB reports that we can leverage from a pricing standpoint?Summary: What reports do we get out of the box from oracle from a pricing perspective? Is there a report which we can use to export the Pricing Strategy assignments? Is …
-
Line Status supply Request CompleteSummary Some of the order lines gets stuck with the status "Supply Request Complete"Content Dear, Some of the order lines gets stuck with the status "Supply Request Comp… -
Convert OTBI number format in exponential format to Number formatSummary: Hi Community, for one of our integration, We create one OTBI report and exported to excel, we entered data for few columns in that excel and convert it to csv f…Subhash M V 51 views 2 comments 0 points Most recent by Subhash M V Payables, Payments & Cash Management
-
we joined two subject areas but when we apply single country it is woking fine but multiple not workSummary: Hi All, we joined two subject areas but when we apply single country it is woking fine but multiple not working. stlll searching mode ? subject area: workforce …AjayKumar Maddipati 22 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to extarct DDL of table in oracle fusion HCM/FSCMHi, We need to extarct DDL for few tables like column name, data type, size, primary key , foreign key constraints . We tried sql query approach but due to data type siz…hiteshsaroha 42 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
How to fetch attachments from OTBISummary: Hi Expert, Currently, I'm using "Recruiting - Recruiting Real Time" & "Recruiting - Recruiting Event Real Time" Analysis and want to see the attached file in my…Saher 171 views 2 comments 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Report to use in journeys e-sign task to pull employee job's job descriptionSummary: Hi, We would like to trigger a journey to internal employees when there is a job change action performed on their employee assignment. I see action "job change"…
-
Query to fetch 'Report Job Histories' data from 'Manage Job History'Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…jahanavi metta 123 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Estimation for Maintenance CostHello, the client requirement is to have an estimation of the Total maintenance Cost (resources + Repair) even before completing the Work order and transfer it to costr … -
Dashboard prompt for effective date reporting possible?Summary: Hi all, I have added SET VARIABLE PARAM_EFFECTIVE_DATE = '@{P_DATE}{@{system.currentTime}[YYYY-MM-DD]}'; into the advanced tab under prefix for a OTBI analysis …Ian.Gooderham 185 views 8 comments 0 points Most recent by Ian.Gooderham Reporting and Analytics for HCM
-
How to import a data from Oracle cloud to OTBISummary: Hi, we try to create a analysis in OTBI using a Payables Invoices - Installments Real Time Subject area, but we didn't get the any results, In ERP we have roles…Alex Pagliarini - Ninecon 11 views 1 comment 0 points Most recent by Abi Osborn Payables, Payments & Cash Management -
Recruiting Real Time: Application Questionnaire reports take several minutes to generateSummary: When trying to run a basic query from RRT Application Questionnaire, it takes several minutes to run the query. Does anyone have ideas on how to improve reporti… -
How to add custom paramter based on other custom parameter in Dashboard PromptHi Team, I need to create custom parameter with formula based on the value from the other custom parameter with formula. Category and Sub cateogry - both are from same f…Harish S 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How i can improve the running time for one report?Summary: Misdated Payroll Relationship timming out I used this formula: CASE WHEN "Payroll Assignment"."First Standard Earning Date" = MIN("Worker Payroll"."Payroll Star…ClaudiaManea 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Procurement CategorySummary: How to bring the browsing categories into OTBI analysis reports? Content (please ensure you mask any confidential information): Hi Experts, Would like to know h…
-
In what subject area can i find the details of a Return Lines (Return to Supplier)Summary: Hi In what subject area can i find the details of a Return Lines (Return to Supplier), specifically the details of the receipt number, RMA, Document Number (PO)…Johann Christian 32 views 5 comments 1 point Most recent by Becca Edwards Reporting and Analytics for ERP
-
Deploying the undeployed KFF's resolved the DFF's not appearing in OTBIWe have created a new DFF for POZ_SUPPLIERS. Deployed the DFF and ran the ESS Job : Import Oracle Fusion Data Extensions for Transactional Business Intelligence. The DFF…Yasasree Boosireddy-Oracle 131 views 11 comments 0 points Most recent by Becca Edwards Reporting and Analytics for SCM