OTBI
Discussion List
-
Report using Contract DFFSummary How to build a report to include Contract DFFContent Hi, I have built a report joining the following subject areas Workforce Management - Employment Contract Rea…User_2025-02-08-08-11-51-624 32 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Subject area for Positions which has missing segments in Costing of PositionContent Hi Experts, I am new to OTBI analysis, I have a requirement to List all Positions which has missing segments in Costing of Position. Can anyone tell me which sub…Raghavendra M 52 views 6 comments 1 point Most recent by Raghavendra M Reporting and Analytics for HCM -
How to query parent value from accounting hierarchy in FA OTBI analysisSummary account hierarchy filter in FA OTBI analysisContent I am trying to build an OTBI analysis in FA transactions real time subject area. I have added an accounting h… -
Single output row for Course and Offering dataSummary Reduce duplicate rows in Learn Reporting of Course and Offering dataContent We have legacy course completion data that was loaded via HDL. Unfortunately we did n…Dean Soto 36 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Head count by department for every month reportContent Hi, I'm looking for headcount report for each month by department. Can someone help me please. Thanks, VijayUser_2025-02-07-19-03-14-525 32 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Performance Rating With Compensation Data causing duplicate rowsContent Using Performance Rating from Compensation - Workforce Compensation Real Time subject area causes rows to duplicate for individual employee. I have tried to use …User_2025-02-10-08-27-16-805 36 views 5 comments 0 points Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM
-
OTBI - get language which user is connected withContent Hello, we need to detect the language which the user is connect with. How it is possible? (OTBI) Thanks NicolaNicola Petri 37 views 1 comment 0 points Most recent by Nicola Petri Reporting and Analytics for HCM
-
OTBI filter cross subject areas problemContent Hi Guys, I created a report with elements from 4 subject areas, It work well, but when I add some filters it give me no results even if before the filter the val…Giuseppe Iacono 53 views 8 comments 0 points Most recent by nitin Sharma Reporting and Analytics for HCM -
Received Quantity of a ASBN in In Transait OTBI ReportSummary In transit ASBN with 1 received and 1 non received lines are not on the OTBI report, Received Quantity is not in the Receiving In-Transit Advance Shipment Notifi…User_2025-02-07-01-41-42-385 27 views 1 comment 1 point Most recent by Yogesh_P-Oracle Supply Chain Planning and Collaboration
-
Display Parent Manager First Name and Last Name in 2 separate columnsContent Hello, I have an analysis I am creating that the end user has requested manager first name and last name to be in 2 separate columns. I have referenced this post…User_2025-02-07-16-42-37-187 166 views 3 comments 0 points Most recent by HROps17 Reporting and Analytics for HCM
-
Report for MFA Multi factor authenticationSummary Report to identify which employees have activated Multi factor authenticationContent Hi Do you know if there is any subject area or database table where I can se…Rogelio H 29 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Oracle Learning Planning Prices -> Any alternates to get previous history from 'wlf_plan_records_f'Summary wlf_plan_records_f - does not keep date-tracked rowsContent Hello, Can anyone please help? At the moment, the OLC table 'wlf_plan_records_f' does not keep date-t…SantoshKumarBhairi 8 views 2 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
In need of an AAP Promotion report (FROM and TO details on job)Summary In need of an AAP Promotion report (FROM and TO details on job)Content We have AAP promotion report due in which they are asking FROM and TO of a job in a promot…Adil_R 70 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Manual User for financial UsersSummary OTBI Manual User for financial UsersContent HI, All Can anyone send me an OTBI Manual user for financial Users? How financial users create their Reports using OT…Mohamed Elwan 46 views 10 comments 4 points Most recent by Mohamed Elwan Payables, Payments & Cash Management -
OBTI Formula for January 1st of Current YearContent I need to get the age of the worker for the start of the year in an OBTI analysis. I have Oracle's formula to calculate age: TimeStampDiff(SQL_TSI_YEAR, "Worker"…Greg Bennett 125 views 8 comments 0 points Most recent by Greg Bennett Reporting and Analytics for HCM -
Will Quality Cloud support SPC?Summary SPCContent Hi, Will Quality Cloud supprt SPC, like control chart, process stability metrics? Regards, Leander Chen
-
is there any to get list of all infolets in oracle FusionSummary is there any to get list of all infolets in oracle FusionSidhartha Wadhwa 35 views 2 comments 1 point Most recent by Sidhartha Wadhwa Payables, Payments & Cash Management -
Expenses Employee Number to Worker - Person NumberSummary Cannot connect 2 subject areas to merge data in OTBIContent Using OTBI I am attempting to merge subject areas Workforce Management -accruals real time with Expen…User_2025-02-10-15-06-52-222 29 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
A company wants to sell part of its businessSummary Typical Organization planning for De-MergerContent There is a Company A, who is on oracle Cloud and now it wants to split the business into two parts i.e. Compan…
-
Transaction Approvals and Person NumberContent Hi, I have created logical SQL to return 'Rejected' Document Records from the following subject areas: * Human Capital Management - Approval Notification Archive…Karen Waddell 58 views 14 comments 2 points Most recent by Karen Waddell Reporting and Analytics for HCM -
Customer Listing Report( to be run by users having Order Management Role)Summary Customer Listing Report( to be run by users having Order Management Role)Content Reports and Analytics- Currently Order Management users doesnot have the ability…User_2025-02-10-10-25-17-537 28 views 1 comment 0 points Most recent by Dhruvjoshi23 Order Management
-
Duplicate rows returned for some Employees in Production OnlySummary Duplicate rows returned for some Employees in Production OnlyContent Hi, When I run the attached analysis which is developed using logical SQL it returns duplica…Karen Waddell 38 views 10 comments 0 points Most recent by Karen Waddell Reporting and Analytics for HCM
-
OTBI-what is the subject area for get the payment conversion rate details in OTBI reportSummary Business is using Payables report, it will fetch Invoice number, amount, date, payment amount. If we need to get conversion amount for payment date, how we can g…User783746-Oracle 32 views 1 comment 1 point Most recent by Kallol Sinha Payables, Payments & Cash Management
-
How to stop depreciation for few years and start the depreciation for specific asset but when deprecSummary How to stop depreciation for few years and start the depreciation for specific asset but when depreciation starts should not catchup the depreciation.Content Hi …
-
modify list of recipients on scheduled reportSummary modify list of recipients on scheduled reportContent We have a scheduled report to which I need to add two recipients. I have not had any luck in the schedule or…