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 Complete List of Subject areas and ESS Jobs to populate with dataSummary Does someone have a complete list of OTBI subject areas that require ESS jobs needed to populated the dataContent These are the only Subject areas that I am awar… -
Transaction Query exampleSummary example of a GL Transaction query flexible to a range of parametersContent Seeking an Oracle Cloud example of a GL transaction query that returns line item detai… -
Newsfeed vs Banner vs PanelSummary Default Home Page Layout OptionsContent Is there a recommended option for Default Home Page Layout? Are there benefits of going with one over the other? Looking … -
Infolet Dashboard to be Printed as a Page for Management ReportingSummary Infolet Dashboard to be Printed as a Page for Management ReportingContent We have built Risk Management Infolet section and Client wants to download this as a re… -
Project Invoice DistributionSummary Project Invoice DistributionContent Hello All, I want to know from which table we can get below information:- -
Need query to get Punchout item detailsSummary Need query to get Punchout item detailsContent Hi Experts, We have a requirement to get punchout item details in existing PO PDF report, Can you please provide m… -
Segment Value Security for Chart of Accounts in Custom BI Publisher reportSummary Enable Segment Value Security for Chart of Accounts in Custom BI Publisher report in bulk modeContent We have a requirement to enable Segment Values Security for…
-
ESS Job monitoring Dashboard or Report- Best PracticesSummary ESS Job monitoring Dashboard or ReportContent Hi All, We have 600~1000 ESS job runs every day, as operation support we need to set up the best way to get them mo… -
1099 Data ReportContent Are you reporting 1099 data based on accounting date or payment date?
-
Missing account coding data for Invoices in Workflow tables in PRODContent Hello, We have a custom BI report that tracks the Account coding details for AP Invoices. We are using the workflow tables to get these details. Per my understan… -
BIP Report Error with XDOException: java.sql.SQLSyntaxErrorException: ORA-01722: invalid numberSummary As soon as report is submitted it throws XDOException: java.sql.SQLSyntaxErrorException: ORA-01722: invalid numberCode Snippet WITH tax_cal_datesAS (SELECT (SELE…
-
OTBI usage tracking in 21ASummary OTBI usage tracking in 21AContent In this new subject area below, will that only track usage within the CRM subject areas or will that track report usage in the … -
Query or report to show B2B Communication details for each supplier siteSummary Query or report to show B2B Communication details for each supplier siteContent Is there a query/analysis/report/data model, etc. available in OTBI to show which…
-
SOAP request for BI Publisher report works for Test pod but not for Production podSummary SOAP request for BI Publisher report works for Test pod but not for Production podContent I am running BIP report by using SOAP request. the problem is that it w… -
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…
-
BI Publisher report with cashing multi-million records query and staggered upload to FTPSummary BIP Maximum Rows for CSV output limit is 2 million. need elegant solution to query database only once for bigger record count and then have staggered upload of r… -
Report on Invoice coding approval flowContent Hi, Is there any seeded OTBI report for invoice coding approval flow. If not can you please help with the SQL query to view using BI publisher Thanks -
A company wants to sell part of its businessSummary Typical Organization planning for De-MergerContent There is a Company A, who is on oracle Cloud and now it wants to split the business into two parts i.e. Compan…
-
How do I find the OTBI Analysis behind a standard Infolet for Project ManagementContent Hi, My understanding (from other posts on this forum) is that I should be able to find the path to a standard Infolet by activating a Sandpit in Page Composer mo…
-
Need number of asset transfers and modifications in 2020Content Hi, I need to find the total number of asset transfers and modifications made in 2020. Is there a BIP query that can return this information please? regards Nige… -
BIP Deeplink in report to view Purchase OrderContent Has anyone added a deeplink in a BIP report to view a PO? Please could you share.
-
Is there a way to specify the e-mail destination when running a job from REST to BI Publisher?Content Hi, I am looking for a REST to specify the e-mail destination when running a job from BI Publisher? Is there some document or samples can refer to? Thank you so …
-
Schedule Job Manager in OTBI to export the report output to Object Storage (OCI)Content Is there a way to export an OTBI BI publisher report to object storage (OCI) as part of a Job Manager scheduled job? -
Substring Function in FRSContent Is it possible to use a Substring function in FRS reports? We have a requirement to Substring the Cost Centre values on one of our reports so I was just wonderin…
-
SQL Select Query to Oracle SaaS TablesSummary Aside from OTBI, BIP or BI Analysis - is there another way to query-select SaaS Tables? Like an Oracle-provided Tool or 3rd Party ApplicationContent Hello, Aside… -
Table name of Remit to AddressContent Hi, When I look for remit to address for a country I get the details populated as in screenshot please let me know the underlying table name associated. Thanks
-
Change Excel Sheet name in BI Publisher TemplateContent Hello, Is it possible to rename the Excel Sheet names of a BI Publisher Template Report [Type xpt] which has default output format as Excel (xlsx) ? I have creat…
-
Updating non-logical OTBI to Logical SQL OTBI without rebuilding?Summary Updating non-logical OTBI to Logical SQL OTBI without rebuilding the original OTBI?Content I need to update an existing OTBI (non-Logical SQL) to use Logical SQL…
-
Fixed Assets- Asset Balance Real Time and GL SegmentsSummary In OTBI Fixed Asset subject don't have the GL Segments - just concatenatedContent I need to build reporting on fixed assets around the different segments in the …
-
ERP – Oracle Digital Assistant: Investment Strategy Update, 03 February 2021, 9 a.m. PT - Submit QuContent Submit your questions for the ERP – Oracle Digital Assistant: Investment Strategy Update session to have them answered during the live event. Post your questions…