Reports
Discussion List
-
Pull all of one HR Action as long as another HR Action doesn't exist afterSummary: Long title after contemplating how to ask this...:) My analysis pulls all HR Actions that equal 'Termination.' What I need to do is exclude any worker who had a… -
Learning Table Details to fetch Learning Access Group related fields along with access group membersSummary: I have requirement create BIP report to fetch all learning item along with access group related details like Access Group selection method, Access group Run as,…Kamini Kaushik-Oracle 226 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Query Slower after patch Favoring Full Table Scan (FTS) instead of Index ScanSummary: A report built to get the timecard details (OTL query) is suddenly running for a very long time after the recent patch was applied. It does full table scan rath…Nisha_Hegde 21 views 1 comment 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM -
How can we fetch data under Performance Goals for the field "Manager Rating" in OTBI.Summary: How can we fetch data under Performance Goals for the field "Manager Rating" in OTBI. We are able to fetch data only for the field "Overall Summary Manager Rati…
-
BIP - For payment methods used by customers against AR invoicesSummary: Content (required): Need to write a BIP to find payment methods used by customers against AR invoices. Facing difficulty in finding link between RA_CUSTOMER tab…Maheedhar_Atmakuru 31 views 3 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
OTBI report - employees' action and action reasonHi all, we are having difficulty in exporting the Action Code/Name and Action Reason Code/Name for each employee. We can connect 'Person Number - Reason Code' but, canno…Lia P 303 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Assignment and Person Information for Whole Employee PopulationSummary: Hi - I have created a report that is supposed to pull in a combination of Assignment data, comp data, work relationship and person real time information (4 subj…Kyle Norris 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is it possible to build OTBI report to show have 0 incumbents for active positions ?Summary: Content (required): Need to build OTBI report to show have 0 incumbents for active positions along with Position HC Version (include the version you are using, …Nikhila 21 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Reflect one row when there are duplicate rows of dataSummary: Request received to have report with multiple rows of data for workers to reflect one row for each worker, but still include all data. Hopefully the screenshot …Jessica D 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to produce interco elimination amount ONLY between active consolidated entity in Interco ReportSummary: We have parent entity that consist of entity with equity consolidation method (only for equity pick up purpose) so intercompany transaction should not be elimin…J Mahero L 21 views 1 comment 0 points Most recent by Shailesh Kumar -Oracle Financial Consolidation and Close
-
How to format thousands with a space in an rtf template for HCM compensation change statements?Summary: How to format thousands with a space in an rtf template for HCM compensation change statements? Content (required): Hello, We are customizing compensation lette…Trisha Bucktawor 111 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Help -> Audit/field Change Reports (Old Value -> New Value) - OTBI or BIPSummary Help -> Audit/field Change Reports (Old Value -> New Value) - OTBI or BIPContent Hello, Looking for a quick help, please. Searched the archives but could not fin…SantoshKumarBhairi 203 views 12 comments 0 points Most recent by Ninja Reporting and Analytics for HCM -
Need to Convert PDF from word and merging more than one PDF documentsHi, we are planning to use BI Publisher of Oracle analytics cloud to print customer invoice out of a custom tool being developed in VBCS. we have a requirement where the…
-
how can we go with below requirement in OTBI between 2022-23 data of absenceSummary: Hi Team, we have requirement in between 2022-23 data for absence accural balance for annual leave , enchased and lapsed. by using accural real time subject area…AjayKumar Maddipati 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Suppress Rows - Zero not working in SmartviewSummary: I am trying to Suppress rows that have HSGETVALUE formulas in them for account member in Smartview report. When the account value is zero, the rows should be su…
-
New tab on the home page of Oracle HCM (Me | My team | My client Group | My reporting) - languageSummary: New tab on the home page of Oracle HCM (Me | My team | My client Group | My reporting) - text depending on language Content (required): Hello, I am creating a n…Jacqueline GRANDIN 103 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Assignment Changes including Effective SequenceSummary: Hi - I have a logical SQL built that is looking for changes in a DFF field that do not take place on a Sunday. It is supposed to capture the changes between row…
-
Pivot table column blankSummary: Content (required): Hi, I've created an OTBI report using the Workforce Performance - Performance Rating Real Time subject area, with a Pivot for the Manager Ra…Joe Dorrian 21 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Grade step start date per employeeSummary: Content (required): Hi, would anyone be able to point me in the right direction for creating a report that tells me how long each employee has been at their cur…Leanne W 11 views 4 comments 0 points Most recent by Kathi Chenoweth-Oracle Reporting and Analytics for HCM
-
Security views for disciplinary and grievances reportSummary: Security views for disciplinary and grievances report Content (required): Hi All, Is there any secured views available for disciplinary and grievances report? I…Venkatesan 1 view 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI Analysis Subject Area: General Ledger - Balance Real Time "Period Name" range criteria issueContent Hello There, I am using a range critera BETWEEN for a OTBI analysis Subject Area: General Ledger - Balance Real Time column name 'Accounting Period Name' and thi…Donald 224 views 4 comments 0 points Most recent by Chandra Kiran Ushakoela Reporting and Analytics for ERP
-
HCM Extract completing with Alerts with no output generated when using aggregate conditionSummary: Hi Team, We have a requirement to get the sum of the attribute conditionally in HCM extract by using it as a summary element. When I am trying to make use of th… -
Mid Year Check In ReportSummary: Hi All, We have a requirement to fetch both the employee's & manager's responses to the questions for the 2022 Mid-Year Check In. Looking for a report which cov…Peeyush Chandel 41 views 4 comments 0 points Most recent by Peeyush Chandel Reporting and Analytics for HCM
-
How to convert English language to Arabic in rtf templateSummary: how to convert below English text into Arabic language and split it into two lines in rtf template. Example input text: "EIGHT HUNDRED FIFTY-SIX BAHRAINI DINARS…
-
Assignment EFF Rest APII am trying to query from postman with the relevant platform_id information using Assignment eff rest api,(/hcmRestApi/resources/11.13.18.05/emps/{empsUniqID}/child/assi…Cansel Karasoy 11 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
calculate the past experience in HCM BI ReportSummary: calculate the past experience in HCM BI Report Content (required): My client requirement is to calculate the past experience and current organization experience…