Reporting
Discussion List
-
What are the options available to mask Test instance dataHi Experts I would like to know what are the different options available for Data Masking in Oracle Fusion. For example: If we want to grant access to our test instance … -
Are the tables related to OTBI reports available to report on in OTBI?Summary Would like to monitor changes to OTBI reports at the table level until OTBI reports are being monitored via Audit PoliciesContent Would like to monitor changes t…Jeff Hare CPA CISA CIA 158 views 6 comments 3 points Most recent by User_BZ5TP Reporting and Analytics for ERP -
We require to reconcile the Landed Cost Clearing Account?We require to reconcile the landed cost clearing account. Kindly provide us with any tips, white papers, reports which we can use to do the reconciliation. We also requi… -
Fusion Role Required for Approval & ReportsContent This sounds like a basic question, however we did not get a convincing answer via My Oracle Support. We are a Finance & SCM customer, and we would like to know (… -
Mapping Oracle eBS (12.2.8) tot Oracle CloudContent We are currently investigating moving from Oracle eBS on premise (12.2.8) to Oracle cloud. We have quite some customizations and reports build on the old datamod…Pam Koertshuis 397 views 3 comments 2 points Most recent by Manju Chugani Reporting and Analytics for ERP -
Are the BPM configuration tables exposed to OTBI?Summary Looking to query BPM configuration tables directly to support external audit change management populationContent Are the BPM configuration tables exposed to OTBI…Jeff Hare CPA CISA CIA 85 views 6 comments 0 points Most recent by Bianca Lei Villareal Reporting and Analytics for ERP
-
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…Mig_ph 31 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
How to find SQL query or logic behind the value set attached to the ESS job?Summary: Is there a way to figure out how the Asset book list of values are populated when running Create Mass Addition program? As per below screenshot, List of value s…Karun_Jain-Oracle 67 views 3 comments 0 points Most recent by Ravi Prakash Shukla-Oracle Reporting and Analytics for ERP
-
Report for BPM Workflow RulesSummary: Is there a mechanism to pull out list of BPM rules as an extract or report. Also the workflow Rules Report covers some of the workflows but not all. Content (re…hkubba_del 160 views 2 comments 0 points Most recent by James McBride Reporting and Analytics for ERP
-
"Create Uninvoiced Receipt Accruals" ESS job is ending with 'Retrying' statusSummary: "Create Uninvoiced Receipt Accruals" ESS job is ending with 'Retrying' status Content (required): We have added required Privileges, DSPs & Role Hierarchy in Cu…
-
Add invoice tax lines on the separate remittance adviceSummary: Unable to find data model to customize separate remittance advice report Content (required): We need to add invoice tax lines on the separate remittance advice …
-
create pivot report with additional fieldsSummary: in fusion i want to create income statement report as pivot table , i know how i create pivot in template. but the first issue is i get some accounts the get su…ghrbia 51 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
How to categorize system notifications (AP Invoices, Expenses, PRs, etc.)Summary: Instead of having all notifications with only date ordering, the system must group system notifications of approvals, and others by category for EX (Expenses, J…Ahmed_Attia 11 views 1 comment 1 point Most recent by Mihaela Cozma GL-Oracle Payables, Payments & Cash Management
-
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…ShitalRamteke 22 views 4 comments 0 points Most recent by ShitalRamteke Reporting and Analytics for ERP
-
Accounting Entries generation for invoices matched with POs with credit linesSummary: Content (required): Hi, This is with regard to the accounting entries relevant to the feature introduced by 23A "MATCHING OF INVOICES WITH PURCHASE ORDER LINES …
-
Role needed to create new ESS jobSummary: Which role is need to provide access to create new ESS job via the Manage Enterprise Scheduler Job Definitions and Job Sets for Financial, Supply Chain Manageme…El1a 1.1K views 3 comments 0 points Most recent by Ravi Prakash Shukla-Oracle Reporting and Analytics for ERP
-
Legal report for Portugal to communicate the inventories once every year - Portugal localizationsSummary: Portuguese companies are required to communicate to the Tax Authority the inventory relating to the last day of the tax period, through a file with defined char…Siddharth JSS 81 views 6 comments 0 points Most recent by Bogdan Pana-Oracle Reporting and Analytics for ERP
-
Translation urgent help needed from expertsSummary: Translation urgent help needed from experts Content (required): We have entities in across the world and all needs to be translated into Reporting currency i.e.…Kumar 57 42 views 3 comments 0 points Most recent by MariCostache-Oracle Payables, Payments & Cash Management -
Existing HFRS report built on tree needs to be compared with control budget that doesn't have a treeSummary: Content (required): Hello Aim - To have a report that can be used to compare actual and control budget data. The below points describes the issue that we are cu…Nirav Vekaria 42 views 2 comments 0 points Most recent by Nirav Vekaria Reporting and Analytics for ERP -
How to Create Alias TableSummary: Hello, I have requirement to create FRS reports for multi-language reports in oracle cloud and need help to create Alias Tables as this is required to fulfill t…Singh Inderjeet 31 views 1 comment 0 points Most recent by Singh Inderjeet Reporting and Analytics for ERP
-
Any benefits to benchmarking Fusion processes and activities?Summary: We are considering a benchmarking activity across our systems, although with Fusion being a cloud product the benefits of such an activities are uncertain - oth…Mark_Simpson 21 views 1 comment 0 points Most recent by Anca A-Oracle Reporting and Analytics for ERP -
How to rollup the quarterly data in SmartView ?Summary: The QTD column is not fetching data in SmartView ad-hoc analysis. What is the procedure to enable quarterly roll-up? Content (required): We have created an Inco…Preethi Srinivasan 52 views 5 comments 0 points Most recent by MariCostache-Oracle Reporting and Analytics for ERP
-
Out of the box reports in Oracle Cloud ERP with samplesSummary: I'm aware of the seeded reports that come out of the box in Cloud ERP with some samples included in it. There was an Oracle Support note or something similar bu…Raj Mohanraju FRNT 787 views 1 comment 0 points Most recent by MariCostache-Oracle Reporting and Analytics for ERP
-
How to get value of previous periodSummary: Content (required): Dears , We are working on Balance sheet report using specific period as parameter , we need to add new column using values of previous perio…Bishoy Talaat 32 views 1 comment 0 points Most recent by MariCostache-Oracle Payables, Payments & Cash Management
-
SQL for List of Overflow Checks PrintedSummary: Overflow Checks Content (required): Is there a table where it'll show a list of overflow checks (void-by-overflow) that was printed? Version (include the versio…M.Naing 41 views 2 comments 0 points Most recent by Kondaiah Mandadi-Oracle Payables, Payments & Cash Management
-
Irreversible- Key setups/design considerations detailsSummary: Hi Experts, We are planning to implement Oracle Fusion modules(Financials-GL, AP, FA, Payments, Project Financials, Procurement - Purchasing & SSP and localizat…Spats 55 views 1 comment 0 points Most recent by Helle Hennings-Oracle Reporting and Analytics for ERP
-
Table information to obtain Expense Report Owner and PreparerSummary: Content (required): Hi, Please be kind enough to direct me to a table or query that can be used to obtain the Expense Report Owner and Preparer. Appreciate a pr…