OTBI
Discussion List
-
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 NumberHello everyone, We're working on the earnings report and there are some employees have two assignments for one year. We are looking for the solution to combine them into…Yiming Xiong 21 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 61 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 242 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): …
-
Move to HR blank in analysisSummary: Move to HR blank in analysis Content (please ensure you mask any confidential information): Hello experts, we are creating a custom OTBI analysis where we need … -
How to fetch latest record in OTBI ReportSummary: Hello All, I am developing an OTBI report to fetch Person's Skills and development data. For this, i have used 'Workforce Management - Person Profile Real Time'…Amarnath Podaralla 82 views 3 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
DFF in termination under PER_PPS_DF which subject area can we report from?Summary: We have added a DFF to termination under PER_PPS_DF and would now like to report on it in OTBI, which subject area can we do this from? Content (please ensure y…Sharon Ferguson 21 views 1 comment 0 points Most recent by Joe Dorrian Reporting and Analytics for HCM
-
When we try to fecth the inactive employees data using OTBI we facing below the issueSummary: Hi Team, when we try create the inactive employees data we facing the issue that is suppose some of employees have mutlipule terimation relationships like 'X' e…AjayKumar Maddipati 51 views 8 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM