Category 129
Discussion List
-
Fusion BI Report Custom LOV description alignment problemSummary: The problem : The description is not properly aligned (see below in yellow) in custom LOV. The user has requested for the description to be left-aligned. Conten… -
How to enable the File Data Sources in Oracle BI PublisherSummary: How to enable the File Data Sources in Oracle BI Publisher? The guide shows how to do it but we are getting the error (Fusion Middleware Administrator's Guide f…Raymond Alvizo 21 views 2 comments 0 points Most recent by Raymond Alvizo Reporting and Analytics for ERP
-
Analysis - SQL expressionSummary: How to get first month of previous date - SQL Expression (Criteria ) Content (required): We have created a Analysis report and business needs to schedule this a…
-
OTBI Dashboard Record Count MismatchHi Team, We have built a dashboard and that has a record count to count the number of rows. We could see the record count shows different numbers for people with differe…Swapnil Kashid 81 views 6 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
What is SQL Receipt Accounting join to source_id_int_1 column from xla_transaction_entities?Summary: Trying to go from GL through Subledger Accounting to Receipt Accounting in Data Model SQL. Didn't find any documentation or hints on this. Content (required): V…huronstevesmith 981 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Is it possible for an analysis to link to a dashboard prompt?Hello, I would like to link one analysis to the prompts on a dashboard which will then update another analysis. Is that possible? Thank you, Julia Oracle Fusion v23AJulia Looi 31 views 1 comment 0 points Most recent by Saurabh Poddar-Oracle Reporting and Analytics for ERP -
OTBI Dashboard combining two subject areas of two different modulesSummary: We want to prepare an OTBI dashboard having 2 analysis. First analysis will pull the data from Procurement contracts module for lets say 10 suppliers and then s…Vicky Adwani 81 views 2 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
How to Find All Scheduled ESS Jobs, Frequency, Submitted By, And Other Inofmration?Summary: Just like the title says, we are having trouble find that information. I wrote the SQL Below which does return the required information but in XML/BLOB Format. …Abdulwahab-KFH 1.2K views 2 comments 0 points Most recent by Abdulwahab-KFH Reporting and Analytics for ERP
-
Disable online Output view for BIP reportsSummary: Disable online output view for BIP reports Content (required): We are trying to restrict the online view of outputs in BIP. We don't find any suitable report op…SayanDutta 41 views 2 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
How to make a dashboard prompt work with a custom logical sql?Summary: Hi I have created a custom logical sql, because I needed an outer join between two Subject Areas(Payables Invoices - Transactions Real time and Payables Payment…Anders W. Langholm 190 views 5 comments 0 points Most recent by Julia Looi Reporting and Analytics for ERP -
Access to Vertex Tax Error reports - not displaying in scheduled processesWe use Vertex for tax calculations and in the document referenced below, there is an error report that should be available via Scheduled Processes. I'm on the admin team… -
View Contract Authoring Party in OTBI?Summary: We are trying to see which contracts were created with an "external" authoring party or an "internal" authoring party, as well as which contracts had the contra…Jennifer Popowicz 41 views 0 comments 0 points Started by Jennifer Popowicz Reporting and Analytics for ERP -
Error Code : OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65PSummary: Hi All, I created a custom OTBI report. I have used two subject area : Subledger Accounting - Journal Real Time and Payables Invoices- Transaction Real Time The…
-
BI publisher custom notification needs to be consolidatedSummary: We have created BI publisher custom notification for expenses approval. When the person submits the reimbursement request, the mail will trigger for the manager…Jebarsan Thangam John Durai Raj 71 views 0 comments 0 points Started by Jebarsan Thangam John Durai Raj Expenses
-
Oracle Fusion - Process monitor - Process "NAME"Summary: Hi All, I am working on creating a report to have the list of job failed in a specific date range. I am able to get the required information from the ess_reques…
-
Setup dynamic column from analysis in subject line of email sent using AgentSummary: Setup dynamic column from analysis in subject line of email sent using Agent For ex: Email subject should include " Project Name: needs renewal" Any inputs on …Santhi Sree 101 views 11 comments 0 points Most recent by Santhi Sree Reporting and Analytics for ERP
-
Ability to create a Analysis report in OTBI from Manage External fileSummary: Hi How can we implement a process where a third party stores/sends/puts a file in a designated place, and we pull data from that file to create an OTBI report? …
-
Subject Area - Payables Invoices - Transactions Real Time - distribution amountSummary: Using Payables Invoices - Transactions Real Time, The Invoice Distribution is getting incorrect amount after adding Overridden account concatenated segments Col…JSalarza 91 views 1 comment 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
Missing data in some columns in FscmTopModelAM.FinExtractAM.GlBiccExtractAM.CodeCombinationExtractPVSummary: Hi We can see all our columns in our COA, but there is only data in segment1. What do we need to do in order to see more data? Content (required): Version (incl…Bo Tøpgaard 61 views 4 comments 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for ERP
-
Customize create accounting jobHi, We have more than 50 ledgers and would like to schedule a create accounting program for all the ledgers. Ledger is a mandatory field while submission of the program …
-
Developing of a Report to capture Requisition Approval HistorySummary: We require to capture the approval history of Requisitions. Such as who the requisition is currently pending approval, who has completed approval, the next appr…Janitha Perera 721 views 9 comments 0 points Most recent by Janitha Perera Reporting and Analytics for ERP
-
How to configure a company's logo for all standard reports?Summary: Hi all, Thank you in advance for your help and support. I am trying to configure the client company's logo on Oracle Cloud for all the standard reports. Is ther…Paul Younes 521 views 5 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
How to get Payment Id and Invoices related to a posted G/L batch?Summary: We need to get the payments and invoices related to a posted batch and prints it (the invoice) in a custom BIP Report Content (required): We're working on a cus…Claudio Errecart 124 views 0 comments 0 points Started by Claudio Errecart Reporting and Analytics for ERP
-
How to view attributes for a value within OTBI Subject Areas such as enabled flag, start date etc.Summary: Need to view attributes of a value such as enabled flag, start date, end date, allow posting, account type etc. Content (required): Our client wants to be able …Shiva K 131 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
User unable to create report in OTBISummary: User unable to create report in OTBI Content (required): Is there a request that must be submitted for users who have access to various subject area, but are un…CraigX 111 views 5 comments 0 points Most recent by Saurabh Poddar-Oracle Reporting and Analytics for ERP
-
find an approver from the setup tablesHi, We don't have any report or workflow to check the potential approver once Invoice adjustment is submitted by the user in Receivables Module. so I am trying to develo…Madhu A 41 views 1 comment 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
How the system of Oracle Cloud save de period close information?Summary: I want to know if the system save the information of earning or loss of each period. Content (required): In our other system when we create the statement of fin…Jessica Yamilet Valdes Romero 41 views 1 comment 0 points Most recent by Jessica Yamilet Valdes Romero Reporting and Analytics for ERP
-
Were Does The 'Generate Audit Report' Data Model reside in BI Publisher.Summary: Hi there, Were Does The 'Generate Audit Report' Data Model resides in BI Publisher ? Content (required): Does anyone know where the data model linked to the 'Ge…
-
OTBI Report Showing Budget Measures for All TasksHello, I am trying to create an OTBI report that shows the following Tasks for a project starting with the "Project Control - Budgets Real Time" but when I add the Budge…
-
RSUM Not working for running cost totalHi, I tried using the RSUM function to get a running total of the project actual costs (Actuals column). However, that function is not working as I expected in the last …Julia Looi 41 views 3 comments 0 points Most recent by Santa_B-Oracle Reporting and Analytics for ERP