Author Archives: shivmohan purohit

Oracle BPA – Bill Presentment Architecture – No more AR Invoice Print customization – How

Oracle BPA – Bill Presentment Architecture – No more AR Invoice Print customization – How

Every Financial implementation expect change in standard AR Invoice template layout. Now with BPA ( Bill Presentment Architecture ) , we can avoid any customization along with quite good handy feature…

have you seen  a new button available for completed transactions in the Transactions Workbench. The button opens a web-based window that shows the transaction details. this icon in the Transactions Workbench is for a Bill Presentment Architecture (BPA). The setup and wording of the window can be customized through the Bill Presentment Architecture module.

BPA is a module that allows you to retrieve billing data from multiple data sources for presentment on a bill. This means that the physically presented bill is no longer limited to information contained within Oracle Receivables. BPA provides template-based configuration of online and printed bills, giving you the ability to select the content of the bill, choose the layout design, display parent billing lines and drilldown details, and then set up the assignment of these billing templates by defining rules based on criteria you specify. By separating bill presentment from transaction accounting, Oracle BPA allows for more understandable and comprehensive bills, increasing the likelihood and timeliness of bill payment.

BPA provides the architecture to retrieve billing data from multiple sources, including transaction flexfields and other data not interfaced and stored in Oracle Receivables. Because bill presentment is not limited to transaction accounting information, you can present bills that are more comprehensive and meaningful to your customers.

With BPA, you first indicate the data sources that you want to collect billing data from. BPA provides a framework for collecting billing data stored in:

  • Oracle Receivables
  • Oracle applications seeded in BPA, such as Oracle Order Management and Oracle Service Contracts
  • Other Oracle applications
  • Legacy systems and other non-Oracle applications

You then design billing templates for each transaction class, choosing the layout and content to determine how you want billing data to appear in an online or printed bill, and assign the templates to customers or customer categories. You can print bills individually or in batches from your billing templates created within BPA or uploaded from external sources.

Customizing the bills that your customers see helps them reconcile bills with purchase requests and facilitates timely bill payment.

Your customers can view summarized billing information and drill down using hyperlinks to detailed billing information and other related details necessary to understand and pay the bill.

Here are the steps involve in summary :

  • Design layout and select content for a bill
  • Display on bills information that is not stored in Oracle Receivables
  • Create hyperlinks that enable access to related billing information
  • Display summary and child lines
  • Provide online drilldown to transaction line details
  • Upload external templates
  • Incorporate attachments on online bills
  • Assign bill formats to specific customers or user-defined customer categories
  • Print transactions and bills
  • Preview billing templates using real-time data

I will prepare more detail article with steps but in case if you are implementation AR Invoice printing then do reach out me to use this feature.


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.