BI Publisher
Discussion List
-
How to get ESS job schedule end date for all scheduled ESS JobsSummary: How to get ESS job schedule end date for all scheduled ESS Jobs Content (please ensure you mask any confidential information): Hi Team, Greetings! We have multi…Parag Hiremath 6 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM -
Extra blank line in Excel output from BI Publisher RTF template due to using page break to get multiSummary Extra blank line in Excel output from BI Publisher RTF template due to using page break to get multiple tabsContent Hi Experts, I have a problem. There is a BI R…Aloka Bhattacharya 304 views 14 comments 0 points Most recent by User_39GIV Reporting and Analytics for HCM -
Oracle Compatible Tamil FontSummary: I have a Letter development which need to compile with Tamil Font. For that I have using Using NirmalUI font and it works fine with word format and rtf format. …Dhajani Perera 5 views 0 comments 0 points Started by Dhajani Perera Reporting and Analytics for HCM -
Hide Disable Actions Menu in BI Publisher Report or Hide Export and Schedule buttonSummary: I want to hide Action menu in BI Publisher Report or want to hide Export and Schedule button. Only need online view. Is there any way to do this ? Version (incl…
-
Report on questionaire details tagged to a courseHi, I have requirement to fetch Questionaire name, question text and answer text tagged to activity of a course but I am facing an issue while joining the learning item …
-
Reporting for Workers CompGood morning. I am in need to find a report that will show rates and also a worker's comp audit report. Has anyone had success with these types of reports.?Tisha Negrete 7 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
BI Report Catalog window (Data Model ) to be made Read OnlySummary: Please refer attachement. I need to make the BIP reports query read only in BIP Content (please ensure you mask any confidential information): Version (include …Preeti Khondre 11 views 2 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
which table can store the information about user's parent & child relationship roles in fusion hcmHi All, Thanks for looking into this issue. I am looking for table, which can store the current logged user parent -child roles(for Ex: One big role have more number of …Ravindr-Oracle 36 views 4 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
How do you display the run date, time (AM/PM), and timezone. Example 11/28/23 11:57 AM ESTSummary: When running a BIP report I am trying to show the timezone of the run date and time being displayed. I am using an RFT template. Content (please ensure you mask…
-
Is there a report I can run with earnings history?Summary: Is there a report I can run with earnings history? Content (please ensure you mask any confidential information): Version (include the version you are using, if…
-
OTBI Training Tutorials on YouTubeSummary OTBI Training Tutorials posted on YouTubeContent 26 OTBI, BIP & SmartView tutorials are now available on YouTube, Oracle Learning Library and Oracle HCM Cloud R1…User720640-Oracle 308 views 2 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Candidate status in reports?Hi, Can someone help me with the table to get "Candidate Status " value in recruiting? Regards, NivyaNivya Mathire 44 views 9 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
SQL query to get CPP Exempt and EI Exempt status from Tax Crdit InformationSummary: SQL query to get CPP Exempt and EI Exempt status from Tax Crdit Information Content (please ensure you mask any confidential information): Need SQL query to get…
-
RTF Excel Output Merging CellsTeam, We have developed BI Report with RTF template. When user exporting the output in Excel output the cells are getting merged. Example B & C columns are merged. We ha…
-
Talent Pool Report in Oracle BIPSummary: This report is required by the business to report on the grades of talent pool candidates while they are actively part of the talent pool and later, in future y…Pradnya_Pampatwar 24 views 4 comments 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM
-
OTBI > Transpose Rows to Columns in OTBI > Ability to Perform Sum Only on One RowSummary: OTBI > Transpose Rows to Columns in OTBI > Ability to Perform Sum Only on One Row Content (please ensure you mask any confidential information): Hello, We want …
-
job history reporthi Experts, From the below table I am able to get only the history of past one month. Does anyone now the table names to get the report for more than month ? fusion_ora_…
-
Select data which are displayed on the All-In-One EvaluationSummary: As per customer's request, I'd like to make a BI report that selects the data displayed on the All-In-One Evaluation. Content (please ensure you mask any confid…S.Watanabe0110-Oracle 22 views 0 comments 0 points Started by S.Watanabe0110-Oracle Reporting and Analytics for HCM
-
Host address in BI publisher reportIs it possible to get the host address in the BI publisher report? Regards, NivyaNivya Mathire 46 views 8 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM
-
Get Time Card Period (Employee Time Card Details)Summary: We have a requirement to get employee's timecard (timeentry details) ... daywise. We have got the measure (days) from the table hwm_tm_rec using the resource_id…
-
Where can I find the database table that holds Segment Value Security Conditions and Policies?Summary: I'm looking for the table in the database where Segment Value Security Conditions and Policies live. Content (required): I am making some changes to the rules a…David Rabalais 60 views 2 comments 0 points Most recent by David Rabalais Reporting and Analytics for HCM -
How to stop BI Workflow Notifications (Personal Information - Disability Info) in Fusion HCMSummary: A BI notification is triggered when an employee enters Disability Info (Navigation Person Details -> Disability Info). We can see there are a couple of seeded B…Nitin-Jain 20 views 2 comments 0 points Most recent by Mandeep Gupta Reporting and Analytics for HCM
-
BI Report to show all Employee/Manager HierarchySummary BI Report to show all Employee/Manager HierarchyContent Hi Community I am trying to build a report which shows all employees and their managers.. I need it to sh…Kunal Daya-175386 304 views 3 comments 0 points Most recent by Amrit Reporting and Analytics for HCM
-
Query to find schedule details of a BIP reportSummary: Content (required): Hi Team, Is there a way to identify the schedule details of a BIP report like schedule start date, schedule end date, frequency etc? Version…Mandeep Gupta 239 views 6 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
How we can pull old assignments and old payroll name?I need logic for old assignments and payroll name, it will be appreciable if you will provide me any sample query. This is the Requirement Global Transfers processed in …
-
organization hierarchy report using per_org_tree_node_cf and per_org_tree_node_rf tablesSummary organization hierarchy report using per_org_tree_node_cf and per_org_tree_node_rf tablesContent HI Team, report has to be developed in the column format parent_n…Hanuman Chennamsetty 418 views 3 comments 2 points Most recent by User_1KIIB Reporting and Analytics for HCM
-
Sending emails using agents to recipients from an analysisContent Hi I want to send reports to users using agents. The problem is, I want to send different data to each recipient based on their requirements. e.g. I would like t…Mohit Gupta-45440 81 views 10 comments 0 points Most recent by Catherine Abi Samra Reporting and Analytics for HCM -
What role or privilege do we need to access "Inherit Segment Value Attributes" ESS JobSummary: We would like to understand what role or privilege do we need to access "Inherit Segment Value Attributes" ESS Job. We tried searching for this in OTBI and "Man…
-
Hiding Schedule and Job from BIP report part of dashboardSummary: Hiding Schedule and Job from BIP report part of dashboard Content (please ensure you mask any confidential information): Hi, We've a BIP report part of a dashbo…Bhavna-Civeo 19 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Query to find Ownership type of candidate pool(Private, Shared, Global)Summary: I need to show ownership type(Private, Shared, Global) of Candidate Pool in BI report. I am unable to find any table that stores this information. However, ther…Sujay Bhowmick 29 views 3 comments 0 points Most recent by Mandeep Gupta Reporting and Analytics for HCM