Category 81
Discussion List
- 
             Ability to burst output file from BIP Report to OCI object storageWe have a requirement to burst output files of BIP reports to the OCI object storage buckets. Currently we don't see any delivery option in bursting that supports this. …Phaneendra Vallapu 163 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM Ability to burst output file from BIP Report to OCI object storageWe have a requirement to burst output files of BIP reports to the OCI object storage buckets. Currently we don't see any delivery option in bursting that supports this. …Phaneendra Vallapu 163 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
- 
             Accessing worker details in learning report by learning specialistDear Community, We have the BIP report request from user which required to show worker name, worker number and department information in the report. While the users are … Accessing worker details in learning report by learning specialistDear Community, We have the BIP report request from user which required to show worker name, worker number and department information in the report. While the users are …
- 
             A HR rep user should access all active emp of USA, except Partner and Managing Partner jobs in OTBIPrevious access rights: all employees in USA New access rights to be given: all employees in USA, except Partner and Managing Partner jobs The active employees report is…Shouvika 1 view 1 comment 0 points Most recent by Deaconu Constantin Valentin-Oracle Human Capital Management A HR rep user should access all active emp of USA, except Partner and Managing Partner jobs in OTBIPrevious access rights: all employees in USA New access rights to be given: all employees in USA, except Partner and Managing Partner jobs The active employees report is…Shouvika 1 view 1 comment 0 points Most recent by Deaconu Constantin Valentin-Oracle Human Capital Management
