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
-
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 … -
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 … -
Moved: OTBI “General Ledger - Journals Real Time” which fields are these in the journal load FBDI t…This discussion has been moved. -
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 … -
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.
-
Need Custom Advance Shipment Report fileSummary Need Custom Advance Shipment Report Sample fileContent Need Custom Advance Shipment Report file -
Read Only AccessContent Hi, How to provide read only access to Analysis Report to end users. Please advise Thanks -
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…
-
Query To Find Label Name For Each Node ValueSummary: Dear All, I need a Query to extract Label Name for each Node Value. Content (please ensure you mask any confidential information): Dear All, I need a Query to e… -
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…
-
Do we have BICC PVOs for ERP’s Audit logs?The client has enabled Audit in the ERP Cloud as per regulatory requirement. I would like to understand if we got these audit logs in PVO's for BICC extraction. Can you …
-
how to calculate BEG_BALANCE_CR for QTD in glSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Oracle Fusion - User and roles last used detail reportWe are using Oracle Fusion release 23B, would like to know any seeded report available to get the user, role and last role used detail. Basically user, role and last rol…
-
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… -
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)…
-
Deep Link to navigate to CHANGE REQUEST,PROPOSAL or CONCEPT using OTBIHI All, We could see the deep link doesn't work for CHANGE REQUEST, PROPOSAL ,CONCEPT and REQUIREMENTS. If I try to use OTBI dashboard a blank page opens up. However, wh… -
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. …
-
ESS Job monitoring Dashboard or Report- Best PracticesSummary ESS Job monitoring Dashboard or ReportContent Hi All, We have 600~1000 ESS job runs every day, as operation support we need to set up the best way to get them mo… -
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…
-
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…
-
Dashboard or report to show all changes/updates to reports/data models for auditingSummary Hi we need a report that will show if any bi reports or data models for BI have been updated in the last 90 days for audit purposes?
-
Moved: SQL query to get the Item Category HierarchyThis discussion has been moved. -
SQL query to get transaction date on statement lin, joining CE_BAT_TRANSFERS with CE_STATEMENT_LINESI'm trying to create a query where I want to find the transaction date of an Internal Bank Transfer. The goal is to create a report which is used for reconciliation of b… -
How can we merge multiple OTBI report lines into one lineWe are building one report which contains project wise team member details. As per the requirement, we should have one line in the report for each project displaying eac…
-
Can I change bip:AUTHOR on a saved BI report?Summary: Is it possible to change the bip:AUTHOR value on a saved BI report? Content (required): I want to make some reports public that I've exported to a .CATALOG file…
-
ERP Cloud -- Add digital signature to AR invoice PDFOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): DHL Supplychain Limited Description (…
-
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…
-
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…
-
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…
-
Need OTBI to bring the newest site only (Latest creation DateSummary: I created an OTBI report for Supplier and Supplier Sites. I need to enhance the report to bring only one site for 1099 purpuses. The site needs to be the one wh…