Query ( SQL) to fetch the item details such as Item number, lead time, planner code, min max quantity in Oracle R12
Blog
MTL_PARAMETERS: Columns, Indexes & Few Tips
MTL_PARAMETERS: Table Structure, Indexes and a few salients points to brief the importance and usage of the table in Oracle R12.
MTL_SYSTEM_ITEMS_B: Columns, Indexes & Few Tricks
MTL_SYSTEM_ITEMS_B: Table used by Oracle R12 for storing the Item information. Or in other words, it is R12 equivalent of EGP_SYSTEM_ITEMS_B table in Oracle Fusion. Slight difference is that MTL_SYSTEM_ITEMS_B table stores the item number in segment1 field. And since the item is defined at Inventory Org level, Combination of Inventory_item_Id and Organization_Id will give… Continue reading MTL_SYSTEM_ITEMS_B: Columns, Indexes & Few Tricks
OTBI Report Creation in Oracle Fusion
A Step by step guide to create an OTBI ( Oracle Transactional Business Intelligence) Analysis in Oracle Fusion.
Load Plan Creation and Scheduling in ODI
How to create new Load Plan in ODI and how to schedule it to cater to various load activities to automate the process.