BI Publisher
Discussion List
-
Does anyone know the arguments for pay_balance_utility.get_bal_grp_usage_values?Summary: Content (required): I would like to run a quick SQL to validate the balance group usage without creating and running a full HCM Extract. This procedure was ment…Scott Paulin 71 views 8 comments 0 points Most recent by Scott Paulin Reporting and Analytics for HCM -
How to sort characters numerically in OTBI?I'd like to order these custom values in OTBI numerically. However, this is how my current values sorted: The requirement is to sort them like this: 0-0.5 0.5-1 1-3 3-5 … -
Adding Grade Details to Standard Approval Workflow Notifications using Custom templateBusiness has a requirement to add Grade under Employment Details section that is displayed in the delivered/standard Workflow Approval notifications. We have tried achie…Neeraj Awate 12 views 1 comment 0 points Most recent by Claudiu Postolache-Support-Oracle Human Capital Management
-
Is the Revoke User Access field from HCM termination process available in BI Publisher?Summary: The field "Revoke User Access" stores option of revoking user access on Termination. We need to pull it in a BI Publisher report, but we have not been able to f…
-
Oracle HCM Table for currency exchange ratesSummary: Content (required): Hello experts, we have implemented custom BI Compensation reports displaying payroll elements and amounts in local currencies. Our customer …Valerio Curzi 291 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Salary Amount Fast Formula Compilation ErrorSummary: Fast Formula for getting Salary Amount is giving compilation error saying: the assignment uses inconsistent data types Content (please ensure you mask any confi…
-
User System Usage ReportSummary: User System Usage Report Content (please ensure you mask any confidential information): Hi Team, Greetings! We are looking to get the data for the periodic or d…Parag Hiremath 132 views 2 comments 0 points Most recent by Parag Hiremath Fusion Applications Administration -
Solutioning Data Archival for US(United States) and CA(Canada) Legislations.Summary: My Client has a requirement to archive complete fusion data and I want to understand how could we preserve anything and everything from Fusion HCM Cloud's Criti…SAHILVASYANI 41 views 5 comments 0 points Most recent by Anca Andronic-Oracle Payroll and Global Payroll Interface (GPI)
-
Need report of SVC_SERVICE_REQUESTS table details with SR employee, his dept, reporting dept, team,Summary: Need report of SVC_SERVICE_REQUESTS table details with SR employee, his dept, reporting dept, team, unit,section, trying with following query, but i am getting …
-
how to get the length of service based on gradeSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…a.w.anand 11 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to get Federal Tax Exempt and commission Information from Tax Calculation Card in OTBISummary: How to get Federal Tax Exempt and commission Information from Tax Calculation Card in OTBI Content (please ensure you mask any confidential information): Versio…
-
CSV output in body and attachmentSummary: Is it possible to show data in CSV format in the body of the email bursting as well as in an attachment? Content (please ensure you mask any confidential inform…Consultant Ian 11 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM -
Unable to configure RTF Template on the basis of DatesSummary: Unable to configure RTF template on the basis of date of completion of course. For example CPO of the client firm has been changed and the change happened on 2n…Minal Nitnaware 21 views 3 comments 0 points Most recent by David --Oracle Reporting and Analytics for HCM -
Employee Advance details in oracle Fusion HCMSummary: Employee Advance details in oracle Fusion HCM Content (please ensure you mask any confidential information): Hi, Please help to identify table/query for Employe…Hitha Harikumar 141 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
I am getting exception error for one of scheduled report through bursting.Summary: I am getting exception error for one of scheduled report through bursting. Does anyone know what should be the reason. Content (required): Job Priority: Normal …
-
is there any way to trigger email notifications through BIP based on demand.Summary: We want to trigger email to associates immediatly after the course enrollment through Bip is it possible to do?if it's possible how to approach.Help appreciated…
-
Draft water mark is missing in the draft fileSummary: Content (please ensure you mask any confidential information): Hi Team, Draft watermark is missing in the draft file. I have used the RTF template in the report…Ashok Dhara 112 views 1 comment 0 points Most recent by Iulian Brinzoi-Nuta - HCM-Oracle Reporting and Analytics for HCM
-
How to create a button that links to different reports?Summary: Different link on the same button based on conditions. Content (please ensure you mask any confidential information): In Performance Management, under My Client…Stefano_Mazzocca 21 views 1 comment 0 points Most recent by Neelakanta-Oracle Performance Management -
Gigs progress history is not available in IRC_LC_HISTORY tableSummary: Gigs progress history is not available in IRC_LC_HISTORY table such as Gig Filled date, Gig completed date, unpublished date, etc. We are unable to extract data…Shalini.bh 31 views 1 comment 0 points Most recent by BrianLawrence.G-Oracle Reporting and Analytics for HCM
-
How to Prevent Spacing between unmet conditions?Summary: I am currently in the process of consolidating multiple offer letters into a single document. Within this composite offer letter, I've included several sequenti…Emily Cox 1 view 1 comment 0 points Most recent by Patricia-S-Oracle Reporting and Analytics for HCM
-
Information about Report and its linked data modelSummary: looking for any table or Subject area where we can get information about Report and its linked Data model. to ensure that every report linked with report after …Amit_Ekbote 1 view 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Consolidate multiple extract in single extractSummary: I need to develop three separate HCM extracts. However, I would like to consolidate the data from all three extracts into a single XML file. Is there a method a…
-
How to query rehire contingent workers in BI reportSummary: I need to query for rehires To look for rehires the person has to have an active Contingent Worker assignment from the past and either a pending worker or conti…Vishnupriya 471 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Report on Leave of AbsenceSummary: In our company, we use an Action in the Employment page to track if the employee is going on Leave of Absence (e.g. Maternity leave). Then, we use another actio…
-
Need to provide SFTP URL as a hyperlink in RTF template.Hi, We have a requirement to send email notification to user after extract run, in email we have to provide SFTP location as a hyperlink so that when user clicks on it, …
-
I am looking for Oracle fusion HCM exit interview questionare tables to develop a BI reportSummary: with the columns mentions below Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code …Shyam Kumar Ganti 47 views 1 comment 0 points Most recent by Mihnea Savu-Oracle Reporting and Analytics for HCM
-
Remove column from Excel BI Publisher reportI have a report containing many columns that I prepared using Excel Publisher and I want to remove a column, but when I upload it back to the system by clicking delete t…Cansel Karasoy 524 views 2 comments 0 points Most recent by Alexandru Burcea-Oracle Reporting and Analytics for HCM -
OTBI report how to display parameter list of values only with the report result in the list ?Hello , In OTBI report, we would like to have a list of values on parameter “location “ based on the values of the report result . Only the values that are extracted fro…Revital Mefano 431 views 4 comments 0 points Most recent by Revital Mefano Reporting and Analytics for HCM -
Displaying different sections in mobile app and web app on dashboardHello, in the dashboard I have prepared, I want some sections to appear only in the web application. I want some of them to appear only in the mobile application. Is thi…Sinem Kara 21 views 1 comment 0 points Most recent by Florin Loghin-Oracle Reporting and Analytics for HCM
-
BI Report Logo not displaying when exporting report to MS WordSummary: BI Report Logo not displaying when exporting report to MS Word. Content (please ensure you mask any confidential information): I have created a BI report. I use…IanDeKoker 51 views 1 comment 0 points Most recent by Andra Maria Popescu-Oracle Reporting and Analytics for HCM