Can Oracle Apps DBA Learn Oracle Financials

Oracle EBS consultant

1986 to 1990 measurement and control technology

Programming languages: Basic, Pascal, C, Assembler

Extension of a program for the production control of car radios

Software development for the control of a fully automatic adjustment station

Software development for an antenna amplifier alignment station

Software for the calibration of measuring instruments


1990 to 1995 database programming for Oracle 6 and 7

Programming languages: C, Forms 3.0, Omnis, SQL, PL / SQL, awk

Creation of interfaces, evaluations and dialog in close cooperation with the customer

DBA activities on Unix platform


1995 to 1998 Oracle financials 10.4

Programming languages: Forms 2.3, SQL, PL / SQL, awk

Expansion of the AR module to include the "multi-currency capability" function

Creation of a customer module for Letter of Credit

Creation of a customer module for cost accounting

Creation of reporting date-related evaluations in AR

Creation of a balance sheet with customer information

Realization of the currency revaluation in the AR module

Clearance of OP-managed G / L accounts in GL manually or automatically

Realization of interfaces and evaluations

Migration from AR and GL to SAP


1997 to 2001 Oracle financials 10.7

Programming languages: Forms 4.5, Reports 2.5, SQL, PL / SQL, awk

Implementation of the CE module, automation of processes

Clearance of OP-managed G / L accounts in GL, manually or automatically, with automatic calculation of the exchange rate differences.

Individual or total transfer of postings from the sub-ledgers, depending on the account

Creation of reporting date-related evaluations in AR

Realization of interfaces and evaluations

Adaptation of the dunning program

Reminders grouped according to orders

Dynamic texts, depending on the customer language, the payment method and other freely definable criteria

VESR print for Switzerland

Interface to the Swiss VESR clearing house

Reading in of the bank data, generation of payments and automatic allocation to the invoices.

Realization of a new customer interface for performance reasons

Tuning the application

Calculation of the daily interest rate for receivables and liabilities between group companies


1999 to 2000 Oracle financials

2nd level support AR and CE for Oracle Germany


2001 Migration from Oracle financials 10.7 to 11.03

Programming languages: SQL, PL / SQL

Complete transfer of customer data from a client

Transfer of open items (AR, GL) with conversion into euros

Transfer of exchange rate differences

Permanent interface GL 10.7 / GL 11.03

Permanent interface CE 11.03 / CE 10.7 with automatic coordination in the correct instance: PL / SQL

Takeover of the system with conversion into euros. Adjustment of the calculation tables due to the short fiscal year


2002 to 2004 Extension and maintenance of Oracle financials

Programming languages: Forms 4.5, 6.0, Reports 2.5, SQL, PL / SQL, awk

Consulting, analysis and creation of customer requirements

Creation of a module for automatic individual value adjustments

Change of the dunning program: output in PDF, fax functionality

Migration of the systems of different companies from Excel tables.

Migration of a company's systems to SAP


2003 to 2004 Implementation of Oracle financials 11.5

Programming languages: Reports 6, SQL, PL / SQL, awk

Project management, consulting and setup for the implementation of Oracle Financials 11.5 (PO, AP, FA, CE, AR, GL, AX) in Paris

Creation of several payment programs for the CFONB formats

Creation of a Masterpiece Oracle GL interface

Creation of an Oracle-Oracle GL interface

Migration of the systems from Masterpiece

Creation of a semi-automatic comparison between supplier invoices and orders

FSG: Preparation of the balance sheet in the format of the French forms with active / passive exchange


2005 to 2006 projects in Oracle financials 11.5

Programming languages: SQL, PL / SQL

Conceptual analysis and implementation of new requirements on the part of customers in the various modules of the financial software from Oracle Applications. This includes tasks in application development as well as tasks from the consulting area

Independent participation in projects for the introduction of the financial software Oracle Applications at various companies

Independent collaboration in projects to expand the standard functionality of the financial software Oracle Applications at various companies

Implementation of setup activities

Project management and advice on the introduction of direct debt collection in Austria.

AR consulting for the introduction of Oracle in Poland

Integration of a new reservation system in Switzerland: definition of interfaces, acceptance test and migration from SAP.

Advice on merging several companies and migration.

Concept and implementation of the debit intergroup reconciliation


2007 Adaptation Oracle financials 11.0.3

Programming languages: Forms 4.5, SQL, PL / SQL, Unix shell

Realization and implementation of GL interfaces

Realization and implementation of a customer interface

Realization and implementation of interfaces for an automatic assignment of payment advice notes

Adaptation of some forms.


2007 Projects in Oracle financials 11.5.10

Programming languages: Forms and Reports 6.0, SQL, PL / SQL, awk, Unix Shell

Data migration AR, AP, GL, FA

Adaptation of forms and reports

Consulting and implementation of a short fiscal year for several companies



2008 Projects in Oracle financials 11.5.10

Programming languages: SQL, PL / SQL

Data migration AR (merging)

Definition of interfaces to AR

Evaluations via liquidity planning (CE, AR, AP)

Evaluations for quality management (all modules)

Evaluation of bank transactions for the National Bank of Poland


2008 to 2009 projects in Oracle financials 12.0.4

Programming languages: SQL, PL / SQL, awk, Unix shell

Data migration from 11.0.3 to 12.0.4:

Customer base

Supplier master

GL balances

AR open items

Adoption of the adjustments

Takeover of an intranet solution based on IAS servers (evaluations of all modules).



2009 Projects in Oracle financials 12.0.6

Programming languages: SQL, PL / SQL

Conception of the implementation.

Realization of the bank interface for the bank code file of the Deutsche Bundesbank

Realization of the customer interface.

2009 to 2010 projects in Oracle financials 12.0.6

Programming languages: SQL, PL / SQL, Unix shell

Conception, realization and implementation of an EDI interface for customer orders

2010 to 2011 projects in Oracle financials 12.1.3

Programming languages: SQL, PL / SQL, Unix shell

Turnover and sales analysis of purchasing and sales with Excel output from PL / SQL.

Solution for fax and e-mail output from Oracle Application.

Connection of a document management system (DocuWare) for all relevant documents and a scanning workflow solution (Rec solutions) for the accounts payable invoices in cooperation with the company Sattel Business Solutions GmbH.

2010 to 2012 support of an Oracle financials 11.5.10 instance

Programming languages: SQL, PL / SQL

Definition of the AR interfaces for the connection of new reservation systems.

Support: cleaning up the interfaces, correcting transactions.

Reconciliation of the sub-ledgers.

SQL evaluations.

2013 to 2014 projects in Oracle financials 11.5.10

Introduction of SEPA direct debit for B2B and B2C

Change in the time of booking for insurance revenues.

Since 2013 support of an Oracle financials 12.1.3 instance

Programming languages: SQL, PL / SQL, Unix shell

Maintenance of the financial modules. Realization of evaluations.

Realization of an automatic invoice verification module for freight invoices.

Since 2016 support of an Oracle financials 11.5.10 instance and projects

Introduction of a new voucher system.

Migration to SAP GL and AR.
Maintenance, support