OTBI
Discussion List
-
The supply plan tables could be printed in BI report?Summary: Hello, I have a custom table for supply planning, I need a BI report to print data generated into the table for the 3 measures per period while is filtering by …Diego Zegarra 11 views 1 comment 7 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM -
SQL for OTBI Analysis historyContent Does anyone know if there is a seeded report/analysis or SQL to pull the history of all OTBI analyses? We have a lot of old OTBI analyses that were created by fo…Mike Burnett 105 views 12 comments 4 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP -
How can I add suggested start date of a maintenance program generated work order to an OTBI report.?Summary: I am trying to add the suggested start data of a work order to an OTBI report. Work orders that are created by maintenance programs have a suggested start date.…Phillip_Shearer 1 view 1 comment 0 points Most recent by Ezra Anderson Reporting and Analytics for SCM -
How to make US1099 report to be emailed to Vendor?Summary: Content (please ensure you mask any confidential information): Is there a way to email US 1099 to the email addresses on file? User has run this in excel and .p…Vikram_Patel 11 views 3 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Oracle OTBI Report View does not run for wider searchThe only table/view I have been able to identify, that provides OTBI report usage statistics is the BIPUBLISHER_V view as provided by Oracle. This view consistently eith…Marko Puskac 21 views 2 comments 0 points Most recent by Marko Puskac Reporting and Analytics for ERP
-
Need subject area for Bank return number to add column in OTBISummary: Hi Experts, I am looking for subject area for bank return number to add in OTBI report. Task: Payments—> Manage bank Returns —> search with invoice number— Retu…Mahindra reddy-Oracle 11 views 1 comment 0 points Most recent by MiaM-Oracle Receivables & Collections
-
Absence Calendar Subject Area not showing all dataSummary: When I run my report using the Absence Calendar Subject Area a large amount of data is missing. I have tried running the Generate Daily Breakdown of Absence Det… -
All upcoming training/courses should be visible to learnerSummary: Hi, We have a requirement where from Me→ Learning tab employee can see a dashboard kind of things to check upcoming training or courses and can enroll them self…
-
API to run financial reportSummary: We have the following query, we need to call a financial report using a web service, we have tried using the WSDL (/xmlpserver/services/ExternalReportWSSService…Arin 11 views 2 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Need table names or SQL for Approved OTL timecard details in BIPSummary: Hi Team, I Need table names or SQL for Approved OTL timecard details in BIP. We need particular person entries and along with approver comments. Navigator->my c…Janardhan ACS-Oracle 301 views 5 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
How to create a dashboard.Hello, we have a Report set up to show managers their staff learning record. Is there a way to add this to a dashboard for them - at the moment they have to go into repo…
-
Capture the Learning Activity description in OTBI reportSummary: Content (please ensure you mask any confidential information): Hi there, is it possible to get the description of an Activity in an Offering from the Learning R…Bobby Jourdan 41 views 4 comments 0 points Most recent by Ramchander Pothanolla Reporting and Analytics for HCM -
Length of service calculationSummary: How to calculate Length of service from latest hire date of employee? Content (required): I am using Workforce Trend Real Time Subject Area, I need to show the …Raghavendra M 793 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Create Report to Include Sign On Bonus from Offer LetterSummary: I have an analysis report that list candidates that we had hired. However, I need to add Sign On Bonus amount into the report. I found the "Other Compensation" …
-
OTBI Analysis for Remote Workers and Onsite Associate Work Location State and Postal CodeSummary: We currently have a large population of workers who work remote or their "Work Location" is classified as their home office. Our population of around 18,000 wor…Kayla Malecki 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Download AR attachment from OTBIIs it possible to download the attachments from and AR invoice directly from OTBI? These are attachments that are uploaded directly into each invoice and the user wants …
-
Is there a way to pull out job offer comments in OTBI?Summary: Is there a way to pull out job offer comments in OTBI? Content (please ensure you mask any confidential information): Hello Experts, We are challenged to pull o…Volodymyr Faranosov 22 views 1 comment 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
Enhanced subject areas - Oracle Fusion ERP Analytics (24D)In the whats'new 24D note we have an enhancement in these subject areas: Encumbrance Accounting is available as an additional opt-in Generally Available pipeline feature…Rocha, Diego Rodrigo 41 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Why are users with my custom role for OTBI not able to see data in OTBI reports?Summary: I created a custom role with copying "Project Administrator" role. Remove all "Function Security Policies" and do not touch "Data Security Policies". Remove all…
-
OTBI report returning Lookup codes, how to fetch meaning instead of codesSummary Few Talent profile attributes in OTBI report returning lookup codes.Content Hi, In the Person profile>License and certifications section few fields are lookup ty…Challa Vidyasagar 293 views 3 comments 0 points Most recent by ShivaBildikarMGS Reporting and Analytics for HCM -
RTF file ConfigurationSummary: Dynamically Present non null column in table Content (please ensure you mask any confidential information): I am creating an RTF file using Word table with 3 fi… -
Optimizing Infolet Loading Time on the SpringboardHello Community, We’ve designed and implemented multiple infolets for employees, line managers, and HR, placing them on the springboard to provide quick access to releva…HarishVummidi 11 views 1 comment 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
OTBI Data Discrepancy for "Performed Action" Approve in Procurement - Requisitions Real TimeSummary: Hi Community, I'm encountering an issue in OTBI (Oracle Transactional Business Intelligence) when retrieving data from the Subject Area: Procurement - Requisiti…
-
Request for Infolet Samples to Enhance User Experience in Core HR, Absence, ORC, OTL, and PayrollHello Community, I’m currently exploring ways to enhance the user experience for employees, line managers, and HR teams in Oracle Cloud by leveraging infolets effectivel…HarishVummidi 21 views 0 comments 4 points Most recent by HarishVummidi Reporting and Analytics for HCM
-
How to capture Tax Registration Number at Supplier Address level in OTBI reportSummary: Hello Oracle Experts, Currently the OTBI Report is showing only the Tax Registration number in the supplier Profile level under Transaction Tax. But we are capt… -
I need an SQL to extract ONLY the learner who have a completion date equal to Today minus 10 daysSummary: I want to create a BI Analysis for assignment criteria that extract ONLY the learner who completed a specific learning item 10 days ago. Content (please ensure …
-
How to have a Batch ID parameter which is present in BIP Report in the Dashboard?Hi , We are creating a dashboard of a BIP Report for our use-case, BIP Report has a parameter called Batch ID with which we will pull the data regarding that batch load.…Sainatha B 21 views 1 comment 0 points Most recent by Ramchander Pothanolla Reporting and Analytics for HCM
-
Are there BI Cloud Connectors for OTM Cloud? If yes, where to find them?Summary: Are there BI Cloud Connectors for OTM Cloud? If yes, where to find them? Content (please ensure you mask any confidential information): Version (include the ver…
-
What is the meaning of the LAST_UPDATED_BY and LAST_UPDATE_DATE in GL_FRC_REPORTS_B?Summary: Our auditors asked us to extract the contents of the table GL_FRC_REPORTS_B for them. While reviewing this data, we noticed that for many of the reports it is s…Chris Mansfield 63 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany