OTBI
Discussion List
-
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 11 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 161 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 22 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 211 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 71 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 -
How to put filter on Phone Line Type and also include employees without the type in OTBI?Summary: Hi All, I am fetching employee's data through OTBI where I also want to fetch the employee's Home Mobile Phone data only. After I apply the filter to Phone Line…Robinson Ng 32 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Busting OTBI Myths - Using different security in OTBI to HCM CloudContent Myth: OTBI doesn't allow me to access different data to HCM Cloud Occasionally you need to allow a user to report on more or less data than they have access to i…Julian Challenger-Oracle 773 views 5 comments 9 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Is there a way to pull Executive Manager Name on a Terminated employee record?Summary: Trying to run a report by our executive manager's to see how much turnover each manager has had. Appears that Manager details are dropped from an employees reco…CGardner01 41 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Average Salary per HourSummary: We have an OTBI analysis with each department headcount and I need to get the average salary rate per hour in another column. Content (please ensure you mask an…Ayesha Iroshani 12 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI Analysis multiplying fields ‘FTE & Salary’ – How to resolve?Summary: I am writing an analysis from three subject areas were multiple columns have expressions, when I add an expression which is including the Manager Flag from Work…Scott_Turner_ 21 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to show CR and DR account combination in two lines with correct transaction amount in OTBISummary: How to show CR and DR account combination in two lines with correct transaction amount in OTBI analysis? Content (please ensure you mask any confidential inform…