OTBI
Discussion List
-
Mailto links not workingSummary: I am trying to embed a mailto: action link in a report to create an email to a requester where they need to take action, for example where they have an invoice … -
Table to use to get the project and task details under Supply and PlanningHi, We have created a SQL query to get some details under the Supply and Planning. We are almost done but we get stuck on the project and task column. We already checked…
-
Configuring Descriptive Flexfield Segments With Expense Report ParametersContent What attributes are enabled as flexfield parameters, and the syntax to be used in the value set logic for the Expense Report? I'm creating a new flexfied, in the… -
OTBI RSSP Receipt NotesSummary: We need to be able to provide information to AP regarding RSSP receipts via an OTBI report. We want to add the notes in the Receipt Details screen Notes field a…
-
Add Learning Incident Comment into ReportSummary: I had created a Learning Incident report so that we can see who had reported the incident. Learning Admins receive notifications when incidents are reported but…Ratha Sun 51 views 4 comments 0 points Most recent by Albertson Vergara Reporting and Analytics for HCM
-
Enable tax details on sales orderSummary: How can tax details be made visible on the sales order when clicking on the total amount? Content (please ensure you mask any confidential information): Version…
-
Quality Issue OTBI custom attributes not visible. Custom fields created using application composerHi Experts, We are working on OTBI reporting using the “Enterprise Quality Issues Real Time” subject area and are facing an issue with certain fields not being available…
-
Self-Service Receiving – Viewing Purchase Orders with Need-by Date Older Than 60 DaysSummary: Hi Team, We have a business requirement where requesters need to view all purchase orders that are pending receipt and have an Item Need-by Date older than 60 d…Abhishek Tiwari-Oracle 1 view 2 comments 0 points Most recent by Ashok Sriniva-Oracle Inventory Management
-
Can we exclude minimum amount receipts from AR Aging report (like -0.01)Our customer don't want receipts which has amount less than $1 in their AR aging report (attached ss for the same), can we exclude those receipts from this report? -
Incremental extract for EFF BICC PVOs (FulfillLineBIEffEFFBIFlattened , HeaderBIEffEFFBIFlattened )Summary: We are Unable to run incremental extract for BICC PVOs (FulfillLineBIEffEFFBIFlattened , HeaderBIEffEFFBIFlattened ) There isn't a suitable column (like a last …
-
Which privilege gives access to employee abstract role view own data in OTBI reportSummary: Currently employee not able to view their own data in OTBI analysis with custom employee role. But when I used the seeded employee abstract role it gives too ac…Aditya Jena 21 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Print Expense Report - Failed to load errorSummary: Content (required): Hi, I have tried to get the Expense Report output by using the "Print" option on the actions of the Expense Report. However, the error "Fail…
-
Phone Numbers are not showing up in BI Publisher ReportSummary: Phone Numbers are not showing up in BI Publisher Report Content (please ensure you mask any confidential information): I created a custom BI Publisher report to…
-
How to send attachment from content server to email through BI bursting in fusionSummary: Let’s say we have uploaded a PDF attachment in the contract, and the uploaded attachment gets saved in the content server. Now, we want to send this attachment …
-
How to join Procurement - Procure To Pay Real Time and Enterprise Contracts - Contracts Real TimeHi Team, I am currently working on joining the below two OTBI subject areas, but I am unable to establish a proper join between them: Procurement - Procure To Pay Real T…
-
OTBI Dashboard Prompt Default TimeHi, I am trying to set a dynamic value for Calendar Year in an OTBI Dashboard Prompt. I am using the "Recruiting - Recruiting Events Real Time"."Time"."Calendar Year" co… -
We need to map segment labels to the existing Chart of Accounts Segments for OTBI reportingCurrently, a few GL segments in the Chart of Accounts are not available in the OTBI reports. We have already gone live and started using these chart of accounts segments…Venkata Gadiraju 11 views 2 comments 0 points Most recent by Venkata Gadiraju General Ledger & Intercompany
-
How to report when a pay batch was approved in Incentive CompensationSummary: I need to create a report for a weekly integration that only will pass data for pay batches that were approved during current week. "Last updated date" is too u…Justine Klemetson 1 view 0 comments 0 points Started by Justine Klemetson Reporting and Analytics for ERP
-
What reporting options are available for Role Guides beyond the standard UI views?Summary: What reporting options are available for Role Guides beyond the standard UI views? Specifically looking for OTBI subject areas or delivered reports that support…Career and Skills Product Manager 1 view 0 comments 0 points Started by Career and Skills Product Manager Learning
-
HR Help Desk Infolets "My HRHD Request Work Time" and "Team HRHD Request Work Time" return no dataSummary: Hi, I have a question about HR Help Desk Infolets. "My HRHD Request Work Time" and "Team HRHD Request Work Time" return no data and I am trying to understand wh…Viktoria Priona-Oracle 41 views 2 comments 0 points Most recent by Shelleyyo Reporting & Analytics for Fusion Service -
OTBI Report Issue - "Compensation - Workforce Compensation Real Time"I am currently building a report using the “Workforce Compensation – Real Time” subject area in OTBI. My objective is to retrieve basic employee details along with their…Abdul Raqueeb 31 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI analysis report output does not show the values selected in the prompts when scheduledHi, I currently have the prompt fields as a Static Text element in the results. Running the report directly shows the selected prompt values normally, but does not appea…notautomni9 1 view 1 comment 0 points Most recent by Julia Kiszelewska1234 Reporting and Analytics for HCM -
How to get order details from the charts on OM Redwood page?Summary: We have created a visualization chart on the Order management Redwood page. Now when we click on the charts on the classic page, we are able to see the details …
-
Any ideas why a previously working OTBI report would now be showing this error?Summary: I have a report that is supposed to return the start date and expiration date of a validity period that was previously working. However upon logging in, the rep…
-
HCM OTBI subject areas to database lineage mapping spreadsheetThis spreadsheet documents HCM OTBI subject areas to database lineage mapping and subject area security. Content This spreadsheet is published by Oracle OTBI Development…Raghavendra Raghunath-Oracle 48.9K views 198 comments 131 points Most recent by MazCham Reporting and Analytics for HCM -
Is there a filter/prompt/SQL or a report for a daily dashboard for HR Helpdesk for new/close SRis there a dashboard available or report, or any sql/filter/prompt I can use for OTBI in order to get a daily dashboard for HR Helpdesk queries specifically looking for …
-
Tables of ESS/BIP jobs and their parameters in Oracle fusionSummary Please share the tables in which the parameters of the ESS and BIP Jobs submitted are saved.Content Please share the tables in which the ESS and BIP Jobs, and th…Roohi Syed 4.1K views 6 comments 0 points Most recent by SUDERSHAN PRASAD TIWARI Reporting and Analytics for ERP