1. Background

• What it solves / Objective: This manual defines the data integration process (interfaces) between external systems and Códice Customs Control (CCC), ensuring proper validation, loading, and traceability of information through structured files.
• Product: Códice Customs Control (CCC)
• Module: Interfaces / Data Integration
• Applies to: CCC versions on Oracle 18c and 19c (Production and QA environments)
• Estimated time: Initial configuration: 2 to 6 hours Process execution: 5 to 15 minutes per file (depending on volume)
• Risk level: Medium (impacts operational data integrity)
• Prerequisites:
  • CCC installation on Windows server
  • Oracle database (18c or 19c) configured
  • Oracle client installed on access workstations
  • Active CCC licenses
  • Valid access credentials
  • Knowledge of data loading layouts
  • Folder configured on Oracle server with read/write permissions
  • Network path configuration (UNC or mapped drive)
  • (Optional) SQL*Loader available for local loads

2. Step by step (Procedure / Solution)

2.1 Manual interface loading process

1. Navigation path: Menu → Interfaces → Interface selection
2. The user must select the corresponding interface type (from available options).
3. The user must load the file in format:
   • Tab-delimited text (.txt) or
   • CSV file (.csv) according to the defined layout.
4. The system processes the file to intermediate tables in Oracle.
5. The user must review the information loaded in intermediate tables:
   • Validate structure
   • Detect format or content errors
6. If the information is correct, the user must execute the integration action to the system.
7. Save / Execute: Confirm final load to production tables.
8. Validation:
   • System messages indicating success or error
   • Review of loaded records
   • Confirmation in operational screens or reports
   • Process log validation
9. Upon success, the system automatically clears intermediate tables.