Reports
Discussion List
-
we joined two subject areas but when we apply single country it is woking fine but multiple not workSummary: Hi All, we joined two subject areas but when we apply single country it is woking fine but multiple not working. stlll searching mode ? subject area: workforce …AjayKumar Maddipati 21 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to extarct DDL of table in oracle fusion HCM/FSCMHi, We need to extarct DDL for few tables like column name, data type, size, primary key , foreign key constraints . We tried sql query approach but due to data type siz…hiteshsaroha 41 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
How to fetch attachments from OTBISummary: Hi Expert, Currently, I'm using "Recruiting - Recruiting Real Time" & "Recruiting - Recruiting Event Real Time" Analysis and want to see the attached file in my…Saher 136 views 2 comments 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Report to use in journeys e-sign task to pull employee job's job descriptionSummary: Hi, We would like to trigger a journey to internal employees when there is a job change action performed on their employee assignment. I see action "job change"…
-
Issue with extract for termination detailsSummary: We are using this extract from couple of months back . It is working for all other employees. Only 2 employees facing issue with termination details , we could …Vishnupriya 39 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Query to fetch 'Report Job Histories' data from 'Manage Job History'Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…jahanavi metta 78 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Manage Enterprise HCM InformationSummary: Hello everyone, I have a report about Manage Enterprise HCM information. Can anyone advise on how to pull the corresponding columns? You can find them by naviga…Chris Carloff 41 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Help with "Guide me" ReportSummary: Hello, I am building a report that fetches information about Grade Ladder, Grade Name, Step Name, and Value. The query itself is not an issue. However, I need t…Matheus Roberto 11 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Need to fetch Resignation/Termination withdrawn after last working dateSummary: Hi, There is a requirement to pull all the employees who has withdrawn the resignation/terminations after the last working day need to include pending for appro…Aruna Aounti -Oracle 1 view 0 comments 1 point Started by Aruna Aounti -Oracle Reporting and Analytics for HCM
-
Recruiting Real Time: Application Questionnaire reports take several minutes to generateSummary: When trying to run a basic query from RRT Application Questionnaire, it takes several minutes to run the query. Does anyone have ideas on how to improve reporti… -
Need a report with following fields employee name,# of reportees, # of “reporting levels”Summary Need a report with following fields employee name,# of reportees, # of “reporting levels”User_2025-02-07-09-10-02-492 15 views 11 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Manage Administrator Profile Values - Is there a Report for this?Summary Get list of all Enabled Profile Values - Manage Administrator Profile ValuesContent Hi All Could any of you have a Report for the Administrator Profile Values? W…Mansur Khalil 184 views 8 comments 1 point Most recent by Natwar Singh Rajawat Reporting and Analytics for HCM -
Issue with Dependent Filters and Multiple Selections in BIP Report for CoursesSummary: Hi Team & @AshishERPCloud, I have created the BIP report for the Courses. Where I have given the filters of Course, Offering, Business Unit, Start and End Dates…Dasari Dileep 51 views 2 comments 0 points Most recent by SAI KOMATIREDDY Reporting and Analytics for HCM
-
How to add Business Title from Worker Assignment Realtime in User System Usage subject area?I have created an analysis under User System Usage subject area. However, upon adding Business Title column from Worker Assignment Realtime subject area, data became emp…Welsey 11 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Learn Module | SQL query to get specialization details , module name, offering name, enrolled learneContent Hi All, I am working on a report where I need to fetch specialization details and its' corresponding module name, offering name, enrolled learners, current statu…Arti P 1.8K views 8 comments 0 points Most recent by Sriram Shashank Reporting and Analytics for HCM
-
Customize- Payroll Register Report for the Latest ProcessSummary: Can we add additional attributes by customizing the seeded extract "Payroll Register Report for the Latest Process". Content (required): Can we add additional a…Mohan Murali 131 views 6 comments 1 point Most recent by Nithya_Bussety-Oracle Reporting and Analytics for HCM
-
Termination Approval Process ReportHi… does someone have a report, either an OTBI or BIP, that captures the full termination process with comments, who it is/was assigned to, and status. We are having iss… -
Matrix Managers field onto a reportSummary Need to pull Matrix Manager field onto a standard OTBI reportContent Need help to understand how can I pull Matrix Manager field (Type as Matrix Manager in myHR)…Abhishek Bagh 225 views 3 comments 0 points Most recent by Brent_Beardsley Reporting and Analytics for HCM
-
If a EFF does not have a value is there a way to pull it into reporting?Summary: We have some positions that have Extensible flex fields entered for Background checks and Licenses - but some of the positions do not have this yet (so essentia…THawkins_LGI 61 views 17 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Multiple Assignment ReportSummary: Does anyone have an XML or data model that captures employees with two (or multiple) active work assignments; showing job, department and manager details. Conte…
-
Building a custom report for pay ratesSummary Client is using the newly released salary basis based on rates of pay. There are no OTBI subject areas and need to create a new data model.Content The tables hol…User_2025-01-28-05-08-05-606 71 views 2 comments 0 points Most recent by Rajesh Jupudi-Oracle Reporting and Analytics for HCM
-
Extract run Failing after adding new FastFormulaSummary: Extract is failing after adding new rule to get the correct parking tier based upon employee salary Content (please ensure you mask any confidential information…GauravGupta39 23 views 4 comments 0 points Most recent by GauravGupta39 Reporting and Analytics for HCM
-
OTBI report prompt to display only direct reports for Line managersSummary: We have created an OTBI report using the subject area - 'Workforce Learning - Learning Management Real time'. We have created a prompt which displays all the Em…Sovan Mishra-Oracle 491 views 9 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Difference between Headcount and worker count in fusion analytics dashboardsSummary: Why are there two extremely similar workbooks (for many metrics) which include Person Count and some which do not. Their descriptions show the only difference i…ClayJ 21 views 2 comments 0 points Most recent by community-dw-integration Reporting and Analytics for HCM
-
looking for ytd and ptd bip reportSummary: lookind for ytd and ptd bip report Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Co…
-
Can i see what a user sees from PER_ASSIGNMENT_SECURED_LIST_VWe have a user downloading a report but seeing just 600 result compared to another users that can see more than 800. The only thing in the report that could prevent him …margherita bonfiglio 21 views 2 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
Page breaks do not work for bursting (RTF template -> Excel output)Report has RTF template and it is exported to XLSX format only. Resulted Excel has 2 separated sheets (from functional logic one Excel file contains 2 reports are spaced…Sourabh Patial 13 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
BIP encryption with UTF-8 encoded csv fileHi Team, Can you please help me know how to generate a UTF-8 encoded csv file with encrypted pgp extension file. I am using etext template. Thanks.SM_EP 14 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Unable to find table name that stores comments from 'Request more Info' section of BPM approvalsSummary: Hi All, Unable to find where the comments are stored from 'Request more Info' section of BPM approvals. It's not in table FND_BPM_TASK_COMMENT or HRC_TXN_COMMEN…Nirmal Ignatius 11 views 3 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM -
BI Report on candidate interaction date as per applicationNeed BI Report on candidate interaction date as per application. Code Snippet (add any code snippets that support your topic, if applicable):Aishwarya Somvanshi 11 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM