Category 81
Discussion List
-
Combine multiple Ethnicities in OTBI "Two or more races"Summary: Per the below - we have some Team Members that classify with more than one Ethnicity and the "Two or more race" option is no longer available in Oracle. This is…THawkins_LGI 211 views 16 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM -
How to hide Schedule option from BI Reports for ManagersSummary: We created a one of the report and provided folder read access to manager role, however - customer wanted to restrict the managers to stop schedule this report.…Rama123-Oracle 11 views 2 comments 0 points Most recent by Rama123-Oracle Reporting and Analytics for HCM -
Change to absence start or end date - event level reportingSummary: We have a requirement to report on changes to absence start and end dates i.e. when someone edits an existing absence. The OTBI Subject Areas are all Real Time …Amanda Hope 23 views 3 comments 0 points Most recent by Shivam Trivedi-Oracle Reporting and Analytics for HCM
-
Renamed position reportSummary: Hi, We have a requirement to report on changes to employees positions, which is fine but we have an issue when the Position name itself has been updated and the… -
How to eliminate duplicate measure after joining 2 OTBI subject areaSummary: Hi all, I have a report with 2 subject areas (HCM and Projects) Is there a way to show for highlighted values 8, instead on 40 reported hours? Basically is the …Raluca Balan-Oracle 14 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Required table for the Payment Method Preferences in PayrollSummary: Hi, Could you please let us know the table where the information of Payment Method preference stored for Payroll module. PAY_ORG_PAY_METHODS_VL has no informati…
-
Query to link between State and component group ruleSummary: what is the link between component group rule and this state through SQL query or backend table. We got one table HZ_GEOGRAPHIES where GEOGRAPHY_TYPE = 'STATE' …
-
custom email - how to add a link to access the systemSummary: Hi all, I would like to create a custom email. in the text of this email I would like to insert a link to access the system. in particular, I would like to inse…Alessandro Nesi 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Subject Area: Payroll - Personal Payment Details Real TimeHello, Could anyone help or confirm if the Subject Area: Payroll - Personal payment details real time can extract the Account Suffix for our Personal Payment Method? Cou…
-
How to embed Logo/Images in BI Publisher RTF Template in RTF Output formatSummary: How to embed Logo/Images in BI Publisher RTF Template in RTF Output format Need to Embed Logo in RTF output format for BI reports Template. Content (required): …Bala Kasineedi 337 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Need to make dynamic file name in BIP reportWe have a requirement to place the BIP report to SFTP server , file name should be dynamic as 'Filename_(sysdate-15)_(sysdate-3)'. I tried to make the filename as Filena…
-
Which table stores Career sites details in Recruiting?Summary: Which table stores Career sites details in Recruiting? Content (please ensure you mask any confidential information): Version (include the version you are using…
-
FDI - Is there a Manager Flag or Supervisor Indicator field available for selectionSummary: Is there a specific field within FDI that can be used to check if an Employee is also a Line Manager? e.g. If I used the the Subject Area MTS HR Analytics - Wor…David Thomson-265878 22 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
How to embed Dashboard to My Team Page tab?Summary: Content (required): Could you please advise where I can find the instruction on how to embed an OTBI dashboard into My Team as a new tab? Thank you! Version (in…Evgeniya Repnina 194 views 12 comments 0 points Most recent by Vittoria Reporting and Analytics for HCM -
Seeded Process/Report/Data Model customizationSummary: Once we did customization of seeded Process/Report/Data Model, after applied any patch/upgrade then the customization changes will override. Content (please ens…
-
What is the exact query to get all values of transaction consoleSummary: What is the Backend Query to get the transaction details of a particular transaction as it is appearing in the transaction console. Content (please ensure you m…JSAHOO1988 14 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
BIP Vs OTBI What is the practicality of moving BIP reports to OTBI?Summary: I am recommending that my client investigates the possibility of using OTBI in preference to BIP for their reports (including whether this is just for new repor… -
Unable to fetch Enrollment Action time, Disclaimer status and Assigned date in a BI report.We need to retrieve the Action Time, Disclaimer Status, and Assigned Date fields from benefit enrollment records for a BI report. However, these columns do not appear to…
-
How to connect organization hierarchy with job requisition?Summary: I am using recruiting real time subject area and trying to connect Job Requisition with Level 3 Organization Name but unable to get result on the Level 3 org na…
-
Does any OTBI subject area have these payroll schedule related columns?Do we have any OTBI subject area where we can fetch these columns? Period Schedule Name, Period Schedule ID, Usage, Frequency, Period Start Date, Period End Date, Paymen…MeghnaDe 13 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Can we filter data using values from two columns?Summary: To obtain the data using values from two different columns. Content (please ensure you mask any confidential information): I am working with Workforce Managemen…Pranav Waichal 22 views 5 comments 0 points Most recent by Pranav Waichal Reporting and Analytics for HCM -
Impact on BIP Schedule if Only Data Model is ChangedSummary: I’m planning to make changes to the data model of a BIP report. I want to confirm whether modifying only the data model will have any impact on the current repo…KHALED IHADDADENE 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Historical FTE values in BICCHi, The customer would like to extract assignment history data, including FTE, using BICC. I found that we can retrieve historical assignment data through HcmTopModelAna…
-
Why is "Compensation - Salary Details Real Time" so slowSummary: We have an employee roster/list that uses "Compensation - Salary Details Real Time" If we use 3 columns from that subject area (pairing with Person Seniority an…Monique 41 views 5 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Workforce Goals - Goal Tasks Real Time 'Development Goal.description same as 'Task Name.description'Creating a simple analysis to report each development goal along with it's associated task(s) by using the Workforce Goals - Goal Tasks Real Time subject area. The 'Deve…
-
How can we convert CLOB datatype to string in OTBI Reports?Hello, We are trying to remove HTML tags from a CLOB datatype column in OTBI report by using Substring and Replace function in the analysis. This is resulting us to get …Vaishnavi Katiyar 25 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI British Summer Time effecting dates in Payroll - Element Entries History Real TimeSummary: British Summer Time (GMT +1) is producing incorrect results from the date Prompt using Effective Start annd End Dates Content (please ensure you mask any confid…Kevin Robertson 5 views 0 comments 0 points Started by Kevin Robertson Reporting and Analytics for HCM
-
Options to control and monitor the download of Custom BI ReportsHi, We have a custom BI Report containing multiple layouts The client has raised a request to understand anyone options on how to do the below Information on options: Te…Steven_Bullock 11 views 4 comments 0 points Most recent by Steven_Bullock Reporting and Analytics for HCM
-
Query to extract attachment URL (i.e. Document of Records; Skill and Qualifications)Summary: Content (required): Hello experts, do you have a query to retrieve the attachment URL? In other words, I need to retrieve the URL for some Document of Records a…Valerio Curzi 1.4K views 10 comments 0 points Most recent by Robinson Ng Reporting and Analytics for HCM -
Organization tree OTBISummary: We have an Organization Tree in Fusion HCM where: LE = Top Parent Node Division = Child Node under LE Departments = Child Nodes under that Division LE-->Divisio…charan_Gudla 36 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM