Oracle Applications – Business & Technology

Entries from December 2008

I Wanted To Change The World

December 25, 2008 · Leave a Comment

An Inspirational Short Story with Wisdom
I Wanted To Change The World

By Unknown Monk, 1100 A.D.
When I was a young man, I wanted to change the world.I found it was difficult to change the world, so I tried to change my nation.
When I found I couldn’t change the nation, I began to focus on my town. I couldn’t change the town and as an older man, I tried to change my family.

Now, as an old man, I realize the only thing I can change is myself, and suddenly I realize that if long ago I had changed myself, I could have made an impact on my family. My family and I could have made an impact on our town. Their impact could have changed the nation and I could indeed have changed the world.”

 

 

 

Food For Thought:

“After you’ve done a thing the same way for two years, look it over carefully. After five years, look at it with suspicion. And after ten years, throw it away and start all over. ” Alfred Edward Perlman
“All changes, even the most longed for, have their melancholy; for what we leave behind us is a part of ourselves; we must die to one life before we can enter another.” Anatole France

“Growth is the only evidence of life.” John Henry Newman

“If nothing ever changed, there’d be no butterflies.” Author Unknown

“When we are no longer able to change a situation, we are challenged to change ourselves.” Victor Frankl

 

 

Categories: Managment · Messages
Tagged: , , , ,

Happy Festival Time and Year 2009

December 24, 2008 · 2 Comments

Happy New Year , Wishing to have a very good time on x’mas and New Year.

— best wishes from “KnowOracle” Team —

image’s credit belongs to –http://www.colorcubic.com/work/print/2009.php

Categories: Messages · Oracle Functional · Personal

Shivmohan – Oracle Financials

December 17, 2008 · 2 Comments

What is Oracle Financials?

 

Oracle Financials products provide organizations with solutions to a wide range of long- and short-term accounting system issues. Regardless of the size of the business, Oracle Financials can meet accounting management demands with:

Oracle Assets: Ensures that an organization’s property and equipment investment is accurate and that the correct asset tax accounting strategies are chosen.

Oracle General Ledger: Offers a complete solution to journal entry, budgeting, allocations, consolidation, and financial reporting needs.

Oracle Inventory: Helps an organization make better inventory decisions by minimizing stock and maximizing cash flow.

Oracle Order Management: Provides organizations with a sophisticated order entry system for managing customer commitments.

Oracle Payables: Lets an organization process more invoices with fewer staff members and tighter controls. Helps save money through maximum discounts, bank float, and prevention of duplicate payment.

Oracle Purchasing: Improves buying power, helps negotiate bigger discounts, eliminates paper flow, increases financial controls, and increases productivity.

Oracle Receivables:. Improves cash flow by letting an organization process more payments faster, without off-line research. Helps correctly account for cash, reduce outstanding receivables, and improve collection effectiveness.

Oracle Revenue Accounting Gives an organization timely and accurate revenue and flexible commissions reporting.

Oracle Sales Analysis: Allows for better forecasting, planning. and reporting of sales information.

Thanks , plz share your feedback / comments
Shivmohan Purohit

Categories: Application Developer · Knowledge Base · Oracle AP Functional · Oracle AR Functional · Oracle FA Functional · Oracle Functional · Oracle GL Functional · Oracle Inventory Functional · Oracle Technical · System Administrator
Tagged: , , , , , , ,

Keep the Spark – Get Inspired

December 17, 2008 · Leave a Comment

Keep the Spark

Inaugural Speech by Chetan Bhagat for the new batch at the Symbiosis BBA program 2008

Good Morning everyone and thank you for giving me this chance to speak to you. This day is about you. You, who have come to this college, leaving the comfort of your homes (or in some cases discomfort), to become something in your life. I am sure you are excited. There are few days in human life when one is truly elated.  The first day in college is one of them.  When you were getting ready today, you felt a tingling in your stomach. What would the auditorium be like, what would the teachers be like, who are my new classmates – there is so much to be curious about. I call this excitement, the spark within you that makes you feel truly alive today. Today I am going to talk about keeping the spark shining. Or to put it another way, how to be happy most, if not all the time.

 Where do these sparks start? I think we are born with them. My 3-year old twin boys  have a million sparks. A little Spiderman toy can make them jump on the bed. They get thrills from creaky swings in the park. A story from daddy gets them excited. They do a daily countdown for birthday party – several months in advance – just for the day they will cut their own birthday cake.

 I see students like you, and I still see some sparks. But when  I see older people,  the spark is difficult to find. That means as we age, the spark fades. People whose spark has faded too much are dull, dejected, aimless and bitter. Remember Kareena in the first half of Jab We Met vs the second half? That is what happens when the spark is lost.   So how to save the spark?

Imagine the spark to be a lamp’s flame. The first aspect is nurturing – to give your spark the fuel, continuously. The second is to guard against storms.

 To nurture, always have goals. It is human nature to strive, improve and achieve full potential. In fact, that is success. It is what is possible for you. It isn’t any external measure – a certain cost to company pay package, a particular car or house.

Most of us are from middle class families. To us, having material landmarks is success and rightly so. When you have grown up where money constraints force everyday choices, financial freedom is a big achievement.

 But it isn’t the purpose of life. If that was the case, Mr Ambani would not show up for work. Shah Rukh Khan would stay at home and not dance anymore. Steve Jobs won’t be working hard to make a better iPhone, as he sold Pixar for billions of dollars already. Why do they do it? What makes them come to work everyday?

They do it because it makes them happy. They do it because it makes them feel alive. Just getting better from current levels feels good. If you study hard, you can improve your rank. If you make an effort to  interact with people, you will do better in interviews. If you practice, your cricket will get better. You may also know that you cannot become Tendulkar, yet. But you can get to the next level. Striving for that next level is important.

Nature designed  with a random set of genes and circumstances in which we were born. To be happy, we have to accept it and make the most of nature’s design. Are you? Goals will help you do that.

I must add, don’t just have career or academic goals. Set goals to give you a balanced, successful life. I use the word balanced before successful. Balanced means ensuring your health, relationships, mental peace are all in good order.

There is no point of getting a promotion on the day of your breakup. There is no fun in driving a car if your back hurts. Shopping is not enjoyable if your mind is full of tensions. 

 You must have read some quotes -  Life is a  tough race, it is a marathon or whatever. No, from what I have seen so far, life is one of those races in nursery school. Where you have to run with a marble in a spoon kept in your mouth. If the marble falls, there is no point coming first. Same with life, where health and relationships are the marble. Your striving is only worth it if there is harmony in your life. Else, you may achieve the success, but this spark, this feeling of being excited and alive, will start to die.

 One last thing about nurturing the spark – don’t take life seriously. One of my yoga teachers used to make students laugh during classes. One student asked him if these jokes would take away something from the yoga practice. The teacher said  – don’t be serious, be sincere. This quote has defined my work ever since. Whether its my writing, my job, my relationships or any of my goals. I get thousands of opinions on my writing everyday. There is heaps of praise, there is intense criticism. If I take it all seriously, how will I write? Or rather, how will I live? Life is not to be taken seriously, as we are really temporary here. We are like a pre-paid card with limited validity. If we are lucky, we may last another 50 years. And 50 years is just 2,500 weekends. Do we really need to get so worked up? It’s ok, bunk a few classes, goof up a few interviews, fall in love. We are people, not programmed devices.

 I’ve told you three things – reasonable goals, balance and not taking it too seriously that will nurture the spark. However, there are four storms in life that will threaten to completely put out the flame. These must be guarded against. These are disappointment, frustration, unfairness and loneliness of purpose.

 Disappointment will come when your effort does not give you the expected return. If things don’t go as planned or if you face failure. Failure is extremely difficult to handle, but those that do come out stronger. What did this failure teach me? is the question you will need to ask. You will feel miserable. You will want to quit, like I wanted to when nine publishers rejected my first book. Some IITians kill themselves over low grades – how silly is that? But that is how much failure can hurt you.

But it’s life. If challenges could always be overcome, they would cease to be a challenge. And remember – if you are failing at something, that means you are at your limit or potential. And that’s where you want to be.

 Disappointment’s cousin is  frustration, the second storm.  Have you ever been frustrated? It happens when things are stuck. This is especially relevant in India. >From traffic jams to getting that job you deserve, sometimes things take so long that you don’t know if you chose the right goal. After books, I set the goal of writing for Bollywood, as I thought they needed writers. I am called extremely lucky, but it took me five years to get close to  a release.

Frustration saps excitement, and turns your initial energy into something negative, making you a bitter person. How did I deal with it? A realistic assessment of the time involved – movies take a long time to make even though they are watched quickly, seeking a certain enjoyment in the process rather than the end result – at least I was learning how to write scripts  , having a side plan – I had my third book to write and even something as simple as pleasurable distractions in your life  – friends, food, travel can help you overcome it. Remember, nothing is to be taken seriously. Frustration is a sign somewhere, you took it too seriously.

 Unfairness – this is hardest to deal with, but unfortunately that is how our country works. People with connections, rich dads, beautiful faces, pedigree find it easier to make it – not just in Bollywood, but everywhere. And sometimes it is just plain luck. There are so few opportunities in India, so many stars need to be aligned for you to make it happen. Merit and hard work is not always linked to achievement in the short term, but the long term correlation is high, and ultimately things do work out. But realize, there will be some people luckier than you.

In fact, to have an opportunity to go to college and understand this speech in English means you are pretty darn lucky by Indian standards. Let’s be grateful for what we have and get the strength to accept what we don’t. I have so much love from my readers that other writers cannot even imagine it. However, I don’t get literary praise. It’s ok. I don’t look like Aishwarya Rai, but I have two boys who I think are more beautiful than her. It’s ok. Don’t let unfairness kill your spark.

 Finally, the last point that can kill your spark is isolation. As you grow older you will realize you are unique. When you are little, all kids want Ice cream and Spiderman. As you grow older to college, you still are a lot like your friends. But ten years later and you realize you are unique. What you want, what you believe in, what makes you feel, may be different from even the people closest to you. This can create conflict as your goals may not match with others. . And you may drop some of them. Basketball captains in college invariably stop playing basketball by the time they have their second child. They give up something that meant so much to them. They do it for their family. But in doing that, the spark dies. Never, ever make that compromise. Love yourself first, and then others.

 There you go. I’ve told you the four thunderstorms – disappointment, frustration, unfairness and isolation. You cannot avoid them, as like the monsoon they will come into your life at regular intervals. You just need to keep the raincoat handy to not let the spark die.

 I welcome you again to the most wonderful  years of your life. If someone gave me the choice to go back in time, I will surely choose college. But I also hope that ten years later as well, you eyes will shine the same way as they do today. That you will Keep the Spark alive, not only through college, but through the next 2,500 weekends. And I hope not just you, but my whole country will keep that spark alive, as we really need it now more than any moment in history. And there is something cool about saying – I come from the land of a billion sparks.

 Thank You.

Categories: Managment
Tagged: , , , ,

Oracle Property Manager

December 17, 2008 · 1 Comment

Oracle Property Manager – An Overview

The management of a property portfolio from a corporate or commercial perspective is a responsible and often time consuming task. With the high value and volume of transactions often involved, it is critical that this area of a business is managed in an efficient way using tight controls.

