OTBI
Discussion List
-
Is there a way to set a section to collapsed state by default on OTBI dashboard page?Summary: Need solution to set section collapsed on load of dashboard page. I understand there is an option to save the customization for each user but it is not viable t…Shreya Agarwal-Oracle 1 view 0 comments 0 points Started by Shreya Agarwal-Oracle Reporting and Analytics for HCM -
Create SAFT-PT Audit File for Portugal not generating XML fileHello All i am trying to run the process Create SAFT-PT Audit File for Portugal and in the parameter i'm including the file i want it as XML but when the process succeed… -
How to report on details held in Past Incumbents section of Position DetailsSummary: We need to add some of the fields held in 'Position Details' into an existing report but cannot find within any tables columns that correspond to the fields vis…Leanne W 103 views 3 comments 0 points Most recent by Revathiiyyanar Reporting and Analytics for HCM
-
Report to say if employee has any direct reportsContent Hi, have a simple report that says something like PERSON NUMBER | Name | Department. I need to add an additional column that returns yes/no for if that employee …Mike Borghoff 128 views 7 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Installed Base Assets data not showing in the TablesHi All We are trying to build a Reconciliation report for the Installed Base assets records that we loading through the FBDI. Currently we are using table CSE_ASSETS_VL … -
Is it possible to add a time zone prefix to an OTBI report?Summary: If I want my OTBI report's data to only display one specific time zone no matter the user's preferences, how would I do that for just one report? Could the pref…CCannadayCTR 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Report requirement for Bad debt Allowance/ ProvisionSummary: Hi This is regarding a report requirement related to allowances /Bad provisions and write off at entity level that we would like to clarify, The business expect…
-
Difference between Oracle Delivered OTBI Report-Budgets Wrksheet & Budgets Wrksheet Worksheet MgnrWhat is the difference between these two out of the box OTBI reports? Budgets Worksheet and Budgets Worksheet for Worksheet Manager Path: /Human Capital Management/Compe…MeghnaDe 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Overtime status is not showing data in workrelation subject areaSummary: Hi Team, We had defined overtime status at job level. like below. but the information is not showing workrelationship subject area. Request you to help on to fi… -
Looking for a Applicant Report < Oracle delivered report>Summary Looking for a Oracle out of box report output - To display all candidate responses to the application questions/fields including the signature with date and time…Prabhu Krishnamoorthy 19 views 3 comments 0 points Most recent by Karen Long Reporting and Analytics for HCM -
Current approval status table name for development goalsUnable to get approval status for development goal: Need a table name and SQL query for development goa approval status to check whether the goal is approved? rejected o… -
Trying to find a Link between Career Site and RequisitionSummary: We are trying to derive the career sites where a specific job requisition is published. Can you point us to a REST API which can provide this information ( alre…
-
Select performance goal seeded report customization in not working in Production.Summary: Select performance goal seeded report customization in not working in Production . where as working in TEST pod. Below are the steps followed to customize the r…
-
Subject Area to determine the Legal Entity details in Workforce Succession Management Subject AreaSummary Subject Area to determine the Legal Entity details in Workforce Succession Management Subject AreaContent Hi , While building some reports for the talent Module,…Manisha Chakraborty 105 views 3 comments 1 point Most recent by Atif Nisar Reporting and Analytics for HCM
-
To update the "Send statement" box, we use the REST API for Customer profile.Summary: to update the "Send Statement" checkbox for a customer in Oracle Fusion do we have the rest api and If yes what it is Content (please ensure you mask any confid…
-
Help with setting up Map View in OTBI - Map showing marker on incorrect StatesSummary: I'm looking to create a headcount by State/City/County report and use the map feature to display the results. State appears to be working correctly and the head…
-
How to retrieve Work Day Definition (Weekly Working Hours section) using OTBIContent Hello We need to extract the information: Work Day Definition (Weekly Working Hours section) using OTBI. USA are using this information to track Shift informatio…Lucile Fleischman 103 views 3 comments 1 point Most recent by Thomas Samuel19 Reporting and Analytics for HCM -
Difference between two dates with decimal outputSummary: In an OTBI report, the requirement is to calculate years of service for terminated employees (difference between hire and term dates). The output needs to be 2 …JHaden3 31 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Issue and Resolutions from the Transaction ConsoleSummary: Hello, I was able to find the issue description and resolution information from the table "HRC_CONSOLE_FAULT_DETAILS_VL". However, I'm unable to connect the act…
-
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):…