OTBI
Discussion List
-
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 33 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 62 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 22 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 318 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 61 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 222 views 1 comment 0 points Most recent by John Hung-Oracle Reporting and Analytics for HCM -
How to validate Budget importSummary: How to validate Budget import Content (please ensure you mask any confidential information): How to validate budget imported from Hyperion Planning into Oracle …
-
Requirement to restrict the access of subject areasDears, We have a requirement to restrict access to subject areas to specific users. These requirements are only for the requisitions, which means that users should only …Ejada- Adel Elsaid 73 views 5 comments 0 points Most recent by Kim, Powell-Oracle Self Service Procurement
-
repricing after scheduling or ReschedulingSummary: Hi All, We have requirement to reprice the order based on schedule ship date and if there are any changes to schedule ship date then order should be reprice. Co…
-
Maintenance history of the logical hierarchySummary: When I create a maintenance work order for a child asset within a logical hierarchy, I need it to be reflected in the history of the parent asset. Exist any way…
-
How can I create a custom job Role in BI Publisher?Summary: I can view the Roles and Permission under the Security Center using the /xmlpserver/. However, I cannot create a custom Role as there is no way for me to see th…Cristelle Rose Sampang 11 views 3 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales
-
identifying OTBI reports based on keyword along with the usage historySummary: identifying OTBI reports based on keyword along with the usage history Content (please ensure you mask any confidential information): Hi Team, Greetings! We are…Parag Hiremath 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM