Sample Reports
Discussion List
-
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 … -
How can I join General ledger and ExpensesHow can I join General ledger and Expenses I am precisely looking to join below tables gl_je_lines gl_ledgers exm_expense_types Much appreciate your help on this
-
We are not getting GL Cost Center information when we are trying to pull data across learning recordSummary: We have a requirement to pull cost center details in learning history report across learner assignment details. In our project cost center is linked to departme…Pankti Shukla 22 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM -
OTBI_Pivot_IndexSummary: Hi, If anyone knows how to use index on pivot table in OTBI, I would greatly appreciate your help. Thank you. Regards, Melek Content (please ensure you mask any…Melek Cinar 22 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
Court Orders - Report on field called 'Order Reference'Hi all, I'm hoping this is a quick and easy question. I'm building a report to report on Court Orders and they've asked us to include the value from the field front end …MikeW 24 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
Is there any seeded OTBI Analysis for Person Seniority?I'd like to know if there's any seeded OTBI Analysis which can relate to Person Seniority?Welsey 11 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM -
how to attach a static pdf from webcenter as attachment into our emailWe want to send a Email with a static pdf file as attachment to employees. So we are using the RTF template as the Email body and. And we have to attach the PDF file as …Dara Nagasai 2 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM -
Track approval workflow status for goal managementSummary: Track approval workflow status for goal management Content (please ensure you mask any confidential information): Hello experts, we have enabled an approval wor…Oriana L. 31 views 1 comment 0 points Most recent by Adriana Tudor-Oracle Reporting and Analytics for HCM
-
BI Publisher Handle No Data in RTF TemplateHello, I want to prepare a report that returns data that I call from the web service via OTBI. However, when I try to return this value in BI Publisher rtf template, the…Sinem Kara 47 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
query to get deactivation date of userSummary: query to get deactivation date of user Content (required): May I know if any one know how to get deactivation date of user, I tried using end_date from per_user…Swati U 295 views 7 comments 0 points Most recent by Adrian Dogeanu-Support-Oracle Reporting and Analytics for HCM
-
How to fetch all sites linked to a particular customer using querySummary: How to fetch all sites linked to a particular customer using query Content (please ensure you mask any confidential information): Version (include the version y…Neelesh Varma 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
need query to get activities content type for all the courses along with offeringsHi we have requirement to get the Course names along with the offerings and their activites content type in the bi report. Can any one share me the sql for fetching all …
-
Time Between Promotion in Oracle Fusion HCMSummary: Time Between Promotion Content (please ensure you mask any confidential information): Hi Team, Please help to create query for Average number of months between …Hitha Harikumar 12 views 2 comments 0 points Most recent by Hitha Harikumar Reporting and Analytics for HCM
-
OTBI - Store Analysis or static Briefing booksSummary: Can we use OTBI to store month-end snapshots of static data to refer back to without exporting offline? Content (please ensure you mask any confidential informa…Clare Murtagh 1 view 2 comments 0 points Most recent by Clare Murtagh Reporting and Analytics for HCM -
Someone Deleted the Custom folder from my Username. Is there any way to find the IP address or HOSTSummary: Someone used my credentials to login into UAT POD and Deleted the whole custom Folder. Is there any way to find the IP or Host of the user so that I can find wh…VarunMittal01 1 view 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
How to get Periodic accrual Projected Hours Value in OTBISummary: how to get Periodic accrual Projected Hours Value in OTBI Content (please ensure you mask any confidential information): Version (include the version you are us…
-
How to create analysis for Check-in Documents Created vs. Not Created?I need an analysis to get a list of employees who haven't created their Check-in Documents yet. I'm currently using Workforce Performance - Performance Check-In Real Tim…Welsey 32 views 2 comments 0 points Most recent by Suman Chenumalla-Support-Oracle Reporting and Analytics for HCM
-
FA-SAAS Enhanced SQL Guardrails and Tuning for Long Running BI SQLs for Oracle CloudSummary: FA-SAAS Enhanced SQL Guardrails and Tuning for Long Running BI SQLs for Oracle Cloud Content (required): We got mail from Oracle Cloud Saying following : As par…Swati U 859 views 7 comments 0 points Most recent by Avinash Veeranna Reporting and Analytics for HCM
-
Report footer not showing completely in report outputSummary: Report footer not showing completely in report output. My client wants to display this footer on all the reports. When I run the report then everything in the f…Consultant Ian 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
how to show different content for in app and email workflow notificationswe have a requirement to show different content for in app and email notifications of RESIGNATION. So I used below condition in the RTF template using the oracle docs. …Dara Nagasai 36 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Using BI Publisher attempting for get Learner - Self Service Setting and if overwrittenSummary: Using BI Publisher tables I am attempting to get default access - learner serf-service setting on a catalog/enrollment and then see if it was overwritten at the…Nicolas Trojack 41 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM -
payroll report with gross pay showing element entry deductionsSummary: I need to create a report (OTIBI or BIP) that shows a person name, person number, pay period, pay period week, gross pay (for the pay period), add-in bonuses, (…
-
Create Security Report in OTBI with details of roles both past and present with dates and statusI tried submitting this question in the HCM Report Sharing Center that was discussed during yesterdays HCM Customer Connect but was getting an access denied error so pos…
-
Getting extra employees in BI report those are not direct or indirect reports of logged in managerSummary: Created BIP report to get direct indirect reports of manager however we are getting few extra employee those are not direct or indirect of logged in user (line …Swati U 33 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Talent Pool Report in Oracle BIPSummary: This report is required by the business to report on the grades of talent pool candidates while they are actively part of the talent pool and later, in future y…Pradnya_Pampatwar 31 views 9 comments 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM
-
{ELE_NAME} in FND_MESSAGES_TLWe have a requirement to display Message Name and Message Text in Payroll Message Report. We are getting these values from FND_MESSAGES_TL table. Now our client wants th…
-
How to: Translate BI Publisher Report Parameters at 24ASummary: How to: Translate BI Publisher Report Parameters at 24A Content (please ensure you mask any confidential information): Version (include the version you are usin…Ishtiaque AHmed 41 views 1 comment 0 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM
-
Compensation Plan Worksheet with notesSummary: I have created a report to pull compensation worksheet with notes. I am facing the following issues: 1) It only picks up employees with Notes. I need to pull th…
-
OTBI-Dashboard promt values not showing in Dashboard after added the new oneSummary: HI Team, We have new enhancement requirement in old dashboard that is needed to change the check task name from HR Questionnaire First 2-weeks check into Onboar…AjayKumar Maddipati 21 views 9 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Pivot Table > Sorting Date in Ascending Order Not WorkingSummary: Pivot Table > Sorting Date in Ascending Order Not Working Content (please ensure you mask any confidential information): Hello, We want to display the time card…