General Transactional Reporting (OTBI)
Discussion List
-
Is there a way to add calculated row in the pivot table (OTBI Analysis)Summary: Is there a way to add calculated row in the pivot table (OTBI Analysis) Content (required): I am trying to create an analysis like below using pivot table funct… -
Link Payroll Run Results Real Time and Payroll Flows Real Time for Processed Date from Payroll FlowsSummary: We have a supplemental payroll cycle that runs weekly. During the Payroll Flow set up the Payroll staff uses the "Override" date on the flow parameters in order… -
OTBI report gives an error when add Workforce Management - Person Real time subjectDear , I have an OTBI report which works fine on subject Workforce Management - Worker assignment Real time but i need two more column which is in Workforce Management -…
-
Is write back supported in OTBI in SaaS?See https://docs.oracle.com/middleware/12211/biee/BIESG/GUID-6F16F7CA-E525-4569-A5A0-C1C0F851F57E.htm#BIESG1354 Is this functionality also available in OTBI in the SaaS? -
Invalid date in BIP report for some usersHello, We have an issue where some of our users are seeing invalid dates in the BIP report. e.g. actual date in table (at db level) is 15-Nov-21 but certain users are se…
-
How do we create a role to view OTBI analysis for a user that doesnt have transactional access?Summary: We have users that dont work with AR, but we want them to be able to open OTBI analysis made with AR subject areas. We tried creating a Financials role with the…
-
How can you edit the subject area of a report?Summary: Can I edit the subject area/column of a report? I only want a portion of the information to appear on the report. Content (required): Version (include the versi…
-
Prompt on empty datesSummary: We need to have a prompt where you can not only filter on a date range but also on the empty date fields Content (required): We want to filter in the prompt on … -
How to link Receivables - Customer Real Time and Receivables - Payment Schedules Real Time in OTBISummary: I am wanting to create a report with certain bill-to customer information that is not located within the Receivables - Payment Schedules Real Time subject area,… -
How to verify and validate correct date formats in OTBI where the column is supporting references.Summary: We have a scenario where we are using a supporting reference column and casting it as date. But due to multiple formats of date being entered in the column with…
-
How to link Receivables - Customer Real Time and Receivables - Payment Schedules Real Time in OTBISummary: I am wanting to create a report with certain bill-to customer information that is not located within the Receivables - Payment Schedules Real Time subject area,…
-
REST API for Oracle BI Publisher not working in 22AHi Everyone, Tried calling REST API for Oracle BI Publisher from postman but got error from Oracle Public cloud with 404 code and page not found error message. Not sure …
-
FTE Breakdown (last year of 2020 and 2021)Summary: I want to make a report showing FTE by worker category, department, legal employer... per end of a period like end of month, end of quarter and end of year. I t…
-
Oracle Autonomous Data Warehouse (ADW) and OTBISummary: Hi, I would like to understand if we can integrate ADW with OTBI. Our client currently uses ADW functionality and would like to understand if they can access th…
-
OTBI Logical SQL complex query assemblerSummary Combine 2 analyses from 2 different subject areasContent While building a report on OTBI, you will encounter some cases where the Subject Area will only provide … -
Hide Seeded Folders from Reports and AnalyticsSummary: We are able to hide customs Folders by Using Shell role and and Permission feature. However While trying the same with Seeded Folders or the folders within them… -
Any advice on version control for OTBI reports?Summary: Is there a good way to deploy some sort of version control within OTBI? Content (required): We work with a third party and also make updates internally and some… -
Calculated column with interval between start and end dates selected in promptSummary: When i select the start and end dates in a prompt, i want to have a calculated column that shows the interval between the start and end dates, i want to use thi…
-
ZMM Notes columns - SOURCE_OBJECT_CODE, SOURCE_OBJECT_UID in Receivables - Transactions Real Time?Summary: Is anyone familiar with the subject area - Receivables - Transactions Real Time? I am looking for the equivalent of SOURCE_OBJECT_CODE, SOURCE_OBJECT_UID column…
-
OTBI Report running into error when I add Sum on a column-Sort has no work space in the work directoSummary OTBI Report running into error when I add Sum on a column-Sort has no work space in the work directory.Content Hi, I have an OTBI Report running into error when … -
Text AnalyticsSummary step by step procedure to proceed Text Analytics in OBIEE 11gContent Hi, I need step by step procedure to proceed Text Analytics in OBIEE 11g. I'll be happy to r… -
how to auto run an analysis with promptSummary: I have created an analysis with prompts. I want that when an analysis is run, it should display the output with default prompt option 'All Column Values'. Curre…
-
Why does the table edit page return results but the results page error?Summary: I have created a case when clause in my OTBI report which should return a column of show or group based on the criteria. When I see it in the table edit view, i… -
OTBI analysis based on results of another analysisSummary: I have 1 OTBI analysis that looks at all invoices in system and filters it down based on 10 parameters. I have a second OTBI analysis that I then have a filter … -
R13 21D Financials OTBI database mapping with ViewObjectsSummary: Where can we find R13 21D Financials OTBI database mapping with ViewObjects? Content: Where can we find R13 21D Financials OTBI database mapping with ViewObject… -
Export OTBI to CSV includes excluded columnsSummary: How do we ensure that OTBI reports exported into CSV, do not include the excluded columns. Content (required): Currently I have a learn report that I have filte…
-
Person Records Secured By AOR Does Not Restrict Data Reflected In OTBI ReportsSummary: Hello Everyone ! I am trying to secure the data returned by HR_ANALYST job role by using an AOR with a scope of Department. Although, it works fine in the HCM U…
-
No. of rows in the CSV output file of ESS job in Oracle CloudSummary: Hi, We are seeing the below error in the CSV output file of an ESS job in the Oracle Cloud. Flatten data truncated due to MaxRows=2000000 has been reached. Is t…
-
ESS Schedule Process ID into OTBISummary: Obtaining ESS Schedule Process ID into OTBI data model Content (required): Hi all, Has anybody every seen or done getting the ESS “Scheduled Process” request ID…
-
Query to find the HRBP Representative of an Employee in HCM DatabaseSummary: Find a 'HR Business Partner' of an Employee in HCM Database - to create a report on Employee and his/her 'HR Business Partner Representative' details. Content (…