Oracle´s Property Manager module provides organisations with the tools to improve the management processes of both their internal or external property portfolios. From a corporate management perspective, Oracle Property Manager provides tools to map and visualise internal floor space, allowing organisations to manage occupancy and determine under-utilised floor space. Further functionality ensures that occupants can be charged based on occupancy, whether this is to internal or third party occupants.

From a commercial perspective, Oracle Property Manager provides functionality to maintain and track property leases. Full integration with Oracle´s Accounts Payable and Accounts Receivable modules ensures that payments to landlords or bills to tenants can be generated in a timely and efficient manner and that any rental increases can be handled automatically.

Categories: Oracle Functional

CareerFruits – A Good Initiative

December 14, 2008 · Leave a Comment

CareerFruits – A Good Initiative

I came across this good website, which provides free education on technical subjects, management subjects, career guidance, theory subjects for class X to XII. Watch out this site for more….

A snippet from CareerFruits website blog.

“I intend to write this blog to highlight how one should get benefited from the home computer. Home PC is one of the most common things in today’s world. I see that people use PCs just to create word docs, ppts or may be for some accounting software. The rest of the time goes on Internet searching for things. Most parents think that computer will empower their Kids to learn better and do good in their studies. This is not always true. Kids are spending most of their time with Social Networking Sites like Orkut and Facebook – in competition to get more scraps to each other. This kills the time like anything.

We have started CareerFruits in the motive of providing quality education at the finger tips of a PC user. We want you to realize that time is not going to come again. Whatever you spent, its gone. So think carefully and use the resources to shape your future. We invite you all to join our efforts and get benefited from what we have. Provide suggestions and help us get better everyday. Ask your kids to join our classes, get help from our experts and do whatever it takes to get a good career, good marks, good grades in exams.”

——————————————

thanks – Shivmohan

Categories: Managment
Tagged: , , , , ,

Oracle Business Accelerators for EBS

December 13, 2008 · Leave a Comment

 

Oracle has – after a long wait – released the new set of tools called Oracle Business Accelarators, for eBusiness Suite.

What are Accelarators:

Accelarators, as per Oracle, are the next generation tools for rapid and precise implementation. They Automatically configure the EBS Flows based on leading industry practices. These accelarators user a highly structured, prescribed method reducing impact due to varying implementation skills.

As of now, Accelarators are only available to trained Oracle Partners and Oracle Consulting.

To know more about these tools and to get trainined in them, you may visit https://accelerators.oracle.com/

 

Categories: Apps Add-in Tools · General Technical · Oracle Applications Technical
Tagged: ,

Oracle General Ledger and Budgeting

December 12, 2008 · Leave a Comment

 

What is planning budget ?

The plan for the future expenses is planning budget. It is a paper work. There is no funds requirement. It does not require journals. There are no restrictions for estimating of funds. It is a budget through which you cannot exercise budgetary control. But u can compare your actual with budgets through inquiry window.

What is Consolidation in GL?

It Consolidates the Subsidiaries & Parent financial information. At a point of time we can check the Performance of the Companies overall Performance. When we have multiple setup and combine primary and secondary books getting the financial reports is called consolidation We will use consolidation reports at the time of period end closing Consolidation is the Process of combining the Financial results of different companies typically combining subsidiary accounting information into a parent company.The main purpose of consolidation is for reporting purpose. Consolidation is the period-end process of combing the financials of separate subsidiary with the pay rent company to from single ,combine statement of final result consolidation is one of the reporting tool.consolidation may map the subsidiary set of books to parent set of books, even if the set of books values are different using segment rule,accounting rule It is the process of combining the financial results of multiple companies into one financial statement the company may have different sobs in different countries,so we will collect all the financialtransactions(sob) in to one set of book ,that is parent sob then the company easely findout all the finacial year endingresullts in their functional curency,that purpose multiple companies are using consolidation I think consolidation can be done with two ways that is FSG, GCSÂ for FSG it can be done when both parent SOB and Subsidary SOB have Currency, Calender, COA, same then we go for FSG.In Global consolidation System currency, coa, calender are different in parent sob and subsidary sob we have to go for GCS.I am Saikrishna actaully I am pursuing my oracle financials in hyd i just completed one of my module GL institute.

How to import data to General Ledger by Feeder System ?
There are three ways:
 

 

1- You can upload Journal Entries using ADI (Application Desktop Integrator) functionality. ADI is used to interface spreadsheet uploads with Oracle applications data. ADI allows users take advantage of many of the data-entry shortcuts of a spreadsheet, such as copying and pasting cells, dragging and dropping ranges of cells and using formulas to calculate journal line amounts. ADI validates the data entered against the accounts, security rules and reference information that are defined in the General Ledger (GL).

2- Using Journal Import, we can bring the data from the feeder system; to import the Transactions from External Feeder Systems following are the steps-1. Populate the data from External system to GL_Interface table (GL_INTERFACE table acts like a bridge between the external system and the Oracle General Ledger Base tables where journals are stored). 2. Run the Journal Import process to import the date to base tables (Errors in Journal Import are listed in Execution Report)
 

 

3. From any sub module run individual module transfer to GL program Ex: Payables transfer to General Ledger

After creating Journal Source how do we approve to the specific Set of Books ?

To approve journals from specific source, while creating the source ‘Require Journal Approval’ check box should be enabled. To approve all the journals that come from different sources In the Set Of Books window under ‘Journaling’ tab ‘journal approval’ should be enabled.

While creating combination of accounts what is the use of PRESERVED check box ?

If we check preserve for a account code combination then even if you disable this account segment value, the inherited (parent. child) segment values will not be disabled. If it is unchecked all the related segment values will be disabled. Preserved check box will help you to retain the original character of the General Ledger code combination, even after u change the nature of the segments during maintenance of the GLCC.

What is the MD form 50 ?

