OTBI
Discussion List
-
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 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 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 214 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 199 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 57 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 71 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
-
Error Codes: EKMT3FK5 Limitation of Pivot table in OTBISummary: https://us.v-cdn.net/6034893/uploads/ANZBLDIHH4AG/earnings-27-report.txt I pivot 'Balance Name' (around 70 columns) and get this error message if I output too m…Yiming Xiong 32 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How to find the information of different view objects using same tableSummary: Hi, We have used the "Rel13_23D_BICC_FSCM_Database_Mapping_with_ViewObjects.xlsx" provided by oracle. We have looked for VO using the table GL_JE_LINES. The spr…