OTBI
Discussion List
-
HSDL template failing for certain usersHi, We are experiencing performance issues with HCM Spreadsheet Data Loader (HSDL). Users are able to generate/download the spreadsheet from Oracle Fusion HCM successful… -
OM Cloud - Has someone created any dashboard or report for the credit exposure details like in EBS?Summary: In EBS, there is a credit exposure report which has complete credit information of customer like open invoices, existing open sales order etc. which help busine…
-
How to prevent purging of MSC_ST_MEASURE_DATA table?Hi, I am currently working on to load the supply chain planning shipments history using FBDI. When I load FBDI file using Load Planning Data from Flat file ESS job, it f…Ankit_Bhadja 4 views 0 comments 0 points Started by Ankit_Bhadja Supply Chain Planning and Collaboration -
How can I access the list of EU countries?I have a query; SELECT * FROM hz_geographies WHERE geography_type IN ('ECONOMIC REGIONS') I want to question the countries within the EU. However, when I run the query, …Gül Öner 25 views 1 comment 0 points Most recent by Gangadhara S Ariga Reporting and Analytics for ERP
-
26B - Some learning assignments missing Actions issue will be fixed in patch?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Bursting query to trigger resignation letter to personal emailSummary: Hi Team, I need help with a data model and bursting query. The goal is to trigger the resignation letter and route it to the employee's personal email. Could yo…
-
How to fetch the document names of the attachments on a Journey Checklist taskSummary: I need to fetch the names of the attached documents on a checklist task, onto my OTBI analysis. Content (required): I need to fetch the names of the attached do…User_2025-07-18-13-29-11-469 51 views 4 comments 0 points Most recent by Himanshu Chavan Reporting and Analytics for HCM
-
Cloud Bi Publisher - BIP bursting not sending emailsHi All, I am using Oracle Analytics Publisher and have built a report and associated data model, with a bursting query. I want to schedule the report to be sent to email…NZ-user999 1K views 3 comments 1 point Most recent by Ashish_Sahoo_Trinet26624 Reporting & Analytics for Fusion Service
-
OTBI Subject Area: "Payroll - Personal Payment Details Real Time" --> Target Bank --> Selected AccoSummary OTBI Subject Area: "Payroll - Personal Payment Details Real Time" --> Target Bank --> Selected Account FlagContent HI, I am looking to identify a field in the OT…User_MC37Q 374 views 5 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
What are the limitations for BI Published reports?Summary: What are the limitations for BI Published reports? Content (please ensure you mask any confidential information): What is the maximum number of rows I can expor… -
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 25 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 13 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… -
No analysis available while creating a visualization metricI am trying to configure a visualization in the Inventory Management Landing page using an analysis, however when trying to search for the created analysis in the Visual…Ahmed Sameh Mohamed 21 views 2 comments 0 points Most recent by Ahmed Sameh Mohamed Reporting and Analytics for SCM -
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 16 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 53 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 22 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…