MD50 is a Functional design document, designed by the functional consultant. After interacting with the client, functional consultant will prepare this document. In this we will compare the present business process and client requirement. It is mainly used for Application Extensions and Interface functional design.

What are the journal entries in Procure to Pay Cycle ?

When the Material Received at the Gate-

Receiving Accrual A/C — DrMaterial AP Accrual A/C — Cr
 

 

 

When the Material delivered to The Inv Org Material

A/c Dr Purchase Price Variance A/c Dr Receiving A/c Cr

When the Invoice Is enterd into the Payable with Matching Of PO Material

Ap Accrual A/c Dr Invoice Price Variance A/c Dr AP Liability A/c Cr

Material Receipt

Receiving Accural Dr AP Accural Cr

On completion on inspection and accepting of goods

Inventory Dr Receiving Accural Cr The Above given 2 entries are in PO module

On entering Invoice in AP

AP Accural Dr Accounts Payable Cr

On Making payment

Accounts Payable Dr   Cash/Bank Cr 1. On Entry of PO ________ No accounting impact On Material

On Payment

Accounts Payable Dr’ Cash/Bank Cr

When we raise the Purchase Order entry 

Material in transit a/c Dr To AP Accrual A/c

 

Thanks – Shivmohan

 

Categories: Interview Questions · Oracle GL Functional · Oracle GL Technical
Tagged: , , , , , , , , , ,

OCP Advisor – Mohan Dutt

December 10, 2008 · 4 Comments

Name

Mohan Dutt, a.k.a. OCP Advisor

Expertise

Oracle 11i, Oracle R12, Project Management

Organization

Oracle, Hyperion, PwC and a few others

Contacts

Email: ocp.advisor@gmail.comhttp://ebizocp.blogspot.com  

Blog:

Site : www.mohandutt.com

1.      Tell something about you, your professional experience/ background, past assignment, Interests.

Ans: Started my professional career in exports for a global electrical power equipment manufacturer. Those were exciting times when software companies like Oracle were launching an integrated application to address all the operations of a global company. I joined the consulting practice of Pricewaterhouse Coopers. PwC was perhaps the Oracle consulting organization at that time. Later I joined an Oracle Advantage Partner. About four years ago, I joined Hyperion and today I am part of the Oracle ecosystem.

2.      Please share any of your Oracle work related professional /project experience.

Ans:  For more than a decade, I have implemented, upgraded, migrated, managed and supported various releases of Oracle E-Business Suite from 10.7 to 12. I was fortunate to work in global implementations on a single global instance for multiple projects. Oracle Release 12 addresses many of the requirements that I came across the projects over the years and would highly recommend to any organization planning to scale their operations globally without worrying about their enterprise application scalability.

3.      What would be your recommendation for Oracle Applications/ Financials professional in regard to available certification paths? Also what are pre-requisite for any of 11i or R12 Certification

Ans: There are several certification options for the Oracle E-Business Suite professionals. Oracle offers Oracle Certified Expert track and Oracle Certified Professional tracks. Based on an individual’s work experience and expertise, one can choose their certification roadmap. The certification exams ask real-life case study based questions and hence an expert knowledge level for the application module (e.g. General Ledger, Payables, Receivables etc) is required.  Certification is the recognition of one’s superior skill and expertise. Hence, I encourage individuals to get certified through this globally recognized credential. Certification opens new doors and also provides an implicit assurance to your clients or users of your professional ability.

4.      Please advise how an individual interested in Oracle Applications related certification, i.e. Payables, how she/he should go for it i.e study material, duration, practice etc

Ans: As mentioned in my previous answer, it is assumed that the individual has working knowledge and exposure to the application. Oracle University provides instructor led training (ILT) classes for each of the modules. Attending an ILT class would help one get a very good idea about the exam content since the exams are based on the courses. In case one is already an expert implementer or power user, only a quick revision of the exam content topics is necessary. For this profile of candidates, I have recommended reviewing the Oracle Tutor documents. Oracle Tutor documents are available as patch downloads on Metalink. Both the ILT student guides and Oracle Tutor documents have practice exercises that reinforce the module concepts. In case one is not confident about a specific exam topic I would suggest a review of the Oracle user guide and implementation guide for the module. Lastly, I would recommend the #1 habit for highly successful OCP individuals – read the EBS OCP blog as often as you can! There are practice questions that one can answer and evaluate one’s exam preparedness.

5.      You have received lots of recognition and accolades; please share some information about those.

Ans: I have been working closely with the Oracle Applications community for a decade now. I have participated in many roles at the Oracle Application User Group (OAUG) over the years. It was a pleasant surprise to be recognized in 2007 as the Member of the Year for my contributions. Today, I continue to participate in various forums and engage in conversation (offline and online) with Oracle professionals from all around the world. I hope to continue my self-described role as an Oracle Applications Evangelist in the future too.

6.      Need your view on terms Functional, Technical and Techno-Functional. How you think these have relevance. Do techno-functional professional real advantageous or it is kind of overlapping.

Ans: An individual’s education background typically determines their intial role – functional or technical. For example, with an accounting background one would probably start as an end user or implementer in a functional role. As one adds experience across projects and over the years, an individual becomes more techno-functional with the relative percentages depending on their interest and expertise. To be a solution expert as an implementor or any super user, one has to pick up both functional as well as technical knowledge. So I feel for further career advancement, one should pick up both the skills. In a senior position, one is assumed to have both the skill sets to architect any solution.

7.      Your advice/ Suggestion for Oracle Technical and Functional Professions

Ans: We are fortunate to be working on Oracle technologies, which are always the leading edge, and with a complete roadmap for any enterprise and business. This is also a time for introduction of new platforms and tools. As a professional in the Oracle space, focus on upgrading your skills to the latest releases and tools. Once you have gained expertise, have a plan for certification because that also serves as a measurable goal for your personal growth.

