OTBI
Discussion List
-
Unable to scroll Subject Areas with UnionSummary: When trying to use the "Combine results based on union intersection and difference operations" I'm unable to scroll past the initial list of Subject Areas to th… -
Handling Invalid Dates in a CASE statement in OTBISummary: How do you replace 00--0 with an actual date in OTBI? Getting error with CASE statement below Content (required): My CASE statement is coming back with an error… -
How to get Active Bank Account DetailsHi Experts I am trying to write a query to get Active Bank Account Details for a given employee. I am not sure in which table and column this flag is stored. I checked "…Dharmendra Shukla 531 views 4 comments 0 points Most recent by Dharmendra Shukla Reporting and Analytics for HCM -
How do you include inactive requisitions in an analysis?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Ed Sevilleja 52 views 4 comments 0 points Most recent by Ed Sevilleja Reporting and Analytics for HCM
-
How to report on Date Paid in last 12 monthsSummary: I have a report using the Payroll Balances Real Time subject area. The requirement is that when the report runs on the first day of every month, the output is f…
-
OTBI - Locating 5th occurrence of characterSummary: Several fields have been migrated into one field and need to split into separate columns into OTBI Content (required): We need to pick the department from the c…Sai Revanth-Oracle 43 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for SCM -
Any other customers using OTBI notifications for LearningSummary: We are unable to use alerts for Learning notifications due to our food store population not having work email addresses, so therefore need to filter them out fr…
-
Reporting on ICD/Manage Personal Contribution Requests that have been SavedSummary: Content (required): We use Individual Compensation Distributions for our employees to claim for irregular payments (overtime worked etc.) as we are not yet usin…Leanne W 42 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Reports and Analysis tab is blank in SCM Work areaSummary: The reports and Analysis tab is blank in all Work areas of SCM Content (required): The reports and Analysis tab is blank in all Work areas of SCM like Purchasin…
-
Return to work learning with restrictions how do you manage?Summary: Any solutions for when an employee returns to work with restrictions, and they have learning that requires skills to be checked off? Content (required): CPR tra…
-
Annualized TurnoverSummary Want to incorporate an annualized turnover in my Turnover DashboardContent Is there currently anything with annualized turnover, or do I need to formulate someth… -
How to apply a 'Custom Theme' to OTBI reports/dashboards.Summary: How to apply a Custom Style Theme to dashboard and reports to align to Company standard. Content (required): is it possible within OTBI to generate and apply a … -
Last 7 days or week query - Looking to query for Opps, Contacts or Accounts updated in last 7 daysSummary: I am trying to generate reports on Opportunities Created or modified in last 7 days - or "Last Week". Also, I want to do the same with Contacts and Accounts cre…
-
Equivalent table/view of GMS_BALANCES from EBS in Oracle CloudSummary: I am not able to find equivalent table for GMS_BALANCES from EBS. I had an interface which fetched period to date values from eBS (mentioned below) but not able…Nilesh R Goyal 43 views 1 comment 0 points Most recent by Shivashish Dwivedi-Oracle Subledger Accounting & Accounting Hub
-
Timecard status reportSummary Trying to retrieve a report in Fsuion which gives timecard at its different status of its lifecycle.Content Does anyone know of a report that would give the time…Shelly-Ann Mahabir 90 views 4 comments 0 points Most recent by Shelly-Ann Mahabir Reporting and Analytics for HCM
-
The promt does not affect the analysis report on the Dashboard screen.I have an analysis report that I use on the dashboard screen and parameters that I expect to affect this report, and one of these parameters does not affect the report, …Cansel Karasoy 63 views 10 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Is there a standard report for generating invoice cover letter by contractSummary: Is there a standard report for generating invoice cover letter by contract Any inputs on this will be appreciated. Content (required): Version (include the vers…
-
Is there a REST/SOAP API to get Production Transaction History Details?Summary: Looking for a REST/SOAP Webservice to get the Review Production Transaction History Details. Content (required): Is there a REST or SOAP service that can be use…
-
GL seeded report or similar report requiredSummary: Business wants to generate Foreign currency detail TB. Content (required): Business wants to generate Foreign currency detail TB. UK Ledger currency GBP and the…Kumar 57 63 views 2 comments 0 points Most recent by Suresh Kumarasamy-Oracle General Ledger & Intercompany -
Which table stores the "Assign as" information for initiativeSummary: Hello All, I am trying to build a report to fetch learning initiative details but i am not finding any information regarding the assign as column in the UI.Plea…minati_behera-Oracle 53 views 3 comments 0 points Most recent by minati_behera-Oracle Reporting and Analytics for HCM
-
How can i query the "Active" Organization Tree version description?Summary: How can i query the "Active" Organization Tree version description? Content (required): I'd like to be able to return the value / name of the Version ID tied to…Shant Karakashian 3K views 3 comments 0 points Most recent by Shant Karakashian Reporting and Analytics for HCM