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
-
How much do last the attachments on a newly created custom page?Summary: How much do last the attachments on a newly created custom page? Content (required): We have created a custom page and used it for a source of entry for some jo… -
Oracle Business Process FlowsHi, I've found this note in Oracle Support which highlights the business processes (L1-3). I'd like to understand if there's any other documents which Oracle has publish…
-
Can we select a range of member values in the prompts while running a FRS reportHi Team, We have a requirement to provide prompts for running an FRS report, wherein we can select a range of values, like 'From' and 'To' option while selecting account… -
Table name that holds the Supplier Site Purchasing Tab dataSummary: Table name that holds the Supplier Site Purchasing Tab data Content (required): I'm trying to create a BI Report to monitor when PO's are not communicated out t… -
SFTP bursting to home directoryHi All We have an issue delivering files to "\" directory for a vendor.. There are no sub directories and oracle documentation mentioned \ should not be used. and when n… -
How to use Starts With or Contains function in BI Report SQL QuerySummary: Is it possible to use Starts With or Contains function in BI Report SQL Query? If so, how? Content (required): Is it possible to use Starts With or Contains fun…
-
Disable auto run in OTBI analysisSummary Need to stop run reports automatically on initial page entryContent Hi Team, OTBI analysis report running automatically and resulting it displaying the “No Resul… -
Query to retrieve entries using accounting period from and accounting period to parameterSummary: Query to retrieve entries using accounting period from and accounting period to parameter when both are optional Content (required): Version (include the versio… -
How can we secure/hide the Reports and Analytics Panel Tab on a given page?Summary: Requirement is to secure the Reports and Analytics Panel Tab on certain pages to certain roles or in one case hide it completely. How do we do so. Content (requ…
-
OTBI Analysis exceeded the Maximum query governing execution timeSummary When users run a OTBI analysis gets the error exceeded the Maximum query governing execution time - what is the time limitContent I have a user that is running a… -
How to apply font color conditionaly in BIP ExcelSummary: We are currently building an audit report in which changes should be highlighted. The report contains values before and after. If value after is different from …
-
Error in accessing BICC URL ending fusion pod /biacmSummary: Hi Team, We are getting error while trying to access BICC using url - fusion POD /biacm. Anyone faced similar issue, so need help in resolution of same. ADF_FAC…
-
Is there a plan to lengthen the BIP audit log data of 90-day retention period to, say, 180 daysSummary: We would like to ask if Oracle Product Team has planned to lengthen the 90-day retention period for BIP audit log data. Content (required): Audit Log Version (i…
-
Unable to call BIP report with REST APISummary: Hi Experts I'm trying to use the REST APIs for the BIP report developed in Fusion but I'm getting not found error, please help me if I'm creating a wrong URL Be…
-
Can we add attachments using sandbox?Summary: We have a business requirement that the users wants to attach documents in the Supply Request Form. Can we add attachments '+' using sandbox? kindly guide us ho…
-
Getting Errore in FRS Report - Internal Essbase JAPI errorSummary: Getting Errore in FRS Report - Internal Essbase JAPI error Content (required): Dear All, I tried to run a FRS Report and I am getting the below error. Error exe… -
Connecting Workiva Cloud Service with ERP Cloud for SEC ReportingSummary Would like to know if anybody has done this connection and how worksContent Hello, I'm trying to learn from somebody that already experienced how to connect Work… -
No access privilege for subject area errorSummary: User getting this error No access privilege for subject area when trying to access OTBI Reports using Order Management – Fulfillment Lines Real Time subject are…
-
Getting error in FRS reportSummary: Getting errors in the FRS report Content (required): Hi All, I moved one FRS report from TEST instance to PROD. When I try to run the report in PROD, I am getti…
-
How to configure the notification for Journal Request ProcessOracle OneERP --> General --> Journal. A notification e-mail is currently automatically sent to journal requestors' individual e-mail addresses. Can we change the config…
-
How to find SQL query or logic behind the value set attached to the ESS job?Summary: Is there a way to figure out how the Asset book list of values are populated when running Create Mass Addition program? As per below screenshot, List of value s…
-
Looking for SQL query for Duty Role to Job Role mappingSummary: We have a couple of job roles and child duty roles and privileges assigned to the same job role. Can someone help me with SQL to fetch the same as we need to co… -
Need help with querySummary: May I know what is wrong in this query Content (required): SELECT order_key, dfla.source_order_number, dfla.source_line_number, DFLA.ordered_qty using_requireme…
-
Report for BPM Workflow RulesSummary: Is there a mechanism to pull out list of BPM rules as an extract or report. Also the workflow Rules Report covers some of the workflows but not all. Content (re…
-
Audit Tables in Oracle CloudSummary: Audit Content (required): We are working on Audit Report. User is not happy with the output provided by the Audit Report functionality in Oracle and we want to …
-
Output Name is incorrect in Report Job HistorySummary: Content (required): We used Bursting to set the file name of the report. It is displayed correctly on the Schedule Report Job History screen inside file name bu…
-
How to use INSTRING function to retrieve string Position in OTBI Formulae column?Summary: How to use INSTRING function to retrieve string Position in OTBI Formulae column? Thanks, Immanuel
-
How to default System Date using Sandbox?Summary: We have one requirement that we need to default the system date in the Supply Request Form Content (required): We have one requirement that we need to default t…
-
OTBI User sessions not shown in Manage sessionsSummary: Other user's OTBI sessions don't seem to be always passed through and visible in Admin>Manage sessions, even when using report with prefix set to: SET VARIABLE … -