8.      Your feedback on Knoworacle.wordpress.com

Ans: Knoworacle.wordpress.com is an excellent blog that explains Oracle application concepts in a very lucid and interesting manner. Subscribe to the blog and read the posts everyday. We are very lucky to have blogs like knoworacle teaching us the finer points of the application. Learning never stops till you knoworacle.

9.      Please any additional questions/ thoughts from your sides

Ans: Thank you very much for the opportunity to speak to your blog readers. Once again, I encourage all Oracle certification aspirants to visit the #1 ranked (on Google search) blog on certification topics. Best of Luck from your OCP Advisor!

Disclaimer:  Opinions expressed by the OCP Advisor is entirely his own and do not reflect the position of Oracle or any other corporation. Any advice or recommendations discussed are not validated by Oracle.

Thanks – Shivmohan Purohit ( knoworacle.wordpress.com )    

Categories: General Technical · Oracle Applications Technical · SME Interview · Subject Matter Experts
Tagged: , , , , , , ,

Oracle Timecard (OTL) Automation

December 8, 2008 · Leave a Comment

Recently i have seen many requests for OTL timecard automations in Oracle. One of the reasons is the financial downturn in the martket.

Many companies have announced furlough for employees- meaning the offices and manufacturing units will be shutdonw for a specified amount of time and it will be mandatory for employees to either take that time off from their vacation time, flex time, may be borrow it from next year or simply be unpaid for that time period. Whatever be the case, it saves company a lot of money that it was otherwise obligated to pay in vacation time or paid days. Now because its mandatory, it has to be in the system for the payroll to pick it up.

If the organization uses time entry system – like oracle – to enter vacation/flex time, and processes payroll then following needs to happen in order for a succesfull furlough automation.

- Employees time must be entered on the online timecard.

- The timecard must be approved by manager or Auto-approval process.

- This OTL timecard must be transferred to Batch Element Entries for Payroll.

To automate this process we will use HXC Timecard APIs provided by Oracle. These APIs help us in creating a timecard for a day, week, and also attach elements/ projects to the timecard. Also, the APIs submit the timecard with a workflow process type so it can either be picked for AUTO processing or Manual approval.

Before we go into the details, we have to see how a typical timecard is built. For the sake of simplicity, we will consider Monthly Paid (exempt) employees.

A timecard is a combination of DAYS. Each DAY will be one Row in a table. For Every day that you need to enter time (e.g. Saturday Sunday will not need a time entry being a holiday) you need a DETAIL type row also. And, for each DETAIL record that has to go into an element or project for costing or payroll purpose, we need an ATTRIBUTE also.

These are nothing but the TIME BUILDING BLOCKS. To make things simple, lets go and see these records:

select * from hxc_time_building_blocks

TYPE: MEASURE ( Number of hours to be put in that particular day) or RANGE (For period like week or day).
SCOPE: TIMECARD, DAY, DETAIL or APPLICATION_PERIOD

Now, if you see a typical timecard, this is how it looks (Use the hierarchical Query below):

TIMECARD (12/1/2008  - 12/7/2008) TYPE: RANGE
               |_  DAY (12/1/2008 – 12/1/2008) TYPE: RANGE
                                    |_  DETAIL (12/1/2008):  8 HRS   (may have attributes)  TYPE:MEASURE
               |_  DAY (12/2/2008 – 12/2/2008)
                                    |_  DETAIL (12/2/2008):  8 HRS                                                      
               |_  DAY (12/3/2008 – 12/3/2008)
                                    |_  DETAIL (12/3/2008):  8 HRS                                                      
               |_  DAY (12/4/2008 – 12/4/2008)
                                    |_  DETAIL (12/4/2008):  8 HRS                                                      
               |_  DAY (12/5/2008 – 12/5/2008)
                                    |_  DETAIL (12/5/2008):  8 HRS                                                      
               |_  DAY (12/6/2008 – 12/6/2008)
               |_  DAY (12/7/2008 – 12/7/2008)

 SELECT htbb.time_building_block_id, htbb.TYPE, htbb.measure, htbb.unit_of_measure, htbb.start_time, htbb.stop_time,htbb.parent_building_block_id, ‘N’ parent_is_new, htbb.SCOPE,htbb.object_version_number, htbb.approval_status,htbb.resource_id, htbb.resource_type, htbb.approval_style_id,htbb.date_from, htbb.date_to, htbb.comment_text,htbb.parent_building_block_ovn, ‘N’ NEW, ‘N’ changed,htbb.application_set_id, htbb.translation_display_key
FROM apps.hxc_time_building_blocks htbb START WITH ( htbb.time_building_block_id in (6848088) AND htbb.object_version_number in () )CONNECT BY PRIOR htbb.time_building_block_id =  htbb. parent_building_block_id AND PRIOR htbb.object_version_number = htbb.parent_building_block_ovn ORDER BY htbb.time_building_block_id  ASC

NOW Over to APIs….

 

 

 

 

 

 hxc_timestore_deposit.create_timecard_bb 
– Create a Timecard building block (only timecard, no days, or details)
– Here are the parameters it takes
(
   p_start_time => to_date(‘01-DEC-2008 00:00:00′,’DD-MON-YYYY HH24:MI:SS’) ,
   p_stop_time =>  to_date(‘07-DEC-2008 23:59:59′,’DD-MON-YYYY HH24:MI:SS’),
   p_resource_id => emp.person_id ,
   p_comment_text => ‘Automated TimeCard: DEC08′,
   p_approval_style_id => 41, –This is your workflow approval style, default to AUTO APPROVE
   p_app_blocks => l_tbl_timecard_info,
   p_time_building_block_id => l_tc_bb_id –returns the id of  TC Building block
   );

