PROMATIS Best Practice Solutions for Oracle E-Business Suite

PROMATIS Best Practice Solutions are functional extensions and adjustments of Oracle Applications. They were developed directly in practice for practice and can be installed without risk. The result: The economic benefit of your Oracle Applications increases quickly and sustainably.

PROMATIS Extractor

PROMATIS DataSmart

PROMATIS Best Practice

PROMATIS Extractor

The PROMATIS Extractor is a universally applicable software tool for data extraction from Oracle enterprise applications. Application-oriented plug-ins with preconfigured extraction routines are available for numerous migration objects from the areas of Financials and Supply Chain Management of the Oracle E-Business Suite and the Oracle Fusion Applications Cloud. Customer-specific plug-ins can be developed and integrated.
Datasheet

The add-on modules (plug-ins) offer optimal support for the implementation of application-specific tasks.

The following plug-ins are available for the PROMATIS Extractor:

MEC / GoBD
With the Plug-in MEC (Month End Closing)/GoBD, the information for the digital audit can be extracted from the Oracle E-Business Suite in accordance with the principles for the proper management and storage of books, records and documents in electronic form as well as for data access (GoBD), and can be made available in a GoBD-compliant format. The data can be read and analyzed directly by the standard IDEA tool of our partner Audicon.
Datasheet
MDM
The Plug-in MDM (Master Data Management) enables the extraction of complete master data records from the Oracle E-Business Suite. Available master data objects include customers, suppliers and articles. This data can be imported into analysis tools or Microsoft Excel. This plug-in can be used to provide data that is required to answer customer inquiries about personal data according to article 15, paragraph 3 of the General Data Protection Regulations (GDPR).
Datasheet
P2P
The Plug-in Procure2Pay (P2P) enables the extraction of complete purchasing and accounts payable transactions from the Oracle E Business Suite. Available transaction objects include purchase orders, incoming goods and accounts payable invoices. This data can be imported into analysis tools or Microsoft Excel.
Datasheet
O2C
The Plug-in Order2Cash (O2C) enables the extraction of complete order and accounts receivable transactions from the Oracle E Business Suite. Available transaction objects are, among other things, sales orders, deliveries and accounts receivable invoices. This data can be imported into analysis tools or Microsoft Excel.
Datasheet
DATEV
The Plug-in DATEV enables the provision of tax-relevant data in DATEV format. With this plug-in, all postings with subledger information as well as balance carried forward values and master data (customers, suppliers, chart of accounts) can be provided and directly imported and analyzed in the DATEV software solutions.
Datasheet
E-Balance
The Plug-in E-Balance enables the legally compliant creation, documentation and transmission of information for the annual financial statements in XBRL format to the tax authorities via the Elster Rich Client (ERiC) process.
Datasheet
UVA ELSTER
The Plug-in UVA ELSTER (advance VAT return) is an interface perfectly tailored to the Oracle E Business Suite and fully automates the transfer of the advance VAT returns to the tax authorities. The tax-relevant information is exported from the general ledger (GL) and then transferred to ELSTER with just one click.
Datasheet
ZM ELSTER
The Plug-in ZM ELSTER enables the electronic transmission of the recapitulative statement (German: ‘Zusammenfassende Meldung’, for short: ZM) to the German tax authorities. Using the Oracle Standard ESL (European Sales Listing) report, the exported sales list (XML output) with tax-relevant information from the receivables subledger is transferred to the ELSTER interface with just one click.
Datasheet
MIG
The Plug-in PROMATIS MIG supports the data migration from the E-Business Suite into the Oracle Fusion Cloud. It enables the extraction of complete data sets (e.g. Accounts Receivables, Accounts Payables, General Ledger, Order Management) from the Oracle E-Business Suite. The data is exported in CSV format and can then be uploaded directly into the Oracle Fusion Cloud.
Datasheet

PROMATIS DataSmart

PROMATIS DataSmart is a high-end version of the extraction tool. Through innovative technologies and the use of an Oracle-based data mart, dedicated data is extracted from various data sources in a high-performance and secure manner into predefined data tables. The tables are accessed via APEX dashboards or by using common Oracle query techniques. Application-specific plug-ins are provided by preconfigured dashboards, which can be complemented by customized additions. The table structures can also be extended according to customer requirements.

The add-on modules (plug-ins) offer optimal support for the implementation of application-specific tasks

The following plug-ins are available for the PROMATIS Extractor DataSmart:

