OTBI
Discussion List
-
How to add a date promptSummary I would like to add an 'As At' date prompt to an existing basic employee analysis reportContent Hi, I'm relatively new to OTBI and unable to add a 'as at' date p…User_2025-02-05-22-44-35-842 145 views 14 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM -
How to get the last incumbent date for vacant positionsSummary Trying to get details on vacant positions as to when it was last filledContent Looking to get whether the position ever had an incumbent and if so what the last …Mario B 57 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to identify employees who haven't created any performance goals and those who haveSummary Looking to create a quick reference report for Division heads to see which employees have created goals and which have notContent I have been trying to use the G…Mario B 186 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Future Project Start Date - Project details for Project manager not been foundContent Hi All, We have issue where in the project start date is in Future , lets say 1- Jun - 2020 and the project manager is also assigned to the project. Now when we …User_2025-02-06-13-19-17-977 53 views 1 comment 0 points Most recent by Sampath Banda-Oracle Project Management
-
Report completed in errorsSummary OTBI report completed in errorsContent Hi all, I have custom a OTBI report with data model and layout. Also, I have defined the ESS job in SaaS for user to submi…User_2025-02-04-05-26-22-197 37 views 3 comments 0 points Most recent by Sahil_Makhiza Reporting and Analytics for ERP
-
Using external data in OTBIContent Hi folks! help needed! We are implementing a manager dashboard, where we need to use default expense account field. As confirmed in the following post…Nicola Petri 41 views 3 comments 0 points Most recent by Sahil_Makhiza Reporting and Analytics for HCM
-
Need to report on hires, terminations, promos, transfers between sub-departmentsSummary I need to produce a monthly report showing key assignment events and movement between sub-departments (custom field on assignment record)Content I have a require…James Hoffmann 117 views 22 comments 1 point Most recent by James Hoffmann Reporting and Analytics for HCM
-
Daily Breakdown ProcessSummary Workforce Management Absence Calendar Details Real TimeContent Hi, I've received a request to build an absence report using the 'Workforce Management Absence Cal…User_2025-02-05-22-44-35-842 37 views 8 comments 1 point Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
ExternalReportWSSService -> runReport failing with error 415 Unsupported Media TypeContent I am trying to run a simple report from pl/sql using ExternalReportWSSService -> runReport and it is failing with error 415 Unsupported Media Type. The same payl…Murthy Kodavati 140 views 1 comment 0 points Most recent by Murthy Kodavati Reporting and Analytics for ERP -
What View Object uses GL_DAILY_RATES in 20A?Summary I need a VO that uses the data in that table to export via BIACC.Content Hi. I need to export the daily currency rates my company loads in Oracle. I checked the …User_2025-02-07-06-48-26-537 39 views 5 comments 0 points Most recent by Gabriel Grigorie-Oracle Reporting and Analytics for ERP
-
How to remove html tags from report outputContent Hi team, We built some Analysis based on Sourcing related subject area's Where we see some html texts in the resulting columns like below. How remove these sufix…Nishanth B Jain 144 views 5 comments 0 points Most recent by Anandakrishna Thamballa Reporting and Analytics for ERP -
Create a prompt on a calculated fieldContent Hi, can you suggest a way to create a prompt based on a calculated field? Thanks a lot! NicolaNicola Petri 26 views 1 comment 0 points Most recent by Gabriel Grigorie-Oracle Reporting and Analytics for HCM
-
How to prevent closing of work order depends on the PR/PO stausSummary How to prevent closing of work order depends on the PR/PO stausContent Hi Everyone, We are implementing manufacturing process for one of our client and we are us… -
The Data is of zero or negative value and cannot be displayedContent Hello, Is there a way to customize/change the message which returns when a column result is zero? 'The Data is of zero or negative value and cannot be displayed'…Susan Anderson 42 views 4 comments 0 points Most recent by Susan Anderson Reporting and Analytics for HCM -
Performance Document Submission Date and HourContent Hello experts, How can I track the Performance Document Submission Date and Hour in reporting? Are there any field in OTBI reporting that allow me to get these i…Samanta Lorando 14 views 1 comment 0 points Most recent by Gabriel Grigorie-Oracle Reporting and Analytics for HCM
-
Cost Allocation - KFF setupSummary Provides step by step points on how to configure and manage the Cost Allocation Key Flexfields.Content To generate costing results for your payroll run results a…Tanvi Jain-Oracle 275 views 3 comments 4 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Fetching resignation reason and separation/resignation type in sqlSummary Fetching resignation reason and separation/resignation type in sqlContent Hi all, How to fetch resignation reason and separation/resignation type(ie.resignation …User_2025-01-29-01-27-20-754 680 views 12 comments 0 points Most recent by User_OWH0W Reporting and Analytics for HCM
-
How to register ESS Jobs in R13 20B?Summary How to register ESS Jobs in R13 20B?Content Hi Everyone, Can you please share your thoughts on How to register ESS Jobs in R13 20B? Thanks, -
Distribution Email List for ESS JobsSummary Distribution Email List for ESS JobsContent Hi Everyone, Can you please share your thought on , how to setup distribution Email List for ESS Jobs? Thanks,
-
00/00/0Summary Cannot filter on report returnContent Hi all I am looking at working pattern reporting. All our full time standard working hours peeps inherit their working patt…Dawn Cawston - CPS 46 views 7 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM -
Job seniority date reportSummary Job Seniority Date reportContent I just created a rule in "configure seniority date" section for job, level workrelationsihp. Then i ran the populate process aga…Adil_R 106 views 3 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Identify in the Learning Catalog a learning item corresponding to a SCORM objectContent Hi, I have imported in the "Learning Catalog" some courses provided by Skillsoft. When a learner does a course, in the SCORM tables (those starting with WLF_SCOR… -
Data is getting filtered when Trading Partner Details column is selectedSummary Data is getting filtered when Trading Partner Details column is selectedContent Hi, We are developing an OTBI Report with Subject Area as "Product Management - T…Narayana Kayala 28 views 3 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM
-
Seniority Dimension OTBI ReportingSummary Seniority date dimension added in 19D for V3 seniority datesContent Hello, 19D introduced a new dimension for Seniority Date reporting, specifically for use with…Whitney Van Way 46 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI > Workforce Profiles – Person Profile Real Time > Cannot count the Persons in different years bContent Hello, We have created the following analysis (PFA S1) The field “Years of Experience Band” first computes the total years of experience by calculating the sum o… -
A simple SQL created using the Create Analysis from Simple Logical SQL is not working as expectedSummary A simple SQL created using the Create Analysis from Simple Logical SQL is not working as expectedContent We have tried a simple sql : SELECT B.Content_Item_Id FR…Sreedharan-Oracle 43 views 2 comments 0 points Most recent by Sreedharan-Oracle Reporting and Analytics for HCM -
Connecting Worker Assignment and Comp Salary work areasSummary Connecting Worker Assignment and Comp Salary work areasContent Hi ALL, I'm need fields from "Workforce Management - Worker Assignment Event Real Time" ."Assignme…User_2025-02-07-19-03-14-525 23 views 7 comments 0 points Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM
-
oracle.xdo.servlet.data.DataException: ORA-01722: invalid numberSummary oracle.xdo.servlet.data.DataException: ORA-01722: invalid numberContent Hi i have below error in Data model Parameter name: p_JV_NUM oracle.xdo.servlet.data.Data…Mahgoub S.Mohamed 425 views 3 comments 0 points Most recent by Ahmed Mousa Reporting and Analytics for ERP -
Is it possible to link a BIP or OTBI report to an FR report using related contentSummary Recently found that we can drill to a second FR report using related content and the parameters get passed on from the first report cell from which we drill. Exp…Shweta Prithviraj-163613 39 views 0 comments 0 points Most recent by Shweta Prithviraj-163613 Reporting and Analytics for ERP