OTBI
Discussion List
-
Database Update for Fixed Asset AdjustmentSummary: When is the database updated when an asset is adjusted? Content (required): We are in the process of building an integration to a 3rd party. We are finding that… -
Create custom report for Purchase Requisition Approval HistorySummary: Our client asks for a custom report to show full approval history for Purchase Requisitions. Content (required): I search for SQL query to show all approvers , …Mohamed Faramawy dev.-Oracle 1.3K views 2 comments 0 points Most recent by Mohamed Faramawy dev.-Oracle Self Service Procurement -
I'm looking below columns in otbi or any reference reportSummary: Hi , I'm looking below columns in otbi or any reference report ,any help me on below columns. Thanks, Ajay Content (required): Opening EL leave balance /DOJ (Da…AjayKumar Maddipati 41 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Time card dashboard for line managersSummary: Need assistance on using the Time card dashboard filtered for line managers Content (required): Need assistance on using the existing seeded Time card dashboard…VenkataSubbareddy 41 views 3 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM
-
Subject Area - How to add the attachments field in a reportSummary: How to add the attchament field in a report made through the subject area "Sales - CRM pipeline" Content (required): We want to add the attachment field in a re…SERGIO BARRETO 263 views 2 comments 0 points Most recent by SERGIO BARRETO Reporting & Analytics for Sales -
Most Recent Assignment RecordSummary Most Recent Assignment RecordContent When we need to report inactive and active employees in one analyses, it is not easy to get the latest record (for example, …User_2025-01-23-21-37-42-476 76 views 9 comments 1 point Most recent by Julie Mandel Reporting and Analytics for HCM -
Geography Mappings in Oracle HCM CloudSummary: How is data from hz_geographies mapped to per_addresses for countries other than the US Content (required): I am working on a Peoplesoft to Oracle HCM Cloud imp…NathanParry 111 views 1 comment 0 points Most recent by Sebastien Mariller Reporting and Analytics for HCM
-
How to replicate values from a calculated column to all table rows in an OTBI analysis?Summary: I have a table that shows columns related to Innovation Management Proposal's instances like Proposal name, profit, proposal type, proposal squad, proposal trib… -
Table/Tables to find the "Cost Center Owner" Name/ID in OTBISummary: We are looking for the exact table name/set of tables through which we may find the Cost Center Owner Name or ID. Any information on the Subject Area where we m…
-
User-define column does not return valuesSummary: Content (required): Hello everyone, We are currently trying to create a data model using the following sql: SELECT /*+ MATERIALIZE */ r.row_low_range_or_name SS…Maria Xydopoulou 41 views 10 comments 0 points Most recent by Maria Xydopoulou Reporting and Analytics for HCM -
Reporting on 'Required' Field in OTBI From the Learning CatalogHello all, Does anyone know if its possible at all to report on the 'Required' section of any assigned learning to an individual? Within the Learning Catalog, we have co…
-
OTBI Query not working with where clause in BI publisherSummary: OTBI Query not working with where clause in BI publisher We have query which works in BI Publisher with no where clause but when added with where clause the whe…
-
Privilege for ORA_PER_LINE_MANAGER_ABSTRACT to access Workforce Management - Worker Assignment SASummary: Hello, Does anyone know what is the exact privilege required for ORA_PER_LINE_MANAGER_ABSTRACT to run the data of subject area Workforce Management - Worker Ass…Hazel De Castro 52 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to give special access to LMS Specialist to be able to schedule OBTI report they create.Summary: We have leadership and different area of the organization request specific information from learning data. They often want this more than one time, and we can't…
-
OTBI plugin for officeSummary: BI Publisher tab disappeared from Word Content (required): I installed OracleAnalyticsPublisherDesktop-6.4.0-win64.exe, and it opened Word after the installatio…Maboagamo 81 views 17 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM
-
Formula for exporting date in csv as dd mmm yyyySummary: I have a need to present date in a csv extract as dd mmm yyyy. I have the below formula that presents it as dd mm yyyy, any assistance that could be provided to…
-
New Hires ReportSummary: Is it possible to create a new hire details report that pulls in the effective date from the assignment vs the proposed start date in the offer letter? Content …Bhuangtran 192 views 8 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM
-
OTBI Analysis with suspended assignment detailsSummary: We have an OTBI analysis to capture employees' suspended assignment details and need to add the date of the that suspended assignment started. Content (required…Ayesha Iroshani 31 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Exact Privilege for Human Resource Analyst Role to view own data in the OTBI reportSummary: Hello, Does anyone know what is the exact privilege required for Human Resource Analyst Role to view own data in the OTBI report. It appears that there are nume…Hazel De Castro 42 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Need Sample Report for Learner Interaction with SCORM ContentSummary: We need to report on interactions of Learners taking tests (pre and post) within our SCORM packagees. This would include their score, number of attempts, time s…
-
Item Pricing informationSummary Need to extract item pricing information by locationContent Hi, We are looking for BIP report/OTBI subject areas that can extract Item pricing information. Is th…User_2025-01-28-21-08-12-167 49 views 2 comments 1 point Most recent by Waleed Fetoh Reporting and Analytics for SCM
-
Is it possible to have multiple organization trees active in core HR?Summary: Is it possible to have multiple organization trees active in core HR? What is the impact if the hierarchy is different? Does this affect reporting? Content (req…
-
Compensation Eligibility StatusSummary: Content (required): Hello everyone, I'm currently trying to create a Value Set that will get me the Compensation Plan ID and the Compensation Eligibility Status…Maria Xydopoulou 51 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Degree Reporting - Item Code not available in Subject AreaSummary: Hello there, I'm trying to create a simple analysis that provides a full list of Degrees and the Item Code. There doesn't seem to be a "Item Code" option to sel…
-
Consolidated List of OTBI and BI Publisher Reports Posted (16 October 2015)Content The following is the list of published OTBI and BI Publisher reports for Fusion HCM. New posts between 10 August and 16 October 2015 are marked with NEW. 10 rep…Julian Challenger-Oracle 488 views 9 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Error on running an OTBI report after 22B being appliedSummary: We are facing issues in running a OTBI report post 22B upgrade. Please see the attached error and let me know how to resolve this issue. Content (required): Ver…
-
Custom date and currency formatting in report data table columnsSummary: Is there a vehicle for providing custom formats? Content (required): In OTBI data tables, columns only offer a limited set of pre-defined formatting. How can I …Maboagamo 41 views 8 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
How to count number of offerings within a courseSummary: There is probably a really easy guide to this, but I can't get the count to work! I am using the Learning Records Real Time area and I am trying to get the numb…Mark Stoker 83 views 5 comments 0 points Most recent by David --Oracle Reporting and Analytics for HCM