OTBI
Discussion List
-
"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 382 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 90 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 91 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 61 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…
-
OTBI Report for Current Invoice ApproverSummary: I am trying to build an OTBI report that shows invoices that are pending approval along with the name of the current approver. For the most part, I have been ab…Neal Foley 611 views 11 comments 0 points Most recent by Manisha Sujal Puria Payables, Payments & Cash Management
-
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 31 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…
-
Issue with Month-wise Active Headcount Count in Workforce Real time Trend Subject Area - OTBI ReportHello All, I am working on a report using the Workforce Trend - Real Time subject area in OTBI. The requirement is to show month-wise new joiners, attrition, and total a…KetanChavan 101 views 6 comments 0 points Most recent by Suneha .-Oracle Reporting and Analytics for HCM -
How to restrict users from accessing cost centers that doesn't belong to them in FRS?I enabled a Segment Value Security Rule to restrict users from seeing cost centers that don’t belong to them. The users are correctly restricted in the Journals area — t…
-
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 31 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 Started 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'…
-
How to access smart form name in OTBI?Hello Oracle gurus, Our business uses a DFF in procurement at requisition line level. We have now upgraded to Redwood applications and are using smart forms and the DFF …Sheetal VBCS 3 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM