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
-
Table/Query to find the BPM work flow notification pending with particular personSummary: We are looking for Workflow notifications (Especially Expense report) pending with one particular person for approval. Do we have any table which stores this de… -
can we pull historical details of CANCELLED ESS jobs from back-end?Problem Description --------------------------------------------------- AUDIT CONCERN: can we pull historical details of CANCELLED ESS jobs from back-end? During an audi…
-
How to link between General Ledger, Subledger and Receivables tables in BI PublisherSummary: I'm trying to add information from the Receivables tables to a General Ledger query on income when a transaction has come from the receivables ledger. But I am …
-
Payables Posted Invoice Register to show final approver doubles invoice line amountsSummary: I'm trying to modify the Payables Posted Invoice Register to show the final approver, but the output shows the invoice line multiple times. Content (required): … -
In Oracle Cloud can you see which processes are scheduled automatically?Summary: In Oracle Cloud can you see which processes are scheduled automatically? Content (please ensure you mask any confidential information): In Oracle Cloud can you …
-
query for rejected invoices and rejector commentSummary: We're looking for a query that will show rejected invoices and the reason they were rejected as well as the cost center and creator. Content (please ensure you … -
Bug 28478515 : AUTOPOST JOURNALS PROCESS FOR MULTIPLE DATA ACCESS SETSummary Unable to perform batch posting by "Batch ID" due to data access set designContent Is there is update or ETA for fixing of this bug? Bug 28478515 : AUTOPOST JOUR… -
How to Version Invoice templatesSummary: We currently create Invoices by using an OTBI report to gather the data and put it into a RTF Template. However when you upload a new version of the template, t…
-
Oracle roles required for developing BI reportSummary: Need to know what Oracle roles are required for an user to develop BI report Content (please ensure you mask any confidential information): Version (include the…
-
Searching for table containing segment values and descriptionsSummary I'm writing the SQL in a data model where I need to display account value and descriptionContent I'm creating a data model where I want to display segments in th…
-
Ago Function not working in OTBISummary: We trying to use AGO function for Previous Year Actuals Column in OTBI General Ledger - Balances Real Time. But report is showing null values in Previous Year A…
-
Can we call OTBI/Analytics dashboard using SOAP/REST webservices in oracle fusion?Hi , We have a requirement to run/submit the analytics/OTBI dashboard using rest/soap webservices. Please share your inputs. Appreciate your help. Thanks in advance.
-
How to print tables side by side in BI publisherHi, I was trying to develop a rtf template to print the Invoice copy. As part of the requirement, I need to print tables side by side. I was able to add the tables side …
-
REST API to run FRS reports in FusionSummary: Need to know REST API details if any to run FRS reports in Fusion Content (required): REST API to run FRS reports in Fusion Version (include the version you are… -
DFF Value (Change/Update) reflection in OTBI Subject AreaSummary I have a DFF with current value as A and OTBI shows that DFF value as A... Now I change the DFF field value to B Does the Value B automatically gets reflected in…
-
Taxable lines in journal entries not generating in the Deductible VAT Declaration Report for FranceHello, We are encountering an issue whereby taxable lines in journal entries are not being generated in the Deductible VAT Declaration Report for France. Taxable Purchas… -
Which Table Have Review Completed Transactions DataContent Dear , I want to know that which table have review completed transactions data for inventory. if any have query and know the table name please guide me. Kindly c… -
How can we get GL accounting date for budgetary control ?Summary: Hi Team, We have requirement to build a report which will have accounting date for each line in budgetary control. How can we link budget and GL tables to fetch…
-
Can we change the default report format for standard reports generated from scheduled processes?Most of the reports are generated in PDF format by default. Can we change the default format to excel?
-
PVO for GL Secondary Balancing Segment KFF?Summary: On a quest for chart of account segment descriptive labels (KFFs) for secondary balancing segment. Content (please ensure you mask any confidential information)… -
Receivables OTBI report: Line level transaction report with payment informationSummary: I have created an OTBI report to show line level detail of AR transactions using the Receivables- Transactions Real Time subject area. I am looking for a second… -
OTBI Incremental Date Parameter ValuesHi, We have a requirement to run the Payables Invoice Register OTBI report with incremental date parameters. We would like to schedule the Payables Invoice Register OTBI…
-
Is there any termination date set for the Audit report ( or can it be set)?Summary: I was wondering if the audit trail captured in the audit report remains infinitely in the system or does it gets purged/terminated. Content (please ensure you m…
-
Is there any way to skip "Columns" in Report Output as when they are empty?Hi Dears, We're working on a new BIP Report under Cloud implementation project and we want to used Excel template. We've been looking around how to skip/hide columns whe…
-
Sending Reports to a Google DriveSummary: One of our customers is looking to have certain reports from ERP delivered to a Google drive location. Has anyone tried this and if yes how was it done? Any inp…
-
Trial Balance with UNPOST journal entriesContent Dear experts, We got an requirement that create Trial Balance with Unpost JEs. I tried to use OTBI with cross subject areas GL-Balance and GL-Journals by adding …
-
Does BICC support Extensible Flexfields (EFF) ? How do we extract information from EFFs ?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Oracle Business Intelligence Cloud Co…
-
What is the current OTBI export limitSummary: What is the current OTBI export limit in Oracle Fusion? Content (please ensure you mask any confidential information): Version (include the version you are usin…
-
Do we have report which gives user is present in which approval workflowsSummary: We are searching for report which we can run by user name and the report should gives us details in which workflow approval user is present. Eg: PO , Req, Invoi…
-
Oracle Fusion Financial Data Retention PolicyWe wanted understand the below to requirement about the Fusion Data retention policy . What is the Oracle standard policy being followed by oracle across module with res…