Reporting and Analytics for ERP
Discussion List
-
Highlight duplicate values based on a value in another columnContent Could somebody help me with the following issue, please: In an OTBI report with data from the Enterprise Contracts module, I would like to highlight (eg. with co… -
How can I get to the person number from the workflow tables?Summary We need to report out the comments on terminated employees and while I can get to the comments there is no separate column for person number to get to the other …
-
Struggling to Find Expense Report Line DetailsSummary Can't Find Receipt Date and Number of Days in "Expenses - Expense Transactions Real Time"Content We are seeking the following fields for Expense Report Items: -R… -
Expense Report AnalysisSummary We are trying to improve our reporting on expense reports and add additional fields in our reportsContent We are trying to improve our analysis on expense report…
-
BI Parameter IssueSummary ORA-01795: maximum number of expressions in a list is 1000Content I have a BI Publisher report with a parameter that gets its list of values from a sql query. If…
-
OTBI Catalogs for Primary Statements (Balance Sheet, Cash Flow, Income Statement)Summary OTBI Catalogs for Primary Statements (Balance Sheet, Cash Flow, Income Statement)Content Hi Is there standard catalog files available for primary statements whic… -
21b Upgrade causes Data Models to FailSummary 21b upgrade has failed testing because of failed to load servlet/dmvalidate errorContent We have had 21b on our 3 test environments and it caused an issue that i…
-
From To Accounting period condition in OTBISummary From To Accounting period condition in OTBIContent Hi all, Is it possible to keep 'From' and 'To' Accounting period as input prompts in PTBI GL/Subledger subject…
-
What Role/Privilege grants access to edit Scheduled Agent "RUN AS" in OTBI?Content Does anyone know what Role/Privilege allows access to update the "Run As" field in a Scheduled Agent for an Analysis in OTBI? I've assigned the following to a te… -
Receiving - Purchase Receipts Real Time returns no data for ReceiptContent Hi, We have a requirement to create a report that provides details for Receipts. I'm trying to build the report using the Receiving - Purchase Receipts Real Time…
-
AR Aging ReportSummary AR Aging ReportContent Hi all, I am doing a AR Aging Report using OTBI. For example: AR aging report has following columns: Customer Name, Transaction Date, Tran…
-
Fixed value in Value set querySummary Fixed value in Value set queryContent we have defined the value set and validation type is Table we have written condition to pick email ID from PER_EMAIL_ADDRES…
-
BIP Schedule Skip or Resume after Oracle DowntimeSummary BIP Schedule Skip or Resume after Oracle DowntimeContent Hello, Whenever Oracle SaaS is down due to patching or release upgrades, does it pause all the BIP Sched…
-
Add new permission to existing custom folder in BI CataglogSummary Error when adding new permission to existing custom folder in the BI catalogContent 'Assertion failure: !tAccountId.isEmpty() at line 282 of project/websecurity/…
-
Selecting multiple column headers for styling in OTBI analysisContent Hello all, May I know, if there is an option to select all the column headers and apply a certain style rather than selecting each and every column and applying … -
How to import data model in fusion biContent Dear , We have data model but cant find to import data model into fusion. Could you please guide how to import data model into fusion. step by step We have admin… -
create if condition in bi in add element by expressionContent i need to create element by expression and use if condition . how i create if condition in add element by expression ? (with example please)
-
BI Publisher report in Oracle fusion not completing after 21B upgradeSummary BI Publisher report in Oracle fusion not completing after 21B upgradeContent Hello Peers- Posting our experience with one of the BI Publisher reports after upgra… -
Analysis BI displays duplicate values in parametersContent This problem appeared on May 5th and disappeared with update 21B. All Analysis BI in our production instance showed the same behavior. We validated that the anal…
-
Invalid Subject Area Error in OTBI report creationSummary Invalid Subject Area Error in OTBI report creation using Create Analysis from simple logical sqlContent Hi, We are getting an Invalid Subject Area Error while cr…
-
Knowledge Foundation SOAP connections are no longer availableSummary Knowledge Foundation SOAP connections are no longer availableContent Knowledge Foundation SOAP connections are no longer available https:///cgi-bin/.cfg/services…
-
Subject Area Real timeSummary Hi Team, Could you please help understanding what is a "real time" that is always are added with a Subject AreaContent Hi Team, Could you please help understandi…
-
Influencing the SQL Optimizer in SaaS ERP ApplicationsSummary We have a query that was running perfectly in our non-prod environment for month up until mid December 2020. Then it suddenly timed out and performs poorly.Conte…
-
Restrict users from sending reports to external email addressesContent Hi, As we know, Oracle allows to include the email address when adding a Destination for a report output in both OTBI and BIP reports. Is there a way to restrict… -
define dff attribute10 in ar invoice header (appear on otbi analysis)Content i want to craete otbi analysis on ar transaction , and i define attribute10 on invoice header. i need to get this colum on analysis but i can't find it . how i g…
-
What forum is used to submit a question regarding jobsets?Content Hello: I have a question regarding the Job Set Steps for stop/yield per step for a jobset created for various inventory processes. What specific forum would be u…
-
UK Payslip CustomisationSummary UK Payslip CustomisationContent Hello Experts, Need your help. Can you please help if you have already done UK Payslip Customisation; Like the details of the cus…
-
BPM Worklist - Approval Aging ReportSummary Report to calculate the average time it takes approver to approve a taskContent Hello, We have a requirement to build out a report/analysis to calculate the aver…
-
po number - po_amount - invoice amount - payment amountContent i need to create analysis to get these information po number - po_amount - invoice amount - payment amount
-
Why is there no output from a scheduled OTBI report when the interactive version works fineSummary A report with csv output with parameters can be run interactively, but when scheduled no output can be found in scheduled processes, but available though e-mailC…