By Two Tea - True Bonding

These words are used here in India spontaneously to ask for a break in work,to share some thoughts,to analyse something or simply for timepass.Also whenever friends meet after a long time, first they ask 'How are you ?' and next 'By two Tea?'. Such is the importance of tea.If head count increases 'By'remains same but the count after that is directly proportional to number of heads.But its the responsibility of the person who is paying the bill to indicate exact number of Full Chai's (Teas) purchased.

We freinds have adopted this interseting part of our life during our Engineering college days.Most of them were away from home first time and this is when we really had a time to celebrate.This is the period when we realised the true value of friendship with chai.

During College days these are the repetative scenarios:

Money:
You have bunked lot of class and need to pay attendance shortage fee.
You went movies on weekend and purchased ticket in black for high value.
Arranged weekend trip to nearby place without informing parents.
Made few mischiefes in Labs which attracted additional penalty on your bill.
Did not note down in the class hence need to take friends entire notes xerox.
Browsed much more in cafe.
You spent much on outside food to avoid hostel food.

Internals:
You did not studied at all and tommorow is a last internal in the subject.Last two you scored less thinking you will makeout in the last.You want your friend to sit beside you during internals.

Final Exam:
You need a viva questions asked by external to your friend who just finished his lab exam and tommorow is yours.
Important questions for tommorows final exam.

New Entry:
Freshers entered colleges and you want to show your friend one pretty girl you already started liking :P

Last day in college:
You are packing your stuff and memories spent in college back to home after giving your final exams.

The only words which may help you for discussion or to get assistance with your friends is ' By Two Tea?'
In the end you get help or not, you expressed yourself or not 'By Two Tea' has done the trick for Tea seller and Yourself.

Now we moved from Era of 'College Days' to so called 'Unemployed Best Days' (Neither you are a student nor a responsible person to complete client assignment) toughest days of our Life although no exam to write nor any project deadline to meet.

Now 'By Two Tea' pulls you to discuss 'Which courses to choose?', 'Where to drop resume?' ,'Where are walkins?','Can we use Forwarded call letter to attend the interviews?', 'Do we have any references in any company?', 'Who got job in our batch,Importantly when is the treat?', 'Good source for daily rotis? That too cheap and best', lot more!!!!!!

Tea helped to boost our moral , yes you can do it!!!! true we did it. I am not saying that Tea did it , I just explained Tea was a part of it.

As we moved into our professional life we took more time to think and grow as person whom this society recognises for unique reason, qualification. The time we spent for thinking is directly proportional to the Tea we had as single or 'By two'.When you say 'By Two' you have been always together with your Freind, Collegue, Competitor and Boss(the worst tea you had). Now you can see professionals working in any MNC will come for smoke outside but he wont hesitate to take Tea from the small shop.Status cannot be bought infront of Tea.

This proves 'Tea' is an Unbiased part.

Now Modern CCday's ,Barishta have made the places to hangout with your loved ones with full cup of coffee, but in your heart you will be missing those 'By Two Tea'.

So in a way Tea helps you to share Happiness, Sorrow of you and your close ones. This is just a thought around glasses of 'By Two Tea'.

Lot can happen over Coffee ....

I realized this 4 years ago, but daring to ink the same on the note now.Here I am absolutety referring coffee in view of Cafe day and thus not including Barishta in the list(Later one never worked for me either).

We met in CC day. She talked.She Talked. She talked. She talked. She talked. She talked.We left the ccday for the day.

We again met in CC day.She talked.She Talked. I saw 'chocolate fantasy' disapearing in a second from the plate. We talked. I kept on sipping the 'Café Frappe' just seeing her eyes and dint realised that mug was empty so fast while listening to sweet spoken chatter box. We left the ccday for the day.

We met again in CC day. She Talked. I again saw 'chocolate fantasy' disapearing in a second from the plate.She talked. I burnt my tongue while sipping 'Café Mocha' while listening her past and future. She talked.She talked . Finally I got an opportunity to talk.I paid.We left the ccday for the day.

We met again in CC day. She Talked. we talked.I paid.We left the ccday for the day...

We met again in CC day .Happy part of the story as well as coffee date continues.

We met again in CC day. Today she was sad. She dint speak. I talked.I talked. Unable to sip all the coffee. We left the ccday for the day....

We met again in cc day.She was angry. She talked. She talked. I talked. I talked ( literally Shouted).Unable to sip all the coffee. We left the ccday for the day....Sorrow part of the story as well as coffee date continues...

We met again in cc day. I was sad and even she. Only Coffee day girl talked (asking for order). Unable to sip all the coffee.Paid the bill. We left the ccday for the day....

We met again. Both were happy. Meeting last time in CC day with the existing relation. Finally coffee date will come to end. We both were very happy. Even I had my part of 'chocolate fantasy'from the plate.We went to cash counter for the first time. We paid the bill and handed over a Marriage invitation card to the guy who was serving a coffee during these dates.He wished us a luck.We left the Ccday for the day.

We are married now.

|||||||Now whenever I see CCday I think Barishta would have been the good choice...(:P). I assume my wife cannot read between the lines|||||||||

Leisure (Life) and Work

Above label looks very short and sweet but understanding and implementing best practice of balanced life will take 'Lifetime’. But it is must and mandatory you should balance your work and life, if you want to live 25-30 years of your remaining life peacefully or happily or least living while breathing.

The work and lifestyle has drastically changed in last 30 years. I used to keenly observe my parents work schedule daily when I am young. At the age of 5 or 6 I assumed work is something like staying away from your home/loved ones for 7-8 hours 6 days a week. (My father and mother into teaching profession).Life as relaxing on weekends with some nice breakfast and lunch. Enjoy the festival holiday with new dress, delicious food, relatives, short nap in the afternoon. Life would have been more enjoyable when we were on summer or winter vacations (1-2 months) when we used to go for Relatives house, new temples, and new beaches and so on....So if you understand mathematics you will calculate the work as 17% time of a year.


Year day 365

sundays 48
Summer holiday 50
Winter holiday 25
Govt Holiday 20
Total Holiday 143

Total Working Day 365-143
222 Days

Taking 7 hours per day 222*7
1554 Hours

Converting to day 64.75 Days

i.e. 17% of year.

Looks very interesting and a crooked smile on your face right.


So I might be enjoying remaining 80% time one or other way surely not work. Earlier work and leisure had clear cut boundary i.e. office wall or Compound :). Once you came out of office compound you are celebrating your leisure.


Now myself so called Software engineer/consultant put my yearly work breakup on paper this is how it looks.

Year day 365

sundays 48
Saturdays 48
Paid Holidays/Sick leave 20

Total Holiday 116

Total Working Day 365-116
249 Days

Taking 13 hours per day (3hours for travel in Bangalore) 249*7
3237 Hours

Take Client call from home 8 hours monthly 96 Hours
Work on 10 weekends to meet project deadline 130 hours
Total working hours 3463 Hours

Converting to day 144.29 Days

I.e. 40 % of the year

Now Big question mark on your Face....


So Work in your life has been increased from 17% to 40%. Simple calculation but big difference. Now the question is not choosing the career profession it’s about accommodate leisure in the work.

You will tell me how to accomplish it. The ideas are most welcome until and unless I get the Same CTC and the same job profile.

Chaos.

R12 Mock Implementation - Business Process

ORA_APPS_R12_NG
Natgeo Gas
Project Management
(Mock R12 Implementation Project)

Project Sponsors:
Not applicable

Document Owners:
Gururaj Gouda

Contributors:





STANDARD DISCLAIMER:
This research and document is meant for educational purposes only. Any resemblance to real Organization/Unit is purely coincidental.



Table of Contents
About Client: 3
GAS Manufacturers and distributors overview: 4
Existing ERP/MIS tools: 5
Statistics: 5
Operating Structure 6
Existing Process: 6
Details of the existing Business process: (As-Is) 7
1.Procurement of Natural gas from Manufacturers and Local Distribution Companies (Buy) 7
2. Maintaining the gas in internal plant and procured from different vendors (Maintain) 9
3. Distributing/Selling as per the customer forecast demand. (Sell) 10
SCOPE: R12 Implementation Project for the Client Natgeo Gas 11



About Client:

Client: Natgeo Gas
Client info: http://www.natgeogas.com/
With the largest fleet of service society in Metro Atlanta, Natgeo Gas provides the most cost-efficient and reliable propane services for forklifts in the area.
 On-site cylinder fill, or cylinder exchange service available
 Regular scheduled deliveries from more than once a week to monthly depending on your usage. Will call service is available.
 24 hour emergency service.
 Fleet of fourteen radio dispatched trucks.
 Employee safety programs available.
 Cylinder storage racks and cages available in various sizes. We also sell tanks to those customers who would prefer to own their tanks.
 Cylinders available for every application.
 Parts & Service Center where we sell propane parts and equipment to support your needs.
 Service is always available to repair, recondition, requalify or move tanks. If a tank is leaking, our service department is dispatched immediately
Natgeo Gas works with builders who want to provide their customers with energy choices that make sense while enhancing the quality of their home. Our program includes underground tanks, contractor pricing and rebate programs. Whether you are building individual homes or an entire community, we can work with you to come up with the right gas solution.
Gas Price Programme: Natgeo Gas Distributors offers several different pricing and payment options to help you better manage your propane bill. Our most popular program is our Budget Billing Plan. This plan gives you the convenience of level, year round monthly payments based on your estimated annual usage. Instead of paying for your winter gas usage per delivery, you can spread your payments over a year. Additionally, you are also automatically enrolled on our “Guaranteed Keep-Full Delivery” service, which means that we will keep your tank filled and you won’t have to worry about running out of gas.

GAS Manufacturers and distributors overview:
Simplified Structure of Industry after Pipeline Unbundling


The diagram shows a simplified representation of the structure of the natural gas industry after pipeline unbundling and wellhead price deregulation. It is important to note that the actual ownership pathway of the gas may be significantly more complicated, as the marketer or the LDC are not the final users. Either of these two entities may sell directly to the end user, or to other marketers or LDCs.
The regulatory environment of the day has a dramatic effect on shaping the structure of the industry.
The actions of the federal government and its related agencies and departments can also have a significant impact on the structure and functioning of the natural gas industry.

Industry Makeup
Now that the basic structure of the natural gas industry has been discussed, it is possible to examine the business characteristics and relevant statistics of each industry segment.
• Producers - There are over 6,300 producers of natural gas in the United States.
• Processing - For more information on natural gas processing, visit the Gas Processors Association.
• Pipelines - There are about 160 pipeline companies in the United States, operating over 300,000 miles of pipe. Of this, approxiamtely 180,000 miles are interstate pipelines.
• Storage - The EIA maintains a weekly storage survey, monitoring the injection and withdrawal of stored natural gas. This survey gives a good indication of the status of the natural gas market, measuring the natural gas that is extracted or stored at any one time in response to the demand for natural gas.
• Marketing - The status of the natural gas marketing segment of the industry is constantly changing, as companies enter and exit from the industry quite frequently. As of 2000, there were over 260 companies involved in the marketing of natural gas. In this same year, about 80 percent of all the natural gas supplied and consumed in North America passed through the hands of natural gas marketers. The volume of non-physical natural gas that passes through the hands of marketers is very large, and can be much greater than the actual physical volume consumed.
• Local Distribution Companies - There are about 1,200 natural gas distribution companies in the U.S., with ownership of over 1.2 million miles of distribution pipe. While many of these companies maintain monopoly status over their distribution region, many states are currently in the process of offering consumer choice options with respect to their natural gas distribution.
The process of getting natural gas out of the ground, and to its final destination to be used, is a complicated one. There is a great deal of behind-the-scenes activity that goes into delivering natural gas to your home, even though it takes only the flick of a switch to turn it on. This section provides an overview of the processes that allow the natural gas industry to get their product out of the ground, and transform it into the natural gas that is used in your homes and in industry.
• The Exploration section outlines how natural gas is found, and how companies decide where to drill wells for it.
• The Extraction section focuses on the drilling process, and how natural gas is brought from its underground reservoirs to the surface.
• The Production section discusses what happens once the well is drilled, including the processing of natural gas once it is brought out from underground.
• The Transport section outlines how the natural gas is transported from the wellhead and processing plant, using the extensive network of pipelines throughout North America.
• The Storage section describes the storage of natural gas, how it is accomplished, and why it is necessary.
• The Distribution section focuses on the delivery of natural gas from the major pipelines to the end users, whoever they may be.
• The Marketing section discusses the role that natural gas marketers play in getting the gas from the wellhead to the end user.

Existing ERP/MIS tools:

Presently client using the EDI and Legacy system which cannot be integrated with oracle. So the existing MIS and ERP tool can be decommissioned once we get into new packaged solution.

Statistics:

Number of estimated system users: 100 ( Plus 20 Buffer)
Number of super users need to be trained in IT: 8
Maximum Duration of the project: 8 months

Operating Structure

Following diagram shows the basic organization structure for Natgeo gas. Natgeo has its registered headquarters at Cairo, Lake Forrest Drive, Suite 258, Cairo GA 30328.
Cairo also has storing units which supplies the gas to all southern part of Georgia. Their business process includes Receive and fulfills order, procure gas for Cairo and Sylvania via bidding process and maintain the inventory.This Unit is responsible for generating revenue, submitting financial reports and maintaining the ledgers. Most of the Natgeo business arises in this corporate sale office.


Fig 1.6
Sylvania, ABC West, Marine drive, GA 30358. Acts as a major supplier for defense wing. This organization only receives order and get the material procured from Cairo. It handles only shipping and maintaining inventory for Natgeo.
Oakwood, P.O. Box 99, Oakwood, Georgia,30566 is the biggest storing plant among all the 3. It works as procuring and selling unit for Natgeo. All north and West Georgia Commercial and domestic needs are fulfilled by the Oakwood plant.
Existing Process:
Existing Business process can be divided into 3 major sections
1. Procurement of Natural gas from different Manufacturers and Local Distribution Companies (Buy)
2. Maintaining the gas in internal plant and procured from different vendors (Maintain)
3. Distributing/Selling as per the customer forecast demand.(Sell)


Details of the existing Business process: (As-Is)
1.Procurement of Natural gas from Manufacturers and Local Distribution Companies (Buy)

When procuring Natural Gas Natgeo will select suitable suppliers of the item to be purchased from among registered suppliers. As a rule, tenders will be by competitive bidding between selected suppliers. However, in certain cases, a specific supplier may be designated based on patent rights held by that supplier, compatibility with the existing facilities, whether they are the sole supplier of a given item, or similar situations.
A request for tenders indicating the conditions of the tender, contract conditions, and tender specifications will be provided to potential suppliers who will be invited to submit tender proposals.
In addition to the proposal made in accordance with the tender specification, alternative proposals containing additional cost-saving options other than as specified by Natgeo in the tender specification may be submitted provided that such alternatives meet the performance and function requirements as specified in the tender specification.
In cases where any changes could result in a change in the bid price, the supplier will be asked to submit such price adjustment and explanation.
Natgeo will award the Long term contract (Least 3 months to Max of 6 months) for the specific supplier based on the price and the strict delivery dates. This contract can be renewed via new tendering process on every quarter if required.
Products are to be delivered as agreed to in the contract. Natgeo reserves the right to claim liquidated damages if delivery is delayed beyond the specified delivery deadline. Payments are made once commodity is received and QA is passed. There will not be delay of 15 days after the commodity passed QA test.

Flow Chart for BUY process:
Department/Users Business events
Procurement Refer the demand schedule

Refer the previous bids/quotes/Blankets if any

Raise RFQ for the suppliers

Get quotes from suppliers

Award quotes based on the price and date schedule

Issue Blanket agreement for the awardee

Monitor Supplier activities

Issue order based on demand schedule.

Receiving Dept receive the goods and Inspect.

Payables Pay for the Quality accepted

Close the books monthly

Finance Check for any discrepancies , report the same to Procurement dept. or fix .
Fig 1.2







2. Maintaining the gas in internal plant and procured from different vendors (Maintain)
Natgeo gas has 3three different reservoir plants in Cairo, Oakwood and Sylvania.

Natural Gas is usually measured by volume and is stated in cubic feet. The gas procured from the vendor is inspected and once it passes the QA will be transferred to the respective containers.

One tanker will store only one lot from a single supplier. There are around 35 storage tankers spread across 3 different cities in Natgeo which act as storing reservoirs. Stock person is responsible for checking and maintaining the exact quantity as per safety norms.

Monthly maintenance will be scheduled all tankers/reservoirs on 2nd Sunday of every month.

Natgeo gas maintains following 8 grades of natural gas depending on the usage and consumption pattern.

3. Distributing/Selling as per the customer forecast demand. (Sell)

The following figure illustrates the ‘Sell’ process for the Natgeo gas. The shipping may be via existing pipeline or through road, rail and ship. Marketing department is responsible for taking the orders and taking approval from the respective business head.

Shipping/Stock personnel takes care of shipping the natural gas grade to the respective end customers.

Receivables department set the credit option for the low profile customers and the payment need to be collected from the end customer within 20 days from the date of delivery.

