OTBI
Discussion List
-
What is the role required to access the Negotiation OTBI reports?Summary: We need to know the exact role or privilege required to access the Negotiation OTBI reports. Content (please ensure you mask any confidential information): Vers… -
Export audit logs through OTBI\BI publisherHi, need assistance on how to pull mass audit logs from the OTB?I\Bi publisher. thank you in advance.Gal Shani 41 views 1 comment 0 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM -
Course CategorySummary: Hi, Do you know where can I find the course category either in BI Publisher or in OTBI? Content (please ensure you mask any confidential information): Hi, Do yo… -
OTBI analysis joining General ledger and Project subject areas blank fieldsSummary: We are trying to pull GL transaction data and add the project and invoice information to it when relevant. Content (please ensure you mask any confidential info…Tashi Temple-Wood 161 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany
-
Query for Person Security Profile ReportHi team, we need a person security profile report. can someone help me to provide the query of this if anyone has already gone through this type of requirenment. Thanks!Pushpendra Patle 11 views 3 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
OTBI: Prompt Link not workingHello All, When prompt link is generated either from edge or chrome browser it error out as Bad Gateway. Any help would be appreciated! Thank you.Gail Wilmoth 21 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to insert the filter on org_id in SQL query ?Summary: Hi , how can we insert a filter in a query to extract both management and financial project? We try with this expression : ORG_ID>0 but is not valid. The tables…Michela A. Morgillo 11 views 1 comment 0 points Most recent by Michael Gibby - Huron Consulting Group Self Service Procurement -
How to output a list of all reports and their folders in Production environmentSummary: We are trying to map all reports in our production environment, with their folder locations. Does anyone know of an administrative tool that might be able to ou…Rich R 1.4K views 28 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Migrating OTBI reports from test to production environmentsHello, We are in the process of implementing Oracle HCM system and have created OTBI reports in test environment that we need to move to production. Our implementation p… -
OTBI Report to get Activity Status value "Required"Summary: can anyone have OTBI Report to status of Activity in course - Learning Module Navigation for Requirement My Team>Learning>>Worker name>Course title>>Enrolment T…Rajdeep Chavda 11 views 2 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM
-
How to get distinct record for Dimension field in OTBI just like SQL?Summary: Any DISTINCT function that can be used in OTBI to get distinct Dimension record just like SQL ? Content (please ensure you mask any confidential information): A…Pradnya_Pampatwar 461 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How to get Salary Transaction entered by Name from Salary Transaction entered by for a Person NumberHello Everyone, I am using "Compensation - Salary Details Real Time" subject are to build a report. This subject area already holding a field "Salary Transaction entered…Ranjubala Pradhan 21 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to find out the name of "Analysis Report Criteria" used during Initiative creation?Content Hi, I assigned a Course to learners through Learning Initiative and I have used "Analysis Report Criteria" when creating the Initiative. I want to know the table… -
How to link Dependent Care Physician to DependentSummary How to link a Dependent with their Dependent Care PhysicianContent I am trying to pull a report of employee and dependent care physician after Open Enrollment. I…User_2025-01-30-03-28-08-030 41 views 9 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM -
Direct join between Benefit and Element tables issueSummary: Hi, I am building a report where I need to show the CONTRIBUTION_PERCENTAGE (BEN_PRTT_RT_VAL.ANN_RT_VAL) from Benefit and CONTRIBUTION_AMOUNT (pay_element_entry…Ranjubala Pradhan 91 views 3 comments 0 points Most recent by Ranjubala Pradhan Reporting and Analytics for HCM
-
Financial Reporting Web Studio Save button not saving changesThroughout Web Studio Workspace. For example, I originally had a text box in a header which contains the "" function on the first line and a "" function on the second. T…Keith Doucet 11 views 1 comment 0 points Most recent by Daniel14337-Oracle Reporting & Analytics for Fusion Service
-
AP Invoice Account Coding initiation dateSummary: which fusion table will have information of AP invoice Accounting Code, Initiation Date to write a SQL query Content (required): AP Invoice Account Coding initi…Harish Pati 171 views 2 comments 0 points Most recent by James Canaber Payables, Payments & Cash Management
-
BICC extract for P2PThe business wants pinpoint info that which BICC extract contains the data from these four tables: po_headers_archive_all po_lines_archive_all po_change_orders_all po_lo…
-
Not getting the proper charts on the user defined logical sqlSummary: I have written a sql statement by performing a left join between two subject areas. Have got the desired output. However am note getting the expected outcome wi… -
Absence Date End problem with clock change in OTBISummary: During British Summer Time (BST) (GMT+1) the Date End of an absence has a time stamp of 1am the next day. So 01/05/2021 00:59 not 30/04/2021 23:59. Content (req…Robert Craske 41 views 4 comments 0 points Most recent by Mark Stoker Reporting and Analytics for HCM
-
Role to access Negotiation OTBI reportsSummary: I need to know the role required to access the Negotiation OTBI reports. Content (please ensure you mask any confidential information): Version (include the ver…
-
How to customize the data model to include disputed transactions for Strategy based dunning letters?How to customize the data model to include disputed transactions for Strategy based dunning letters? What data fields are required to be added for including the disputed…Kratika Sharma 31 views 1 comment 0 points Most recent by Daniel S.-Oracle Receivables & Collections
-
Check list real time SA for onboarding questionnaire but output vertical view issue in reportSummary: Hi Team, How can I convert Vertical into horizontal of question text and response answer . we need candidate onboarding questionnaire feedback suervy but in que…AjayKumar Maddipati 51 views 10 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
OTBI Dashboard Usage Via TileHi all, We've built an OTBI dashboard and we'd like to share this via a tile on the front end of PeopleCloud. We've followed these instructions we found on here (pdf att…MikeW 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to get bursting delivery detailsSummary: How to get bursting delivery details Content (please ensure you mask any confidential information): Hi All, We need to develop a BI report to show the bursting …Venkatesan 32 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Metric Descriptions - Service Subject AreasSummary Descriptions of all the out of box metrics found in the 'Service - CRM Service Requests Real Time' and 'Service - CRM Service Request Lifecycle' subject areasCon…Anand DN-Oracle 56 views 2 comments 2 points Most recent by Jenny Truong-Scognamiglio Reporting & Analytics for Fusion Service
-
US compliance reportingWe plan to retire our US & CA Operational Data Store (ODS). Currently, it feeds HR & payroll data to multiple downstream applications. Equally as important, it helps us …Santo Campione 21 views 2 comments 0 points Most recent by Allen D'Souza-Oracle Reporting and Analytics for HCM
-
How to join/merge/combine two sql queries.Dear Experts, Thanks For Looking into this post. Could you please help out me. I have two queries as shown below, we need to join one together. Query1: UDT_LKP query. Qu…Ravindr-Oracle 31 views 2 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM
-
Formula to prevent deletion of annual absences with Approved status in the system.I prepared a validation formula so that absences with "Approved "status cannot be updated or deleted in the system. The formula for updating is running and an error mess…Cansel Karasoy 51 views 7 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM