OTBI
Discussion List
-
Is it possible to build OTBI report to show have 0 incumbents for active positions ?Summary: Content (required): Need to build OTBI report to show have 0 incumbents for active positions along with Position HC Version (include the version you are using, …Nikhila 25 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Reflect one row when there are duplicate rows of dataSummary: Request received to have report with multiple rows of data for workers to reflect one row for each worker, but still include all data. Hopefully the screenshot …Jessica D 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to create a role with limited access (by module) to Reports and AnalyticsSummary: When you give a user access to the BI catalogue as a 'BI Consumer' then the person has access to data from all modules in play. We want to limit certain users t…Reinhard Klahn 71 views 3 comments 0 points Most recent by Reinhard Klahn Reporting and Analytics for ERP -
Procurement - Procure to Pay Real TimeSummary Procurement - Procure to Pay Real Time not displaying the Receipt Numbers created against the POsContent Hi, We would like to create an OTBI report using the Pro…
-
Help -> Audit/field Change Reports (Old Value -> New Value) - OTBI or BIPSummary Help -> Audit/field Change Reports (Old Value -> New Value) - OTBI or BIPContent Hello, Looking for a quick help, please. Searched the archives but could not fin…SantoshKumarBhairi 204 views 12 comments 0 points Most recent by Ninja Reporting and Analytics for HCM -
Case Statement Length of ServiceSummary: I would like some assistance on a case statement calculating length of service. Content (required): I am creating a case statement that looks at the assignment …
-
How to create a log file of invoices that were sent by email ?Summary: How to create a log file of invoices that would be sent by email ? Content (required): Hello I was wondering If you can share with me an SQL of the invoices tha…
-
how can we go with below requirement in OTBI between 2022-23 data of absenceSummary: Hi Team, we have requirement in between 2022-23 data for absence accural balance for annual leave , enchased and lapsed. by using accural real time subject area…AjayKumar Maddipati 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Pivot table column blankSummary: Content (required): Hi, I've created an OTBI report using the Workforce Performance - Performance Rating Real Time subject area, with a Pivot for the Manager Ra…Joe Dorrian 21 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Identify all actions/pages that contain Business TitleSummary: I need to identify all actions/pages that contain the Business Title in order to hide them, because client doesn't have them updated. Content (required): Versio…Stela Martins-Oracle 21 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Grade step start date per employeeSummary: Content (required): Hi, would anyone be able to point me in the right direction for creating a report that tells me how long each employee has been at their cur…Leanne W 11 views 4 comments 0 points Most recent by Kathi Chenoweth-Oracle Reporting and Analytics for HCM
-
Need query to pull item cost details for specific transactionsSummary: Content (required): Business requirement is to pull item cost details for specific transactions from the refurbished SKUs Version (include the version you are u…kalyan gade 11 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
Assignment EFF Rest APII am trying to query from postman with the relevant platform_id information using Assignment eff rest api,(/hcmRestApi/resources/11.13.18.05/emps/{empsUniqID}/child/assi…Cansel Karasoy 12 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
calculate the past experience in HCM BI ReportSummary: calculate the past experience in HCM BI Report Content (required): My client requirement is to calculate the past experience and current organization experience…
-
Measurement to sum Actua Effort for yeach years starting from Current_DateDears, i've been trying to create performance tiles based on following measurements so to have sum of actual effort for the last 3 years splitted by years: Sum of Actual…
-
Is there a report or SQL that will show all Miscellaneous transaction carried out on Inventory ItemsSummary: There will be an upcoming audit in our client's organization. Is there a seeded report or SQL query that can display all Miscellaneous transaction reports condu…Lucky Aro 112 views 1 comment 0 points Most recent by Lynn Warneka-Oracle_inactive Inventory Management
-
Total Salary by Division for the first of each month - OTBISummary: I feel like maybe this is very obvious and I'm overlooking it. But here it goes: We want a report that total salary for a given division on the first of each mo…Monique 11 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
In which subject area can I find 'Business Title'Summary: I need to create a report/analysis, showing all assignments, where job is not equal to Business Title. Content (required): I have started on an analysis with su…Morten Graae 541 views 4 comments 0 points Most recent by Stela Martins-Oracle Reporting and Analytics for HCM
-
Custom Error message on OTBI Reports / Dashboard Reports DisplaySummary: We need to display the custom error message on OTBI reports. Please provide the workaround for this. Content (required): OTBI Reports / Dashboard Reports - Disp…
-
Learning OTBI - Manage Default Access infoContent Hi there, is it possibile to extract the Manage Default Access info (course level) via OTBI? We would like to display the Self-service settings > view mode, plea… -
Actual Effort Attempts ReportSummary Tracking report on self paced activities with the actual training effort for every attemptContent Hello there, We need a tracking report on self paced activities…
-
How to create a report with manager management levelSummary: report with manager management level Content (required): Hi, I need to create a report with every employee of my company and relavite manager. I need also to re…Alberto Americi 112 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Deep link for a reportI have created a new page entry under "My Team" and i want a report to be triggered when someone clicks on that. Screenshot attached. How can i obtain the link to a repo…Girish Bhatia 21 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Report on Prior Visa InformationSummary: I needed help with BIP SQL code that can help me extract prior visa information for employees. Content (required): Currently if an employee has multiple visa in…Rohan Fernandes 21 views 8 comments 0 points Most recent by Rohan Fernandes Reporting and Analytics for HCM
-
Payroll-Personal Payment Details Real Time Target Bank Account is Null but not "IsNull" in the fieldSummary: Content (required): We are trying to find all the employees that have missing Bank Account Numbers or Bank Sort Codes We are currently using Payroll - Personal …Clifford Trett 21 views 1 comment 0 points Most recent by Chris Ford Reporting and Analytics for HCM -
Poor performance with CASE statement and sub-querySummary: Custom analysis with CASE statement extremely slow Content (required): Good afternoon, I have created an OTBI analysis that yields the names of line managers wh…ammiano 52 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
"Add to Favorites" is not working as expected for OTBI reportsSummary: Hi When I add a OTBI report(having input parameters) to Favorites, the output resulting from favorite displays the output without asking for input parameters. I…
-
Learn Admin view on Workflow ApprovalSummary: Dear Community, Is there a way for Learn Admin to view on Workflow Approval? Currently Transaction Console is granted only to IT Admin. Worklist is not able to …