MEC / GoBD
With the Plug-in MEC (Month End Closing)/GoBD, the information for the digital audit can be extracted from the Oracle E-Business Suite in accordance with the principles for the proper management and storage of books, records and documents in electronic form as well as for data access (GoBD), and can be made available in a GoBD-compliant format. The data can be read and analyzed directly by the standard IDEA tool of our partner Audicon.
Datasheet
MDM
The Plug-in MDM (Master Data Management) enables the extraction of complete master data records from the Oracle E-Business Suite. Available master data objects include customers, suppliers and articles. This data can be imported into analysis tools or Microsoft Excel. This plug-in can be used to provide data that is required to answer customer inquiries about personal data according to article 15, paragraph 3 of the General Data Protection Regulations (GDPR).
Datasheet
P2P
The Plug-in Procure2Pay (P2P) enables the extraction of complete purchasing and accounts payable transactions from the Oracle E-Business Suite. Available transaction objects include purchase orders, incoming goods and accounts payable invoices. This data can be imported into analysis tools or Microsoft Excel.
Datasheet
O2C
The Plug-in Order2Cash (O2C) enables the extraction of complete order and accounts receivable transactions from the Oracle E-Business Suite. Available transaction objects are, among other things, sales orders, deliveries and accounts receivable invoices. This data can be imported into analysis tools or Microsoft Excel.
Datasheet
DATEV
The Plug-in DATEV enables the provision of tax-relevant data in DATEV format. With this plug-in, all postings with subledger information as well as balance carried forward values and master data (customers, suppliers, chart of accounts) can be provided and directly imported and analyzed in the DATEV software solutions.
Datasheet
E-Balance
The Plug-in E-Balance enables the legally compliant creation, documentation and transmission of information for the annual financial statements in XBRL format to the tax authorities via the Elster Rich Client (ERiC) process.
Datasheet
UVA ELSTER
The Plug-in UVA ELSTER (advance VAT return) is an interface perfectly tailored to the Oracle E-Business Suite and fully automates the transfer of the advance VAT returns to the tax authorities. The tax-relevant information is exported from the general ledger (GL) and then transferred to ELSTER with just one click.
Datasheet
ZM ELSTER
The Plug-in ZM ELSTER enables the electronic transmission of the recapitulative statement (German: ‘Zusammenfassende Meldung’, for short: ZM) to the German tax authorities. Using the Oracle Standard ESL (European Sales Listing) report, the exported sales list (XML output) with tax-relevant information from the receivables subledger is transferred to the ELSTER interface with just one click.
Datasheet

PROMATIS Best Practice

For the Oracle E-Business Suite, provider Oracle offers a country-specific localization. PROMATIS Financials are functional extensions and supplement this localization aiming at an improved usability and automation.

Balance Sheet Report
This report collection creates an output based on general ledger information (totals and balance lists). This report was created with the Business Intelligence Publisher (BI Publisher) and supports output formats such as PDF, HTML and MS-Excel.
Profit and Loss Report
This report creates an output based on general ledger information (totals and balance lists). It was created with the BI Publisher and supports output formats such as PDF, HTML and MS-Excel. The PROMATIS Profit and Loss Report is in the outputs Balance Sheet and P&L.
Financials Summary Report
The PROMATIS Financials Summary Report creates an output based on general ledger information (totals and balance list). This report was created with the report generator and supports output formats like PDF, HTML and MS-Excel. The Financials Summary Report is in the Balance Sheet and P&L outputs.
Provision Report
The PROMATIS Provision Report prevents that the provision account for expense orders with cost centers is posted. The number of account combinations as well as the reconciliation effort at the end of the month is reduced to a minimum.
Trial Balance Detail Report
The Oracle standard report Trial Balance Detail Report (Totals and Balance List Detail) is supplemented by a BI Publisher Layout, so that output formats such as PDF, HTML and MS-Excel are supported.
Aging 7 Buckets by Account Report (Receivables)
The Oracle standard report Aging 7 Buckets by Account (Receivables) is supplemented by an additional BI Publisher layout, so that output formats such as PDF, HTML and MS-Excel are supported and data in MS-Excel can be filtered simply (‘flat’ Excel format).
Dunning Letter
In perfect interaction with the Report Dunning Proposal List, the PROMATIS Report Dunning Letter shows the debit-side transactions to be dunned (invoices, credit notes, prepayments, unidentified payments) including their dunning levels. A corresponding BI Publisher template is included, which can be customized (e.g. by adding the customer logo).
Dunning Proposal List
In perfect interaction with the Report Dunning Letter, the PROMATIS Report Dunning Proposal List shows the debit-side transactions to be dunned (invoices, credit notes, prepayments, unidentified payments) including their dunning levels in Excel format. A corresponding BI Publisher template is included.
SEPA Extension (Payables)
PROMATIS SEPA (Single Euro Payments Area) Extension is a tool that supports the currently valid German SEPA payment procedures for the standardization of credit transfers, direct debits and card payments in the Euro Payments Area. The invoice date and the number of the payment run are included in the SEPA file, which allows for a simplified reconciliation with the account statements.

With the help of interfaces, the programs of PROMATIS Best Practice Bank Statements enable the automatic exchange of financial data with banks. This way, both payment information as well as bank statement data can be received and transferred.

Program: LockBox (debitorial)
PROMATIS LockBox supports the automatic creation and reconciliation of customer payments and other payments. Account statements are automatically imported, payments based on rules are created and, if necessary, assigned to customer invoices.
Program: Loading Account Statements (CAMT, MT940)
PROMATIS supports the automatic transfer of account statement data into Oracle applications according to the defined XML data transfer format CAMT and the SWIFT standard MT 940.

The PROMATIS Report Enrichment serves as supplement to the standard reports.

Program: Report Enricher
This PROMATIS solution is exclusively available for the Oracle E-Business Suite and complements the standard reports, which were e.g. created with Oracle Reports. The special feature of this solution: When adding the missing fields, the Oracle source code is left unchanged. The generated file is completed with the missing fields in the XML structure before it is transferred to the BI Publisher.