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
-
Do we have any WebService to display the list of reports in Oracle Fusion ?Summary: Hi Team , Do we have any WebService to display the list of reports in Oracle Fusion ? ** i have used the table : GL_FRC_REPORTS_B , but its of not much use - as… -
How to add last_updated_by column in the report/data downloaded from "Submit Vacation Rules Report"How to add last_updated_by column in the report/data downloaded from "Submit Vacation Rules Report" in "Manage Workflow Rules in Spreadsheet". Please help to find standa…
-
How to create Job Set in Oracle fusionHello Cloud Expert We have requirement to create Job set which would consists of same job with different parameter . Basically We wanted to have job set for ESS job 'Cre…
-
OTBI project costing assets subject area filtering on in-service date results in no recordsI created an OTBI analysis using the project costing assets subject area. See fields in the screenshot below. The analysis returns correct results. However, when I filte…
-
Connect Oracle Database Actions to Oracle Fusion ERPSummary: Connect Oracle Database Actions (SQL Developer Web) to Oracle Fusion ERP Content (please ensure you mask any confidential information): Are we able to connect t…
-
can we get the amount/numaric value in words in Polish language for OTBI ReportsGenerally we uses the function iby_amount_in_words.get_amount_in_words to display the amount/numaric value in words in English language for OTBI Reports. I would like to…
-
FRS branch wise bifurcation for calculated fields like gross profit and percentageSummary: I am taking branch in rows. I need to display the gross profit data branch wise and percentage should also be calculated branch wise. Content (please ensure you…
-
Default person name using SQL query for DFFHi Team, We have a requirement to default the person name on DFF filed using SQL query. By default the DFF value should be the person name who is logged in currently. We…
-
How to add security on custom BIP folderSummary: We want to implement security to a custom BIP folder to give restrict access of some users to it. How can we do that? Is there something we can do in permission…
-
What are the standard Smart View reports available in Oracle ERP Cloud?Hi, What are the standard Smart View reports available in Oracle ERP Cloud? Such as for Cash Management we have the Cash Forecast and Cash Position Report which could be…
-
Which subject area can I use for procurement contract agreement deliverablesSummary: Which subject area can I use for procurement contract agreement deliverables? Content (please ensure you mask any confidential information): Version (include th…
-
Convert UTC timestamp data to Mountain Time using "Format Mask Feature" in Oracle Cloud BI ReportI am using below code in data model to convert UTC to MT in report output. But column looses formatting when exported in excel and used in Pivots. How to achieve the sam…
-
how to show alternate account GL combination in BIP report?Summary: User requirement to show alternate account GL combination but cannot find correct field. Content (please ensure you mask any confidential information): When vie…
-
CC wise expense report in OTBISummary: we have tried to create an OTBI report for the expense total with break down by Cost Center with GL but it not showing any break down sum we can get only total …
-
How to change the SQL Query Timeout value?Summary: How to change the SQL Query Timeout value? Content (please ensure you mask any confidential information): Version (include the version you are using, if applica…
-
We would like to understand the New Redwood features for Oracle FinancialsHi Team, Can someone please help us understand What are the new Redwood Oracle financial features? Is there any documentation or screenshots explaining the Finance upgra…
-
Ability to create OTBI analysis calling a APISummary: Ability to create OTBI analysis calling a API Content (please ensure you mask any confidential information): Is it possible to invoke a custom API from OTBI to …
-
SQL query to create list of values for past 24 monthsSummary: I've been searching and attempting to create a List of Values to be used in a Data Model for a report to make the parameter selection dynamic year over year ins… -
I'm new to BICC - any PVO advice?I hope this is the right community. I couldn't find one specific to BICC. My background is in integration platforms such as OIC and BizTalk, so working with the Fusion &… -
Extra space at the top of the page : RTF TemplateSummary: Having a strange issue with PDF generated form RTF Template. The RTF template has a header. The PDF output when generated has a blank space at the top of the he… -
Unable to see and run "Input Tax Gain and Loss Report for Singapore"As per suggestion given on "https://docs.oracle.com/en/cloud/saas/financials/25b/ocuar/input-and-output-tax-gain-loss-reports-for-singapore.html#Frequently-Asked-Questio… -
Connect to PaaS db from BIP to create report from custom tables created in PaaSSummary: Connect to PaaS db from BIP to create report from custom tables created in PaaS Content (please ensure you mask any confidential information): We have a require…
-
User Login History of ERPCan someone help me with any seeded report that will give me the last date/time that each Oracle user has signed into ERP like we have for EPM -
How to delete page entry which are created using structure toolSummary: How to delete page entry which are created using structure tool Content (please ensure you mask any confidential information): Hi All, We created page entry(Rep…
-
Report that can extract information about the user's active tasksIs there a report that can extract information about the user's active tasks, which are displayed in the task area of each module? A report on the privileges assigned to…
-
What tables stores fixed choice list dependency created using application composerSummary: A custom application was created using Application Composer. A fixed choice list field was set up to depend on another fixed choice list. However, the selected …
-
Is there something similar to srw.abort_program in Fusion ERP bip reportIn Oracle report writer one could abort the report using SRW.ABORT_PROGRAM Built in. Is there similar built in in FUSION ERP BIP Report? -
Date filter in rtf templateSummary: Hi All, Good Day! The template is in RTF . need to see the output in excel. Can anyone help on this ! Content (please ensure you mask any confidential informati…
-
Can anyone please share OTBI dashboards for procurement?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to pass system date in subject line of email notification when scheduling an Ess jobSummary: I am scheduling ESS job set, our requirement is to print system date in email notification subject line and attachment name. How to configure dynamic date (Sysd…