OTBI
Discussion List
-
Which Subject Area to use for Assignment EITSummary: Which Subject Area to use for Assignment EIT Content (required): I cannot see any subject area field showing "Assignment EIT Information EFF: Assignment Extra I…Hrms Project 51 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Hyperlinking BI Publisher reports in a DashboardContent Hello, We have a requirement to create a dashboard which will list all the reports available for certain user popluation. As per screenshot you can see that we m… -
OTBI - Purchase Agreements - Enable Automatic Sourcing flagSummary: Unable to find 'Enable Automatic Sourcing' flag in the OTBI Subject Area 'Procurement - Purchase Agreements Real Time' Content (required): Hi, I'm creating an O… -
Employee Commute DistanceSummary: We need a way to calculate and report on Employee Commute distance to support our Environmental, Social and Governance reporting. In our legacy data warehouse w…Chelsea Holden 31 views 3 comments 2 points Most recent by Chelsea Holden Reporting and Analytics for HCM -
RCOUNT("Worker"."Person ID" by "Learning Items"."Learning Item Number")Summary: I am trying to fetch the latest status of a particular learning item number per employee. I have used RCOUNT and Max to fetch the data. When I filter with perso…Anita 141 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to format the date field from time dimensionSummary: How to format the date field from time dimension Content (required): I have column Calendar Month from Time dimension it is showing the output as 2022101.0 for …Raghavendra M 21 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Can't see 'Administration' Tab in Catalog?Summary: Content (required): Can't see 'Administration' Tab in Catalog after the last update? any feedback? note: the user has all related (HR Analyst, Admin Roles, and …Walid Hamdy 61 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Positions Filled in less than # daysSummary: Need to track positions filled that took less than/more than 60 days to fill. Content (required): I need to find a way to not only track the # of positions fill…Scott Conaway 11 views 1 comment 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
NI thresholds - How to report in OTBISummary: Please can someone confirm if it is possible to report on NI thresholds using OTBI. Alternatively, which table in BIP can we derive the NI thresholds from Conte…
-
Error When open Dashboard by a certain user!Summary: Content (required): I received this error when opening a custom dashboard, noting that the user has access to the report and its Subject Areas The report can be…Walid Hamdy 21 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Analysis Female Successors for Critical RolesSummary: I am trying to work out #critical roles: used distinct (Plan Business Unit)- Correctly getting the count #atleast 1 female successor on these critical roles # c…
-
Identifying/Removing Duplicate rowsSummary: I am creating a report that is trying to highlight any blanks or erroneous data in our active workforce. It requires combining the following subject areas: Work…
-
Ask for table name - who answered the questionnaire, the questions and answersSummary: Ask for table name - who answered the questionnaire, the questions and answers Content (required): Table name for Questionnaire related have found the following… -
Fusion P2P – Oracle Fusion Procure to Pay (P2P) Life Cycle with Functional and Technical flowContent The P2P cycle comprises of the following steps,01. Create Requisitions02. Approve Requisitions03. Create Purchase Orders04. Approve Purchase Orders05. Receive Go… -
Number of Candidate Pool Members metric doesn't match with the value showed in UISummary: Content (required): Hello, We would create a simple analysis that extract the Number of Candidate Pool Members inside the different pools. We create the analysi…Giuseppe Iacono 41 views 8 comments 0 points Most recent by Giuseppe Iacono Reporting and Analytics for HCM
-
How Time Dimension works?Summary Report with snapshots by end of monthsContent Hi Everyone, I am struggling to build an OTBI analysis that creates a monthly Head Count report. I am using "Workfo…Alvaro Couto 104 views 12 comments 1 point Most recent by Raghavendra M Reporting and Analytics for HCM -
Total on the Top of Stacked Vertical BarSummary: Total on the Top of Stacked Vertical Bar Content (required): How to add Totals on top of Stacked Vertical Bar in OTBI, Please see below image, If its possile pl… -
Can't view own record in OTBISummary: I have a custom role where I would like to see my own data, only in OTBI but not to be able to correct it in HCM. Like add absence to my own person. I don't wan…Nicolas Vahman 572 views 11 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
ORC: Tracking all the End Dates for a RequisitionSummary: Hi, Can we track & report all the end dates for a requisition if Hiring Manger changes the End Date of the Requisition? Any help with details like Tables, Repor…Bhaskar Konar 41 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Requisitions per Department ReportSummary: Content (required): Hello Guys, We would create a report that show the number of requisitions for Departments and that it also have the functionality to explain…Giuseppe Iacono 31 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM