Sample Reports
Discussion List
-
Requisition Life-cycle report (OTBI)Summary Simple report showing creation date, approval date, PO creation date etc for purchase requisitionsContent See attached screenshot for details. Unarchive the atta…Andy Gough 920 views 10 comments 8 points Most recent by JLogan-EncoreGlobal Reporting and Analytics for ERP -
Content Status - Correct common lookup typeSummary: Hi, Content Status - For fetching the exact content status names, we see there are two lookup types available. Neither of them have the complete set of data tha… -
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 11 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 -
Content Type - Web LinkSummary: What is the correct mapping for content weblink for a web based content type. We are mapping the Web link from table - WLF_LI_CONTENT_F and field - STARTING_URL…
-
Need to create Dependent Value Sets in a Data model in oracle cloud (SAAS)Content Problem Description --------------------------------------------------- Hi Team, Is there any possibility to create a dependent value set in a Data model in orac…User_1B10X 46 views 8 comments 1 point Most recent by Britika Kumari Reporting and Analytics for ERP
-
Learning Completion date of a course under specializationHi All, I am not able to get courses under a specialization to get its completion date. Any help is appreciated? Thanks-Praveen
-
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 11 views 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 33 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 966 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 31 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 -
how to use listagg function in rtf template?Summary: Requirement to display a value (output of for loop) in a single row in RTF template, as of now its displaying each value in each row. Needs to be handled in RTF…Thanigainathan R 427 views 4 comments 0 points Most recent by Thanigainathan R Reporting and Analytics for ERP
-
Define a global function in BI reportsDear All, Is there a way to define a global function in BI reports to use it across all reports? For instance, NLS_NUMERIC_CHARACTERS?George Mattar 31 views 2 comments 0 points Most recent by Alex Kaleas Reporting and Analytics for ERP
-
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…
-
List of seeded reports & analyses for Procurement Contracts/ Enterprise Contracts module in oracle fSummary List of seeded reports & analyses for Procurement Contracts/ Enterprise Contracts module in oracle fusionContent Hi, Is there any way to get the list of all the …Aman Vasishtha-Oracle 543 views 2 comments 0 points Most recent by Bill McLarty55-Oracle Reporting and Analytics for ERP
-
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 41 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to fix the error results in this report?Summary: We tried to add a column name ORIGIN from Workforce Management - Person Real time however, every time we add any column from Workforce Learning in the subject a…
-
ISO Format for the positive pay templateSummary ISO Format for the positive pay templateContent Hello All, We got a requirement for the positive pay in the ISO format but as of now we have only an etext seeded…Koteswararao Yenikepalli 184 views 6 comments 1 point Most recent by Ruthwij Reporting and Analytics for ERP -
HDL Template to update assignment recordsSummary: Hi All, I may request a data loader to update all the assignment records simultaneously too since I just received ALL the statuses for 100% of the population to… -
Is there a way to pull the name of third party provider in the report or only training supplier?Summary: We tried to pull the report the name of the third party provider however, only training supplier for ILT can be pull. We need to pull the name of provider like …
-
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 41 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
-
how to create pivot table in a BIP report ?I am creating a work in progress report using BIP. I have projects with costs and revenue distributed on months. how can i get an output like this image. does anyone hav…Omran Zeaiter 281 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP