Author Archives: shivmohan purohit

Introducing : Neeta Shelar : New Author & Contributor : Oracle Projects Accounting

Here i like to introduce New author and contributor on this blog. Her name is Neeta Shelar.

She is  having a total experience of 12 years, out of which 7 and half are in IT sector. She has been working as functional for Oracle Projects (primary skills) , AP & AR modules. In PA , She has worked on new roll outs, enhancements & R12 upgrade project.

She is having very practical and hands on expertise in Oracle and I am sure, All reader will get benefits of her knowledge and expertise in Oracle Projects Accounting, Billing, Costing and Oracle EBS in general.

Thanks – Shiv

Video : Oracle Unified Method ( OUM ) – An Overview

A video tutorial on Oracle Unified Method ( OUM ) – This helps in supporting complete enterprise IT Lifecycle. This Tutorial includes: definition of OUM, OUM focus areas and scope of OUM

How To Identify Where An Expense Report Is In the Process

You wish to identify where in the Expenses Process an Expense Report is by looking at the EXPENSE_STATUS_CODE in the table ap_expense_report_headers_all

The values for the column EXPENSE_STATUS_CODE in the table ap_expense_report_headers_all come from the Payables Lookup Code EXPENSE REPORT STATUS


Lookup Code Meaning




Pending Individual’s Approval


Pending System Administrator Action


Hold Pending Receipts


In Progress


Ready for Payment


Pending Payables Approval


Ready for Invoicing




Partially Paid


Payables Approved


Pending Manager Approval


Pending Payment Verification




Pending Your Resolution

















Expense report transaction has been inserted into the expense report transaction tables but have not passed the Payables Validation Function in the Server Side Validation Process of the Expense Report Workflow process. This transaction is not viewable in the Oracle Payables Enter Expense Reports Window.



Expense Report transactions has successfully passed the Payables Validation function in the Expense Report Workflow Server Side Validation Process and is viewable in the Oracle Payables Enter Expense Reports Window.
Transaction has not completed the Expense Report Workflow yet.



(10.7 – 11.0.2)
If Expense Report was created through the Web Interface (identified by the workflow_approved_flag), expense report transaction has successfully completed the Expense Report Workflow process and is ready to be picked up by Oracle Payables Invoice Import program.



Expense Report transaction has successfully completed the expense Report Workflow process and is ready to be picked up by Oracle Payables Invoice Import program.



If Expense Report transaction is created from the web (check the source), then expense report has been submitted, but not been manager or payables approved. Expense Report transactions not created from the web will have workflow_approved_flag = NULL.



Expense Report transaction has been saved and not yet fully completed or submitted.



Implicit save, in OIE.K/R12 there is an implicit save when navigating from one page to another.



Expense Report transaction has been Manager rejected.



Expense Report transaction has been Manager approved.



Expense Report transaction has been Payables approved.



Expense Report transaction has been ‘Automatically’ approved, i.e. Manager approved but Payables approval not needed because expense report didn’t need payables to check for receipts or policy.



Expense Report has been Withdrawn.



Expense Report transaction has been both Manager and Payables approved.

Introducing : Muthu Vadde – New Author and Contributor for Oracle Technical

Hi ,

Here i like to introduce New author and contributor on this blog. Her name is Muthu Vadde.  I am sure now we can put more technical and techno functional articles so it can help more people. 

She is having more than 10 Years in Oracle. She is expert in many tools. I am sure she will be great help for everyone in Oracle Technical areas like

  • SQL
  • Oracle Reports
  • Oracle XML Reports
  • Oracle Discoverer Reports
  • Oracle Form personalizations
  • Oracle Workflow
  • Oracle Application Framework
  • Oracle Application Development Work
  • Oracle SOA

Be free to keep writing me for any help or questions. thanks – Shiv


Hello Friends , here is some of quite commonly used AR ( receivables )tables and their usage. There are many other tables also in AR but here i am putting only few commonly used tables. for other table if needed we can … Continue reading

Oracle AR -Difference between PARTY and CUSTOMER

Difference between PARTY and CUSTOMER?

1. When we create New Customer in ERP, why a PARTY will be created automatically?
2. Can I create a Customer without Party?
3. Can I create a Party without Customer?
There is already a lot of material out there on this topic. There are a couple of articles on this, on oracle forums as well. I will try to explain this as elaborately as possible and not waste my “thanksgiving holiday”. I can get really pedantic at times, when im bored.Oracle as a company was basically into ERP solutions only. As part of its efforts and vision to branch out into every other application such as SCM, CRM and other domains, it started acquiring smaller companies. It acquired Siebel which was one of the industry leaders in the CRM domain. Just to provide some insight into CRM, it is an acronym for Customer Relationship Management. Any CRM is basically a marketing tool. If you understand the definition of the word “marketing”, you will easily understand the difference between a party and customer.

