Oracle EBS Custom Code Inventory Worksheet
Every EBS upgrade, migration or retirement starts with the same question: what have we built? This worksheet gives you a structured inventory of custom reports, interfaces, conversions, extensions and forms, with a disposition and a cost estimate for each, so the plan rests on a list instead of memory.
| Object name | Type | Module | Business owner | Runs per month | Disposition | Effort hours (h) | Rate per hour | Estimated cost | |
|---|---|---|---|---|---|---|---|---|---|
$3,400 | |||||||||
$1,020 | |||||||||
$0 | |||||||||
$5,100 | |||||||||
$6,800 |
Build the starting list from your own instance, for example custom applications in FND_APPLICATION, programs in FND_CONCURRENT_PROGRAMS, and objects named with your custom prefix in DBA_OBJECTS. Adjust effort by object complexity rather than using one flat estimate.
Review your custom code list
Optional review of your inventory to spot objects that standard features or read-only AI queries could replace.
Optional. The tool and every export work without this. No spam.
How to use the worksheet
List one object per row. Pick the type and module, name a business owner, and enter how often it runs. Choose a disposition: keep, rework, replace with standard functionality or retire. Enter effort hours and a rate to get an estimated cost, and read the totals to size your project. Export to Excel and share it with business owners for sign-off on the retire and replace decisions.
Where the inventory comes from
Query your own instance rather than trusting old documents. Custom applications, concurrent programs, value sets, workflows and database objects with your naming prefix are a good starting set. Add personalizations and OAF extensions, which often hide outside the normal object lists. Compare run frequency from the concurrent request history to find objects nobody uses, since those are the cheapest to retire.
- Check FND_CONCURRENT_REQUESTS for actual usage
- Look for customisations to seeded forms and packages
- Include integrations that live outside the database
- Flag objects that touch Oracle seeded tables directly
Common mistakes
Teams undercount personalizations, custom triggers and database links. They also assume every custom report must be rebuilt, when many can be replaced by standard reports or BI Publisher templates. Another mistake is a flat estimate per object. A simple report and a heavy interface with custom validation need different numbers, so use hours per row and review the largest few with the developers.
Frequently Asked Questions
What does RICE mean in Oracle EBS?
RICE stands for reports, interfaces, conversions and extensions. Some teams add forms, workflows and personalizations. It is the common grouping used to inventory and estimate custom work in EBS projects.
How do I find all custom objects in my EBS instance?
Combine several sources: custom application tables, FND programs and value sets, DBA_OBJECTS with your naming prefix, workflows, and personalization listings. No single query catches everything, so validate with the functional owners.
How should I estimate effort for each object?
Use hours per object based on complexity: size of code, number of tables, integration points and testing needs. Review the top ten largest items with the developer who maintains them, since they drive most of the total.
Which custom objects can I retire?
Start with objects that have not run in a year or more, duplicates of standard reports, and one-time conversions. Confirm with the business owner and keep the code archived in case an audit needs it.
If the inventory shows a long tail of custom reports, we can talk about answering those questions from read-only ERP data instead of rebuilding each report.
Related Tools
Oracle EBS Concurrent Program Registration Request Template
A request form that captures everything an EBS developer needs to register a custom concurrent program: executable, execution method, parameters, request group and incompatibilities.
OracleOracle EBS Profile Option Change Log Worksheet
Track every profile option change with its level, old and new value, reason and approver, so clones, upgrades and audits stop being guesswork.
OracleOracle EBS Instance Clone Request Template
A clone request form for EBS refreshes: source and target, backup point, data scrambling, post-clone configuration and sign-off.
OracleOracle EBS Tablespace Growth Forecast Calculator
Project compound growth of an EBS tablespace or database, find when it crosses an alert threshold and how much storage to add.
More Oracle tools
See all- Oracle EBS Inventory Tables Reference
- Oracle EBS WIP Tables Reference
- Oracle EBS Cycle Count Workload Calculator
- Oracle EBS Discrete Manufacturing Go-Live Checklist
- Oracle EBS Inventory Accuracy Readiness Assessment
- Oracle EBS Concurrent Request Phase and Status Reference
- Oracle EBS Responsibility Design Worksheet
- Oracle EBS GL Period Close Checklist
- Oracle EBS AP Invoice Interface Template
New to Oracle E-Business Suite? Start with the Oracle E-Business Suite guide and toolkit, or plan with Oracle EBS Roadmap Planner, Training Path Builder, ERP Certification Study Planner.
Keep exploring
Free tools
- Oracle EBS 12.2 Custom Code Remediation Effort CalculatorEstimate the hours, cost and weeks needed to make custom objects online-patching compliant and retested for EBS 12.2.
- Oracle EBS Custom Forms to APEX Migration Effort CalculatorEstimate the hours and cost to rebuild EBS custom Forms as Oracle APEX pages that launch from the EBS menu with EBS authentication.
- Oracle EBS 12.2 Upgrade Readiness ChecklistCheck whether your EBS environment, custom code and team are ready to move to Release 12.2 and what to settle before the project starts.
ERP fixes and how-tos
- How to Use Forms Personalization in Oracle EBS (No CUSTOM.pll Needed)How to use Oracle E-Business Suite Forms Personalization to hide fields, set defaults and raise messages without touching CUSTOM.pll or custom forms code.
- How to Create an Item in Oracle EBSCreate an inventory item in Oracle EBS: Master Items form, master organization, templates, attributes, organization assignment, categories and common errors.
- Data Conversion in Oracle EBS: Interface Tables, Open Interfaces and ReconciliationHow data conversion works in Oracle EBS: extract, stage, validate, load through interface tables and APIs, then reconcile. Practical steps and common failures.
Runs with your ERP
- Cloud Inventory (DSI) with Oracle E-Business Suite: Mobile Barcode InventoryCloud Inventory, formerly DSI, adds offline mobile barcode inventory to Oracle E-Business Suite and JD Edwards. Data flows, setup steps, pitfalls and AI notes.
- Esker Order Management and Oracle E-Business SuiteHow Esker captures customer POs from email, fax and PDF and creates sales orders in Oracle EBS: integration, data flows, setup, pitfalls and a private AI layer.
- Oracle Mobile Supply Chain Applications (MSCA) for Oracle EBSOracle Mobile Supply Chain Applications (MSCA) for EBS: native RF transactions for inventory, WMS and manufacturing, setup, pitfalls and where private AI helps.
AI on your ERP
- AI for Oracle E-Business Suite, Without Leaving On-PremHosting Oracle EBS 12.2 on-prem or in a private cloud? Add a private LLM over concurrent programs, interface tables and AP/PO data without moving to Fusion.
- AI for Oracle EBS in Industrial Manufacturing: WIP, MRP, and BOM Questions Answered DirectlyAI for Oracle E-Business Suite in industrial manufacturing: WIP jobs, BOMs, MRP, inventory and purchasing answered in plain English, private and read-only.
Integrations
- How to use ChatGPT with Oracle E-Business SuiteUsing ChatGPT with Oracle E-Business Suite: export vs live access, custom GPT actions over ISG REST, enterprise data controls and when to keep data on-prem.
- How to add AI agents to Oracle E-Business SuiteHow to add AI agents to Oracle E-Business Suite R12: tool layer over ISG services and open interfaces, approval gates, and on-prem model hosting options.