OTBI
Discussion List
-
Goal library extractionHi to all, do you know if there is a possibility to extract all the goals entered by the HR on the Goal Library? Is there an OTBI area? Thanks in advance, Best Regards, … -
Latest Invoice Date by Supplier - OTBISummary: I need a report that shows the latest supplier activity by either invoice date or po creation date, in aggregate form Content (please ensure you mask any confid…Wilson_Kevin 26 views 1 comment 0 points Most recent by Gangadhara S Ariga Reporting and Analytics for ERP -
BIP Scheduled Trigger Failing - Help NeededSummary: Hi all, I'm trying to add a schedule trigger to my BIP report that's currently scheduled, but when it runs with the code, it fails with the following message: D… -
OTBI Report Giving Performance issue specifically for Non BI Admin UsersWe created a custom OTBI report in Oracle BIP using the "Inventory - Inventory Transactions Real Time" subject area. When the report is run by users with BI Admin access…User_G9BRM 51 views 3 comments 2 points Most recent by Saloni1412 Reporting & Analytics for Fusion Service -
How is everyone handling and accessing metadata within OracleSummary: Looking for metadata for both business and log-based data. Would like the Oracle dictionary rather than re-creating the wheel. Where can I locate a full table a… -
Work Order Operation Transaction Import FBDI fileSummary: We are trying to leverage 'WorkOrderOperationTransactionTemplate.xlsm' FBDI for an integration and we would like to use DFFs to capture few fields. We do not wa… -
Organization Calendar Events with Coverage Area Data Extraction QuerySummary: Query to extract Organization Calendar Events with Coverage Area (Geography) Content (please ensure you mask any confidential information): Hi, We have a requir…Vasanthakumar Ravi 12 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
OTBI - Issue while submitting Custom report - Asset Cost DetailSummary Error while selecting parameters for Custom OTBI report which was copied from Asset Cost Detail reportContent Error while selecting parameters for Custom OTBI re…User_2025-02-04-10-47-46-258 55 views 4 comments 0 points Most recent by User_HI2N6 Reporting and Analytics for ERP -
Unable to View "Not Started" Course Status for Assigned LearnersSummary: In the Specialization view, the course status is displayed as “Not Started” for learners who have already been assigned to the specialization. However, when an … -
Cross validation Rule extract by report / SQL querySummary Need report/SQL query for extracting Cross validation rulesContent I am looking for Cross-validation report or SQL Query to extract all cross-validation rules at… -
Add an Infolet Box of OTBI Report in Invoice Page like seeded infolet using SandBoxSummary: I am working on a requirement in OTBI where I need to create Infolets on the Invoice page in the front end, similar to the seeded Infolets, using Sandbox. There… -
OTBI Pivot Table Issue–Unable to Retrieve Questionnaire Response Text and Response Answer CorrectlyWe are using the subject area Workforce Management - Checklist Real Time to retrieve the following attributes: Questionnaire Question Text Response Answer Response Text …Katherina Palissade 25 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Ljava.lang.Object; is passed when multiple values are seleted in parameter in oracle BIP reportSummary: Hi Everyone, We have created a custom BIP report that will trigger the OIC integration from the Data model. We are passing a few parameters to the report. One o…
-
Journal approval and rejection reportSummary: Do we a report in Oracle that provide information on journals which were submitted for approval and have been rejected. If not can anyone share any queries wher… -
How to delete association organizations for an itemSummary: We have a requirement from the customer to remove certain inventory organizations associated with this item. Is there a bulk upload method (such as FBDI or CSV)… -
Query/Report to pull employees details whose YTD amount is greater than Total OwedWe would like to know is there any way to pull employees details whose YTD amount is greater than Total Owed for a particular element entry. Kindly suggest.Aravind_Raj 23 views 0 comments 0 points Started by Aravind_Raj Reporting & Analytics for Fusion Service -
active_flag in per_userwhat does the status of the user who's active_flag is marked as "N" and suspended_flag as 'N'. does the employee is still inactive and can we check who inactivated the u…Akhila Khammammettu 13 views 0 comments 0 points Started by Akhila Khammammettu Reporting & Analytics for Fusion Service -
Learning OTBI reports does not retrieves data when item has no access view modeHello, I'm trying to build a report from the subject area Workforce Learning - Learning Management Real Time to extract learning history of workers (completed courses). …Victoire Bizieau 52 views 5 comments 0 points Most recent by HCM.Fusion009 Reporting and Analytics for HCM -
How can we view the approval pending receiving transactions?Summary: 26B: Receiving approval workflow After submitting for approval on self-service receiving page, how can we check the pending approval RCV transactions? I cannot …Tomoyuki Hyakutake-Oracle 11 views 3 comments 0 points Most recent by Tomoyuki Hyakutake-Oracle Inventory Management -
Redwood Purchasing Landing Page - Seeded KPIs and OTBI Analyses AvailabilityHi All, I'm implementing the new Redwood Purchasing Landing Page feature and trying to add KPIs to the Visualization Configurations page. When I access the configuration… -
Can we restrict OTBI report 'edit' access for user to edit OTBI Analysis created by themselves onlySummary: How can we restrict user to edit only the OTBI Analysis created by themselves, provided 'BI Author Role' access has been assigned to the user and user should ha… -
To hide "Home", "Catalog" option while opening an OTBI Dashboard via Widget on Home Page.Content We have a requirement where we need to call an OTBI dashboard via Widget on the Home Page. The road block is to hide the Home, Catalog, Advance, etc. tab that ar… -
Work Schedules for non-primary assignments in Person Real Time Subject AreaSummary: I'm trying to report on the work schedules for employees with multiple assignments. However the OTBI Person Real Time Subject Area / Person Schedule Assignment …Richard Kemp-Eyre 62 views 5 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Update of Invoice Landing Page to add custom infolet/infotileHello, The requirement is to update the Invoice Landing Page to add custom infolet/infotile. We would like to verify if this is feasible. Navigation: Payables > Invoice …Mark Llasos 31 views 5 comments 0 points Most recent by Faiz Ahmed Shaikh Payables, Payments & Cash Management -
Report for getting shift overlap or shift with open end dateSummary: Report for getting shift overlap or shift with open end date Content (please ensure you mask any confidential information): Hi Team, Greetings! If anyone has an… -
How to avoid duplicate invoice number while performing the PO receivingWe have observed a scenario where a PO receiving was created twice using the same invoice number. Currently, the system allows entry of duplicate invoice numbers without…