Blanket sale agreement will be issued to the Industrial End customers who require staggered shipments.

If the Grade8- Propane - Defense only , need to be shipped in the Sylvania , Natgeo gas adopts drop ship process from the few suppliers in the Cairo city to reduce the shipping cost and to meet the scheduled ship date.



They use the 3rd party tool ORDER_DYNAMICS for booking the order for regular orders ( excluding the Blanket and drop ship process). This needs to be integrated with the new package. Regular orders would/will be entered in the old ERP tool.

Booking and shipping process will be implemented in the new ERP package solution.





SCOPE: R12 Implementation Project for the Client Natgeo Gas

We will choose Oracle apps package solution to map the above process and build the rigid system which will help partner to smoothen their business flows as well as help the top management to keep eye on their financial aspects at any point of time.
ERP: Oracle e-Business suite Release 12
Nature: Implementation and Post go live support

Modules:
Area Modules Integration with existing system
Common Oracle Financials
Oracle Cash Management
BUY Oracle Procurement
Oracle Sourcing
Oracle Payables
Maintain Oracle Inventory
Oracle Enterprise Asset Management
Sell Oracle Order Management Yes (ORDER_DYNAMICS)
Oracle Receivables

Who Visited ?

R12 Accounting Setup details (Outline)

The ledger is a basic concept in Release 12. The ledger replaces the 11i concept of a set of books. It represents an accounting representation for one or more legal entities or for a business need such as consolidation or management reporting.

Companies can now clearly and efficiently model its legal entities and their accounting representations in Release 12. This seems to be a major area in getting success of the shared service center and single instance initiatives where many or all legal entities of an enterprise are accounted for in a single instance, and data, setup, and processing must be effectively secured but also possibly shared.

Now, legal Entities can be mapped to entire Ledgers or if you account for more than one legal entity within a ledger, you can map a legal entity to balancing segments within a ledger.

While a set of books is defined by 3 C's
1. chart of accounts
2. functional currency
3. accounting calendar,
The addition in this list the ledger is defined by a 4th C: the accounting method,

This 4th C allows you to assign and manage a specific accounting method for each ledger. Therefore, when a legal entity is subject to multiple reporting requirements, separate ledgers can be used to record the accounting information.

Accounting Setup Manager is a new feature that streamlines the setup and implementation of Oracle Financial Applications. The Accounting Setup Manager will facilitate the setup required for simultaneous accounting for multiple reporting requirements.

With the Accounting Setup Manager, you can perform and maintain the following common setup components from a central location:
* Legal Entities
* Ledgers, primary and secondary
* Operating Units, which are assigned to primary ledgers
* Reporting Currencies, which is an enhanced feature
* Subledger Accounting Options.
This is where you define the accounting methods for each legal entity subledger transaction and associate them to the ledger where the accounting will be stored. * Intercompany Accounts and Balancing Rules * Accounting and Reporting Sequencing * Both Intercompany and Sequencing.

Upgrading?
The upgrade creates a separate accounting setup for each primary ledger that is Upgraded from a set of books. The status of the accounting setup will be completed. Each accounting setup is a grouping of accounting-related setup components.
The following lists the Release 12 setup components and how the Release 11i features map to them:
• Legal Entities: HR Organizations classified as GRE/ LE in Release 11i will be preserved as Legal Entities in Release 12. Legal entities can be manually assigned to a ledger and balancing segment values can optionally be mapped to legal entities to help you identify transactions by legal entity during transaction and journal processing.

• One Primary Ledger: Most sets of books in Release 11i will become primary ledgers in Release 12.
• Operating Units: All HR Organizations classified as operating units will be Preserved in Release 12. If operating units are assigned to a set of books, then they will be associated to a primary ledger in an accounting setup. You can now view all operating units assigned to an upgraded primary ledger using Accounting Setup Manager.
• Reporting Currencies: Multiple Reporting Currency (MRC) reporting sets of books become reporting currencies in Release 12.
• Secondary Ledgers: Multiple-Posting set of books (Global Accounting Engine) will upgrade to secondary ledgers.
• Intra-company Balancing: Inter-company Accounts in Release 11i is renamed to intra-company Balancing Rules, a feature provided by the new Advanced Global Inter-Company System.
• Inter-company Accounts The Release 11i Global Inter-company System (GIS) will be Replaced by Advanced Global Inter-company System (AGIS).

Apps SCM Module Setup steps