Oil Refineries and Oil Wharfs have numerous storage tanks for finished products like petrol, gasoline, kerosene, etc. Many of these refineries use mainframe based bespoke applications to manage the oil inventory. Therefore maintenance of the systems in the long run is expensive and the systems lack integration with the other ERP systems being used in the rest of the organization.
Some other business challenges include:
- Lack of online reporting of oil inventory across multiple sites and ensuring a timely ordering of the fuel
- Ineffective reporting of inventory of the products in ambient and standard temperature of 15 degree centigrade and
- Compliance to ASTM D 1250-80 calculations (American Society For Testing & Materials – American Petroleum Institute) for Volume Corrections and Net Weight
Bulk Storage Solution is an Oracle Consulting solution offered by Oracle SSI, that -
- Helps maintain, control and monitor fuel stock
- Interfaces with the electronic gauging systems like Honeywell ENRAF systems to monitor stock levels in each tank
- On line accurate reporting of Inventory stocks in tanks across multiple sites
- Interfaces with LIMS systems to perform Quality certification and release of Oil tanks for shipping products.
Key Features
- Tank Static Data - Stores tank static data of name, number, owner code, temperature, density and item tank relationship
- Tank Calibration Data Interface - Calibration data is received from calibration systems as flat files and interfaced in to EBS tank gauging system
- ENRAF Interface and converting Volume to On-hand- ENRAF Readings (received every 15 mins ) for all the tanks are uploaded to EBS and custom program convert ENRAF readings for each tank and display on hand Volume in Tanks
- Predict Stop gauge function - To determine amount of a product required to be added or removed from a tank
- Freeze Log Function - Snap shot of the Inventory stocks of various products in various tanks
- Tank Gauging Reading - ‘Tank Gauging‘ feature is used to review the ENRAF readings, Pumping Rate, Current Volume of a particular tank. Option is available to query the ENRAF readings in the period of 15 mins, 30 mins, 1 hr or a day.
Optional Features
- Automation of the Product Quality Certification process using Workflows
- Automation of Tank Certification/Release Process using Workflows
- Automate Custody Transfer process - Tank open and close gauges, product densities and temperatures, sealine and pipeline densities are all incorporated into the calculation algorithm. Differences in the sealine and pipeline densities at opening and closing are taken into account, as are volume and thermal correction factors. Computer tables of tank calibration are accessed directly to convert product gauges to product gross volumes
Benefits
- Process streamlining and Automation
- Improved decision support by online reporting
- Seamless integration with ERP systems
For further information on the solution, contact Gururaj TS, Group Head - Industry Solutions, Oracle SSI.
