Best Practice for Finance and Accounting

For the Oracle Fusion Applications Cloud, Oracle offers a Austrian localization. This ensures that the Oracle Fusion Applications Cloud can be used in accordance with the principles of proper management and retention of books, records and documents in electronic form, as well as for data access (GoBD) by the tax authorities. The PROMATIS Best Practice products complement this localization with the goal of improved usability and automation.

Financials Reports

  • Balance Sheet Statement
    This reports creates an output based on General Ledger information (Trial Balance). This report was created with BI Publisher and supports various output formats such as PDF, HTML and MS Excel. Supported methods are:
    – Total Cost Accounting
    – Cost of Sales Accounting
  • Profit and Loss Statement (P&L)
    This reports creates an output based on General Ledger information (Trial Balance). This report was created with BI Publisher and supports various output formats such as PDF, HTML and MS Excel. Supported methods are:
    – Total Cost Accounting
    – Cost of Sales Accounting
  • Financial Closing Overview Statement
    This reports creates an output based on General Ledger information (Trial Balance). This report was created with BI Publisher and supports various output formats such as PDF, HTML and MS Excel. Supported methods are:
    – Balance Sheet Statement
    – Profit & Loss Statement (Total Cost Accounting)
  • Trial Balance Template
    The Trial Balance Template complements the Oracle Standard Report (GLTRBAL1) with a BI Publisher layout so that various output formats such as PDF, HTML and MS Excel are supported.
  • Fixed Assets Summary Report
    This report provides a gross fixed assets summary layout according to valid jurisdiction including the consideration (reported separately) of capital in progress (CIP) assets.
  • Preliminary Dunning Letter / Final Dunning Letter
    The Preliminary Dunning Letter and Final Dunning Letter show in perfect harmony the overdue transactions (invoices, credit memos). All types of customer payments (on account and unapplied) can be taken into consideration – also with their dunning levels. An appropriate BI Publisher template is included.
  • Aging 7 Buckets by Account Template
    The Aging 7 Buckets by Account Template complements the Oracle Standard Report (ARXAGSW) with a BI Publisher layout so that output formats such as PDF, HTML and MS Excel are supported.

Financials Screens

  • Read-Only Invoice Form
    The PROMATIS Invoice Query Form is an additional development and serves as a read-only screen with lots of display fields entered in Oracle Payables (AP). Here, starting from a vendor, all related invoices are displayed. The invoice query screen features a search functionality with many search parameters.
  • Statement Form
    Through this PROMATIS personalization, it is possible to process debit and credit side payments in the payment management, without having to switch to a vendor or customer-responsibility. The corresponding masks are accessed in a parameterized manner.
  • Collection Form
    With this personalization, the transaction date is added into the Oracle Accounts Receivables (AR) Collection Form and the date range is extended from 180 days to 10 years. With this personalization, now all transactions are completely shown without having to extend the date range manually.
  • Start Invoice Print
    With this personalization, the report PROMATIS Invoice Printing can be triggered with one click from the Oracle Receivables (AR) transaction form.

Extractor Tools

  • Extractor GoBD
    Tool for providing the tax-relevant data according to access type Z3, which is required by the GoBD of the tax authorities. The Java application provides all accounting transactions with sub-ledger information as well as balance reporting values and master data (customers, suppliers, chart of accounts) in a GoBD-compliant format. This data can then be read directly into the standard IDEA tool from our partner Audicon.
  • Extractor Migration
    Universal software tool to extract data in the context of data migration (master and transaction data) for many applications, e.g. as part of new implementations, master data management or data quality management. The scope of supply includes preconfigured extraction routines for numerous migration objects from the areas of Financials and Supply Chain Management in the Oracle Fusion Applications Cloud. The tool is flexibly expandable, supplied extraction routines can be extended and new ones can be added. Productivity gains can be achieved not only in data migration but also by providing real-world data in system tests.
  • Extractor Audit
    Extraction tool to support audit processes. It is based on the audit standards of the American Institute of Certified Professional Accountants (AICPA), which take into account all journals, all financial transactions, open items, and charts of accounts information, such as value amounts or balances. The following components are available: Order-to-Cash, Procure-to-Pay, FixedAssets-to-Depreciation, Receiving-to-Shipment.

Financials Tools

  • LockBox
    The PROMATIS LockBox supports the automatic creation and reconciliation of customer payments and other payments. Account statements are automatically imported, payments are created based on rules and, if necessary, assigned to customer invoices.
  • Accrual Account: Expenses without CCTR
    This PROMATIS adjustment prevents the accrual account from being booked with expenses orders with cost centers. The number of account combinations and the month-end reconciliation effort are kept to a minimum.
  • Auto Accounting
    The PROMATIS Auto Accounting is an adaptation of the revenue accounting rules used when importing customer invoices and credits. Deviating from the Oracle standard, segment information of the posting key is taken from different sources (e.g. info flex fields). For example, a separate sales account can be automatically selected for one order type per tax key.
  • COGS Workflow Adjustment
    The PROMATIS COGS customization is an adjustment to the Cost of goods manufactured account assignment rules used in the shipping process. Deviating from the Oracle standard, segment information of the posting key is not only taken from the article master data, but from other sources as well.
  • Report Enrichment
    This PROMATIS solution complements the Oracle standard reports. The special feature: When adding the missing fields, the Oracle source code is not changed. The generated file is supplemented by the missing fields in the XML structure before being passed on to the BI Publisher.
  • SEPA Extension
    SEPA (Single Euro Payments Area) is the payment integration initiative for simplification of bank transfers, direct debits, and card payments denominated in euro. The former national payment and direct debit payment methods in euro were replaced by the SEPA payment procedure as of 1 February 2014 on the legal basis of EU Regulation No. 260/2012 (“SEPA Migration Regulation”). Since Oracle does not support the current German SEPA version ZKA 2.5 (NOV 2010: pain.001.002.03.xsd, valid thru NOV 2012, based on EPC Rulebook 4.0), PROMATIS provides the corresponding extension.
  • UVA ELSTER Interface
    PROMATIS UVA Interface meets all functional and technical requirements for the electronic transmission of a VAT return. With the UVA Generator tax-relevant information can be exported from the general ledger (GL) and subsequent with only one click data are transferred to ELSTER.
  • RS ELSTER Interface
    The PROMATIS RS interface fulfills all functional and technical requirements for the electronic transmission of recapitulative statements (RS). Using the sales list (XML) with tax-relevant information from the general ledger (GL) exported as a standard report, the data is transferred to ELSTER with just one click.

Financials Tools (partner product)

  • E-Balance Generator
    The PROMATIS E-Balance fulfills all technical and technical requirements for electronic transmission of the tax balance in the mandated XBRL format. Information required, for example, for the sectors “balance sheet”, “P&L statement” and “cash flow statement” can be exported from the general ledger (GL). The core of the PROMATIS E-Balance is the “white label product” Opti.Tax by hsp Handels-Software-Partner GmbH.