To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for ERP
Discussion List
-
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…
-
Subledger Period Close Exceptions Report query timeoutSummary SQL query time exceeds the limit (2400 sec). Stopped processing.Content Hi, just wondering if anyone has any experiences with the Subledger Period Close Exceptio…
-
Invoice attachment link in OTBI analysisContent Hi, Looking to see if there is a way to provide a hyperlink in an OTBI analysis that would open up (preferably in a new window) an attachment associated with an …
-
Frequently Changing HierarchiesSummary How to perform GAAP reporting on Legal Entity Rollups in ERP CloudContent All we have a use case, which I don't think is that unique, yet I am struggling with ho… -
Updating KFF tree versions causes OTBI Analyses to fail when created in “General Ledger – Balances RSummary We are testing changes to the KFF segment values and hierarchies (aka trees). All seems fine with all changes, and GL OTBI reporting until ‘something’ happens an… -
What are the Correct Parameters for OTBI Fusion GL for ESS "Import Oracle Fusion Data Extensions forSummary This ESS request is the very last process in updating KFF OTBI Trees (so we can use OTBI "GL - Balances Real Time"). "All" or (just) "ERP" doesn't work, but "ERP…