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
-
BICC Extract job timestamp used to extract data when there is a failureSummary What extract timestamp is used for each incremental job after a failureContent When there is a failure in BICC incremental job which timestamp is used to start t… -
Count of attribute column in Learning Real TimeContent Hi there I want to have a count of an attribute column in Learning Real Time. For instance, I have a table with the names of the users and a course name. I want … -
Is is possible to merge Business Units in FusionContent Hi, We have a situation where there are almost 20 Business Units for one Legal Entity. This is posing problems like allowing duplicate invoices across BUs but al… -
OTBI Issue - Costing - Receipt Accounting Real TimeSummary OTBI Receipt Accounting -- Concatenated SegmentsContent Hi All, Appreciate your inputs or suggestions on the below issue. OTBI Report having timeout issue Subjec… -
in OTBI I need to send email or notificationContent I created an analysis for suppliers , I want to sent the output by email or sent tontification . if an analysis has a parameter so whatis the solution ?
-
Release 21BSummary xsl template for ACHContent Hi All, Did anyone worked on the Payables payment process with ACH template with xsl type in 21b.? need inputs on how to develop ACH …
-
Need a query to get total of Current Cost, Accumulated Depreciation, Impairment for asset categoriesContent Hi all, Can someone give me a query that gives a total of : * Current Cost * Accumulated Depreciation * Impairment per asset categories in Fixed Assets Module. R… -
What is the best way to identify whether the current Fusion instance is PROD or Non-PRODSummary What is the best way to identify whether the current Fusion instance is PROD or Non-PRODContent As we need to transfer BIP Reports to different FTP file servers … -
Subledger Details resulting in Duplicate LinesContent I've created a subledger with details, but am noticing the lines are duplicating for my results. I've built the results in a normal table format as well in a piv…
-
create data model using web serviceContent i need an example for creating data model using web service i need to create a report using data model using web service , how i create a data model and report ?…
-
Make a REST call from an ESS Job - Ideas needed!Summary Make a REST call from an ESS Job - Ideas needed!Content Hi Guys, Is there an option to call a REST service from an ESS Job? Please share your inputs. Thanks, Abh… -
New ideas for this month - Working Group on Audit, Security, and Compliance issuesContent We have a group of over 100 companies that meet on a regular basis to identify and review Ideas relevant to Audit, Security, and Compliance. We are tracking over… -
How to implement Segment Value Data Security in BI Publisher ReportContent Hi All, Can someone provide insights on how to implement implement Segment Value Data Security (SVS) in BI Publisher Report. We have a requirement to create BIP …
-
OTBI Subledger Journals subject areaSummary OTBI Subledger Journals subject areaContent Hi, In OTBI Subledger Journals Subject area, We have a date supporting references in the format YYYY/MM/DD. Since sup…
-
Location of the Standard Account Analysis ReportContent Hi all, Are there any direct way to find the location of the standard report ( Account Analysis Report ) in the report and analytics section. Current it shows ma…
-
Why can't I see the information for flexfields from subject areas in Results tab?Content Hi, We have Oracle Business Intelligence 11.1.1.9 and Oracle Cloud Application 21B (11.13.21.04.0) We are development an Analysis using Receivables - Bills recei… -
How can I get to the person number from the workflow tables?Summary We need to report out the comments on terminated employees and while I can get to the comments there is no separate column for person number to get to the other …
-
Inactive User Account shows as 'Active' and 'Suspended' on all HCM ReportsSummary Inactive User Account shows as 'Active' and 'Suspended' on all HCM ReportsContent Hi, I have business requirement to inactivate a person user account, but not re…
-
OTBI Catalogs for Primary Statements (Balance Sheet, Cash Flow, Income Statement)Summary OTBI Catalogs for Primary Statements (Balance Sheet, Cash Flow, Income Statement)Content Hi Is there standard catalog files available for primary statements whic… -
From To Accounting period condition in OTBISummary From To Accounting period condition in OTBIContent Hi all, Is it possible to keep 'From' and 'To' Accounting period as input prompts in PTBI GL/Subledger subject…
-
Add new permission to existing custom folder in BI CataglogSummary Error when adding new permission to existing custom folder in the BI catalogContent 'Assertion failure: !tAccountId.isEmpty() at line 282 of project/websecurity/…
-
Delivered Balance Sheet ReportsSummary Is there a delivered Balance Sheet ReportContent Is there a delivered Balance Sheet Report in Oracle Cloud ERP? Version 21A
-
Analysis BI displays duplicate values in parametersContent This problem appeared on May 5th and disappeared with update 21B. All Analysis BI in our production instance showed the same behavior. We validated that the anal…
-
Group Filter not working in Custom ReportContent We have developed a custom Report. The Data Model is a master detail query includes a main query and three child queries Q_1 - Main Q_2, Q_3, Q_4 are child queri…
-
Subject Area Real timeSummary Hi Team, Could you please help understanding what is a "real time" that is always are added with a Subject AreaContent Hi Team, Could you please help understandi…
-
define dff attribute10 in ar invoice header (appear on otbi analysis)Content i want to craete otbi analysis on ar transaction , and i define attribute10 on invoice header. i need to get this colum on analysis but i can't find it . how i g…
-
Restrict users from sending reports to external email addressesContent Hi, As we know, Oracle allows to include the email address when adding a Destination for a report output in both OTBI and BIP reports. Is there a way to restrict… -
If we need to run a report or a query on all the profile options currently set for our client in FusSummary If we need to run a report or a query on all the profile options currently set for our client in Fusion, is there any way?Version 21A
-
How To Handle "&" (ampersand) symbol extracted from data using Etext templateContent We have "&" symbol used in Supplier names. Ex: ABC & Co. Oracle seeded report would generate xml data with as below: ABC & Co We are using eText template to disp…
-
Query to fetch sum of debit memos and credit memos for an original invoiceSummary Am looking for a query to get sum of credit memos linked to original invoice ie Original invoice -HCS1 Credit memo-HCS2 as shown in below screenshots.Content I w…Sankeerthana Anumasula-Oracle 941 views 2 comments 1 point Most recent by Sankeerthana Anumasula-Oracle