BI Publisher
Discussion List
-
Average Salary per HourSummary: We have an OTBI analysis with each department headcount and I need to get the average salary rate per hour in another column. Content (please ensure you mask an…Ayesha Iroshani 14 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
change sql query timeoutSummary: Content (required): Hi team, we need to increase sql query timeout. We saw from some service requests (https://support.oracle.com/epmos/faces/DocumentDisplay?_a…Claudia Schiff 520 views 4 comments 0 points Most recent by Rebecca Hawker 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 18 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM
-
How to get BIP Scheduled Report To Update 'As of Date' When RunSummary: Hello, I'm having issues with a BIP scheduled report not updating the 'As Of Date' prompt when it's scheduled to run/send to the user. I have the report schedul…
-
per_availability_details.get_availability_detailsTeam, We have a requirement to get scheduled hours from work schedules for all the assignments which falls in the period passed in parameter time period start date (:TC_…
-
Chetana Pawar 25 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Manage Legal Reporting Unit Registrations ReportSummary: Manage Legal Reporting Unit Registrations Report Content (please ensure you mask any confidential information): Hi All, Greetings! May be this is something I se…Parag Hiremath 6 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Manage Legal Reporting Unit HCM Information ReportSummary: Manage Legal Reporting Unit HCM Information Report Content (please ensure you mask any confidential information): Hi All, Greetings! May be this is something I …Parag Hiremath 18 views 0 comments 0 points Started by Parag Hiremath 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…
-
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 16 views 2 comments 0 points Most recent by Rajesh.Vadlamani 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 46 views 9 comments 0 points Most recent by Nivya Mathire 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 …
-
Host address in BI publisher reportIs it possible to get the host address in the BI publisher report? Regards, NivyaNivya Mathire 44 views 8 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM
-
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 105 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…
-
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 523 views 3 comments 0 points Most recent by Amrit Reporting and Analytics for HCM
-
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 3.2K views 3 comments 2 points Most recent by Shrikant Gupta 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 97 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 56 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 78 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Sending of analysis to managers via agentsSummary Sending of analysis to managers via agentsContent Hi - We have set up a number of Analysis which are currently being sent to different business units / locations…Roy Paolo Paunlagui 76 views 9 comments 0 points Most recent by Catherine Abi Samra Reporting and Analytics for HCM
-
Formatting issues in excel template for BIP report (formatted as number in data model but is text)Summary: So, we have a BIP report which details the amount for various pay elements, the element name is hard coded in sub select clauses so we can control the column or…
-
How to get 'Email From Address' in query?Hi, Can someone help me to get the 'from email address' configured in BI server by sql? Regards, NivyaNivya Mathire 64 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
OPSS Audit Report BIP TablesSummary: What are the Tables used in the Oracle Platform Security Services (OPSS) Audit Reports? Need for a BIP Report Content (required): Hello everyone, I have a repor…Tom John Bontoyan 38 views 2 comments 1 point Most recent by Adrian Dogeanu-Support-Oracle Reporting and Analytics for HCM
-
I need to retrieve previous year performance ratings , which tables can I useSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…PranayBhargava13 6 views 1 comment 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
Tables to capture details about the Absence current and previous plan detailsHi All, I'm currently working on capturing details about an employee's current and previous absence plans. I'm seeking guidance on the specific tables that would contain…Sanduni Pathirathne 179 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
in OTBI Performance Report Completion Weight value not showing the total weight percentageSummary: OTBI Performance Report needs to show the Completion Weight percentage value display as the total. it is displaying as the separate Completion Weight percentage…Ritu Surve 16 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Report to extract Assessment Questionnaire of Learning sectionSummary Need to extract assessment questionnaire of an offering linked to a learnerContent Hi All, I am trying to extract the assessment questionnaire with the answers i…teresa.marciano 701 views 3 comments 1 point Most recent by YASHWANTH GOWDA H R Reporting and Analytics for HCM
-
Is it possible to fetch Projected Start Date changes of Pending Workers through HCM Extract or OTBISummary Is it possible to fetch Projected Start Date changes of Pending Workers through HCM Extract or OTBI or BIP?Content Hi Experts, We are working on a requirement to…Harish Kumar Kovi 201 views 4 comments 0 points Most recent by 'Reekey Reporting and Analytics for HCM