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 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… -
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 …
-
How to get list of custom BI and OTBI Reports in FusionSummary How to get list of custom BI and OTBI Reports in FusionContent Hi, Do we have any standard ESS job or tables which can give us below details of custom report: Na…
-
Sample query for Project BudgetsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
FTP a FR studio report to run on monthly basis with previous month as parameterSummary FTP a FR studio report to run on monthly basis with previous month as parameterContent We have two custom FR Studio (Financial Reporting Studio) reports that we … -
What is Retention period for audit trail reportSummary: We wanted to know the retention period for audit trail report. Content (please ensure you mask any confidential information): Version (include the version you a…
-
I couldn't find the user entities that included the work structure dataSummary: I used HCM extract to extract person assignment and work structure data, but I couldn't find the user entities that included the work structure data (position,l…Salma Mohamed Salem 41 views 1 comment 0 points Most recent by Simona Chircu - Support Oracle-Oracle
-
OTBI Remove All Rows SummarySummary: Content (please ensure you mask any confidential information): When exporting an OTBI analysis in the format of xlsx, the last row is a merged and centered tota…
-
How to add Hyperlink in Footer of RTFSummary: Hi team, We have defined a lookup where we are storing links, from the data model we are fetching xml tags and using it in rtf to dynamically change link. when … -
Oracle Fusion Cloud Financials 24A patch scheduling detailsSummary: Please suggest on the scheduling of Oracle Fusion Cloud Financials 24A patch. Is it going to be applied in may along with 24B patch? Content (please ensure you …
-
How to remove Contract Template PDF Cover Page?Summary: How are we able to completely remove/delete the cover page on the contract template PDF page? We were able to remove the signature lines on the last page but ha… -
Moved: Trying to submit HCM extract but no run results appear.This discussion has been moved. -
Create Rules XML File for BI Extender Automation - NO LOVwhen i run Create Rules XML File for BI Extender Automation program, its not showing in any LOV in parameter, role is already assigned to user What could be reason ?
-
Privileges required to run AP Aging and AP Supplier Balance Aging reportSummary: Content (required): Hi, Can someone please let me know the privileges required to run AP Aging and AP Supplier Balance Aging report as soon as possible. Version…
-
Inventory valuation Report (As of Date) - DepericatedWe had Oracle delivered Inventory valuation Report which used to run by parameter as of date. We were using it extensively. Unfortunately Oracle has depreciated this rep…
-
FRS - Does RelativeMember Function work on Prompted AccountingPeriod?Summary FRS - Issue with period-to-period comparison on prompted valuesContent I am creating a Period-to-Period Financial comparison report, where Accounting Period need…
-
Moved: Need help for getting Average cost of an item column in OTBI Subject areaThis discussion has been moved.
-
Custom FolderSummary: We have created a folder named "Reports " - it is not in the custom folder - will this folder be preserved when doing an upgrade or do we need to put all custom…
-
WebService to Update a Legal Entity Address and Legal Entity RegistrationHello Everyone! I need a WebService that updates Legal Entity Registration. While researching I found a SOAP that updates Legal Entity, but it is not possible to update …
-
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 …
-
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…