OTBI
Discussion List
-
Will the backend tables and columns change if I Migrate custom objects from one instance to another?Summary: We created 28 custom objects in one instance and generated some reports from those Custom objects . We used one instance from CRP testing . Now, we want to ensu… -
How do I extract a portion of a text field before a special character in OTBI?Summary: One of our Display Name fields shows Preferred Name Last Name (pronouns). What is the expression to extract the portion of the text before the "("? Content (ple…
-
Restrict the compensation information in reports and analytics.Hi Team, We have a requirement that some set of employees can able to access/view the compensation data in BI and OTBI Analysis reports. E.g: If a user queries the compe… -
Costing Inventory Real time & Inventory – Inventory Transactions Real Time -Subject AreasSummary: Manage Account Alias from the Costing - Cost Accounting Real Time I have one more doubt, I am trying to get Manage Account Alias from the below subject areas to…
-
Subject area for report to fetch content section of person profile typeSummary: Content (please ensure you mask any confidential information): Hello, We want to fetch all the details inside 'Content Sections' under Profile > Profile type > …Aishwarya_Saju 11 views 0 comments 0 points Started by Aishwarya_Saju Reporting and Analytics for HCM
-
withdraw issuewithdraw issue
-
Prompts are not showing while scheduling the OTBI AnalysisThere are 4 prompts in the Analysis. But when we try to schedule the report, these parameters/prompts dont show up in the General tab. Please suggest.Dona Das-Oracle 51 views 3 comments 0 points Most recent by Jagadeeswara Reddy Reporting and Analytics for HCM
-
how to get the retention rate calculationSummary: HI team! Do you know how to calculate the retention rate in an Analysis Report? This is the formula: (Number of employees at the end of the period / Number of e…Claudia Linares L 21 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Analysis report to find all the talent notifications enabled in systemSummary: Content (please ensure you mask any confidential information): Hello, We want to create an analysis report where we get the list of all the enabled and in use n…
-
Verification of User Login Status in ERP CloudSummary: I would like to know if there is a report in ERP Cloud that shows which users logged in and when. Content (please ensure you mask any confidential information):…
-
OTBI costing receipt accounting subject area -- project number is not populating for transfer ordersI have created an analysis in OTBI using the costing receipt accounting real time subject area. The report is working fine, balances to the general ledger and reflects a…Walter L Gess 1 view 1 comment 0 points Most recent by Walter L Gess Reporting and Analytics for ERP
-
Seniority Date in Workforce Management - Worker Assignment RT is not returning any data in OTBISeniority Date.Seniority Date in Workforce Management - Worker Assignment RT is blank whereas Person Seniority Details.Seniority in Workforce Management - Person Seniori…MeghnaDe 21 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Performance Issue - per_availability_details.Get_availability_detailsWe've developed a BI Publisher Report, but it's experiencing performance issues. When run ad-hoc, the report times out (Timeout Error), and when scheduled, it takes over…
-
Table name where the Project Costs Transaction Number field isSummary Table name where the Project Costs Transaction Number field isContent I am looking for the table name that has the Transaction Number field from the Manage Proje… -
How to Setup an OTBI Agent to Alert Buyers about Expiring Agreements Using User NameSummary How to Setup an OTBI Agent to Alert Buyers about Expiring Agreements Using User Name Content Business Case You want to periodically alert buyers when their agree…
-
When a filter is applied after ranking total months of service the analytic function no longer worksI have a report to pull the most recent seniority service data to get a list of employees eligible for a service award. My report works up until I set my final filter. H…
-
How to add Active FTE column to OTBI PivotIs there a way to add a column to the Pivot in this OTBI report that shows CURRENT total FTE by Dept By Job? Here is a print screen of output example. New column hi-ligh…
-
How to fetch report in hiring tab in redwoodSummary: Content (please ensure you mask any confidential information): Hello, When using the Responsive UI, we were able to add a report (Candidate tracking ) in such a…Aishwarya_Saju 11 views 2 comments 0 points Most recent by Shikha Agarwal Reporting and Analytics for HCM
-
Report to fetch all the questionnaire present in systemSummary: Content (please ensure you mask any confidential information): Hello, We want to fetch all the active questionnaires and the items resent in question library, a…Aishwarya_Saju 11 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Which Subject Area is used to access Relationships on Items or ChangesSummary: I am trying to build an Analysis that pulls the relationships of an item or a change. Content (please ensure you mask any confidential information): I am using …
-
Disabling caching for specific OTBI analysis not workingSummary: We tried to disable caching for an OTBI analysis in HCM with both 'Bypass Oracle Analytics Presentation Services Cache' and SET VARIABLE DISABLE_CACHE_HIT=1, DI…
-
Latest Talent Ratings OTBISummary: We are required to create a prompted OTBI analysis that includes each of the worker's latest talent profile ratings. How can this be achieved? Version (include … -
Report to see invoice and their accounting entriesSummary: Content (please ensure you mask any confidential information): Do we have any standard report which can give the details of all the AR invoices and their accoun…
-
Deep link to course in Redwood - used in OTBI reportSummary: Content (please ensure you mask any confidential information): Hi there, I have a nice OTBI report that includes the Deep link to the offering with this code in… -
LSQL print first valueSummary: Moved to SCM Reporting and analyticsVDM_IM 11 views 2 comments 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP -
Searching in Reports and Analytics using the magnifying glass icon giving internal server errorSummary: In reports and Analytics, users wanted to search for some related reports and so by using the search option(magnifying glass icon), they entered some options an…P.S.Nikhitha Muduliar 11 views 2 comments 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
What reports are available for agent level productivity metrics?Summary: We are looking at agent level productivity metrics. What seeded reports are available in Oracle? Or are these custom created reports? This ask is across all the…VWollin 1 view 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to print all lines returned in dashboard from analysis in a PDF print format or PDF export?Summary: I created an analysis, embeded in a Dashboard. I also created a Report under Print & export options in the section Custom Print & Export Layouts. I added date &…VDM_IM 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP