OTBI
Discussion List
-
Organization Chart with Persons ImagesSummary Organization Chart with Persons Images with Google Chart ServicesUser_Z8Y6M 126 views 8 comments 2 points Most recent by Vasiliki Tripolitsioti-Oracle Reporting and Analytics for HCM -
P45 filing dateSummary: P45 filing date in OTBI (or SQL code if not in OTBI) Content (required): Does anyone know where in OTBI I can find the P45 filed date (see bottom of screenshot)…
-
How to include attendees on the business meals seeded Expense Report template ?Summary: How to include attendees on the business meals seeded Expense Report template ? Content (required): Hello Although the user captured the attendees on the busine…
-
Limit invoices to own departmentSummary: Is it possible to create a report which shows only invoices which are related to your own department - and not seeing every invoice of all other departments as …
-
OTBI Subject Area Contents Listing (metadata)How do we provide our users with a user-friendly listing of the contents in each Subject Area? Or, at least, how or where do we get the data necessary to build one? This…Eric Geddes 31 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to Add note to Conference expense screen through a SanboxSummary: How to Add note to Conference expense screen through a Sanbox Content (required): Hello I need to add a note to the screen when conference/seminars is selected.…
-
Termination Reasons & Salary in Workforce Trend to measure TurnoverSummary: When adding Termination Reasons (Action Reason), the terminations sum up correctly, but the Headcounts are inaccurate. Salary data doesn't populate. Content (re…
-
Looking for a YTD payroll reportSummary: I need to create a report showing YTD payroll. Content (required): Report needs to contain employee demographic detail along with current pay rate, YTD earnings…Scott Conaway 361 views 2 comments 0 points Most recent by Scott Conaway Reporting and Analytics for HCM
-
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