hxc_timestore_deposit.create_day_bb
– Creates a DAY building block (only DAY no details)
– Here are the parameters it takes
(
   p_day => l_start_date,
   p_parent_building_block_id => l_tc_bb_id,
   p_comment_text => ‘Automated TimeCard: DEC08′,
   p_app_blocks => l_tbl_timecard_info,
   p_time_building_block_id => l_day_bb_id
   );

hxc_timestore_deposit.create_detail_bb
– Creates a DETAIL building block, in next step we have to attach the attribute to this DETAIL
– Here are the parameters it takes
(
   p_type => ‘MEASURE’,
   p_measure => 8, –Number of Hours
   p_parent_building_block_id => l_day_bb_id,
   p_comment_text => ‘Automated TimeCard: DEC08′,
   p_app_blocks => l_tbl_timecard_info,
   p_app_attributes => l_tbl_attributes_info,
   p_time_building_block_id => l_detail_bb_st_id
   );
   hxc_timestore_deposit.create_attribute (
   p_building_block_id=> l_detail_bb_st_id,
   p_attribute_name=> ‘Dummy Element Context’,
   p_attribute_value=> ‘ELEMENT – 60110′, –This is the Accrual PTO Element we want to update through this API.
   p_app_attributes=> l_tbl_attributes_info);

HXC_TIMESTORE_DEPOSIT.EXECUTE_DEPOSIT_PROCESS
–This is the Submission Call. This process will submit the timecard, days and details with attributes. Timecard will stay in SUBMITTED State until approved via Manual or AUTO Approve process.
(
   p_validate => FALSE,
   p_app_blocks => l_tbl_timecard_info,
   p_app_attributes => l_tbl_attributes_info,
   p_messages => l_tbl_messages,
   p_mode => ‘SUBMIT’,
   p_deposit_process => ‘OTL Deposit Process’,
   p_retrieval_process => ‘BEE Retrieval Process’,
   p_timecard_id => l_new_timecard_id,
   p_timecard_ovn => l_new_timecard_ovn
   );

 

Hope this article helped you in understanding the basics of the Time Entry APIs. Please note that this is  the initial and basic knowledge. You will need some more knowledge – like DELETE timecards API for rollback in case of any issues. UPDATE timecard APIs etc for a full fledge capability on OTL timecard automation.

Categories: Oracle Functional

Oracle Fixed Assets Useful Tables

December 8, 2008 · 4 Comments

Hello Friends , here is some of quite commonly used FA (Fixed Assets) tables and their usage. There are many other tables also in FA but here i am putting only few commonly used tables. for other table if needed we can dig furthur. Let go through below article and let me know if it useful.

1- FA_DEPRN_PERIODS
2- FA_DEPRN_SUMMARY
3- FA_ADDITIONS_B

4- FA_BOOKS

5- FA_CATEGORIES_B

6- FA_DEPRN_DETAIL

FA_DEPRN_PERIODS contains information about your depreciation periods. Oracle Assets uses this table to determine when each period in FA_CALENDARS was open for a depreciation book. PERIOD_OPEN_DATE and PERIOD_CLOSE_DATE are the dates when you opened and closed each book’s depreciation period. Each time you run the depreciation program, it closes the current period by setting PERIOD_CLOSE_DATE to the system date. It also opens the next period by inserting a new row into this table in which PERIOD_CLOSE_DATE is NULL and PERIOD_OPEN_DATE equals the PERIOD_CLOSE_DATE of the old row. CALENDAR_PERIOD_OPEN_DATE and CALENDAR_PERIOD_CLOSE_DATE correspond to your calendar as defined by the START_DATE and END_DATE columns in FA_CALENDAR_PERIODS.

FA_DEPRN_SUMMARY contains depreciation information for your assets. Each time you run the depreciation program, it inserts one row into thistable for each asset. PERIOD_COUNTER is the period for which you ran the depreciation program. DEPRN_AMOUNT is the depreciation expense for an asset in a depreciation period. It is the sum of DEPRN_AMOUNT in all the rows of FA_DEPRN_DETAIL for the asset and period. YTD_DEPRN is the accumulated depreciation of an asset for the current fiscal year as of the end of this period. DEPRN_RESERVE is the total accumulated depreciation for this asset. DEPRN_SOURCE_CODE tells you what program created the row BOOKS Created by the Depreciation Books form, Quick Additions form, or the post mass additions program when you enter a new asset. DEPRN Created by the depreciation program when you run depreciation. ADJUSTED_COST is the depreciable basis the depreciation program uses to calculate depreciation for an asset in a depreciation period. This value is the same as the asset’s recoverable cost, except for assets that use a diminishing value depreciation method, assets to which you have made an amortized adjustment, and assets you have revalued.

For assets that use a diminishing value method, the ADJUSTED_COST is the beginning of year net book value, which the depreciation program updates at the start of each fiscal year. When you perform an amortized adjustment on an asset or revalue it, the ADJUSTED_COST becomes the asset’s net book value at the time of the adjustment or revaluation. BONUS_RATE is the bonus rate that Oracle Assets adds to the adjusted rate to give you the flat rate for the fiscal year. The depreciation program uses this rate to calculate depreciation for an asset. This only applies to assets that use both a flat–rate depreciation method and bonus depreciation.

