OTBI
Discussion List
-
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 52 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 388 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 …
-
OTBI how to list repeated valuesSummary how to use list component to repeat valuesContent Hello, I've created a customized report in OTBI and it i'm using the list component to present the data retriev…User_2025-02-05-18-37-12-438 88 views 5 comments 3 points Most recent by Pratik Raval Reporting and Analytics for SCM -
Termination Headcount from Trend real Time not giving correct headcountSummary: I'm working on an OTBI analysis to calculate and display the turnover percentage for leavers over the last two years as a line graph. The objective is to show t…Srushti 95 views 18 comments 0 points Most recent by Nalsoft Pvt Ltd Reporting and Analytics for HCM
-
Is there a Subject Area in OTBI that will show all user's "Preferred Knowledge Locale"?Is there a Subject Area in OTBI that will show all user's "Preferred Knowledge Locale"? If so, what is the Subject Area? I've tried several "Knowledge" SA's, and a few "…Phillip Jones 64 views 17 comments 0 points Most recent by KMChris-Oracle Reporting and Analytics for HCM -
Custom Pick Slip ReportHi Team, We are trying to build a custom pick slip report which will sort the locator by A to Z and called by Schedule Pick Wave. We need the right parameter name for th…
-
Ability to scan all reports for specific fieldsSummary: Hi - We recently introduced a second Organization tree where we have only had 1 tree since our initial go-live in 2018. With the addition of this new tree, anyw…
-
How to move OTBI & BIP reports from one instance to anotherSummary: How to move OTBI & BIP reports from one instance to another instance? Looking for the easiest way to achieve this. Content (please ensure you mask any confident…
-
How to implement rollup functionality in OTBI / BIP report in Oracle CX Sales Fusion?Hi everyone, I’m exploring whether Oracle OTBI (Oracle Transactional Business Intelligence) or BI Publisher can support a report layout similar to the Rollup (expand/col…Himanshu_Kumar 32 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service
-
received error messages when running Missing Time reportsHi Team, As we are trying to run below delivered Missing Time Reports OTBI then we are getting below error. Could you please help to resolve the issue. ERRORChanikya Neelam-Oracle 21 views 8 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
OTBI report is not showing po number for delivered requisition linesSummary: OTBI report is not showing po number for delivered requisition lines Content (please ensure you mask any confidential information): PO line status is closed but…
-
how to get current status of the negotiation in OTBI reportSummary: How to get current status of the negotiation in OTBI report. when I try to retrieve negotiation and its current status, it giving multiple status against each n…
-
Add columns to Subledger Period Exception reportSummary: How to customize the Subledger Period Exception report to add more columns in the report output and provide option to run the report in OTBI. Content (please en…
-
How to extend limit of Rows to Display in Kanban View Oracle fusion SalesSummary: We have created a Kanban report, but when attempting to display more than 100 rows using the “Rows to Display” field, the Kanban view turns blank. We would like…
-
Subject area for Employee data (About me)Summary: Hi All I am trying to create a report on employee's 'about me' section. Not too sure what subject area/table to use for this? or if someone has something made a…Jeevan Loyal 41 views 6 comments 0 points Most recent by Jeevan Loyal Reporting and Analytics for HCM
-
How to Find an IP Address of a User who has Logged in Fusion Application ?Summary: How to Find an IP Address of a User who has Logged in Fusion Application ? Content (please ensure you mask any confidential information): Hello, I have a requir…
-
OTBI-Cannot find "Structured Payment Reference" field in Cash Management - Bank Statements Real TimeSummary: I'm trying to create a report based on bank statement line items. The one field I cannot seem to find is the "Structured Payment Reference" (see attached). Are …
-
Roles and Privileges Real TimeI am required to show the date when a user was assigned a role. Is that possible either with this subject area or through a custom query. My output needs to be: Person N…David Boudreau 21 views 4 comments 0 points Most recent by David Boudreau Reporting and Analytics for HCM
-
Fusion OTBI Drill Down to different subject area, linking on column with different name in each areaSummary: Hi, Oracle Fusion OTBI. I'm attempting to drill down from and OTBI Report on "Procurement - Procure to Pay" Subject Area to another report based on "Payables In…PeterBridge 33 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM
-
Receivables - Transaction Real Time to Receivables - Standard Receipts Application Details Real TimeHi. We are tying to get this subject are (Receivables - Transaction Real Time TO Receivables - Standard Receipts Application Details Real Time), however data is not show…Krishna Kishore 21 views 0 comments 0 points Most recent by Krishna Kishore Reporting and Analytics for ERP
-
Workforce Profiles - Person Profile Real TimeSummary: Hi Expert, I need your assistance. I picked up multiple values by using the above-mentioned subject area and getting values from different sections of a person'…
-
Custom Pick Slip ReportSummary: We are trying to build a custom pick slip report which will sort the locator by A to Z and called by Schedule Pick Wave. We need the right parameter name for th…
-
Custom Pick Slip ReportHi Team, We are trying to build a custom pick slip report which will sort the locator by A to Z and called by Schedule Pick Wave. We need the right parameter name for th…