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
-
General journals - transaction IDSummary: Hi all - within OTBI is anyone able to let me know where I can find a transaction ID or a global GL transaction number or similar? I'm trying to add it into an … -
Discard the email addresses of all customers in our lower test instance in ARSummary: We are currently seeking a solution to discard the email addresses of all customers in our lower test instance. The objective is to prevent any email triggers d… -
Moved: OTBI “General Ledger - Journals Real Time” which fields are these in the journal load FBDI t…This discussion has been moved. -
How to link Account Receivables (AR) module with Costing to get item cost for an invoice lineSummary: Hello Which table should I use/link with 'RA_CUSTOMER_TRX_LINES_ALL' to get the cost price of an invoice line in AR? Content (please ensure you mask any confide… -
formatting currency through DM or RTF?Summary: when customizing a DM and RTF, I need to format the currency into $****,****.XX format. Content (please ensure you mask any confidential information): Should I … -
OTBI reports: The currency symbol always defaults to dollar $ symbolSummary: We have always used 'User's Preferred Currency' for the Currency symbol under 'Data Formatting' in OTBI reports. We are rolling out reports to EMEA and APAC use…
-
Iam trying to customize the existing standard Supplier Balance Aging ReportIam trying to customize the existing standard Supplier Balance Aging Report where i want to same and export sample data by inputting parameters against the same data mod…
-
Excel output with Multiple sheets with hyperlink for cross-sheet reference BI Publisher ReportSummary: Hi , I have a specific query regarding the feasibility of a dynamic feature: Is it possible to enable a function in BIP's RTF/Excel template where, upon clickin…
-
Transactions coming from external systemsHi We are defining lets say a tax rate 20% and not mentioning whether its inclusive or exclusive at the setup level. If transactions are coming from interfaces, is their…
-
Need to convert string into hash valueHi, I need to convert 'AKEBSTEST-700(2.1)' string into hash value i.e '561956564' using sql or Plsql. Is any function we can use to convert this value.
-
Oracle Analytics Cloud (OACS) Training for a BeginnerSummary: Oracle Analytics Cloud Training for a Beginner Content (please ensure you mask any confidential information): Hello, Can anyone recommend training or resources … -
Can we triggle process in OTBI dashboard?Summary: Can we triggle process in OTBI dashboard? Content (please ensure you mask any confidential information): For example, can we triggle "Create Accounting" process…
-
Internal Auditor Role License ImpactSummary: What are the license impacts of using the Internal Auditor Role? Will the license impact be affected by the product being audited? Content (please ensure you ma…
-
Image in BI Publisher template spills into attachment when sent to e-mail outputSummary: Image in BI Publisher template spills into attachment when sent to e-mail output Content (please ensure you mask any confidential information): In BI Publisher …
-
Error generating view. Error getting cursor in GenerateHeadSummary: We are stuck with this error: I have executed these processes: Publish Chart of Account Dimension Members and Hierarchies to Balances Cubes Create Rules XML Fil…
-
It is possible to include the CX module in the OTBI?Summary: It is possible to include the CX Module in the OTBI even if CX have a separate UI from the Oracle? Content (please ensure you mask any confidential information)… -
Can we hide the OTBI Seeded Folder list in the shared folder?Summary: Is it possible to hide the OTBI seeded folder list in the shared folder and will just only show the custom folder? Content (please ensure you mask any confident…
-
Hide the OTBI Seeded Folder in the shared folderSummary: Is it possible to hide the OTBI seeded folder in the shared folder and will just only show the custom folder? Content (please ensure you mask any confidential i…
-
Visual builder redwood for ERP-FIN-SCMD modules. Any news?Summary: Please, ERP-FIN-SCM team, is there any plan to migrate any screen from ADF to Visual Builder Redwood? I mean suppliers/customers/invoices/journals, etc. Thanks …
-
Moved: SQL query to get the Item Category HierarchyThis discussion has been moved. -
Privilege required to only view Finance workflows in 'Transaction Console'Summary: Hi All, Could you please let me know what would be the privilege or role required to ONLY view Finance related workflows through Transaction Console. We know th…
-
Customize Printable Expense ReportSummary & Content: Need details for the other VOs and the attribute list similar to what was provided for PrintableReportVO and PrintableExpenseVO in the Oracle Ddocumen… -
Is there a size limit to extract data from Fusion ERP?Summary: We will extract data out from Fusion ERP using BIP, BICC to Data warehouse. Is there a data limit? Will Oracle charge for outbound (egress) traffic? Content (pl…
-
Project Control - Budgets Real TimeUsing Project Control - Budgets Real Time subject area need to showcase Budget Cost in Project currency as well as in Ledger currency but unable to identify the dimensio…
-
Generate file name at runtime with respect to parametersSummary: I want to get Report's output where i want to generate name of output report with respect to User Input Parameters against the same Bi Publisher rtf Report. Con…
-
Oracle Social Network Cloud Service (OSN)Summary: Oracle Social Network Cloud Service (OSN) Content (please ensure you mask any confidential information): With oracle retire the Oracle Social Network Cloud Serv…
-
How can we add a widget or train stop custom on ERP page?Summary: Our client would like to have a widget or train stop feature on the ERP Customers page or other ERP pages. Is it possible in ERP and if there is a manual or ste…
-
OTBI GL Subject Area: 'General Ledger - Journals Real Time' unable to find the 'Approval Date'Summary: Hi All, While developing OTBI report for General Ledgers, We are unable to see the 'Approval Date' for the journal in 'General Ledger - Journals Real Time'. Kin…
-
Options to Cancel Long Running ESS jobsSummary: Export Data to Excel ESS job ran for more than 50 hrs. We are exploring option to kill long running jobs after X hours at server level instead of each ESS job. …
-
What is the best way to prepare a consolidated Trial Balance of two business Units?Summary: What is the best way to prepare a consolidated Trial Balance of two business Units? Content (please ensure you mask any confidential information): There are man…