Reporting
Discussion List
-
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 161 views 6 comments 3 points Most recent by User_BZ5TP Financials – General (READ ONLY) -
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 (…Rihan Jameel 58 views 10 comments 2 points Most recent by PradeepPR Financials – General (READ ONLY) -
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 356 views 3 comments 2 points Most recent by Manju Chugani Financials – General (READ ONLY) -
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 83 views 6 comments 0 points Most recent by Bianca Lei Villareal Financials – General (READ ONLY)
-
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 22 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Financials – General (READ ONLY)
-
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 36 views 3 comments 0 points Most recent by Ravi Prakash Shukla-Oracle Financials – General (READ ONLY)
-
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 97 views 2 comments 0 points Most recent by James McBride Financials – General (READ ONLY)
-
"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 …singhankitj1 31 views 1 comment 0 points Most recent by Ravi Prakash Shukla-Oracle Financials – General (READ ONLY)
-
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 Financials – General (READ ONLY)
-
Need the document which provides information about Financial Scheduled ProcessSummary: There used to be a document which listed out Financial Scheduled Process and and details about those, which are now not available. I need to link to that docume…
-
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 Financials – General (READ ONLY)
-
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 21 views 4 comments 0 points Most recent by ShitalRamteke Financials – General (READ ONLY)
-
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 707 views 3 comments 0 points Most recent by Ravi Prakash Shukla-Oracle Financials – General (READ ONLY)
-
Is GDPdU (German Audit File) and GoBD Data Extract Same and Oracle ERP Solution is Generic SAF-TSummary: I have one question on Germany and Poland's localization report. Business requirement is to generate GDPdU (German Audit File) for Germany and Poland. When I tr…Jakeeagarwal 359 views 9 comments 0 points Most recent by Jakeeagarwal Financials – General (READ ONLY)
-
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 82 views 6 comments 0 points Most recent by Bogdan Pana-Oracle Financials – General (READ ONLY)
-
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 Financials – General (READ ONLY) -
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 41 views 2 comments 0 points Most recent by Nirav Vekaria Financials – General (READ ONLY) -
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 Financials – General (READ ONLY)
-
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 Financials – General (READ ONLY) -
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 51 views 5 comments 0 points Most recent by MariCostache-Oracle Financials – General (READ ONLY)
-
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 549 views 1 comment 0 points Most recent by MariCostache-Oracle Financials – General (READ ONLY)
-
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 Financials – General (READ ONLY)
-
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 Financials – General (READ ONLY)
-
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 51 views 1 comment 0 points Most recent by Helle Hennings-Oracle Financials – General (READ ONLY)
-
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…
-
Roles given to External Auditors during AuditContent External Auditors will need to view Journal Entries, Invoices, etc and the supporting documentation. What roles have you provided them? We are trying to avoid cr…Rene George 68 views 4 comments 2 points Most recent by Varun Jain-Oracle Financials – General (READ ONLY)