Marketing is the process of identifying, creating and retaining a customer. CRM tools essentially deal with that process. It is used by companies to identify potential customers, make them buy something from the company, maintain effective relationships with them to retain them for repeat purchases as well. This is what CRM does.

But an ERP like oracle does not have any relationship with a person unless he buys something from the company. A customer is someone who has a buying relationship with the company. So how do we distinguish between a person who has bought something and someone who hasnt purchased anything from you? This is where the party definition comes into picture. A party is anybody that exists. He/She/It does not have to have bought something from the company earlier. In fact, they do not have any relationship whatsoever with the company. So how does the company make them buy something? This is where CRM helps. It helps the company in identifying such people, create some marketing campaigns to make them buy something and convert them into the company’s customers, and keep maintaining relationships with them so that they will keep buying from them in the future as well.

Oracle purchased Siebel CRM to target these companies which require CRM tools to create, maintain and retain new customers. Prior to 11i, Oracle had the customer tables only. It did not have to deal with non-customers. Anyone who purchases becomes a customer and is stored in the ar customer tables. When Oracle bought CRM, it needed to incorporate the concept of a ‘potential”  and “repeat” customer into the existing data model. It could not have had separate schemas or databases for CRM tools and ERP tools. Since CRM and ERP have to talk to each other, they wanted one single model to incorporate customers who bought and people who have not purchased. So they created a layer over the customer definition called party and said “Anyone who exists is a party”. Once this party buys something, it becomes a customer. Kindly note that it is still a party. It is both a party and customer as well after the purchase is made. So for a person to become a customer, he has to exist first. Only then he can make the purchase and become a customer.

So the process would be like this. A company wants to create some new customers. So it first uses some CRM tools to identify new people it thinks can be targeted. It uses some CRM modules like marketing, telesales, telemarketing etc… to target the customer and finally convinces the customer to make the purchase. So, this person has entered the oracle database. Remember he has not bought anything yet. He is only a party for now. How does he buy now? CRM does not have any modules to place or process orders and payments. The party has to place an order in the ERP module Order management. Once he places an order, he becomes a customer too. So he is now both a party and customer. I hope this helps in understanding why some companies need CRM and ERP, and why Oracle bought siebel CRM. Oracle can target companies which deal with a lot of customers in its business like retailers (Walmart, Amazon, Target) and can sell them both CRM and ERP packages as part of a wholesome solution. since ERP and CRM are sold together, they need to communicate effectively and easily with each other and hence one single data model for customers called the “Party model”.

If you understood the above concept, you can easily answer the below questions.

1.When we create New Customer in ERP, why a PARTY will be created automatically?
A: Can a person make a purchase without existing? He has to exist first to make a purchase. He has to become a party first before becoming a customer. Once you place order in OM, the person is created as a party and customer as well. The party information can be used by CRM tools to target the person for future purchases.

2. Can I create a Customer without Party?
A: Can a person make a purchase without existing?

3.Can I create a Party without Customer?
A: Can a person exist independently without making a purchase? He can. So a party can exist without making a purchase. Imagine you went to a store, checked some stuff and did not buy anything. You might be asked to fill some information like your name, your address, what you liked,what you didnt like and things like that. So this information has to be stored somewhere. Here you will be entered in the company’s system as a party, but not a customer. they will then start sending you emails or offers trying to make you buy something using their CRM tools. once you buy something, you become a customer. Until you buy, you are only a party.

Free ITIL® Foundation Certification Class – in Houston, Texas

ServiceNow and Fruition Partners are pleased to extend you an exclusive invitation to our upcoming ITIL® Foundation class. A $1,500 value, our fully accredited ITIL® training boasts a 95% pass rate and delivers expertise that you can use immediately – at no cost to you

Location: Lone Star College (Greens Point Location)
250 N. Sam Houston Parkway E
Houston, TX 77060

Date & Times:

Tuesday, July 30, 2013                8:30am – 5:00pm
Wednesday, July 31, 2013          8:30am – 5:00pm
Thursday, August 1, 2013            8:30am – 2:00pm (Exam)

What You Will Gain:

  • Prepare for and take the ITIL® Foundation Certification exam
  • Practical examples of real-world use of ITIL® processes inside ServiceNow
  • Enhanced knowledge of ITSM processes and procedures
  • Guidance for applying ITIL® to everyday IT situations

REQUEST YOUR SEAT NOW! Space is limited and available on a first come, first-served basis for qualified attendees, limit 2 per company. Lunch will be provided. Networking reception will be held on-site on Tuesday