An Oracle ERP implementation company needs a standalone web application written in Java to transmit and receive e-Ledger data (accounting related General Ledger and Journal Book) to a central data centre unit. The application will extract data from Oracle systems, will wrap the data in required XML format and be able to send / receive e-ledger. E-Ledger data will be sealed and electronically signed and will be uploaded on Government portal for regulatory compliances by companies. Finally patent file is sealed with financial seal by revenue administration and is ready to download for the user. The data will be archived in the oracle database.
In order to accept the files that are created by the standards established by the General Regulations as e-ledger, it has to be sealed with the financial seal or signed with a secure electronic signature and must be patented with e-Ledger application.
The related procedures are listed below-
- “E-Ledger” format files are created in accordance with the standards and formats specified in the relevant manuals.
- The created file is placed is placed in the designated field which is stated in schema structure
- The created “ledger” file is signed or sealed. (The file created in this way has to be kept as ledger by the taxpayer after getting its patent. However, in order to consider the file as valid ledger, the patent must be gotten and be kept together with the file)
- “Patent” file is created by getting certain information from the sealed or signed “ledger” file.
- “Patent” file is signed or sealed.
- Signed or sealed patent file is packed.
- The prepared package is uploaded on e-Ledger Application on www.edefter.gov.tr
- The patent is sealed with the financial seal of the Revenue Administration and is given access to the ledger owner to download. (The e-ledger patent file that has been given access to download must be kept with the signed or sealed ledger file.)
The solution was proposed to development it on JBoss-SpringFramework, Hibernate and JSF development stack. One of the key aspect of the project was to provide Smartcard based digital document signing feature. The signing was essential for uploading documents to Government portal. Documents generated at each stage are stored as Binary object in the Oracle database itself thereby eliminating the need for a separate file database server.
- The solution was implemented within 2 months although it took almost the same amount of time to get the application procedural steps accepted from the Government.
- Application is fully parameterized including name of source and target database, the name of tables, the directory providing the ERP implementer full flexibility to offer this solution as an add on service to its client.