With the Enhanced Security needs of Product development in the Process Manufacturing Industries, fluctuating raw materials prices, high variety of Products demanded by customer, necessitates outsourcing of manufacturing activities in the area of Process Execution so called “Offline Manufacturing”. Any Excessive Material Consumed at Production as against the standard formulation is a deviation which is termed as Material Variance. Formulator analyze the Material variance for a group of products produced in the same lot (similar formulation) and revise formula or advise production for corrective action. In offline manufacturing, since there is no manufacturing involved, we need to have a simplified system to Record Production data against each produced lot and similar formulations. At present, Oracle EBS is not supporting with standard feature for creating Lot based Multiple batches for similar formulations in Process Execution. This paper gives an idea of using custom components designed for formulations and lot based batch production suited to Offline Manufacturing which then integrates with standard oracle products such as OPM Financials.