OTBI
Discussion List
-
Customer Pricing Profiles in OTBISummary: We need to review entered Customer Pricing Profiles using OTBI, is there an available Subject Area to do this? or any workaround? -
Restricting the values of a dashboard promtSummary: Hello, We have made a BIP report on an Assessment which will show the candidates who have reached the assessment state and their results/current status etc. The…Shreya Datir 41 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How can i get access to OTBI?Is there a specific role/privilegie that grants access only to the OTBI? Thanks Guys, Mayko MeloMayko.Melo 31 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Rehires are showing twice when using Seniority Years in Wrkfrc Mgmt - Person Seniority Real TimeContent (required): When I add Seniority Years (or months/days) to a report in this subject area, rehires are duplicated with one row calculating based on their enterpri…Monique Dias 51 views 5 comments 0 points Most recent by Monique Dias Reporting and Analytics for HCM
-
Report for Position Attributes change HistorySummary Looking for a report whcih can give us history of position attribute changes.Content Hi I am looking for a report to track changes in all position attributes lik…Mohit Gupta-45440 235 views 10 comments 1 point Most recent by Jesus N Reporting and Analytics for HCM -
Custom Report example for PPM Allocations ?Summary: Custom Report for PPM Allocations ? Content (required): Hello I would like to create a custom report for PPM Allocations, will you please share with me the tabl…Cesar Saveedra 41 views 1 comment 0 points Most recent by Shivashish Dwivedi-Oracle Project Management
-
Post P2T, how to switch from classic dashboard view to new dashboard view?Summary: We have dashboard in Prod which has a responsive UI as per below. However post P2T, In Test it is showing classic view for the dashboards. How to change this vi…Sathesh Ramaswamy 61 views 9 comments 1 point Most recent by PriyankaM Reporting and Analytics for HCM
-
How to link Top Manager to a username within "Workforce Management - Worker Assignment Real Time"Summary: Hi all I'm trying to create an emergency contact report that allows managers to see their entire reporting line population and the emergency contact details on …
-
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 43 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 262 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 112 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 51 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 191 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