OTBI
Discussion List
-
Supplier real time contact developed through OTBIWe have developed a report using OTBI to extract supplier details using Supplier - Supplier Real Time. Use case: Each supplier have two sites (US and CA) and one contact… -
Absence Balance Report Based on Balance Calculation DateSummary How to get the absence balance to include future dated absencesContent In the existing report, balances are reflected as of today; however, would like it to refl…User_2025-01-28-20-43-56-568 1.8K views 21 comments 3 points Most recent by Raymund J Reporting and Analytics for HCM -
How to Add PO Charge Account on OTBI Report using Payables Invoices - Transactions Real Time when POSummary: How to Add PO Charge Account on OTBI Report using Payables Invoices - Transactions Real Time when PO is set to Accrue on Receipt. Invoice Distribution Concatena… -
Redwood Issuing Comments field in Document Record Displays html Text in OTBISummary: We just implemented Redwood for Document Records. The Redwood field for Issuing Comments (seeded Oracle field) displays as a rich text editor field where bold, …Linda Chirash 32 views 5 comments 0 points Most recent by Linda Chirash Reporting and Analytics for HCM
-
Career Site Metrics ReportSummary: Does anyone have Career Site metrics report based on Candidate Tracking subject area in OTBI? Content (please ensure you mask any confidential information): Doe…AvinashP 1 view 3 comments 0 points Most recent by Durga Magar-232055 Reporting and Analytics for HCM
-
How to report on "Job Description" from "Job Profile"Summary: I need to report on job description and effective start/end date within each job [model] profile, but i can't seem to find it from BI. I tried to query few tabl…Adil_R 272 views 14 comments 0 points Most recent by Srinivas_Godari Reporting and Analytics for HCM
-
OTBI does not generate all lines.Hi everyone. I'm generating a report in OTBI and not all the lines that should be generated are being returned in the report. Is there a limit to the number of lines tha… -
how to add Cash Advance liquidation 'Due date' in OTBI report?In Auditing stage, the expense auditor need to manual input the Due Date of Cash Advance. We want this Due Date field to be added in OTBI report for monitoring purposes
-
OTBI - Legal Employers that use this jobSummary: OTBI - Legal Employers that use this job Content (please ensure you mask any confidential information): Subject Area: Workforce Management - Worker Assignment R…Julie S. 11 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Issue with Error Message and Reported Hours in OTBI Report for Imported Time EntriesSummary: After submitting the process “Process Imported Time Entries”, a few time cards are erroring out. I need to build an error report that shows: Person Number Time …Raghavendra M 31 views 1 comment 0 points Most recent by Raghavendra M Reporting and Analytics for HCM -
Tracking Vendor Registration Duration in Redwood Supplier RegistrationSummary: We have a business requirement where the client needs to track the total time each vendor takes to complete their registration after clicking the external Redwo…
-
Query for Projects, Subledger and General LedgerSummary: Query for Projects, Subledger and General Ledger Content (required): Hello I was wondering if you can share with me any Query for Projects, Subledger and Genera…
-
In which Subject area to find "Negotiation and Renewal" information for Contracts for OTBI analysis?Summary: While using the OTBI analysis under Reports and Analytics tool in Oracle we noticed that there was missing information under the "Enterprise Contracts - Contrac…
-
SQL Query to get Work Definition and resourcesSummary: Hi, Can anyone provide SQL query which will fetch Work Definition and the Resources linked to it? We have Work Definitions defined in Maintenance Cloud and want…
-
OTBI 'Can't load models - Restore your models' issueIn our TEST environment we are seeing the following issue is all users: As far as we are aware nothing has changed in the back end. We have done the following: Purged th…Mike Pee 11 views 1 comment 0 points Most recent by Paul Romero-Support-Oracle Reporting and Analytics for ERP
-
how to add the hyperlink to Dash board AnalysisWe have created an OTBI dashboard with an analysis that includes a graph based on suppliers and their purchased item categories. We need functionality that allows users …venkat chaladi 31 views 1 comment 0 points Most recent by Pratap1305-Oracle Reporting and Analytics for ERP
-
Is there a way to align X-axis labels to the bars in bar graph in OTBI Oracle Fusion.Is there a way to align X-axis labels to the bars in bar graph in OTBI Oracle Fusion.Currently if the orientation is changes to 90 degree, it shows like below:Shreya Agarwal-Oracle 11 views 1 comment 0 points Most recent by Pratap1305-Oracle Reporting and Analytics for ERP
-
Is there any report for Remittance Advice Delivery Email ID by supplier siteSummary: Report for remittance advice delivery email ID by BU Content (please ensure you mask any confidential information): Hi Team We required to update and add more e…JL-JL 114 views 5 comments 0 points Most recent by Emily Downum Payables, Payments & Cash Management
-
Manage Delegations ReportSummary: Is there a seeded report that would list all the active employees that are able to create expense reports for employees? There is not a way to download to excel…
-
RSUM Not working for running cost totalHi, I tried using the RSUM function to get a running total of the project actual costs (Actuals column). However, that function is not working as I expected in the last …Julia Looi 51 views 4 comments 0 points Most recent by Chaunae Walton Reporting and Analytics for ERP -
"Procurement - Procure To Pay Real Time"."Invoice"."Receipt Date" is returning blankSummary: Has anyone get to the bottom of this, I am trying to bring back "Procurement - Procure To Pay Real Time"."Invoice"."Receipt Date" But it is coming black as blan…
-
Is there a suitable replacement for PAY_ACTION_INFORMATION table for 'Employee_Rec' type rows.Hello, Could you please suggest a replacement table for PAY_ACTION_INFORMATION for action_context_type (POA) and action_information_category ('Employee_Rec'). We are fac…
-
Report to extract Payables invoice approval workflowSummary: Report to extract Payables invoice approval workflow Content (required): Need to know source of payables invoice approval workflow setup so that a report can be…Bernadette Dorris 387 views 1 comment 3 points Most recent by amarzhc Reporting and Analytics for ERP
-
New accounting period open but not showing in any LOVSummary: Below we have a new opened period - "the pd 13 is specifically for audit adjustments and we'd always enter them on the last day. It's separate from Sep-13 becau… -
Sql query to get expense report attachment contentHello, Is there any way to retrieve the contents of expense report attachments using an SQL query? I need to include them in an RTF file. I want to generate a report tha…
-
Absence is wrongly calculating in OTBI reports when applied in advanced mode.Hi Folks, While submitting the absence in Advanced mode, the balance is calculating for whole week even if i apply for two days in a week. What might be the issue? Pleas…
-
How to extract records for a specific date that is in CURRENT_YEARSummary: I have an OTBI report showing all employee terminations. What formula can I use to return only terminations in the CURRENT_YEAR? Field is "Worker"."Termination …