Category 81
Discussion List
-
Event Tables Not carrying out the data from PROD to TEST on P2T RefreshSummary: On our recent P2T refresh the below event tables not carrying the data from PROD to the TEST environment. Please provide if there is any doc or reason for this.…Rengaraj G 21 views 1 comment 0 points Most recent by TSCloudLabs-Oracle Fusion Applications Administration -
Changing Aggregation/Group of Column in OTBIHello, I have a Logical SQL report to combine data from the "Workforce Succession Management - Incumbent Plans Real Time" and "Workforce Succession Management - Plan Can…Nick Dorfner 23 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
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 12 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Report not showing pictures when exported as Web ArchiveSummary: We have an OTBI report that stores images + html values. When extracted as Web Archive, first row displays image just fine, but row2 and row3 are only showing I…CAMIL_Q 11 views 1 comment 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 -
Are there any jobs to schedule hourly/daily/weekly for OTBI?Summary: We have schedule jobs for various areas of HCM but nothing that runs hourly/daily/weekly for OTBI reporting. Are there any jobs that you can recommend to schedu…LFafard 25 views 2 comments 0 points Most recent by Julian Challenger-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 -
Reporting on total number of employees that completed a subset of learning itemsSummary: I have a requirement to create a summary report that includes how many employees have completed a subset of all of the learning items included in the filter of …Jacob Arfa 14 views 1 comment 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM
-
DNUSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Anshul-Khandelwal 3 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Do we have any delivered HR and Manager dashboards in 24ASummary: Where can I find the delivered HR and Manager dashboards in 24A Content (please ensure you mask any confidential information): Are there any delivered manager a…Priyanka_Kumari 22 views 1 comment 0 points Most recent by Julian Challenger-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 127 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…
-
How to create a report with full and part time EMP count as per department ?I have created a headcount report with basic employee info. I want to modify it such that it has Emp ID, Dept ID, Full time & Part Time Empl count. Basically I am lookin…Trupti Khodke 12 views 2 comments 0 points Most recent by Trupti Khodke Reporting and Analytics for HCM
-
Send a BIP report to PRINTERSummary: How to send a BIP Report output to PRINTER directly Delivery output should be directly sent to PRINTER Content (required): Version (include the version you are …Mudhassar 139 views 6 comments 0 points Most recent by Nagarjuna Nudurupati Reporting and Analytics for HCM
-
How to add a count column for employees aligned to a job in OTBI.Summary: I have created a report in OTBI to show all job names in our business. I need to create a column which does a count on the number of employees who have this job…
-
In which table does the Candidate Selection Process Code field is storedSummary: I'm trying to fetch the Candidate Selection Process code, but couldn't figure it out where this field is stored. Content (please ensure you mask any confidentia…Sujeeth Chinta 653 views 3 comments 0 points Most recent by Sujeeth Chinta Reporting and Analytics for HCM -
Assignment Manager - Performance Document ReportingHi all, We've built a report that we'd like managers to be able to run that'll return their direct and indirect reports Performance document status details. The issue we…
-
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 94 views 1 comment 0 points Most recent by Iulian Brinzoi-Nuta - HCM-Oracle Reporting and Analytics for HCM
-
Dashboard prompt not applying to linked analysisSummary: The Dashboard prompt for 'Name' is accurately returning the number of Employees for our 'Headcount' tile, but when navigating to the link analysis for Headcount… -
"HcmTopModelAnalyticsGlobalAM.OrganizationAM.LegalEmployerPVO" Does not give latest LE namesSummary: We are not able to get latest LE name from this "HcmTopModelAnalyticsGlobalAM.OrganizationAM.LegalEmployerPVO" , is there any Synch job that can be run to synch…Pooja Naganalli-Oracle 41 views 3 comments 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 23 views 1 comment 0 points Most recent by Neelakanta-Oracle Performance Management -
We are trying to extract month from a date column in OTBI after we convert it to Mountain Time.Summary: We are trying to extract month from a date column in an OTBI report after we convert it to Mountain Time. However we get the month from UTC only.Any suggestions…
-
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 32 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
-
In oracle fusion which table have NationalityDear , I want to know in oracle fusion which table i can find nationality . in fusion i can see nationality in person document but not found in table ThanksMirza_Adeel 2.5K views 10 comments 0 points Most recent by Saleh_Taslaq Reporting and Analytics for HCM -
How to Retrieve Employee Active Assignment through Groovy ScriptsSummary: We are trying to get employee active assignments inside the Groovy scripts. For that, we need to configure the endpoints in web services. In the latest worker e…Karthick_Sathasivam 24 views 1 comment 0 points Most recent by Marius Voicu-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…