EAM HEXAGON & ORACLE P2P
html
Lens A — Process Flow Map: Hexagon ↔ Oracle Equator Grid (Standalone)
LENS A • EQUATOR GRID
Standalone table grid • E1–E10
Process Flow Map: Hexagon ↔ Oracle Equator Grid
E1–E10 • North-to-Equator + South-to-Equator
| System Layer | E1: Item Master | E2: PR Creation | E3: PR Approval | E4: PO Creation | E5: PO Revision | E6: PO Approval | E7: Receipt | E8: Invoice Match | E9: Exception Handling | E10: Payment & Close |
| H5: Hexagon Response | H5.1 Item Updated (Hexagon) | H5.2 — | H5.3 PO Initiated (Hexagon) | H5.4 Supplier Ack (Hexagon) | H5.5 Revision Executed (Hexagon) | H5.6 Receipt Ready (Hexagon) | H5.7 Invoice Preparation (Hexagon) | H5.8 — | H5.9 Correction Applied (Hexagon) | H5.10 Transaction Closed (Hexagon) |
| H4: Hexagon Sync Out | H4.1 Item Master Sync → Oracle | H4.2 PR Sync → Oracle | H4.3 — | H4.4 PO Sync → Oracle | H4.5 Revision Sync → Oracle | H4.6 — | H4.7 Receipt Sync → Oracle | H4.8 — | H4.9 Exception Data → Oracle | H4.10 — |
| H3: Hexagon Create | H3.1 Item ID created/validated in Hexagon | H3.2 PR# generated with sourcing type | H3.3 PR ready for approval | H3.4 PO terms captured in Hexagon | H3.5 Change order created in Hexagon | H3.6 — | H3.7 Receipt record + evidence package | H3.8 — | H3.9 Variance identified, correction needed | H3.10 — |
| H2: Hexagon Control Gates | H2.1 ⚠️ Item must exist in Hexagon | H2.2 ⚠️ All required PR fields present | H2.3 ⚠️ PR completeness check | H2.4 ⚠️ PO draft validation | H2.5 ⚠️ Revision request complete | H2.6 ⚠️ Dispatch readiness | H2.7 ⚠️ Quality and quantity accepted | H2.8 — | H2.9 ⚠️ Correction data validated | H2.10 ⚠️ WO close criteria met |
| H1: Hexagon Data Objects | H1.1 🔷 Item ID 🔷 Category 📋 Status | H1.2 📋 PR# 📋 Sourcing Type 📋 Value | H1.3 📋 PR Status 📋 Sync Flag | H1.4 📋 PO Draft# 📋 Terms | H1.5 📋 Change Order# 📋 Revised Terms | H1.6 📋 Dispatch Status | H1.7 📋 Receipt# 📋 Qty 📋 Quality | H1.8 📋 Invoice Prep Flag | H1.9 ⚠️ Exception Case# 📋 Correction Data | H1.10 ✓ WO Close Status |
| ═══ EQUATOR ═══ | E1: Item Master | E2: PR Creation | E3: PR Approval | E4: PO Creation | E5: PO Revision | E6: PO Approval | E7: Receipt | E8: Invoice Match | E9: Exception Handling | E10: Payment & Close |
| O1: Oracle Data Objects | O1.1 🔷 Oracle Item ID 📋 Approved Status | O1.2 — | O1.3 📋 Oracle PR# 📋 Budget Reserved | O1.4 📋 Oracle PO# 📋 Award Type | O1.5 📋 Revision Status 📋 Voucher Flag | O1.6 📋 PO Version 📋 Dispatch Flag | O1.7 📋 Oracle Receipt# 📋 GL Posted | O1.8 📋 Invoice# 📋 Match Result 📋 Variance | O1.9 ⚠️ Hold Reason 📋 JE/PO ADJ | O1.10 ✓ Payment# ✓ GL Entry |
| O2: Oracle Control Gates | O2.1 ⚠️ Item must be approved to proceed | O2.2 — | O2.3 ⚠️ Budget must be reserved | O2.4 ⚠️ PO must pass Oracle validation | O2.5 ⚠️ Change order must be approved | O2.6 ⚠️ PO must be "clean" (no pending revisions) | O2.7 ⚠️ Receipt must clear GL posting | O2.8 ⚠️ 3-way match must pass | O2.9 ⚠️ Variance must be resolved | O2.10 ⚠️ All approvals must be complete |
| O3: Oracle Process | O3.1 Item approved status confirmed | O3.2 — | O3.3 Budget reserved, approval status = APPROVED | O3.4 Oracle PO# generated | O3.5 — | O3.6 Change order approved, voucher flag set | O3.7 GL posted, ready for invoice match | O3.8 3-way match executed, variance check | O3.9 Hold applied, awaiting Hexagon correction | O3.10 Payment executed, GL finalized |
| O4: Oracle Sync Out | O4.1 Item Status → Hexagon | O4.2 — | O4.3 PR Approval Status → Hexagon | O4.4 Oracle PO# → Hexagon | O4.5 — | O4.6 PO Approval Status → Hexagon | O4.7 Receipt Status → Hexagon | O4.8 Match Result → Hexagon | O4.9 Exception Details → Hexagon | O4.10 Close Status → Hexagon |
| O5: Oracle Applications | O5.1 Oracle PIM (Item Master governance) | O5.2 — | O5.3 Oracle Sourcing (PR/RFQ/Bid) | O5.4 Oracle SSP (Self Service Procurement) | O5.5 Oracle SSP (Change Order) | O5.6 Oracle SSP (PO Approval) | O5.7 Oracle Receiving | O5.8 Oracle AP (Invoice Match) | O5.9 Oracle AP (Exception Review) | O5.10 Oracle Finance (GL/Payment) |
| Loop Conditions | FAIL: Item invalid → Loop to H3.1 | FAIL: PR incomplete → Loop to H3.2 | FAIL: PR rejected → Loop to H3.2 | FAIL: PO incomplete → Loop to H3.4 | FAIL: Revision rejected → Loop to H3.5 | FAIL: Revision pending → BLOCK Receipt | FAIL: Receipt rejected → Loop to H3.7 | FAIL: Match failed → Route to E9 | FAIL: Unresolved → Loop to H3.9 or escalate | FAIL: Payment blocked → Loop to O3.8 |
| Supplier Interaction | — | RFQ Issued (if applicable) | Bid Received | PO Sent to Supplier | Change Order Sent | Supplier Ack Received | Delivery Confirmation | Invoice Received | Supplier Collaboration (DM/CM) | Payment to Supplier |
| Settlement Events | — | — | ✓ PR Approved | ✓ PO Created | — | ✓ PO Approved | ✓ Receipt Processed | ✓ Match Passed | ✓ Exception Resolved | ✓ Transaction Complete ✓ WO Closed ✓ PO Closed |