- 
             Learning assignment alert delivery reportSummary: We have a requirement to report on the delivery of compliance assigned training alerts for audit purposes. Content (please ensure you mask any confidential info… Learning assignment alert delivery reportSummary: We have a requirement to report on the delivery of compliance assigned training alerts for audit purposes. Content (please ensure you mask any confidential info…
- 
             Need a standard SQL query documentation?Can someone please share a Oracle standard SQL query documentation?Gowri Perumal 21 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM Need a standard SQL query documentation?Can someone please share a Oracle standard SQL query documentation?Gowri Perumal 21 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
- 
             How can we fetch Calendar year to date value of any balance in Oracle BI Report.Need to fetch Calendar Year to Date value in Report.Sourabh_Patial 145 views 3 comments 0 points Most recent by Siddarth G L Reporting and Analytics for HCM How can we fetch Calendar year to date value of any balance in Oracle BI Report.Need to fetch Calendar Year to Date value in Report.Sourabh_Patial 145 views 3 comments 0 points Most recent by Siddarth G L Reporting and Analytics for HCM
- 
             Per_Periods_Of_Service Not adding a Row for Voluntary Termination ActionsWe have been noticing that certain termination actions are NOT hitting the per_periods_of_service table. For example, if I submit a retirement for myself and it goes to … Per_Periods_Of_Service Not adding a Row for Voluntary Termination ActionsWe have been noticing that certain termination actions are NOT hitting the per_periods_of_service table. For example, if I submit a retirement for myself and it goes to …
- 
             HR benchmarking data - best practicesHello All We have recently been requested to pull HR bench-marking data, so we can do some analysis on KPIs and metrics that represent the typical performance within our…Clare Murtagh 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM HR benchmarking data - best practicesHello All We have recently been requested to pull HR bench-marking data, so we can do some analysis on KPIs and metrics that represent the typical performance within our…Clare Murtagh 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
- 
             how can I get multiple seniority dates on the same row in OTBIContent (required): I am reporting from assignment real time, person real time, and person seniority real time. When I have Seniority Date showing, there is one row with…Monique Dias 121 views 9 comments 1 point Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM how can I get multiple seniority dates on the same row in OTBIContent (required): I am reporting from assignment real time, person real time, and person seniority real time. When I have Seniority Date showing, there is one row with…Monique Dias 121 views 9 comments 1 point Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM
- 
             Subject Area (or Table) for Regional General Preferences?Summary: Are the General Preferences: Regional reportable in OTBI/BIP? Content (please ensure you mask any confidential information): Hello everyone, Asking if it is cur…Tom John Bontoyan 21 views 2 comments 0 points Most recent by Anusha B S Reporting and Analytics for HCM Subject Area (or Table) for Regional General Preferences?Summary: Are the General Preferences: Regional reportable in OTBI/BIP? Content (please ensure you mask any confidential information): Hello everyone, Asking if it is cur…Tom John Bontoyan 21 views 2 comments 0 points Most recent by Anusha B S Reporting and Analytics for HCM
- 
             Seeded Head Count Reports Not WorkingSummary: We have been trying to run the seeded Head Count reports for our client but none of them have been rendering data. Content (please ensure you mask any confident…Vibha Pandey - Oracle 43 views 3 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM Seeded Head Count Reports Not WorkingSummary: We have been trying to run the seeded Head Count reports for our client but none of them have been rendering data. Content (please ensure you mask any confident…Vibha Pandey - Oracle 43 views 3 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM
- 
             Location Based Access Control (LBAC) and it's Impact on Linkedin IntegrationSummary: Hi All, We are implementing LBAC in our Fusion Application. For 3rd party applications we are whitelisting their IP address and making Roles Public. But we have…Prashant Kumar - 2103 31 views 2 comments 0 points Most recent by Anil Rout-Oracle Applications Security Location Based Access Control (LBAC) and it's Impact on Linkedin IntegrationSummary: Hi All, We are implementing LBAC in our Fusion Application. For 3rd party applications we are whitelisting their IP address and making Roles Public. But we have…Prashant Kumar - 2103 31 views 2 comments 0 points Most recent by Anil Rout-Oracle Applications Security
- 
             Scheduled classes not available in Learning Calendar Summary dashboard?Archived Learning Calendar Dashboard from Oracle demo instance. and unarchived dashboard in our instance. Data is displaying like this but, in oracle demo instance it is…YAMINI DANTOORI 21 views 1 comment 0 points Most recent by AmyLopesNF Reporting and Analytics for HCM Scheduled classes not available in Learning Calendar Summary dashboard?Archived Learning Calendar Dashboard from Oracle demo instance. and unarchived dashboard in our instance. Data is displaying like this but, in oracle demo instance it is…YAMINI DANTOORI 21 views 1 comment 0 points Most recent by AmyLopesNF 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. 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.
- 
             How to suppress values in OTBI?I've created an analysis under User System Usage subject area. I'd like to suppress the values like on what I've drawn below: Though I've already configured it to the co… How to suppress values in OTBI?I've created an analysis under User System Usage subject area. I'd like to suppress the values like on what I've drawn below: Though I've already configured it to the co…
- 
             Table for BPM Worklist vacation periodNeed a query for BPM Worklist vacation period Rules. Which table stores the below information.Aishwarya Somvanshi 144 views 3 comments 0 points Most recent by Madhavi.Modala Reporting and Analytics for HCM Table for BPM Worklist vacation periodNeed a query for BPM Worklist vacation period Rules. Which table stores the below information.Aishwarya Somvanshi 144 views 3 comments 0 points Most recent by Madhavi.Modala Reporting and Analytics for HCM
- 
             How to connect periods of service with schedule assignmentsSummary: Hello, I am currently trying to report on the work schedule assignments for employees with a past termination date. Would anybody know how to connect the two ta…Dan_Hinsley 31 views 4 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM How to connect periods of service with schedule assignmentsSummary: Hello, I am currently trying to report on the work schedule assignments for employees with a past termination date. Would anybody know how to connect the two ta…Dan_Hinsley 31 views 4 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
- 
             How to run Oracle Standard Cheque Report of Payroll of HCMSummary: Hello, I wanted to run the oracle seeded report cheque report of payroll module of HCM. But I don't know how to run this report. Thanks Content (please ensure y… How to run Oracle Standard Cheque Report of Payroll of HCMSummary: Hello, I wanted to run the oracle seeded report cheque report of payroll module of HCM. But I don't know how to run this report. Thanks Content (please ensure y…
- 
             Runtime Properties on BI Published Configuration SettingsHello, Recently, the Sever value for parameter "Exclude Line Feed And Carriage Return for LOB" was updated to TRUE which caused some of our interfaces to exclude Line Fe…Nishit Doshi 11 views 1 comment 0 points Most recent by Sunder Subramanyan-Support-Oracle Reporting and Analytics for HCM Runtime Properties on BI Published Configuration SettingsHello, Recently, the Sever value for parameter "Exclude Line Feed And Carriage Return for LOB" was updated to TRUE which caused some of our interfaces to exclude Line Fe…Nishit Doshi 11 views 1 comment 0 points Most recent by Sunder Subramanyan-Support-Oracle Reporting and Analytics for HCM
- 
             BI Report ran using SOAP service is not picking multiple input parametersSummary: We have a requirement to run BI publisher report using SOAP request. There are 3 input parameters there in the report as well as passed through the SOAP request… BI Report ran using SOAP service is not picking multiple input parametersSummary: We have a requirement to run BI publisher report using SOAP request. There are 3 input parameters there in the report as well as passed through the SOAP request…
- 
             Exit interview questionnarieSummary: Exit interview questionnarie Content (required): Hi All, We got requirement to develop a BI report for exit interview questionnaire details. In that Exit Interv… Exit interview questionnarieSummary: Exit interview questionnarie Content (required): Hi All, We got requirement to develop a BI report for exit interview questionnaire details. In that Exit Interv…
- 
             Line Manager Email notification with their Employees Due and OverDue Trainings in LearningSummary: Line Manager Email notification with their Employees Due and OverDue Trainings in Learning Content (please ensure you mask any confidential information): We hav… Line Manager Email notification with their Employees Due and OverDue Trainings in LearningSummary: Line Manager Email notification with their Employees Due and OverDue Trainings in Learning Content (please ensure you mask any confidential information): We hav…
- 
             How to query user details if person_id and party_id are null and no data in per_ldap_users?Summary: Customer has requested a report to display all the usernames along with their first name, last name, email etc. I have encountered a username for whom person_id…Abhi_19 354 views 2 comments 0 points Most recent by Adrian Nae-Oracle Reporting and Analytics for HCM How to query user details if person_id and party_id are null and no data in per_ldap_users?Summary: Customer has requested a report to display all the usernames along with their first name, last name, email etc. I have encountered a username for whom person_id…Abhi_19 354 views 2 comments 0 points Most recent by Adrian Nae-Oracle Reporting and Analytics for HCM
- 
             Is it possible to query Content server objects?Summary: I would like to query a list of specific Content ID's from object in the content server (https://.fa.em2.oraclecloud.com/cs). Is it possible to find the content…Mia Tøttrup 91 views 3 comments 0 points Most recent by Mia Tøttrup Fusion Applications Administration Is it possible to query Content server objects?Summary: I would like to query a list of specific Content ID's from object in the content server (https://.fa.em2.oraclecloud.com/cs). Is it possible to find the content…Mia Tøttrup 91 views 3 comments 0 points Most recent by Mia Tøttrup Fusion Applications Administration
- 
             Dimension Folder Not Visible in Subject Area But It Is SearchableGood Day Experts, There are times when I am creating an analysis report. Some folder-columns are not visible in the subject area but it is showing when searching in the …JMLMIII 11 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM Dimension Folder Not Visible in Subject Area But It Is SearchableGood Day Experts, There are times when I am creating an analysis report. Some folder-columns are not visible in the subject area but it is showing when searching in the …JMLMIII 11 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
- 
             FTE seasonal, temp, part-time workers not working year-round or full time (40) hrs per weekSummary: FTE / Headcount “how to” calculate for seasonal, temp and part time employees who don’t work year-round or full time (40) hours / week. FTE for someone working …MissHeidiJ 11 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Human Capital Management FTE seasonal, temp, part-time workers not working year-round or full time (40) hrs per weekSummary: FTE / Headcount “how to” calculate for seasonal, temp and part time employees who don’t work year-round or full time (40) hours / week. FTE for someone working …MissHeidiJ 11 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Human Capital Management
- 
             Data not appearing on all tabs of an Excel report when run as a payroll FlowSummary: We have an HDL Error report that is based on a Data Model and creates an Excel spreadsheet with 3 tabs of data. The first tab is the Summary, the second lists a…Al Darabaris 11 views 3 comments 0 points Most recent by Al Darabaris Reporting and Analytics for HCM Data not appearing on all tabs of an Excel report when run as a payroll FlowSummary: We have an HDL Error report that is based on a Data Model and creates an Excel spreadsheet with 3 tabs of data. The first tab is the Summary, the second lists a…Al Darabaris 11 views 3 comments 0 points Most recent by Al Darabaris Reporting and Analytics for HCM
- 
             Custom Expense Approval Notification (Preferred Name)Overall Question: How can I use a custom Report/DM for expense report notifications instead of the delivered one? Context: We have a requirement that our Expense Report …Alex Cardenas 54 views 9 comments 0 points Most recent by Alex Cardenas Reporting and Analytics for HCM Custom Expense Approval Notification (Preferred Name)Overall Question: How can I use a custom Report/DM for expense report notifications instead of the delivered one? Context: We have a requirement that our Expense Report …Alex Cardenas 54 views 9 comments 0 points Most recent by Alex Cardenas Reporting and Analytics for HCM
- 
             How can we get a list of all Scheduled BIP Reports in Oracle HCM CloudSummary: We are looking for a SQL using which we can get a list of all Scheduled BIP Reports and their recent status Content (please ensure you mask any confidential inf…Mridula Mitra Pal 52 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM How can we get a list of all Scheduled BIP Reports in Oracle HCM CloudSummary: We are looking for a SQL using which we can get a list of all Scheduled BIP Reports and their recent status Content (please ensure you mask any confidential inf…Mridula Mitra Pal 52 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
- 
             Solved:I cannot find DOC ID 2478863.1 How to Download and Use the Microsoft Word BI Publisher PluginSummary: Solved by using firefox and using How to Install BI Publisher Desktop Template Builder Add-In - Microsoft Office - Office 365 (Doc ID 2591350.1) ===============…RichardFoxFoxTaskForceNatureScot 242 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM Solved:I cannot find DOC ID 2478863.1 How to Download and Use the Microsoft Word BI Publisher PluginSummary: Solved by using firefox and using How to Install BI Publisher Desktop Template Builder Add-In - Microsoft Office - Office 365 (Doc ID 2591350.1) ===============…RichardFoxFoxTaskForceNatureScot 242 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM