OTBI
Discussion List
-
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 671 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 107 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 427 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
-
Details of run of the analysisSummary Report to know the details of the run of the analysisContent Hi, Is there an out of the box report that will show us how many times an analysis has been run? By …SM-Oracle 25 views 5 comments 0 points Most recent by User_2025-01-25-04-02-13-126 Reporting and Analytics for HCM
-
Tracking non-financial information related to a chart of account segment for reporting with GL BalanSummary Does anyone have recommendations for storing non-financial information related to a chart of account segment and related GL Balance?Content We have some non-fina…User_2025-02-04-18-03-15-131 31 views 1 comment 0 points Most recent by ndryden Reporting and Analytics for ERP
-
Is Seniority Date subject area available in 19D release?Summary Is Seniority Date subject area available in 19D release?Content Hello Team, We have a requirement to get the Seniority date using OTBI report. We found that ther…Harish Kumar Kovi 66 views 11 comments 0 points Most recent by Whitney Van Way Reporting and Analytics for HCM
-
Line Manager Dashboard DocumentationSummary Line Manager Dashboard DocumentationContent Hello, Is there documentation available for details of the dashboards available in HCM like Line Manager Dashboards. …Murthy Kodavati 502 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need to fetch records with valid primary phone in OTBI analysisSummary In OTBI, How to check if all characters in phone number field is numericContent Hi, In OTBI analysis, I have a requirement to fetch employees whose primary phone…RekhaPK 37 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Tips for improving performance of an AnalysesSummary Tips for improving performance of an AnalysesContent Hi, We have parameters - Person number and Learning Type, but the report takes forever to give the output. I…Manoj.Gupta 51 views 1 comment 4 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
BI Content MetricsSummary Is Usage Tracking Available for Cloud-Hosted Installs?Content We are looking to track and report on the usage of various BI content we have developed, including …
-
Using a graph as filter to another graph in Analysis?Content In Tableau I can easily use a graph (lets say, a vertical column of income per month) to filter another graph when clicked on the first one (ie, a second one wou…User_2025-02-07-06-48-26-537 49 views 5 comments 0 points Most recent by User_2025-02-07-06-48-26-537 Reporting and Analytics for ERP