Add support for Oracle ERP Cloud API

[trahulkumar]

Problem

The current prototype sends signals exclusively to SAP S/4HANA via IDoc. To support a broader range of defense contractors and public sector users, we need native support for Oracle Fusion Cloud SCM.

Proposed Solution

Implement a new OracleConnector class that pushes approved procurement signals to the Oracle Purchase Requisition REST API.

Technical Details

• Target Endpoint: /fscmRestApi/resources/11.13.18.05/purchaseRequisitions (Oracle Fusion Cloud SCM)
• Authentication: OAuth 2.0 (Client Credentials Flow)
• Data Mapping:
  • Map GovSignal demand_probability (float) to Oracle RequisitionLine.Urgency.
  • Map GovSignal signal_id (UUID) to Oracle RequisitionLine.Attribute1 (for auditability).
  • Map GovSignal source_url to RequisitionLine.NoteToBuyer.

Tasks

• Create govsignal/integrations/oracle.py
• Implement OAuth token management (handling 1h expiration)
• Define JSON payload schema for PurchaseRequest
• Add unit tests mocking the Oracle API response