FA_ADDITIONS_B contains descriptive information to help you identify your assets. Oracle Assets does not use this table to calculate depreciation.When you add an asset, Oracle Assets inserts a row into this table and into FA_ASSET_HISTORY. When you change the asset information stored in this table, Oracle Assets updates it in this table. It also creates a new row in FA_ASSET_HISTORY. When you perform a unit retirement, Oracle Assets reduces the CURRENT_UNITS by the units retired. UNIT_ADJUSTMENT_FLAG is set to YES by the Additions form if you change the number of units for an asset. The Transfers form resets it to NO after you reassign the remaining units. FA_ADJUSTMENTS stores information that Oracle Assets needs to create journal entries for transactions. The posting program creates journal entries for regular depreciation expense from information in FA_DEPRN_DETAIL. Oracle Assets inserts a row in this table for the debit and credit sides of a financial transaction. All the rows for the same transaction have the same value in the TRANSACTION_HEADER_ID column. The SOURCE_TYPE_CODE column tells you which program created the adjustment:

- ADDITION Depreciation program
- ADJUSTMENT Expensed or Amortized Adjustment User Exit

- CIP ADDITION Depreciation program

- CIP ADJUSTMENT Expensed or Amortized Adjustment User Exit

- CIP RETIREMENT Gain/loss program

- DEPRECIATION Depreciation program (Retroactive transactions andexpensed depreciation adjustments)

- RETIREMENT Gain/loss program

- RECLASS Reclassification user exit

- TRANSFER Transfers form

- TAX Reserve Adjustments form

- REVALUATION Mass revaluation program

The ADJUSTMENT_TYPE column tells you which type of account Oracle Assets adjusts. DEBIT_CREDIT_FLAG is DR if the amount is a debit and CR if the amount is a credit. ADJUSTMENT_AMOUNT is the amount debited or credited to the account. ANNUALIZED_ADJUSTMENT is the adjustment amount for a period times the number of periods in a fiscal year. The depreciation program uses it to calculate the depreciation adjustment for an asset when you perform multiple retroactive transactions on the asset. Oracle Assets calculates ADJUSTMENT_PER_PERIOD by dividing the ADJUSTMENT_AMOUNT for a retroactive transaction by the numberof periods between the period you entered the transaction and the period that it was effective. For current period transactions, this columnis zero. PERIOD_COUNTER_CREATED IS the period that you entered the adjustment into Oracle Assets. PERIOD_COUNTER_ADJUSTED is the period to which the adjustment applies. It is the same as PERIOD_COUNTER_CREATED, unless you enter a reserve adjustment, in which case PERIOD_COUNTER_ADJUSTED is the last period of the fiscal year to which the adjustment applies. CODE_COMBINATION_ID indicates the Accounting Flexfield combination Oracle Assets debits or credits for all transactions except reclassifications and intercompany transfers. This CODE_COMBINATION_ID is generated using the Account Generator, and the posting program does not perform any further processing.

 

FA_BOOKS contains the information that Oracle Assets needs to calculate depreciation. When you initially add an asset, Oracle Assets inserts one row into the table. This becomes the ”active” row for the asset. Whenever you use the Depreciation Books form to change the asset’s depreciation information, or if you retire or reinstate it, Oracle Assets inserts another row into the table, which then becomes the new ”active” row, and marks the previous row as obsolete.

At any point in time, there is only one ”active” row in the table for an asset in any given depreciation book. Generally, Oracle Assets uses the active row, but if you run a report for a prior accounting period, Oracle Assets selects the row that was active during that period. You can identify the active row for anasset in a book because it is the only one whose DATE_INEFFECTIVE and TRANSACTION_HEADER_ID_OUT are NULL. When Oracle Assets terminates a row, the DATE_INEFFECTIVE and TRANSACTION_HEADER_OUT are set to the DATE_EFFECTIVE and TRANSACTION_HEADER_IN of the new row, respectively. This means that you can easily identify rows affected by the same transaction because they have the same DATE_EFFECTIVE / DATE_INEFFECTIVE and TRANSACTION_HEADER_ID_IN / TRANSACTION_HEADER_ID_OUT pairs.When Oracle Assets creates the new row, the value used for the TRANSACTION_HEADER_ID_IN column is the same as the TRANSACTION_HEADER_ID in the row inserted into FA_TRANSACTION_HEADERS, and the DATE_EFFECTIVE is the system date. When you retire an asset, Oracle Assets inserts a new row to reduce the COST by the amount retired. When you reinstate an asset, Oracle Assets inserts a new row to increase the COST by the COST_RETIRED in the corresponding row in FA_RETIREMENTS.RATE_ADJUSTMENT_FACTOR is originally 1. It is used to spread depreciation over the remaining life of an asset after an amortization or revaluation. If you perform a revaluation or an amortized adjustment, Oracle Assets resets the Rate Adjustment Factor to prorate the remaining recoverable net book value over the remaining life. This fraction is calculated as [Recoverable Cost – what Depreciation Reserve would be]/Recoverable Cost. The depreciation program uses this value to adjust the depreciation rate for an asset.

FA_CATEGORIES_B stores information about your asset categories. This table provides default information when you add an asset. The depreciation program does not use this information to calculate depreciation.The Asset Categories form inserts one row in this table for each asset category you define. The Application Object Library table FND_ID_FLEX_SEGMENTS stores information about which column in this table is used for each segment.

FA_DEPRN_DETAIL contains the depreciation amounts that the depreciation program charges to the depreciation expense account in each distribution line.

Oracle Assets uses this information to create depreciation expense journal entries for your general ledger.The depreciation program inserts one row per distribution line for an asset each time you run depreciation.
For example, if you assign an asset to two different cost centers, the depreciation program inserts two rows in this table for the asset. DEPRN_AMOUNT is the amount of depreciation expense calculated forthis distribution line.YTD_DEPRN is the year–to–date depreciation allocated to thisdistribution line.When you add an asset, Oracle Assets inserts a row into this table for the period before the current period. This row has the asset cost in the ADDITION_COST_TO_CLEAR column and a DEPRN_SOURCE_CODE of ’B’. This column is used for reporting on new assets. When you run depreciation, Oracle Assets transfers the cost to the COST column in the current period row, this row has a DEPRN_SOURCE_CODE of ’D’.

 

 

