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
-
Budgetary Control Analysis ReportSummary: Control Budget parameter search does not return all project numbers in the Oracle seeded BI Publisher report Content (required): We have a user that runs the se… -
SmartView Duplicate name Error from sharded driveSummary: Smartview Spreadsheets are kept in a shared drive (OneDrive). After a hierarchy change (A single value added or moved)we continually see errors like : Essbase E…
-
Deeplink to GL Journals from OTBISummary: Hi All, Trying to implement the deeplink in OTBI to GL Journals. No Subject area in OTBI has jeBatchId column. Validate this in Fusion OTBI Data Lineage Mapping…
-
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…
-
How to encode etext output file from UTF-8 to ANSI in OracleSummary: We have custom etext payment file for Citi Bank EFT. the output of Etext file is .txt and it is encoded in UTF-8 by default. how can i convert this text file fr…
-
Why the condition row value is not able to sum up as expected.Summary: We have got a requirement where either of one value is nonzero consider that value for result row. Row values are Account 400000 Department 555015,Account 40000…
-
How to get module column (Finance or SCM) based on the users in user detail reportSummary: Content (required): Hi , I would like to get some query or sample reports to develop a custom user module report as this report is very important for business. …
-
Is the Oracle Analytics Cloud Professional Government is specific to the Government Cloud?Summary: Trying to determine its applicability to city government. Content (required): Is the Oracle Analytics Cloud Professional Government is specific to the Governmen…
-
How much do last the attachments on a newly created custom page?Summary: How much do last the attachments on a newly created custom page? Content (required): We have created a custom page and used it for a source of entry for some jo…
-
Enable Audit Log/System PerformanceHello All, We are interested to enable the Audit log files in Production and we want to know that what is the impact on system performance audit log is enabled once. We…
-
Where is the retention period of ESS jobs maintained ? Can we modify it to 7 days .Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Where can I find the list of native reports that exist in OTBI for purchase contracts?Hello colleagues, I need to know if there is a document that specifies those native or standard reports that Oracle offers, if you have a document with this information … -
Need dataflow/flow chart for Oracle fusion finance(ERP)Summary: Hi Team, We need to give presentation for Oracle fusion-Saas+OIC+anyother application module , so we need data flow diagram/flow chart for the same. This diagra…
-
How to create Account Range parameter?Summary: Standard ESS job - Supplier Balance Aging Report, has a parameter 'Account Range'. How to define the parameter for a custom ESS job? Content (required): Standar…
-
Is it a best practice to enable audit log in all the object attributes of a business object?Summary: External audit requires us to enable audit log. Is it a best practice to enable audit log in all the auditable object attributes of a business object? Let's say…
-
How long are the report jobs and outputs retained on the server?Summary: How long are the BIP Report Jobs and output files are retained on the server? Content (required): N/A Version (include the version you are using, if applicable)… -
How can a User view scheduled OTBI reports monthly?Summary: I removed the BI Author & BI Administrator role from a custom role for a user - leaving only the BI Consumer role within this custom role. User is not able to v…
-
Allocation Pattern SettingsSummary: 配賦パターンの設定について Content (required): 添付に記載のパターンについて、配賦処理設定をしたいと考えているのですが 現在、どのように実現すればよいかがわかって…
-
Getting remittance message columns in OTBI before payment is madeWe want to create a report which we can use to check whether all payment details are filled correctly for large batches of payments before creating them, to prevent down… -
The BIP Excel layout returns no dataSummary: I downloaded a data sample from the data model, added the fields to Excel (creating a XDO_Metadata sheet). The template with the sample data looks fine: But whe…
-
Oracle Business Process FlowsHi, I've found this note in Oracle Support which highlights the business processes (L1-3). I'd like to understand if there's any other documents which Oracle has publish…
-
Employee Audit ReportSummary: Are there any delivered reports or custom BIP reports someone could share to help with an Employee Audit Report? I have already included the required Employee i…
-
Customizing Journal Workflow and Invoice Workflow Notification in ERP Fusion CloudSummary: We have a requirement to customize the notifications from Workflow from Journal approval/Invoice Approval. We wanted to add a table to show the list of approver… -
Project Detail not showing up in Subject Area: Financials - Asset Transactions in FAWSummary: In Fusion Analytics Warehouse: Subject area: Financials - Asset Transactions: when we are pulling Asset Detail: Asset ID, Asset Number and Asset Name with Proje… -
How to map one parameter value to the multiple columnsHi, I have a table like as mentioned in the screenshot. I would like to pull the rows based on the parameter value. Data Model Query select * from supplier where usage1 …
-
Dynamic Legal Entity Name heading in FRS ReportSummary: Hi All, Can we have company or legal entity name derived dynamically in FRS reports based on selected legal entity at page level? Thanks, Content (required): Ve…
-
Customize 'Usage Metrics Drill-Through Report'Summary: Customize 'Usage Metrics Drill-Through Report' Content (required): We need to be informed if it's possible to customize the 'Usage Metrics Drill-Through Report.…
-
How to pass 10K records in IN clauseHi, I would like to pull journal information for 10K batches. I have 10K journal batches in the csv file and need to pull journal information(creation date, category, et…
-
How to provide read only access on all fusion tables (not cloud app pages) for a user accountSummary: We have a requirement from external auditor to provide them with the access of read only , able to query and get exact counts ( just the counts and not the real…
-
What are the advantages and disadvantages of audit policies in Oracle ERP?Summary: When enabling Audit trailing in the Manage Audit Policies in Setup and Maintenance, what are the advantages and disadvantage of audit policies Content (required…