Integration of Corporate Information System with Electronic Document Management System (Oracle 11g, Kontur Diadoc)

Key project description

The project is a PL/SQL package for integrating a corporate information system with the Kontur Diadoc electronic document management system. The main task is to send electronic documents (Universal Transfer Documents, Invoices, etc.), specifically their titles, to Diadoc using the API.

Key functionality

• send_dd_document — main workflow
• Validates incoming XML, Extracts sender and recipient, Generates and signs attachments
• Sends via /V3/PostMessage and processes the response
• process_formalized_doc — processing formalized (UniversalTransferDocument/CorrectionDocument) documents
• Detects title (DetectDocumentTitles method of Diadoc API)
• Parses title (ParseTitleXML)
• Extracts and verifies signer. Signs title and processes attachments
• process_non_formalized_doc — processing non-formalized documents
• Collects attachments and generates XML signer (Signers) with certificate thumbprint
• send_request_blob — HTTP client for streaming binary data with UTL_HTTP and DBMS_LOB to stream BLOBs in chunks. Reads and assembles response as LOB/RAW

XML and JSON handling:

• Working with XMLType / XMLTABLE for parsing FNS formats
• Using pljson / pljson_ext for JSON building and processing
• Integration with local metadata tables to obtain certificates and file paths

Technologies: Oracle PL/SQL, UTL_HTTP, DBMS_LOB, XMLType, XMLTABLE, JSON (pljson/pljson_ext), Diadoc API