ONTAMS - Sr Oracle EBS Technical Specialist

Builds, unit-tests and deploys RICEFW components on Oracle EBS R12 across Procure-to-Pay and Order-to-Cash, for a contract-manufacturing and consignment process. Works from functional specs written by the SCM and Finance consultants, writes the technical design, and fixes defects through SIT and UAT under the Technical Lead.

Required Qualification

- 6–12 years of Oracle EBS R12 technical development, with at least 2 full-cycle implementations (not only support).
- Strong SQL and PL/SQL: packages, cursors, bulk collect/FORALL, exception handling, performance tuning.
- Hands-on build on P2P and O2C tables and APIs: PO_HEADERS/LINES, PO_REQUISITION_ , RCV_ , AP_INVOICES_ , OE_ORDER_HEADERS/LINES, WSH_DELIVERY_ , RA_CUSTOMER_TRX_ , AR_PAYMENT_SCHEDULES, MTL_ (items, on-hand, transactions).
- Open interfaces and APIs: Requisition Import, PDOI (PO and BPA import), Receiving Open Interface, AP Invoice Interface, Order Import / OE_ORDER_PUB, AutoInvoice, Inventory transaction interface.
- Concurrent programs, value sets, request sets, AOL setups (menus, functions, responsibilities, profile options, lookups, DFFs).
- BI Publisher reports from data templates; Oracle Reports (RDF) knowledge.
- Oracle Workflow Builder and AME basics.
- FNDLOAD and code migration practices.
- Writes clear MD070 technical designs and unit test documents.

Good to Have:

- Consigned inventory, Outsourced Manufacturing (JMF) or subcontracting tables.
- WIP and BOM tables and APIs; ASCP/MSC planning tables.
- OAF personalisation and extension, Oracle Forms (Form Personalization, CUSTOM.pll).
- Oracle Alerts, XML Gateway, OBIEE.
- EBS R12.2 online patching rules for custom code (editioning, ADOP-compliant objects).
- Semiconductor, high-tech or discrete manufacturing domain.