Category 81
Discussion List
-
BIP Query to list 'Data Security Policies' tied to a job roleSummary: Client has a requirement to list ALL the Inherited Roles, Privileges and 'Data Security Policies' tied to a job role. We are able to list the Inherited Roles, P…Shrikant Gupta 735 views 8 comments 0 points Most recent by inoappsms Reporting and Analytics for HCM -
How to add values from column to Dynamic column in OTBIHi All, We have a requirement, to add one column values (Answer) to Dynamic columns (Question). Please see the below screenshot to clearly understand the requirement. We…Chaitra Lakshmi Krishna 41 views 3 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
I need to update position of employees using HDL w.e.f 1st Feb 2025Summary: Hi There, Can someone help me with the HDL template to update the employees' position with effect from 1st Feb 2025. Appreciate your help! Thanks, Lakshmi. Cont…Lakshmi Devi Bathala 12 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Convert Fact columns into Measure type in OTBI to get subtotalSummary: Hello, We are building a basic report and we try to view total for Total, Taxable Monthly, Non Tax Monthly etc based on Accounting Date. The issue is that all t…Raluca Balan-Oracle 3 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Absence type display feature tab attributesGood day! I need help in identifying what is/are the table source/s for the items boxed in red below… it is in the Display Features tab in Absence Type: TIA.notautomni9 15 views 1 comment 0 points Most recent by Rajinikanth Sridharan-Oracle HCM-Oracle Workforce Management -
How to link absence details and payroll detailsSummary: Hi all We need a report that provides absence details along with the payroll elements processed based on those absences. Specifically, for the OFFICIAL TRIP abs…Shameer Muhammed P M 54 views 0 comments 0 points Started by Shameer Muhammed P M Reporting and Analytics for HCM
-
Licenses & Certs appearing on OTBI report but not seen in systemSummary: We are seeing a few different scenarios where our OTBI report is pulling in active (not expired) Content Items for employees, but we're not seeing them represen…Jessica D 61 views 5 comments 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM
-
25A New Feature : View Journeys Analytics - How to hide response Summary buttonSummary: We need to hide the Response Summary button, where Oracle soak testing confirmed this can not be handled by privileges, they told to raise SR and SR redirected … -
How to Customize the sub-template for AbsenceApprovalNotificationTemplate?I want to change a couple of words in the content of "AbsenceApprovalNotificationTemplate" workflow notification. As the required place was not found in the AbsenceAppro… -
How to add Role in the Parameters in the Absence Workflow?Summary: Setup a Workflow in Absence wherein we need to check if the initiator of the Absence Entry is a User that has a Specific Role. Requestor's Role Details is not a… -
We need to get Timecard reason on like WFH or Client Site and so onWe need to get Timecard reason on like WFH or Client Site and so on please help with relevant tables
-
Primary keysSummary: Is there any document listing the Primary keys to be joined in the fscm oracle pvo ? Content (please ensure you mask any confidential information): Version (inc…Lauriane Massin Whitaker 21 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for SCM
-
OTBI - Performance Subject area & field to pull Evaluation Topics, Perfomance and Core Value ratingsSummary: We need a report that pulls the manager ratings and comments from the Evaluation Topics section for the performance and core values. Content (please ensure you … -
Issue with the candidates merged record getting pulled into the OTBI reportSummary: We have built an OTBI candidate report to pull candidates in certain phases and states, we are excluding rejected by employer and withdrawn by candidate. We hav…
-
BIP error oracle.xdo11g.xqxp.XQException: FORG0001Summary: BIP error oracle.xdo11g.xqxp.XQException: FORG0001 Content (please ensure you mask any confidential information): Hi Team, Greetings! We have run into error for…Parag Hiremath 298 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Task Performer name in Workforce Management - Checklist Real Time is blank in OTBISummary: Task Performer name in Workforce Management - Checklist Real Time is blank in OTBI Content (please ensure you mask any confidential information): If the Task pe…AvinashP 21 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is Oracle BI Publisher Desktop Plug-In freeSummary: The Oracle BI Publisher Desktop Add-In, which can be downloaded to work with MS Word and Excel, requires a separate license for installation on machines. We are…User_OPF0Z 175 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Requirement for Custom QuerySummary: Hi Experts! We had a requirement from the customer to have a role which would grant access only to CONTRACTOR records and should satisfy the following condition…
-
Dies anyone know the table and field for "Enrollment Type Description" in OBTI Learning?Summary: Does anyone know is what the table and field that correspond to "Enrollment Type Description" and/or "Enrollment Type" in OBTI. Specifically under "Workforce Le…
-
How/Query/Report to identify HCM/Finance Admin privileges from the user rolesSummary: Hi Experts, We need to identify the roles which are having the admin privileges. Is there a way to pull this data from a query or the application? Thanks in adv…
-
Unable to see all privileges in Security - Roles and Privileges Real Time SAWhen I am trying to fetch roles & their respective privileges from subject area(Security - Roles and Privileges Real Time). It is not fetching all the privileges. Can so…SHRUTI PRIYA 21 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Succession Plan ReportHow to view All Private succession plan available in system in OTBI ?prags 61 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is it possible to report on Workforce Compensation Change Statement Volumes executed by managers?Summary: We have our Compensation Change statements configured to Printed and delivered by managers, we would like to monitor and report on how many managers are accessi…Adam_Cantwell 11 views 1 comment 0 points Most recent by Adam_Cantwell Reporting and Analytics for HCM
-
BIP Report schedule to send data only when it has dataSummary: I want to schedule a BIP Report daily but it only send the report if there is a data in the report. If the report does not have any data, it will skip. Content …Haikal Hamdan 32 views 3 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Sql query required to identify time card approver and assignee detailsSql query required to identify time card approver and assignee details. We tried to join hrc_txn_header, hrc_txn_data and fa_fusion_soainfra.wftask to get the details. B…Abhishek Jois 274 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Table for Manage Content TypesSummary: Hi team, Need a table or SQL quere where Manage content type information stored. Content (please ensure you mask any confidential information): Version (include…
-
How can we call BIP Report from Offer Progress Redwood Page through parameterSummary: Navigation: MyClientGroup>Hiring>Job Offer>Progress Content (please ensure you mask any confidential information): Version (include the version you are using, i…Nagendra Chitra-Oracle 21 views 0 comments 0 points Started by Nagendra Chitra-Oracle Reporting and Analytics for HCM
-
Converting to dateSummary: We have hire date and we are using this to create a two new columns called 'Current Year Anniversary Date' and 'Days to Anniversary Date'. It used to work earli…Simranjeet Singh 31 views 2 comments 0 points Most recent by Simranjeet Singh Reporting and Analytics for HCM
-
Can we send alerts to AOR via alert composersSummary: Hi Team, I have a quick query can we share alerts to AOR / role via alert composers Content (required): Version (include the version you are using, if applicabl…priyankatriv 31 views 8 comments 0 points Most recent by ShivaBildikarMGS Reporting and Analytics for HCM
-
Query to get Position History along with Changed Attributes.Summary : I have a requirement to find out Position History details along with the changed attributes as shown in screenshot below. If anyone have query for this kindly …