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
-
LedgerSummary All transaction detailContent Hi experts, I need a report of all single detail of all transactions. Is there any report at "Scheduled Process"? Muhammad Amir Ver… -
New ideas for this month - Working Group on Audit, Security, and Compliance issuesContent We have a group of over 100 companies that meet on a regular basis to identify and review Ideas relevant to Audit, Security, and Compliance. We are tracking over… -
BI Publisher domain whitelisting - creating exceptions to send out supplier communications?Content We've created a whitelist of Allowed Email Recipient Domains for BI Publisher which is working well for restricting communications and enforcing our Data Loss Pr… -
Run BI Publisher reports from excel ( Oracle ERP Cloud SAAS )Summary Run BI Publisher reports from excel ( Oracle ERP Cloud SAAS )Content Is it possible to run BI Publisher reports from excel ( Oracle ERP Cloud SAAS ) ? if so then… -
How to implement Segment Value Data Security in BI Publisher ReportContent Hi All, Can someone provide insights on how to implement implement Segment Value Data Security (SVS) in BI Publisher Report. We have a requirement to create BIP … -
OTBI Subledger Journals subject areaSummary OTBI Subledger Journals subject areaContent Hi, In OTBI Subledger Journals Subject area, We have a date supporting references in the format YYYY/MM/DD. Since sup…
-
AR Docket generation - optionsSummary Business is looking to generate an AR Docket - from Oracle fusion - what options, extensions, enhancements are available for the sameContent Business is looking … -
Location of the Standard Account Analysis ReportContent Hi all, Are there any direct way to find the location of the standard report ( Account Analysis Report ) in the report and analytics section. Current it shows ma…
-
Oracle Cloud Planning Dashboard 2.0 - Waterfall chart and loading timeContent Hi everyone I am trying to build a dashboard by using Dashboard 2.0 function and having an issue here, wondering whether you have had same issue and how to solve…
-
Anyone has AR aging report logic for calculating aging as of a date. We would like to build an AR AgContent Anyone has AR aging report logic for calculating aging as of a date. We would like to build an AR Aging report from scratch but lot of logic is hidden in stored … -
Why can't I see the information for flexfields from subject areas in Results tab?Content Hi, We have Oracle Business Intelligence 11.1.1.9 and Oracle Cloud Application 21B (11.13.21.04.0) We are development an Analysis using Receivables - Bills recei… -
Need a query to derive current cost, Netbook value in Oracle Fusion Fixed assets module with the peContent Hello all, I need a query that gives me the current cost and the netbook value for a specific asset within a period range. Need a parameter too to run the query.… -
How can I get to the person number from the workflow tables?Summary We need to report out the comments on terminated employees and while I can get to the comments there is no separate column for person number to get to the other …
-
Required-Oracle Fusion financials workshop PPT documentsSummary Required-Oracle Fusion financials workshop PPT documentsContent Required-Oracle Fusion financials workshop PPT documents -
How to give an access to specific users to custom ess jobSummary How to give an access to specific users to custom ess jobContent Hello All, We have one custom report and we have created a ess job to it and now wats to give an… -
Inactive User Account shows as 'Active' and 'Suspended' on all HCM ReportsSummary Inactive User Account shows as 'Active' and 'Suspended' on all HCM ReportsContent Hi, I have business requirement to inactivate a person user account, but not re…
-
Join between FA_FUSION_SOAINFRA.WFCOMMENTS and FA_FUSION_SOAINFRA.WFTASKHISTORYContent Hi, We are trying to find comments on actions taken by approvers on expense report. We found these 2 tables : FA_FUSION_SOAINFRA.WFCOMMENTS and FA_FUSION_SOAINFR… -
OTBI Payables Invoices to Subledger joinContent We have a requirement to display Payables Invoices data (Payables Invoices Transactions Real Time) and their corresponding Subledger entries & other Subledger sp… -
AFLOGSummary Value Changing AuditContent Hello everyone, In regards to this process, How To Enable Finest AFLOG Level (Doc ID 2525522.1), is there a business event or other f… -
BI Parameter IssueSummary ORA-01795: maximum number of expressions in a list is 1000Content I have a BI Publisher report with a parameter that gets its list of values from a sql query. If…
-
Receiving - Purchase Receipts Real Time returns no data for ReceiptContent Hi, We have a requirement to create a report that provides details for Receipts. I'm trying to build the report using the Receiving - Purchase Receipts Real Time…
-
What Role/Privilege grants access to edit Scheduled Agent "RUN AS" in OTBI?Content Does anyone know what Role/Privilege allows access to update the "Run As" field in a Scheduled Agent for an Analysis in OTBI? I've assigned the following to a te… -
BIP Schedule Skip or Resume after Oracle DowntimeSummary BIP Schedule Skip or Resume after Oracle DowntimeContent Hello, Whenever Oracle SaaS is down due to patching or release upgrades, does it pause all the BIP Sched… -
OTBI Catalogs for Primary Statements (Balance Sheet, Cash Flow, Income Statement)Summary OTBI Catalogs for Primary Statements (Balance Sheet, Cash Flow, Income Statement)Content Hi Is there standard catalog files available for primary statements whic… -
Fixed value in Value set querySummary Fixed value in Value set queryContent we have defined the value set and validation type is Table we have written condition to pick email ID from PER_EMAIL_ADDRES…
-
From To Accounting period condition in OTBISummary From To Accounting period condition in OTBIContent Hi all, Is it possible to keep 'From' and 'To' Accounting period as input prompts in PTBI GL/Subledger subject…
-
Manage Data AccessSummary Data Access controlContent We need to control users accessing all available business unit and it should be limited to a specific business unit. Scenario :- , Bot…
-
How to import data model in fusion biContent Dear , We have data model but cant find to import data model into fusion. Could you please guide how to import data model into fusion. step by step We have admin… -
create if condition in bi in add element by expressionContent i need to create element by expression and use if condition . how i create if condition in add element by expression ? (with example please)
-
Fusion Applications - Task - Manage Set Assignments for Set Determinant Type - What is the Purpose??Summary For a specific Reference Group Name what is the purpose of associating Determinant Value and Set Name ?Content While exploring the Reference Data Set aspects hav…