OTBI
Discussion List
-
Sub-Recipient in Grants/AwardsSummary: Hi All, we are implementing PPM for our public sector client. There is a federal requirement to print SEFA report from Oracle which lists all the details of exp… -
Can I create a Bank Slips PDF (Boleto Bancário) from all installments of a invoice?Summary: Create a PDF with Bank Slips (Boleto Bancário) of opened installments of a transaction. Bank Slip (Boleto bancário) is a commom payment method in Brazil. Conten…Anderson Paviatto 42 views 2 comments 0 points Most recent by Anderson Paviatto Receivables & Collections -
Do we have any Report giving the details of miscellaneous receipts in Oracle Fusion?What is the name of the BIP report giving providing details of the miscellaneous receipts in Oracle Fusion?KanikaGupta 41 views 2 comments 0 points Most recent by Vivek Mandowara-Oracle Receivables & Collections
-
How to obtain a query between the user and the roles associated with itSummary: Roles associated with a user Content (required): Hi team, We need to obtain the list of users and the associated roles. I have reviewed some tables but I cannot…SERGIO BARRETO 141 views 4 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
No fact table exists at the requested level of detail - Ethnicity IssueSummary: Hi - We have a roster report for our whole employee population and I was trying to tweak the ethnicity section to account for the many scenarios of if they choo…
-
View the Milestone Due Date's Time in OTBISummary: How do I get the time stamp of a milestone's due date? Content (required): I need to present in a report the difference between the current time and the milesto…Richard_Page 31 views 6 comments 0 points Most recent by Bhaskar Konar Reporting & Analytics for Fusion Service -
Create analysis using logical SQL error?Summary: Invalid SQL Identifier: fusion.per_allocated_checklists ac. error Content (required): Hi All, We are looking at building OTBI analyses for identifying allocated…William_Johnson 184 views 3 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
Where can I find Product and Segment from the financials side (default expense account) in OTBI?Summary: I want to join HCM data with expense account data Content (required): I need to be able to pull in the Product and Segment from the default expense account (or …Monique Dias 21 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Calculate Percentage based on Running Sum displayI'm displaying a running sum for minority hires and overall hires from month to month. I want to calculate the % of minorities to hires for each month based on the runni…Susan Anderson 81 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Why do some fields break a report in OTBI?Summary: trying to create a census report with fields from multiple subject areas and many fields work together but certain fields break the report Content (required): I…Monique Dias 51 views 8 comments 0 points Most recent by Monique Dias Reporting and Analytics for HCM
-
Formula for Data Submission Status in Talent ReviewsSummary: Subject Area: Workforce Talent Review - Talent Review Meeting Real Time Content (required): Hi All, We are looking to create an analysis that could be used to m…William_Johnson 52 views 4 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
AOR Templates - RecruitingSummary: I am trying to do an OTBI Report for representatives assigned with Recruiting responsibility type. However, when I add a filter for recruiting responsibility ty…Ridma Karunanathan 51 views 1 comment 0 points Most recent by Mayur Kaushik Reporting and Analytics for HCM
-
OTBI - Need Specific Assignment History along with complete salary historySummary: Hi , Client wants specific assignment history like Job Change, Dept. Change, Status change along with complete salary history. Able to get it but the salary his…
-
Course Comments - ReportSummary: Hi Team, Do we have option to create a report to fetch Comments added by Learners at course level/ Learner name etc currently. This was not possible earlier in …
-
Report on PromotionsSummary: I need to be able to capture anyone who is transferred from a job with a job class of 'S' to a job in any other class (E, D, M, in our case). I'm looking for a …Jessica D 41 views 3 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM
-
May I know which subject area suitable for below columns ?Summary: Hi Team, May I know which subject area suitable for below columns ? unable to find ? Thanks, Ajay Content (required): Version (include the version you are using…AjayKumar Maddipati 21 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Job code with Null profilesSummary: Hi Everyone! I am trying to create a report which should fetch the job codes with No profiles in Manage job page. I hard coded one job code which is having no p…
-
How to find the max value across multiple columns?Summary: Staff can enter up to 6 qualifications in separate flexfields in the UI. We have a requirement to report on the highest value code entered for each employee. As…Joshua Kidd 101 views 3 comments 0 points Most recent by Joshua Kidd Reporting and Analytics for HCM
-
PDH Item PublicationSummary: PDH 'Item Publication' process Content (required): Hi, I am testing the 'Item Publication' process in product hub. I have done the spoke system setup using - ht…Sravanthi Kollapudu-Oracle 41 views 3 comments 0 points Most recent by Manoj Bagul-Oracle Product Master Data Management
-
How to get highest value from 4 different columns for each personSummary: I am trying to retrieve the highest value from 4 fields for each person For example these four people have various values in the 4 columns (some are null) The r… -
Do you know how to add a deeplink in the HTML ouput of an emailSummary: The request from business is to avoid opening a attached report to use deeplink from the report. But the email should contain directly the lines expected with a…
-
Absence duration between dates when absence start/end spans calendar monthSummary: How to report on absences duration within a given month, even if absence starts or ends outside of that month. Content (required): We have a requirement to repo…Michelle Hughes 51 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Subject Area for PO Variance and PO Accrual?Summary: We are generating a PO report, and are looking to include the PO Charge, Variance, and Accrual accounts that are on each line. Subject areas seem to only show t…