Category 81
Discussion List
-
Item Pack Details Report using OTBIContent Will Subject areas relating to Structures and components real time provide the Item Pack Structure details ? Requirement is to fetch the complete Item Pack struc…Sudheer Movva-193114 31 views 1 comment 0 points Most recent by Magesh Kesavapillai-Oracle Product Master Data Management -
SQL to return all job roles where a particular duty role is usedSummary: SQL to return all job roles where a particular duty role is used Content (required): Hi Team, Please share SQL to return all job roles where a particular duty r… -
Pass an employee ID parameter from an analysis to a Skills pageSummary: We want to have an OTBI analysis table of employee information with a link per person that takes the viewer to the Skills and Qualifications page with the emplo…User_2025-02-05-22-55-58-511 41 views 2 comments 0 points Most recent by User_2025-02-05-22-55-58-511 Reporting and Analytics for HCM -
DFF value is not coming in the OTBI reportSummary: Content (required): Hi Expert, We have created a DFF in the document of record and when we are using the OTBI report to fetch the data for this specific dff the…Faizan Rashid 513 views 2 comments 0 points Most recent by Faizan Rashid Reporting and Analytics for HCM -
SQL-Applied ReceiptsSummary: Please share with me any SQL-Applied Receipts Content (required): Hello I was trying to do an SQL for applied receipts , however I always get duplicate records …martingabriel Kinovisques 81 views 1 comment 0 points Most recent by Dhruvjoshi23 Receivables & Collections
-
Is there a UE that can fetch LE details including LE addressSummary: Requirement is to get all active LEs and their respective address along with Bank Details for the UE. Content (required): I tried using the below UE but it does…Vibha Pandey - Oracle 11 views 1 comment 0 points Most recent by Raghavendra M Reporting and Analytics for HCM
-
Can we get offering old and new status?Summary: Hi All, I am working on a report where the requirement to get the old and the current status of the offering. I queried mentioned below tables to get the status… -
Driver used for a source combinationSummary: Need to extract drivers used in rule for a source combination Content (required): Hi, Can I extract Drivers used for allocation of source combination amounts in…Khushbu Premlani 31 views 2 comments 0 points Most recent by Viral Soni Profitability and Cost Management -
OTBI Reporting on Learning CompletionsSummary: I am trying to get a report on a certain learning item. I need a report that show all active employees and their learning completion status on a certain course.…
-
How do I build a report to pull the learning questionnaires' result?Summary: I build two questionnaires for self-paced and instructor-led training. Can someone show me how to build an OTBI report to pull the result? Content (required): I… -
HCM reporting on hours and average hours workedSummary HCM reporting on hours and average hours workedContent Hello Does anyone have any ideas about tracking average hours worked for hourly associates, as it relates … -
Adding data element to a data model (Adding Full_Name to EEO-1 report)Summary: Assistance requested in adding Full_Name to a data model Content (required): We have some EEO-1 reports that were built by someone else prior to my arrival. One…
-
Dashboard Report to display non-catalog Learning Request but NOT external learningWe have created a dashboard report and filtered on learning item type = noncatalog but of course this also returns data from recording external learning. What else can w… -
Source System ID for Work TermsSummary: Sample Query to extract SSID for Worker.dat >>>> Work Terms object upload Content (required): We have a requirement to extract SSID of work Terms object for Wor…Dhajani Perera 602 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Best practices on how to combine HR data from other non Oracle applications with Oracle CloudSummary: I would like to know how other customers have linked data from other applications to their Oracle cloud solution. we have OAC and use ADW as a data source and a…Robert Geddes 11 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Is there an Idea Lab for IDCS?Summary: Is there an Idea Lab for IDCS? Content (required): There doesn't appear to be... How do we log ERs / Ideas? Just through an SR? Is anyone tracking a list of ERs…Jeff Hare CPA CISA CIA 1 view 0 comments 2 points Started by Jeff Hare CPA CISA CIA Identity and Access Management -
Converting UTC to EST time zone in Logical SQLSummary: Our report is built with logical sql, the approval dates are displaying in UTC time zone and we need these to reflect EST time zone. Need help with syntax. Cont…Denise Izzi 2.5K views 7 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM -
Aggregate function in OTBI AnalysisSummary: Please share some documentation on using various aggregate functions on any column of an OTBI analysis Content (required): Need to use aggregate functions acros…Hem 412 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Not getting any data when opening the reportSummary: Content (required): Hi Expert, We have built a report and it is an Individual Compensation report, I have all the roles but when I am assigning payroll admin an…Faizan Rashid 41 views 11 comments 0 points Most recent by Faizan Rashid Reporting and Analytics for HCM
-
On the new OTM Transportation Intelligence Tool OAS (Oracle Analytics Sever) - QR Code generation?Summary: Can we generate a QR Code based on the shipment Id using OAS - within OTM transportation Intelligence. Customer is asking that the shipment id - should be conve…
-
Users cannot see their own accrual balanceSummary: Users cannot see their own holiday accrual balance in OTBI accrual report Content (required): I have an OTBI report showing Accrual Balances using the Accrual R…s_b 21 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM