Oracle ERP Integration — Automated Document Extraction

Overview

Oracle ERP users process thousands of supplier invoices. Cargoffer OCR integrates via REST APIs, replacing manual data entry with AI-powered extraction.

Oracle Cloud Integration

Use Oracle Integration Cloud (OIC) to create a REST connection to Cargoffer OCR. Configure a scheduled flow that polls for new PDF invoices and sends them to the OCR API.

PL/SQL Example

sql

DECLARE
  l_clob CLOB;
  l_json JSON;
BEGIN
  l_clob := apex_web_service.make_rest_request(
    p_url => 'https://ocr.cargoffer.com/api/upload',
    p_http_method => 'POST',
    p_body => l_pdf_blob,
    p_parm_name => apex_util.string_to_table('file:filename'),
    p_parm_value => apex_util.string_to_table(l_pdf_path),
    p_token_url => 'https://ocr.cargoffer.com/api/me'
  );
  l_json := JSON(l_clob);
  :job_name := JSON_VALUE(l_json, '$.job');
END;