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
-
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 937 views 2 comments 1 point Most recent by Sankeerthana Anumasula-Oracle
-
Access to Fusion Accounting Hub Reporting Cloud Service ( FAHRCS).Content Hi all, Please clarify whether the "General Accountant" role has access to Fusion Accounting Hub Reporting Cloud Service ( FAHRCS). Best Regards, Vipusha
-
Account Segment Group ObjectsContent Our team is looking to group together certain accounting segments for use in some of their reporting and imports. They currently have specific payroll object gro… -
Highlight duplicate values based on a value in another columnContent Could somebody help me with the following issue, please: In an OTBI report with data from the Enterprise Contracts module, I would like to highlight (eg. with co…
-
FscmTopModelAM.FinExtractAM.GlBiccExtractAM.BalanceExtractPVO does not contain creation_date, why?Summary Why does FscmTopModelAM.FinExtractAM.GlBiccExtractAM.BalanceExtractPVO not include creation_date column?Content Why is creation_date missing from BICC Balance Ex…User_2025-03-07-18-57-57-349 879 views 0 comments 1 point Most recent by User_2025-03-07-18-57-57-349
-
Newly created Financial Categories do not show in BI report list of valuesContent I'm looking to pull in 3 new Financial Categories into a BI report I created. I've created the lookup codes under GL and attached the categories to the account s…
-
Which BICC PVO should be used to extract Supplier/Vendor 'Name' to match to BICC Invoice Headers extContent Which BICC PVO should be used to extract Supplier/Vendor 'Name' to match to BICC Invoice Headers extract PVO? Version 21_B
-
ExternalReportWSSService sample payload to pass template nameSummary ExternalReportWSSService sample payload to pass template nameContent Hi, Can we pass report template name to ExternalReportWSSService SOAP service which triggers…
-
OTBI Report for element entriesContent Hello Guys, I need to create an OTBI report for element entries, but when i try to creare the analysis the system show me the following error: No Results The spe… -
Change ESS Job Description while submitting it from BIPSummary Change ESS Job Description while submitting it from BIPContent In Cloud, we can submit the ESS Job from BIP using "ESS_RUNTIME.set_submit_args" procedure. Is the… -
OTBI Analysis: Using TIMESTAMPADD to derive last day of the month based on Period Name in Subject ArContent Hello There, I have an OTBI analysis for Subject Area: "General Ledger - Balances Real Time". The analysis has a column "Time"."Accounting Period Name" OR "Time"…
-
Report results pull in journals 1 hour prior to parametersSummary User selects date greater than 3/10/2021 at 12PM, yet the report results is pulling in journals with a timestamp 1 hour prior to set parameterContent User select…
-
Need to report all journals and subledger activity (drilled data) on one reportSummary Currect reproting only allows reporting by one source at a time, need to see all for one account in single reprot.Version Fusion Cloud 20D -
How to write a condition in Delimiter etext templateSummary How to write a condition in Delimiter etext templateContent Hello All, We are creating an etext template for the wire payments(Seeded Disbursement Payment Report… -
Customize Print Receivables Transaction for all Invoice TypesSummary Customize Print Receivables Transaction for all Invoice TypesContent Hello, Oracle has provided 4 different templates for 4 Invoice Types: Invoice, Debit Memo, C…
-
How to track the BI publisher report which calling the specific table and attributeContent Hi, How to track the BI publisher report that calling the specific table (eg.POZ_BUS_CLASSIFICATIONS) and attribute. Thanks, Felicia
-
in gl, how i get parent of account ?Content in gl i need to get parent of account segment , how i do this ? in table gl_seg_val_hier_rf i don't have data .
-
Bursting A Report With SubTemplatesSummary How to burst a report using a sub template.Content Hi Experts, We have a custom report which uses a sub-template. The report also uses bursting to email. But the… -
saas fusion data retention polity - access to transactional dataSummary what is the period users are able to access transactional data (10 yrs?)Content For Fusion financials, users would like to be able to access transactional data f…
-
Project Actual Costs - Account CodeSummary Project Actual Costs - Account CodeContent We are creating a report using the Project Costing - Actual Costs Real Time subject area. We are pulling cost distribu…
-
LicensingSummary Oracle Database Cloud Multitenant Service - S5 & Oracle Java Cloud Service - SaaS Extension - S1Content Does anyone know what these 2 products are for? Oracle Da…