# Oracle EBS Custom Code Inventory Worksheet > Source: https://netray.co/tools/oracle-ebs-custom-code-inventory-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Catalog reports, interfaces, conversions, extensions and forms with a disposition and effort estimate so you can size an EBS upgrade or retirement. ## Category oracle ## Erp Oracle E-Business Suite ## Audience - EBS technical lead - Upgrade project manager - EBS developer ## Tool **Kind:** worksheet **Mode:** editable **Currency:** $ **Columns:** #### Object name **Key:** obj **Type:** text #### Type **Key:** type **Type:** select **Options:** - Report - Interface - Conversion - Extension - Form - Workflow - Personalization - OAF page #### Module **Key:** module **Type:** select **Options:** - GL - AP - AR - FA - PO - INV - OM - WIP - HR - Other #### Business owner **Key:** owner **Type:** text #### Runs per month **Key:** freq **Type:** number #### Disposition **Key:** disp **Type:** select **Options:** - Keep as is - Rework - Replace with standard - Retire #### Effort hours **Key:** hours **Type:** number **Unit:** h #### Rate per hour **Key:** rate **Type:** number **Format:** currency #### Estimated cost **Key:** cost **Type:** number **Expr:** hours * rate **Format:** currency **Rows:** **Obj:** XX_AP_INV_INTERFACE **Type:** Interface **Module:** AP **Owner:** AP Manager **Freq:** 120 **Disp:** Rework **Hours:** 40 **Rate:** 85 **Obj:** XX_AR_AGING_RPT **Type:** Report **Module:** AR **Owner:** Credit Manager **Freq:** 30 **Disp:** Replace with standard **Hours:** 12 **Rate:** 85 **Obj:** XX_ITEM_CONV **Type:** Conversion **Module:** INV **Owner:** Supply Chain **Freq:** 0 **Disp:** Retire **Hours:** 0 **Rate:** 85 **Obj:** XX_PO_APPROVAL_WF **Type:** Workflow **Module:** PO **Owner:** Procurement **Freq:** 600 **Disp:** Rework **Hours:** 60 **Rate:** 85 **Obj:** XXGL_JE_FORM **Type:** Form **Module:** GL **Owner:** Controller **Freq:** 90 **Disp:** Rework **Hours:** 80 **Rate:** 85 **Totals:** #### Total effort **Key:** hours **Agg:** sum **Format:** number #### Total estimated cost **Key:** cost **Agg:** sum **Format:** currency #### Objects listed **Key:** obj **Agg:** count **Summary:** #### Average cost per object **Key:** avg_cost **Expr:** sum_cost / count **Format:** currency **Primary:** true **Notes:** 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. ## Content **Intro:** 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. **Sections:** #### How to use the worksheet **Body:** 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 **Body:** 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. **Bullets:** - 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 **Body:** 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. **Cta:** 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. **Faq:** #### What does RICE mean in Oracle EBS? **Answer:** 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? **Answer:** 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? **Answer:** 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? **Answer:** 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. ## Search terms oracle ebs customization inventory, oracle ebs rice inventory template, ebs custom objects list for upgrade, oracle ebs 12.2 custom code assessment, oracle apps customization list excel, ebs reports interfaces conversions extensions --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json