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 custom folder security in production VS test environmentsSummary How are you managing your OTBI custom folder security from Production to Test when different?Content I our current environment we have several self service users… -
Impersonation auditingContent Hi, I want to know if it is possible to know what a user did on behalf of another (as a proxy) I read that document about impersonation auditing and did the conf… -
TIMESTAMPADD function in OTBI reporting in UTC and not ESTContent We are using the below function to fetch the data for the previous month in OTBI Reporting & noticed it extracting the data based on UTC time zone and not EST. I…
-
Joining between database SQL and Excel Data Sources in the Data ModelContent Hi, I hope someone can help me out here. We have created a report where we have defined a data model with a join between an SQL data set and an Excel (xlsx) data…
-
Etext negative number paddingSummary Etext negative number paddingContent Hi All. We have a requirement to dispay a number like -123 as -00012300. Please suggest how this is possible in Etext templa…
-
COA Segment Values based on Security RulesSummary COA Segment Values based on Security RulesContent We have a requirement to get the Individual COA Segment Values based on the security rules defined for the Role… -
BICC - Selecting Columns from Data Stores Impacts other reportsSummary How to configure BICC reportsContent We are currently working on our migration to Oracle Fusion. I am tasked with looking at extracting data via BICC. How can I …User_2025-02-11-01-36-32-048 203 views 1 comment 2 points Most recent by User_2025-02-11-01-36-32-048 -
in ar i need to get sum lines , sum discount ,sum taxes for each invoice and for each lineContent in ar i need to get sum lines , sum discount ,sum taxes for each invoice and for each line.
-
in gl how i get balance for each account(ptd,qtd and ytd)Content i need to get balance for each account (ptd,qtd and ytd). also i need to get balance for each account and cost center (ptd,qtd and ytd).
-
Number of Accounting Periods in Accounts Receivable for OTBI ReportingContent We have a thirteen period calendar setup in Oracle, each period is four weeks. When we attempt to write OTBI reports we are only seeing 12 periods. My question i…
-
Unsuccessful Login Audit Report & Sign-on Responsibilities Audit ReportSummary Oracle Fusion does have a seeded report/ Bi-report for audit purposes.Content Hi All, We would like to know if there is a fusion seeded report that can give belo…
-
Export Query to Excel Timing OutSummary Exports Timing OutContent We are using firefox for our browser, the export works (from AR, AP or GL) for awhile and then we get a message - a connection to the s…
-
OTBI report to fetch Absence types and related absence plans with approval status, used balance, carSummary OTBI report to fetch Absence types and related absence plans with approval status, used balance, carryover, accruals.Content Hi All, We have an OTBI requirement …User_2025-02-10-16-28-01-402 99 views 0 comments 2 points Most recent by User_2025-02-10-16-28-01-402
-
Config Snapshot - AHCS and Core Fusion SetupsSummary Documentation for Config Snapshot in Oracle CloudContent Hello Team, Please provide a detailed document for Config Snapshot in Oracle Cloud. Also does it cater f…
-
Oracle Docs Links not working error: From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1:Summary When trying to access oracle docs links on Help Centre the links to the docs produce an error and cannot directly accessContent We have just recently identified … -
Need a SQL Query For Segment Value Data SecurityContent Hi there Building a report that show the charts of account data security condition and value. Please advise. Thanks.
-
Is there a way for the values in the page prompt to be displayed as the tab name on excel when its dSummary Need to have the tab label name in Excel output with the value on the prompt for FRS ReportContent Is there a way for the values in the page prompt to be display…
-
Account Analysis Report too large to downloadSummary Account Analysis Report too large to downloadContent Delivered Account Analysis Report was timing out. We extended timeout period, but now are unable to download…
-
OTBI Analysis exceeded the Maximum query governing execution timeSummary When users run a OTBI analysis gets the error exceeded the Maximum query governing execution time - what is the time limitContent I have a user that is running a…
-
Terminate an employee for NON-HCM Customers to redirect approvals in Fusion FinancialsSummary Terminate an employee for NON-HCM Customers to redirect approvals in Fusion FinancialsContent We have implemented Fusion Financials and we don't want HCM Cloud S…
-
Code migration tool -Automation of BIP report MigrationSummary Any code migration tool which can migrate BIP report from one instance to other automatically without manual intervention
-
Audit Report for FranceSummary Does Anyone use Audit Report for FranceContent We are trying to use the provided Audit Report for France and we are running into issues. Did anyone use this repo… -
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…
-
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…
-
Defaulting current month on reportsSummary A request has been made by our users to default the current month/date on report.Content Our issue is that the users have to hunt for the current period on a lis…
-
who open report ?Content after xreated report , i need to know who(user) open report ? and time ?
-
OTBI Administrations security manage privileges changes impact of upgradesSummary Are changes to OTBI Administrations security manage privileges need to be reapplied after upgradesContent We would like to make some additional features of OTBI …
-
BIP report needs to pick transactoions from the last successful runSummary BIP report needs to pick transactoions from the last successful runContent All, How to incorporate logic for a BIP report which needs to pick transactions from t…
-
ADFDI - Is there a list of all the templates available in ERP Cloud?Content Hello, I am looking for a list of all the ADFDI available in 20D. I tried looking in Oracle support and on the documentation, but perhaps you know where I could …
-
ESS Monitor: Cancelling a scheduled daily processSummary I'm trying to cancel a scheduled daily process, that day gets cancelled, but it keeps all other scheduled daysContent I'm trying to cancel a scheduled daily proc…