OTBI
Discussion List
-
Reports in Case ManagementSummary: Case Management has been introduced as part of Next Gen Help Desk. Could anyone please share your inputs if there are any subject areas available to build repor… -
We have OTBI report but need to convert to Dasboard how can I develop ?Summary: Hi Team, We have OTBI report but need to convert to Dasboard how can I develop . Any one help me on I'm new to dashboards ? Thanks, Ajay Content (please ensure …AjayKumar Maddipati 41 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Level 02 Organization Name (Business Area) Not Showing UpSummary: We are currently in the process of implementing ORC and we are trying to create some dashboards that we can use for requisition/candidate data. When we run the …Kyle Norris 131 views 20 comments 1 point Most recent by Kyle Norris Reporting and Analytics for HCM
-
Milestone date showing as Hire Date in Long service Employees Report ?Summary: Hi Team We have long service employees report on who completed the 5, 10, 15 years like and we applied filter on as below. TIMESTAMPDIFF(SQL_TSI_YEAR, "Worker".…AjayKumar Maddipati 21 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
how do I modify the General Ledger and Subledger Account Analysis Report to add address and tax idSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
OTBI Agent to send to HR Business Partner via Username in the agent not sendingSummary: I am setting up a new agent to send via email to users. it is being created by conditional analysis. Get Recipients from the Analysis Used in the Agent Conditio…
-
Need inputs to get the YTD, QTD, MTD balance values using Pay_run_balances tableSummary: Need inputs to get the YTD, QTD, MTD balance values using Pay_run_balances table Content (required): In the Pay_run_balances table able to see "RUN" related bal…
-
We have performance rating report How to fetch latest rating record in OTBI Report ?Summary: Hi Team, We have performance rating report for inactive employees but we need only last rating but in my report showing all years rating. how will get ? Thanks,…AjayKumar Maddipati 71 views 8 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Combing Two Rows into One Based on Person Numberhttps://us.v-cdn.net/6034893/uploads/GBYJEUBQX1Z5/us-audit-report.txt Hello everyone, We're working on the earnings report and there are some employees have two assignme…Yiming Xiong 22 views 10 comments 0 points Most recent by Yiming Xiong Reporting and Analytics for HCM
-
Unable to retrieve the data from OTBI Analysis when two subject areas are addedSummary: In BI Publisher application, the requirement is need to add the contract number(Subscription Number) and known as columns to the customer contact information OT…Chandana Priya-Oracle 62 views 2 comments 0 points Most recent by Chandana Priya-Oracle Reporting and Analytics for SCM
-
Payables Module: Specific tables and fields where the employee banking information is stored?Summary: I've been asked by one of our internal auditors the following 2 questions specific to the Oracle Accounts Payable module: List the specific tables and fields wh…K Hart13 208 views 5 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
OTBI Link between Negotiation and Outcome Document (AG/PO)Summary: When Purchasing document is created thru a Negotiation, there is no reference number of either AG/PO in any of the OTBI Subject areas Content (please ensure you…
-
how to add months 24 to a date field in the OTBI Report FilterSummary: I would like to add 24 months to length of service date field using case when. Please provide the code how to write in OTBI Content (please ensure you mask any …Anjan Polimera 81 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Custom Report - It is possible to translate Layout name i an RTF type reportHello, We have a OTBI report created with a RTF template. In the report, we have by example an Layout name call Approval_RTF. When we attach this report to a dashbord an…Patrick Turcotte 31 views 2 comments 0 points Most recent by Patrick Turcotte Reporting and Analytics for HCM
-
Rcount sort orderSummary: I need to know what controls the sort order for the RCount function. I have a requirement to select one assignment per person from worker assignment real time S…
-
Issue while adding prompts to a pivot view of an OTBISummary: Not able to add and apply prompts to pivot view of an OTBI analysis Content (please ensure you mask any confidential information): The requirement I have is to …Vibha Pandey - Oracle 11 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Payroll Relationship - Element Duration Dates - Final Close DateContent Hello, We're keen to build a report that shows the final close date using OTBIEE Answers (subject areas), however when included this appears to be on the relatio…Kevin M Storrie 197 views 12 comments 0 points Most recent by Sharon Harper Reporting and Analytics for HCM -
Unable to acheive trend analysis using prompt for accounting year in OTBISummary: Unable to use Time series formulae in OTBI to fetch YTD data for past 5 years/ for 5 years based on prompt Content (please ensure you mask any confidential info…Madhuri Kovuri 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Expenses Module: Specific tables and fields where the employee banking information is stored?Summary: I've been asked the following 2 questions by one of our internal auditors, specific to the Expenses Module: List the specific tables and fields where the employ…
-
Some columns have null values for certain records and record is not retrieved when the column is selSummary Some columns have null values for certain records and record is not retrieved when the column is selectedContent I am using "Fixed Assets - Asset Depreciation Re…
-
Query to get Change Orders details like changed/updated data like PO amount, Invoice Number and InvContent Hello all, Can someone tell from where I could pick the details for Change Orders details for a Purchase Order which is in "Open" status and if changes are made … -
Payroll Element Entries Real TimeSummary Results not displayed after adding worker details in the reportContent Hi All, I am trying to pull employee element entry details. For that, I am using Payroll E…Prabhu Krishnamoorthy 56 views 13 comments 0 points Most recent by Oriana L. Reporting and Analytics for HCM -
How can I combine termination count and hire count in one analysisSummary: I have attached two different analysis One is showing hire count and other termination count But the requirement is that I need to have both the columns in the …Shreya Datir 31 views 5 comments 0 points Most recent by Shreya Datir Reporting and Analytics for HCM
-
is there any possibility to customize or copy Standard Purchase Order Dashboard?Summary: How to copy/customize existing Purchase order Over view page (dashboard) for each Business Unit? Content (please ensure you mask any confidential information): …