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 to create deep links with parameters for supplier qualification moduleSummary: As a business requirement, we should create custom Overview page in supplier qualification module. we built a analysis on the new page and when we click on resu… -
How to use the "is based on the results of another analysis" filter operatorSummary: We created two analysis in OTBI and put them in a dashboard. The one report drills to the second report via action links. The second report is using the filter …
-
Manage Audit Policies - Using this for India financial regsSummary: India authorities have introduced financial regulations around system auditing and we all looking to understand how other people have achieved meeting this requ… -
Cost Center wise access to different users to view Financial ReportsSummary: We have a requirement where the client is expecting access to Financial reporting on the basis of Cost Centers authorized for the user. Content (required): For …
-
Showing Payables Invoice Lines with Amounts for Net, VAT and GrossSummary: Users require indirect taxes for payables invoices to be shown against each line, thus for each invoice line they want to see line amounts for Net, VAT, Gross. … -
Access DBCS tables in SaaS BI Publisher ReportsSummary Is it possible to access DBCS tables while creating BI publisher reports in SaaSContent Hello We have a requirement to build some BIP reports out of the tables t…
-
query to get maturity date and cleared date for ar receiptContent in ar receipt i need a query to get maturity date and cleared date
-
Scheduling ESS JobsSummary Scheduling ESS JobsContent When scheduling ESS jobs to run periodically, it is a good idea to save the seed process ID. That way, if you need to change the sched… -
Are the BPM configuration tables exposed to OTBI?Summary Looking to query BPM configuration tables directly to support external audit change management populationContent Are the BPM configuration tables exposed to OTBI… -
Audit log for the Manage Audit policies setupSummary: The Auditors wants to know when the Manage Audit Policies was enabled and the when the Audit policies were updated latest. Content (required): Log for Manage Au… -
Access to Financial Report to the users on the basis of their respective Cost CentersSummary: Access to single Report developed in Financial Reporting on the basis of Cost Centers Content (required): I have created an Income and Expenditure Statement usi…
-
Exporting OTBI dashboards in PPT FormatSummary: Content (required): Hi Team, We have a requirement to explore alternative formats to export OTBI dashboards, other than Excel and PDF. One of the potential expo…
-
-
What are the roles that are part of "Oracle Fusion ERP for Self Service Cloud Service"?Summary: What are the roles that are part of "Oracle Fusion ERP for Self Service Cloud Service"? Version (include the version you are using, if applicable): Oracle Fusio…
-
What are the roles that are part of "Oracle Fusion ERP for Self Service Cloud Service"?Summary: What are the roles that are part of "Oracle Fusion ERP for Self Service Cloud Service"? Exist Fixed Assets role for Self Service Cloud Service? Exist Payables r…
-
Transfer of Business units from one ledger to another ledger and from one legal entity to anotherTransfer of Business units from one ledger to another ledger and from one legal entity to another legal entity. I need the details and Action Plan and What is impact of …
-
How invoke an Web service using an Analysis in OTBI?Summary: Use an Invoke web service get and push the information in another system Content (required): We have a proposal to active an web service when a field in Transac… -
How to Zip BIP output containing multiple output filesSummary: Content (required):We are trying to download zip file(containing all output files for particular schedule) using Compress output prior to delivery. Version (inc…
-
Is there a function/package to retain Hebrew Language source text in BI Report output text using SQLI have a Hebrew text file uploaded in UCM. I pass the file from UCM to the Data Set query. The report output display junk characters and does not retain Hebrew character…
-
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 …