OTBI
Discussion List
-
Create 'Buyer Assignment Rules' ReportGood Day Experts, Is there a way to create a report to show details and information for Buyer Assignment Rules? Screenshot below is the view from Fusion Application. Col… -
Unable to report on Guided Journey QuestionnaireSummary: We've created a guided journey questionnaire as part of the requisition process for hiring managers, however we are unable to report on the data. We've had an S… -
Excel Export Limit Differences Between Prod and CTN (Dev Environments)Hi all, Would anyone happen to know why we appear to have different limits set for exporting OTBI analyses between our production and CTN environments? We're looking to … -
Learning initiative exclude learnerSummary: Exclude certain learners from an initiative based on person number list Content (please ensure you mask any confidential information): We are using OTBI analysi… -
How to Pull Fiscal Classification Name on ReportSummary: We are seeking to include the field "Fiscal Classification Name" on a report because the related field "Fiscal Classification Code" is not meaningful to end use…Dpalmborg-Amica 1 view 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Need table name which store Fiscal Classification CodeSummary Need table name which store Fiscal Classification CodeContent Hi Guru's, Please let me know which table store the Fiscal Classification Code which comes under "M…Rohit Soni-259808 222 views 4 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP -
table/view to list all users with assigned role namesSummary: table/view to list all users with assigned role names Content (please ensure you mask any confidential information): I am looking for an Oracle Table/View name …Naved Khan 1.1K views 6 comments 0 points Most recent by Dai Huynh Minh Reporting and Analytics for HCM -
Problem with scheduling OTBI reports - error messagesContent I've set up loads of scheduled OTBI reports in the last few months. Although they are still coming through by email when they should, if I try to set up any new …User_2025-02-05-04-46-07-194 67 views 3 comments 1 point Most recent by Rebecca Hawker Reporting and Analytics for HCM -
What duty roles and privileges are needed to access withholding tax reports in Fusion?Summary: Hi Everyone, We have a case where a user needs to access the "Payables Withholding Tax by Tax Authority Report", WITHOUT being granted a payables role. The user… -
OTBI – Extract Unposted General Ledger BalancesHello Team, I checked all the OTBI reports related General Ledger data and realized that there is no report to extract unposted balances. Could anyone please advise? -
BI Report to extract daily rates for a specific date rangeSummary: BI Report to extract daily rates for a specific date range Content (please ensure you mask any confidential information): Hi All, I have a requirement to extrac… -
Query to fetch the list of recommended courses again each employeeshi Team, Can anyone share a query to fetch the list of recommended courses against each employees? Thanks, Vinod -
MOT_REF_ENTITIES custom object table not pulling dataSummary: There is a OTBI report built using custom object subject area whose dimension and fact tables are populated with data thorugh some integration reports through s… -
Add requisitioner email address to purchase order rtf templateSummary: We got a requirement to add 'Requesitioner email id to purchase order document. At the moment buyers email id is included in the RTF template Content (please en… -
Participant Feedback Report SQL Issue - HelpSummary: Hi, can someone pls help check what's wrong with this SQL below. When I add the Performance Document Participant"."Role Type, I receive this error: I want to fi… -
Issue Accessing Data in Custom HCM BI Report in Lower EnvironmentHi Team, We have a custom BI report in the HCM module that retrieves both Salaried and Hourly employee data. Although the required data access and roles appear to be cor…Deepak kumar Rai 1 view 0 comments 0 points Started by Deepak kumar Rai Reporting and Analytics for HCM -
Why are some users receiving error:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P ?Summary: Some users are receiving Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P when attempting to access a OTBI Dashboard. However, other …Edlyn Almanzar 698 views 10 comments 0 points Most recent by Bo Tøpgaard Reporting and Analytics for ERP -
How To Change The Date Format For Date Columns In BICC ExtractSummary: Hi Team, My requirement is to insert the values from the date columns of BICC extract into ATP using DBMS_CLOUD.COPY_DATA functionality. COPY_DATA is not workin…VishnupriyaSelvakumar 1 view 0 comments 0 points Started by VishnupriyaSelvakumar Reporting and Analytics for ERP -
How to add Shipment Header DFF in OTBI report?How to add Shipment Header DFF in OTBI report?Mugdha 21 views 3 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM -
How do I create an aged report for open transfer orders in OTBISummary: I am trying to create an OTBI Analysis for Open Transfer Orders. We would like to see a count by destination, date, cost of inventory item and possibly the GL A… -
Oracle criteria to identify OTBI reports with specific column in itHi All, We are migrating to V3 Seniority Date from V1 Seniority dates. This migration is impacting our OTBI reports which are using ‘Enterprise Seniority Date’ column. S… -
Fixed Assets Report Showing Data from Financial Book but Not from Tax BookWhen generating a Fixed Assets report, the output displays information from the Financial Book, but no data appears from the Tax Book. Could this issue be related to a m… -
Subscription OTBI Report is not Fetching Amount data for non-USD currenciesOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Description (Required): I have observ… -
No email notification after Payment Process Request in DEV (Expense Reimbursement)Summary: Not receiving email notification after Payment Process Request (PPR). Content (please ensure you mask any confidential information): After submitting a Payment … -
Workforce Learning OTBI: Learning Community Hierarchy and Course NameHi Team, https://us.v-cdn.net/6034893/uploads/M8KQZ39LW7BG/course-community.txt I have a requirement to build an OTBI report that includes course details such as Course … -
OTBI report is erroring outSummary: An OTBI report is giving error. Would appreciate if anyone can share your inputs. Content (please ensure you mask any confidential information): Version (includ…Global Support Desk 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
OTBI report prompt to display only direct reports for Line managersSummary: We have created an OTBI report using the subject area - 'Workforce Learning - Learning Management Real time'. We have created a prompt which displays all the Em…Sovan Mishra-Oracle 541 views 10 comments 0 points Most recent by Lakshmi Neelima Gollapalli Reporting and Analytics for HCM -
OTBI Report to fetch List of Line ManagersSummary: OTBI Report to fetch a List of Line Managers who have at least one direct report and the direct reports(Employees) should be Salaried. Content (required): For t…Thulasi Ram 481 views 6 comments 0 points Most recent by Lakshmi Neelima Gollapalli Reporting and Analytics for HCM -
I am looking for a report to validate or find missing goals in PerformanceSummary: I am looking for a report where it has Employee number, Name, Performance Document Name, Goal Period Name, manager, and Goals Status(Has goals or No goals ) Con…