OTBI
Discussion List
-
Not getting the proper charts on the user defined logical sqlSummary: I have written a sql statement by performing a left join between two subject areas. Have got the desired output. However am note getting the expected outcome wi… -
Absence Date End problem with clock change in OTBISummary: During British Summer Time (BST) (GMT+1) the Date End of an absence has a time stamp of 1am the next day. So 01/05/2021 00:59 not 30/04/2021 23:59. Content (req…Robert Craske 41 views 4 comments 0 points Most recent by Mark Stoker Reporting and Analytics for HCM -
Role to access Negotiation OTBI reportsSummary: I need to know the role required to access the Negotiation OTBI reports. Content (please ensure you mask any confidential information): Version (include the ver… -
How to customize the data model to include disputed transactions for Strategy based dunning letters?How to customize the data model to include disputed transactions for Strategy based dunning letters? What data fields are required to be added for including the disputed…Kratika Sharma 34 views 1 comment 0 points Most recent by Daniel S.-Oracle Receivables & Collections
-
Check list real time SA for onboarding questionnaire but output vertical view issue in reportSummary: Hi Team, How can I convert Vertical into horizontal of question text and response answer . we need candidate onboarding questionnaire feedback suervy but in que…AjayKumar Maddipati 51 views 10 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
OTBI Dashboard Usage Via TileHi all, We've built an OTBI dashboard and we'd like to share this via a tile on the front end of PeopleCloud. We've followed these instructions we found on here (pdf att…MikeW 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to get bursting delivery detailsSummary: How to get bursting delivery details Content (please ensure you mask any confidential information): Hi All, We need to develop a BI report to show the bursting …Venkatesan 32 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Metric Descriptions - Service Subject AreasSummary Descriptions of all the out of box metrics found in the 'Service - CRM Service Requests Real Time' and 'Service - CRM Service Request Lifecycle' subject areasCon…Anand DN-Oracle 56 views 2 comments 2 points Most recent by Jenny Truong-Scognamiglio Reporting & Analytics for Fusion Service
-
US compliance reportingWe plan to retire our US & CA Operational Data Store (ODS). Currently, it feeds HR & payroll data to multiple downstream applications. Equally as important, it helps us …Santo Campione 21 views 2 comments 0 points Most recent by Allen D'Souza-Oracle Reporting and Analytics for HCM
-
How to join/merge/combine two sql queries.Dear Experts, Thanks For Looking into this post. Could you please help out me. I have two queries as shown below, we need to join one together. Query1: UDT_LKP query. Qu…Ravindr-Oracle 31 views 2 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM
-
Formula to prevent deletion of annual absences with Approved status in the system.I prepared a validation formula so that absences with "Approved "status cannot be updated or deleted in the system. The formula for updating is running and an error mess…Cansel Karasoy 51 views 7 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Requires to have a Cash Flow Report?Hi, We require to have a cash flow report, appreciate if you can provide any existing reports or subject areas which can be used in creating the report, and any inputs y…Janitha Perera 12 views 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
Name of/where to find the OTBI report that produces the infotile on the landing page for ExpensesSummary: I would like to add some content to that infotile, but I have not yet discovered where to find it in the Reports and Analytics folders. At one time the infotile…
-
"Absence Calendar Direct Reports Current Month" - How does it work 'normally' (but with custom SQL)?Summary: I was editing the logical SQL of a seeded analysis and noticed that while it appears to have custom logical SQL, it still works just like a normal subject area … -
How to pass a project parameter to an otbi or bip report from a Maintenance Work order screen?Summary: I want to show a budget report on the work order maintenance screen. The requirement is when a user enters the project number on the work order screen then show…
-
Showing the current, valid training record for courses with reassignment rulesSummary: Is it possible to build a report which only shows the current training record for courses with reassignment rules. So if an individual has taken the course 3 ti… -
How to extract Questionnaires and Employee Response?Summary: How to extract Questionnaires and Employee Response?
-
Is there a way to report on "Withdraw Learners" > Comments section?Summary: Is there a way to report on "Withdraw Learners" > Comments section? Content (please ensure you mask any confidential information): Hi, I'm looking for a way to … -
RTF Excel Output Merging CellsTeam, We have developed BI Report with RTF template. When user exporting the output in Excel output the cells are getting merged. Example B & C columns are merged. We ha…
-
Which column in OTBI will display if employee is also a manager, We need this in Learning ManagementWhich coloumn in OTBI will display if employee is also a manager, We need this in Learning Managment OTBI reportsabhilashanand 11 views 3 comments 0 points Most recent by abhilashanand Reporting and Analytics for HCM
-
Does anyone use Global Access Groups? What would you use them for?Summary: We are wondering if we need to set up Global Access Groups. Need information on what they are, how they work, why would you need them? Content (required): What …
-
How to update ORIG_SYSTEM_REFERENCE filed of HZ_CUST_ACCT_SITES_ALLSummary: customer site was interfaced with wrong ORIG_SYSTEM_REFERENCE value to EPR fusion from an external system. Now we encountered error when tried to interface cust…Mohamed Iqbal Jahangeer 193 views 8 comments 0 points Most recent by Mohamed Iqbal Jahangeer Receivables & Collections
-
Grand Total for OTBI Column measuresSummary: Hi Folks, Grand total for completion count in learning and maximum Training hours is also derived with the option of Show Row Level Grand total in OTBI but that… -
Salary with Currency Euros and not local currencySummary Is there a salary with two currency example local currency and salary in euroContent Hello, I want to view a salary of employee in OTBI in 2 currency. By default…User_I6AXL 60 views 2 comments 0 points Most recent by Neysan Mohajer Reporting and Analytics for HCM -
how can I add requisition number to subject area Supply Chain Orchestration - Supply Request Real TiSummary: how can I add requisition number to subject area Supply Chain Orchestration - Supply Request Real Time? Content (required):n/a Version (include the version you …
-
Apprenticeship ReportingSummary Can we report on Apprenticeships?Content Hi all - we have been asked to report on Apprenticeships that are listed within the Talent Profile. I cannot find anywhe…Prudence K 72 views 1 comment 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM -
Receivables Aging by General Ledger Account ReportSummary: We are developing a custom report to show us aging 13 buckets we are not able to reconcile it with the standard we are facing issues with credit memo refund pro…Shadaab Ahmed 21 views 1 comment 0 points Most recent by Veronica Stefan-Oracle Receivables & Collections
-
have Maintenance Management this Reports, Dashboards and infolets by deault?Summary: I need to develop with OTBI the next data information objects: Mechanist Availability (Report). MTTR (Infolet) MTBF (Infolet) Maintenance Compliance (Report) Ma… -
Documentation on Scheduling OTBI ReportsSummary: Hi! My company is currently implementing Oracle HCM. Is there an oracle manual/guide which goes over all aspects (tabs) of scheduling reports through OTBI sched…Ameya_J 215 views 1 comment 0 points Most recent by John Hung-Oracle Reporting and Analytics for HCM