Thanks – Shivmohan Purohit

Categories: Application Developer · Oracle Applications Technical · Oracle FA Functional · Oracle Fixed Assets Technical
Tagged: , , , , , , ,

Data flow for Order-to-Cash cycle

December 8, 2008 · 10 Comments

Data flow for Order-to-Cash cycle  

Hello friends, here we are having one of the contribution from “Devendra Gulve” , very precise and useful explaination on O2C cycle. hope this be helpful to you.

For more details please visit http://functionalguy.blogspot.com

 

1. Order Entry 
This is first stage, When the order is entered in the system, it creates a record in order headers and Order Lines table.

  • Enter header details: Once you enter details on the order header and save it or move it to lines, record goes to one table oe_order_headers_all
    • No record exists in any other table for this order till now.
  • Enter Line details for this order: Enter different item numbers, quantity and other details in line tab. When the record gets saved, it goes to one table. Order header details will be linked with line details by order HEADER_ID.

2. Order Booking 
This is next stage, when Order is booked then the Flow status changed from Entered to Booked. At this stage, these below table get affected.

  • oe_order_headers_alL
  • oe_order_lines_all
  • wsh_delivery_details
  • wsh_delivery_assignments

*In shipping transaction form order status remains “Ready to Release”.

At the same time, Demand interface program runs in background and insert into inventory tables mtl_demand.

3. Reservation 
This step is required for doing reservations SCHEDULE ORDER PROGRAM runs in the background and quantities are reserved. Once this program get successfully get completed, the mtl_demand and mtl_reservations table get updated.

4. Pick Release 
Pick Release is the process of putting reservation on on-hand quantity available in the inventory and pick them for particular sales order.

Pick release can be done from ‘Release Sales Order’ form or ‘Pick release SRS’ program can be scheduled in background. In both of these cases all lines of the order gets pick released depending on the Picking rule used. If specific line/s needs to be pick release it can be done from ‘Shipping Transaction form. For this case Pick Release is done from ‘Release Sales Order’ form with Pick Confirm=NO. 
Once pick release is done these are the tables get affected:

  • If step 3 is not done then MTL_RESERVATIONS gets updated now.
  • wsh_new_deliveries
  • wsh_delivery_assignments
  • wsh_delivery_details
  • MTL_TXN_REQUEST_HEADERS
  • MTL_TXN_REQUEST_LINES
  • Mtl_material_transactions_temp
  • MTL_SERIAL_NUMBERS_TEMP
  • MTL_SERIAL_NUMBERS

*In shipping transaction form order status remains “Released to Warehouse” and all the material still remains in source sub-inventory. We need to do Move Order Transaction for this order. Till this no material transaction has been posted to MTL_MATERIAL_TRANSACTIONS

5. Pick Confirm/ Move Order Transaction

Items are transferred from source sub-inventory to staging Sub-inventory. Here material transaction occurs.

Order line status becomes ‘Picked’ on Sales Order and ‘Staged/Pick Confirmed’ on Shipping Transaction Form.

  • MTL_MATERIAL_TRANSACTIONS_TEMP
  • oe_order_lines_all
  • MTL_MATERIAL_TRANSACTIONS
  • mtl_transaction_accounts
  • wsh_delivery_details
  • wsh_delivery_assignments
  • MTL_ONHAND_QUANTITIES
  • MTL_SERIAL_NUMBERS_TEMP
  • MTL_SERIAL_NUMBERS

* This step can be eliminated if we set Pick Confirm=YES at the time of Pick Release 

6. Ship Confirm 
Here ship confirm interface program runs in background. Data removed from wsh_new_deliveries. 

The items on the delivery gets shipped to customer at this stage.

  • oe_order_lines_all
  • wsh_delivery_details
  • WSH_SERIAL_NUMBERS
  • mtl_transaction_interface
  • mtl_material_TRANSACTIONS
  • mtl_transaction_accounts
  • mtl_demand, MTL_reservations
  • MTL_ONHAND_QUANTITIES
  • MTL_SERIAL_NUMBERS_TEMP
  • MTL_SERIAL_NUMBERS

7. Enter Invoice 

After shipping the order the order lines gets eligible to get transferred to RA_INTERFACE_LINES_ALL. Workflow background engine picks those records and post it to RA_INTERFACE_LINES_ALL. This is also called Receivables interface, that mean information moved to accounting area for invoicing details. Invoicing workflow activity transfers shipped item information to Oracle Receivables. At the same time records also goes in the table RA_INTERFACE_SALESCREDITS_ALL which hold details of sales credit for the particular order.

ra_interface_lines_all (interface table into which the data is transferred from order management) Then Auto-invoice program imports data from this table which get affected into this stage are receivables base table. At the same time records goes in ra_customer_trx_all and ra_customer_trx_lines_all

8. Complete Line 
In this stage order line level table get updated with Flow status and open flag. 
oe_order_lines_all

9. Close Order 
This is last step of Order Processing. In this stage only oe_order_lines_all table get updated. These are the table get affected in this step. 
 
oe_order_lines_all

oe_order_HEADERS_all

 You will get the details of column values getting updated at different stages and table joins information at http://functionalguy.blogspot.com/2008/05/data-flow-for-order-to-cash-cycle.html

devendra gulve — Expert’s page – click here

special Thanks TO dEVENDRA gULVE ( http://functionalguy.blogspot.com/2008/05/data-flow-for-order-to-cash-cycle.html )

Thanks – Shivmohan Purohit

Categories: Oracle AR Functional · Oracle Inventory Functional · Oracle Receivables Technical · SME Contributions
Tagged: , , , , , , , , , , , , , ,