Reports
Discussion List
-
Period and Years not available in the POV - ReportingSummary: Period and Years not available in the POV - Reporting Content (please ensure you mask any confidential information): Hi All, I was creating a new Financial repo…Antonio Barbaro 41 views 5 comments 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close -
We have OnBoarding_15Days_Report but timeout error coming on below querySummary: Hi Team, we have OnBoarding_15Days_Report its runing ok but few days onwords we getting error is timed out error, we apply one year durationand even schedule al…AjayKumar Maddipati 41 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Fetching column for employee Feedback(in PD) whether it is completed/bypassed in OTBI reportsSummary: I have a requirement to add one column in OTBI report to fetch the status of employee feedback if is completed or bypassed. Can we use SQL query to fetch the de…Kamini Kaushik-Oracle 11 views 2 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
In Salary report one employee showing two records, difference is one is old salary second new salarySummary: HI Team, In Salary report one employee showing two records, only difference is one is old salary and second one new salary , how can we get latest record (New s…AjayKumar Maddipati 61 views 8 comments 0 points Most recent by Amol Patil HCM-Oracle Reporting and Analytics for HCM
-
Need a sql to get "extra info" on "position details" pageHi All, I'm trying to find SQL tables and joins behind getting "Regulatory Licence Information" under Extra Info Section of Position Details. Navigation : Set up and Mai…
-
How to create User defined table (UDT)Summary: How to create User defined table (UDT) with screen shorts. Requirement: i want to store the below data in User defined table & which table can store this inform…Ravindr-Oracle 31 views 3 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM
-
Enhanced Analysis with parameters changesSummary: Created a Reports and Analytics Analysis which others users can run. Then I made modifications to the Analysis, saved it and now the others can still only run t…David Kubiak 11 views 3 comments 0 points Most recent by David Kubiak Reporting and Analytics for HCM
-
How to return Geographies using OTBISummary: We want to return Geographies (State, County and City) using OTBI. But the data should not return the geocodes but should return the actual name. Ex: State: LA …RenzelkeithCoquia 3 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Create a link from PBCS to NRHi All, There is a way to link the whole library or folder of Narrative to PBCS? I only see the option to link report one by one and we have a lot reports divided by spe…
-
csv output giving multiple date format while using etext templateSummary: I have built a report to display a date column in dd-mm-yyyy format using etext template. the report output is displayed in text or csv. In both the cases when …Nisha_Hegde 91 views 9 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
reports (cloud) | suppression using member check on another row or POVSummary: In a report we want to show a number of rows from Entity 302 if Entity 301 has been selected in the POV. What would be a good technique to do this? Content (ple… -
Convert from Thomson Reuters Onesource to TRCSI am in the very early phase of discovery to potentially implement the Tax module in EPM. A couple years (more than 5 now) we implemented Onesource (Thomson Reuters). I …Brian Hargreaves 51 views 2 comments 0 points Most recent by Brian Hargreaves Tax Reporting (Direct Tax)
-
How to filter the column values by another column?Summary: I'm currently creating an OTBI report under this Subject Area: Workforce Management - Checklist Real Time I want to filter employees which have these Response A…
-
Coding Conditional Formatting into LSQL?Summary: Logical SQL Conditional Formatting OTBI Content (please ensure you mask any confidential information): Hi All, When building a report in LSQL - I apply the SQL …William_Johnson 21 views 4 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
Expand Button in FR is not visibleSummary: Hi, After the OCI migration (which happened last Friday, 20 Oct 2023) the expand button in FR is not visible if opened from SmartView: But it's visible if opene…
-
OTBI Learning course detailsSummary Need help to find attributes in subject areaContent Hello everyone, I am having trouble to locate the attributes for the following fields in learning subject are…User_2025-02-05-11-42-08-011 55 views 5 comments 0 points Most recent by VenkataSubbareddy Reporting and Analytics for HCM -
How to create a record in the position flexible field from postman with Oracle Rest API?Hi, I want to send a record to the flexible field opened on the position with the help of Oracle standard rest APIs. But when I examine the oracle document, I cannot see…Cansel Karasoy 31 views 4 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Setup table to pull Approval rulesSummary: Setup table to pull Approval rules Content (please ensure you mask any confidential information): Hi, Could you please advise setup table to pull out Approval r…Bhavna-Civeo 62 views 6 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
To pull Open Enrollment Benefit data if life event closed and Employee Enrollment not yet submittedSummary: To pull Open Enrollment Benefit data if life event closed and Employee enrollment not yet submitted Content (required): We are looking SQL query/OTBI report to …
-
New Hands-on Tutorial for Planning now availableWe are pleased to announce the availability of the following new Hands-on Tutorial. Hands-on Tutorials provide step-by-step instruction on how to complete a set of tasks… -
Issue while configuring BI Publisher ReportSummary: Hi, I've configured the BI Publisher files custom folder but not able to see the folder after Upload successfully done. Do you have any suggestions? Need your h… -
Date Calculation formulaHi, I've a requirement where I have to show some data based on future dates and also print dates like First Calendar Date of Next Month, Last Calendar Date of Next to Ne…Ninja 13 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is it possible for rich text format stored in a Data Field to display as Rich text in a report?Summary: We are using Rich text format in Questioners in Carrer conversation. Content (please ensure you mask any confidential information): 1.Thinking big, what do you …challa praveen 31 views 2 comments 0 points Most recent by challa praveen Reporting and Analytics for HCM
-
How to move data from PCM_CLC to PCM_REP cubeSummary: Content (required): Hi all As per documentation, we have just migrated from Standard PCM to EPCM and we wanted to take advantage of the REP cube. However, I can…NKW 273 views 12 comments 0 points Most recent by Raama Rao-Oracle Profitability and Cost Management