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
-
ESS base cubes Vs RDMBSSummary: I am getting confused here when we say cubes and RDMS in Cloud. Content (required): I had a debate with one of my peers where he said that there is only cubes a… -
GL Budgets not being returned from General Ledger - Balances Real TimeSummary: Subject area General Ledger - Balances Real Time not returning data for GL Budgets (budgets are loaded) Content (required): Hi, I have followed Doc ID 2177122.1…
-
Receivables Aging by General Ledger Account Report - Group by Natural Account segmentRequirement is to group Receivables transactions in "Receivables Aging by General Ledger Account Report" by Natural Account segment only, not by alll Chart of Account di…
-
How to preserve the single space character in the report?Summary: In the data model, LOOKUP_CODE has 'single character space' , and in the report the column content becomes a null value or it is automatically trimmed in the re… -
How to calculate number of periods based on the start date & end date of a GL PeriodSummary: Hello experts, I have a requirement to calculate the number of periods for a particular Invoice Multiperiod Accounting dates mapped to. For example, if the mult…
-
Print Preview can not be customized to show approverSummary: When I try to modify the "Printable Expense Report Template" as described here: https://docs.oracle.com/en/cloud/saas/financials/23c/faiex/modify-the-printable-… -
Has anyone been able to successfully migrate all configurations between Cloud environments?Summary: We wanted to know if anyone has successfully migrated all configurations between Oracle Cloud environments using either Oracle Fusion's native functionality or …
-
How to access P2P OTBI Dashboards in Oracle.Summary: A user is requesting access to P2P OTBI Dashboard they saw in Oracle Learning, we don't know how to get to it. Content (required): From that user: "I’m in Oracl…
-
Cannot connect to URL in FRS ReportSummary: Hello, When trying to edit my FRS report or even adding a member, like Aug-23 in the Accounting Period, the system gives me a white screen with an error of 'htt…
-
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…