Zensar Technologies

ONTAMS - Sr Oracle EBS Technical Specialist

India · On-site
Salary not published
Posted 3 days ago

From Zensar Technologies's careers page

Status: listed on the employer's own careers page when we last checked (daily). Confirm on their site before applying.

About the role

Build extensions such as the Clear-to-Build engine, shortage alert engine and reschedule publication, using Inventory, PO, WIP and BOM tables and public APIs.

What they ask for vs. your profile

Must have

Oracle
Inventory management
SQL
ERP systems

Similar jobs

All jobs

Zensar Technologies

ONTAMS - Sr Oracle EBS Technical Specialist

India · On-site
Salary not published
Posted 3 days ago

From Zensar Technologies's careers page

Status: listed on the employer's own careers page when we last checked (daily). Confirm on their site before applying.

About the role

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.

Key responsibilities

Read functional specs (MD050), raise gaps with the functional consultants, and write technical designs (MD070), unit test plans and migration scripts.

Build PL/SQL packages, concurrent programs and request sets for P2P flows: requisition to PO, blanket purchase agreements and releases, ASL, receiving, consigned inventory from supplier (ownership transfer, consumption advice) and AP invoice creation.

Build O2C components: sales order import, pick-release and ship-confirm hooks, component-sale invoicing to contract manufacturers through AR AutoInvoice, and receipts reconciliation.

Build extensions such as the Clear-to-Build engine, shortage alert engine and reschedule publication, using Inventory, PO, WIP and BOM tables and public APIs.

Develop BI Publisher reports (data templates, RTF/Excel layouts, bursting), such as the consolidated contract-manufacturer inventory view and consigned aging.

Build and customise Oracle Workflow (PO approval, notifications) and AME rules where approvals change.

Run data conversions (open POs, BPAs, on-hand and consigned balances, item and supplier masters) through open interfaces and APIs, including mock loads and reconciliation reports.

Show the full description

Package objects with FNDLOAD, XDOLoader and migration scripts, hand them to the DBA for SIT, UAT and production, and support cutover.

Tune slow SQL and PL/SQL (explain plans, trace/TKPROF, indexing, bulk processing).

Fix SIT and UAT defects within agreed turnaround, and provide hypercare support for owned objects.

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.

Build extensions such as the Clear-to-Build engine, shortage alert engine and reschedule publication, using Inventory, PO, WIP and BOM tables and public APIs.

What they ask for vs. your profile

Must have

Oracle
Inventory management
SQL
ERP systems
Manufacturing
Excel

What they ask for vs. your profile

Must have

Oracle
Inventory management
SQL
ERP systems

ONTAMS - Sr Oracle EBS Technical Specialist

About the role

What they ask for vs. your profile

Must have

Similar jobs

ONTAMS - Sr Oracle EBS Technical Specialist

About the role

Key responsibilities

Good to Have

What they ask for vs. your profile

Must have

What they ask for vs. your profile

Must have

Similar jobs

Key responsibilities

Good to Have

What they ask for vs. your profile

Must have

Your match

ATS check