Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications


Posted on December 31st, 2012 by Sanjit Anand ||Email This Post Email This Post

Wishing all my readers, followers, friends a Happy and Prosperous New Year 2013. May 2013 be all you wish it to be !!!

Here is wishing you a healthy, happy and rewarding 2013!



Posted in Misc | No Comments »

Why you need Third Party Integration for Tax System

Posted on December 28th, 2012 by Sanjit Anand ||Email This Post Email This Post

Third-party tax solutions provide a more complex set of features for sales and use tax calculations than ERP’s like Oracle (EBS, Peoplesoft), SAP based tables. The need for Third Party integration is always demanding if Companies are operating in Noth America.

The need for Third Party Integration for Tax System is ..

  • To get out of the box tax content
  • To avoid continuously monitoring tax law changes
  • Automated tax content updates
  • Better audit support
  • Single solution for Oracle and non Oracle systems
  • Meet local reporting needs
  • Access to tax research of the provider
  • Get out of the box return / support for major countries

While Using so , you can get these benefits

  1. Reduced overall cost of tax compliance
  2. Improved efficiency of transactions
  3. Greater Business Insight
  4. Improved footprint of taxable transactions
  5. Reduced risk associated with manual intervention

Next most vital steps in a successful sales tax system implementation is choosing the right software solution. Every business is unique and has an array of different requirements. Once the requirements have been identified and the type of solution is identified for a tax system implementation, the next step is to research the providers that offer that type of solution.Every software package offers a different set of possibilities. It’s important that the project team is aware of all the benefits and functionality of the different software packages before making the final selection.

Few Third Party Options for Tax Integration Technologies

  • ADP owns Taxware and offers the Sales/Use Tax (SUT) and Taxware Enterprise (TWE) applications.
  • Avalara is privately owned and offers the AvaTax Connect as a web-hosted solution for small-to-medium businesses.
  • Thomson Reuters owns Sabrix, which has been re-branded and integrated as part of OneSource.
  • Vertex remains privately owned and offers the Q-Series and O-Series applications.
  • Wolters Kluwer owns CCH, which offers the Sales Tax Office (STO) solution, and they recently acquired SpeedTax.

I look forward to learing about your implementation experiences!

Posted in Oracle E-Business Tax | No Comments »

Third Party Data Integration with Credit Management

Posted on December 22nd, 2012 by Sanjit Anand ||Email This Post Email This Post

If you are global company and have regional customer , and using third party Credit Bureau data like :

  • Transunion
  • KI
  • Experien
  • Equifax

If you are planning to integrate with Oracle Credit Managment , then there is waiting time for you as out of box feature is not offered.

Currently Credit Management is only designed to work with Dun & Bradstreet .Though if have third part data product you can easily integrate with the help of some customization.


This term refers to businesses that maintain historical information pertaining to credit experience on individuals or businesses.

The data is collected from various sources, most commonly firms extending credit such as credit card companies, banks and credit unions. They also collect information from public records, such as bankruptcies.

You can use Third Party Data Integration to obtain any of these data products:

  • Business Verification
  • Quick Check
  • Delinquency Score
  • Global Failure Risk Score
  • Financial Standing
  • Decision Support
  • Enterprise Management
  • Commercial Credit Score
  • Vendor Management

Posted in Oracle Credit Management | No Comments »

Oracle PIM Integration Capabilities: Business Events Availability by Oracle Product Hub

Posted on December 18th, 2012 by Hub Contributor ||Email This Post Email This Post

Following is a list of Business Events provided by Oracle Product Hub:





Item AML is changed (such as a manufacturer part number is added, updated, or deleted)


Catalog category is changed such as when categories are created, updated or deletedÂ


Category is added to or is removed from a catalog. This event is also raised when the attributes of catalog are changed.


Item CreationÂ


Item UpdateÂ


GTIN Attribute group row is created or updated.


On Item ApprovalÂ


Bulk Item processing (creation, update)Â


Item cross-reference creation, update, or deletionÂ


Item revision is created or updatedÂ


An item role grant is changed (added, modified, or removed)Â


Item Catalog assignment or removalÂ


Item Attribute group row is created, updated, or deleted. This event is raised before the change is committed.Â


Item Attribute group row is created, updated, or deleted. This event is raised after the change is committed. Â

Approval status changesÂ Â

Priority changesÂ Â

Status changesÂ

Workflow status changesÂ Â

Creation of a change objectÂ Â

Posted comment on a change objectÂ

Reassignment of a change objectÂ Â

Common request of a change objectÂ Â

Submission of a change objectÂ Â

Update of a change object Â

Schedule date changeÂ Â

Import is completedÂ Â

Revised item schedule date changeÂ

Revised item status changesÂ


Posted in MDM | No Comments »

What happens if I don’t enter an AutoInvoice grouping rule?

Posted on December 15th, 2012 by Sanjit Anand ||Email This Post Email This Post

Do you Know assigning the AutoInvoice grouping rule to Imported transaction sources that AutoInvoice uses to group imported transaction lines.

If you do not assign a grouping rule to an Imported transaction source, AutoInvoice uses the following hierarchy to determine which rule to use:

  • Grouping rule assigned to the transaction source of the transaction line.
  • Grouping rule assigned to the bill-to customer site profile of the transaction line.
  • Grouping rule assigned to the bill-to customer profile of the transaction line.
  • Grouping rule assigned to system options.

Therefore this is important to review the autoInvoice Grouping Rules set up .Define additional grouping rules or update the default grouping rule provided by Receivabless

Understanding AutoInvoice Grouping Rules: Example

Here is example illustrates how to use grouping rules to group transaction lines into transactions during AutoInvoice import.

Assume you defined an AutoInvoice grouping rule that specifies that to appear on the same invoice, items must match on all mandatory attributes, such as currency and customer bill-to address , and must also match on the optional attribute of sales order type

Below diagram illustrates how three imported invoices are created according to the AutoInvoice grouping rule defined in this example:

grouping rule

Items A and B share the same currency and sales order type, so they appear on the same invoice (Invoice 1). Item C has the same currency as A and B, but it has a different sales order type, so it appears on its own invoice (Invoice 2). Items D and E share the same currency and sales order type, so they appear on the same invoice (Invoice 3).

Hope this helps.

Posted in Oracle Receivable | No Comments »

Oracle Big Data Appliance

Posted on December 14th, 2012 by Sanjit Anand ||Email This Post Email This Post

Oracle offers a broad portfolio of products to help enterprises acquire, manage, and integrate big data with existing information, with the goal of achieving a complete view of business in the fastest, most reliable, and cost effective way .

Oracle’s Big Data Appliance, and Oracle Big Data Connectors is one such solution and portfolio of products bundled together to provide an integrated solution. The good about Oracle Big Data Appliance comes with fact that the process of Acquire, Organize and Analyze work quite closely with their proven Oracle RDBMS technology and thus gives Enterprises flexibility to cover SQL and NoSQL (Key-Value store databases for unstructured, semi-structured data) within the horizon of their analytical needs.

The Oracle Big Data Appliance is an engineered system of hardware and software designed to help enterprises derive maximum value from their big data strategies. It combines optimized hardware with a comprehensive software stack featuring specialized solutions developed by Oracle to deliver a complete, easy-to-deploy offering for acquiring, organizing and analyzing big data, with enterprise-class performance, availability, supportability, and security.

The Oracle Big Data Appliance integrated software includes :

  • Full distribution of Cloudera’s Distribution including Apache Hadoop (CDH)
  • Cloudera Manager to administer all aspects of Cloudera CDH
  • Open source distribution of the statistical package R for analysis of unfiltered data on Oracle Big Data Appliance
  • Oracle NoSQL Database Community Edition3
  • And Oracle Enterprise Linux operating system and Oracle Java VM

The Oracle Big Data Appliance offers the following benefits:

  • Rapid provisioning of a highly-available and scalable system for managing massive amounts of data
  • A high-performance platform for acquiring, organizing, and analyzing big data in Hadoop and using R on raw-data sources
  • Control of IT costs by pre-integrating all hardware and software components into a single big data solution that complements enterprise data warehouses

Oracle Big Data Connectors is an optimized software suite to help enterprises integrate data stored in Hadoop or Oracle NoSQL Databases with Oracle Database 11g. It enables very fast data movements between these two environments using Oracle Loader for Hadoop and Oracle Direct Connector for Hadoop Distributed File System (HDFS), while Oracle Data Integrator Application Adapter for Hadoop and Oracle R Connector for Hadoop provide non-Hadoop experts with easier access to HDFS data and MapReduce functionality.

Oracle Exalytics In-Memory Machine is purpose-built to deliver the fastest performance for business intelligence (BI) and planning applications. It is designed to provide real-time, speed-of-thought visual analysis, and enable new types of analytic applications so organizations can make decisions faster in the context of rapidly shifting business conditions, while broadening user adoption of BI though introduction of interactive visualization capabilities. Organizations can extend BI initiatives beyond reporting and dashboards to modeling, planning, forecasting, and predictive analytics.

These offerings, along with Oracle Exadata Database Machine and Oracle Database 11g, create a complete set of technologies for leveraging and integrating big data, and help enterprises quickly and efficiently turn information into insight.

More Information

Data sheets, white papers and other interesting information can be found here:

Posted in Emerging Technologies | No Comments »

UNDERSTANDING Oracle Bill Presentment Architecture (BPA ): Flexible Invoicing Solution

Posted on December 13th, 2012 by Sanjit Anand ||Email This Post Email This Post

Oracle Bill Presentment Architecture [BPA] is a bill presentment tool [aka user manageable capability] that helps to create and present comprehensive and more-customer-focused invoices that increase the likelihood and timeliness of payment.

BPA provides the architecture to retrieve billing data from multiple data sources, including transaction flexfields and other data not interfaced and stored in Oracle Receivables.

This means that the physically presented bill is no longer limited to information contained within Oracle Receivables.

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. This means that the physically presented bill is no longer limited to information contained within Oracle Receivables.

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 all the invoice specific functionality needed for a full-fledged invoicing solution from Applications .

dgreybarrow COST /PRICING

BPA is included in the Oracle E-Business Suite Financials family of applications. It’s included with Receivables. When reviewing the diagnostic catalog BPA will show up under Receivables.

dgreybarrow BPA TECHNOLOGY

Oracle BPA uses the same Self-Service Framework as all Oracle’s ERP Self-Service products.

BPA uses XML Publisher to physically generate the PDF output of a printed invoice.

BPA is MLS-enabled. Multilingual Support is the ability to install and run multiple NLS (National Language Support) releases within one instance

BPA can use the following delivery channels are possible:

  • Internet Printing Protocol (IPP) Printer
  • E-mail
  • Fax
  • FTP

Using using the Balance Forward Billing (BFB) can opt to create consolidated invoices using BPA [This is possible in Release 12]


With Bill Presentment Architecture (BPA), you can customize the content and format of bills to be viewed online or printed by your customers and your internal users.You can:

  • 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


BPA helps bypass the complex coding and customization traditionally associated with creating customer or industry centric invoices. Though Oracle Documentaion hoighlighted

  1. Registering Data Source
  2. Creating Database Views
  3. Registering Data Source View
  4. Configuring Hyperlinks
  5. Uploading Logo
  6. Creating Custom Message
  7. Template Management
  8. Assigning Templates
  9. External Template Upload
  10. External Template Assignment
  11. Testing the Template

More or less , with these simple five-step process, we can create a customized billing template, and preview it with actual transaction data easily in couple of hrs. These steps are subset of above as follow as:

  1. Create Template to present bills :BPA collects, formats, and presents billing data online and in printed bills, according to templates that you define
  2. Template Assignment :BPA assigns completed billing templates to customers based on the assignment rules that you define. Each rule uses predefined criteria with user-defined conditional values to match templates with customers.
  3. View online bills :Internal users and external customers can view bills online using Oracle Receivables, OracleiReceivables, Oracle Collections or other calling application.
  4. Register Data Sources : This is Required for all nonseeded data sources.
  5. Print BPA invoices

dgreybarrow BENEFITS ON BPA

Major benefits of the BPA functionality are as below :

  1. Expedite Payment and Improve Cash Flow : The invoice designs we create can be assigned to particular customers or particular transactions.This format consistency will help customers process their bills quickly. To efficiently address disputes, billing personnel, receivables clerks, and collectors can view bills in Oracle iReceivables,
    Oracle Receivables, or Oracle Collections, in the same format the customer sees.
  2. MLS enabled : This is the Biggets advantage is MLS-enabled. Templates can be created using any available session language. When printing bills, BPA selects the appropriate template file based on language associated with customer’s address
  3. Flexibility to incorporate Company logo: Custom images and messages can be incorporated in BPA templates
  4. Template for transaction classes other than Invoice :BPA supports template creation for invoices, credit memos, debit memos, chargebacks, guarantees and deposits. Oracle provides seeded templates for the above mentioned transaction classes
  5. Incorporate hyperlinks on online invoices BPA supports creation of hyperlinks and associating them to any content presented in wer online bill, including in the billing lines
    or in the detail lines. Links can be generic, such as access to a company home page, or they can be transaction-specific, such as access to the actual sales order listed on the bill.
  6. Grouping of billing lines For Oracle Service Contracts bills, we can provide summarized billing lines for customers who desire less detail than is stored in Oracle Receivables.

Posted in Oracle Receivable | No Comments »

R12 :Country Specific Bank Account Validations

Posted on December 12th, 2012 by Sanjit Anand ||Email This Post Email This Post

R12 , the Bank Account model allows users to define and keep track of all bank accounts in the e-Business Suite in one place and explicitly grant account access to multiple operating units/functions and users. Bank accounts for internal use are consolidated in:

  • Payables
  • Receivables
  • Treasury
  • Global Financials
  • CRM

The Bank Account model reduces the number of access points to manage bank accounts by providing a centralized user interface where all internal bank accounts can be set up.

Bank account numbers are structured according to national and international standards.

In many countries, Rule are required to check that the bank account number is correct. If this number is not checked in the system and happens to be wrong, any payment orders to this account are rejected and bank fees are charged to the company.

R12 has VALIDATION RULES that were not present before.

Example: 11i would allow you to enter any length account number you wanted. Now, the account number length depends upon the country. This ensures that each country’s payment file requirements are met, by standardizing each country’s data input requirements.


Oracle R12 , added new feature called Country Specific Bank Account Validations

The following information is presented for certain countries:

  • Validation rules: The validation perform for the specific country
  • Unique Validation Rules: The unique validations perform for the specific country

The following countries have country specific validations:

When entering new bank accounts, different countries can have certain rules governing the format and content of the following related fields:

  • Bank Number
  • Branch Number
  • Account Number
  • Check Digit

A new profile option, “CE: Disable Bank Validations” has been introduced. This profile can be set at the site, application, responsibility or user level. The profile is seeded with a default value of ‘No’ at the site level. The country-specific validations pertaining to the bank number, branch number, account number and check digit can be disabled by this profile option.

If the profile is set to ‘Yes’, these validations will not fire. If the profile is set to ‘Yes’ a tip is displayed on the Bank, Branch and Account setup pages. This indicates that the validations have been disabled. A similar tip is displayed in the Supplier (Oracle Payments) Bank Setup UI.

The checks for unique banks, branches, accounts and the mandatory requirement of bank account number are not affected by this profile.

Currently Bank validation is offered for Australia, Austria, Belgium, Brazil, Denmark, Colombia, Finland, France, Germany, Greece, Iceland, Ireland, Israel, Italy, Japan, Luxembourg, Netherlands, New Zealand, Norway, Poland, Portugal, Spain, Sweden, Switzerland, United Kingdom, and United States.

If country does not have validation in above list, still have these default validation aka Unique Validation Rules

The unique key will be the combination of:

  • BANK
    • Bank Number, Country
    • Bank Name, Country
    • Bank ID, Branch Number
    • Bank ID, Branch Name
    • Bank Branch ID, Bank Account Number, Bank Account Name, Currency

Posted in Cash Management | No Comments »

Oracle Fusion Applications Documentation Library

Posted on December 12th, 2012 by Sanjit Anand ||Email This Post Email This Post

Oracle Fusion Applications Documentation Library for links to release notes, guides, licensing information,and more can be found here


You can use this page to learn about Oracle Fusion Applications . You can use the tabs to find user guides, implementation guides, and other documentation resources for each product family.

dgreybarrow Other Documentation Links

  • Oracle Fusion Applications Technology Library : You can use these library for technical guides such as install, patching,implementation, and extensibility. click here to get .
  • Oracle Enterprise Repository : You will get technical information about integrating with other applications,including services, operations, composites, events, and integration tables. click here to get .
  • Oracle Fusion Applications Documentation Info Center : To access this you need my Oracle support access. If you have valid access rights , you can get white papers, release notes, What’s New and other resources.

Posted in Fusion Application | No Comments »

APIs/Web Services Avaiablity by Oracle Product Hub

Posted on December 8th, 2012 by Sanjit Anand ||Email This Post Email This Post

As you know, Oracle Product Information Management Data Hub is an enterprise data management solution that enables customers to centralize and master all product information from heterogeneous systems, creating a single view of product information that can be leveraged across all functional departments.

Following is a list of APIs/Web Services provided by Oracle Product Hub


Oracle API/Web servics Description
EGO_USER_ATTRS_DATA_PUB.Get_User_Attrs_Data This API is used to access user-defined attribute data for a particular item

This API is used to copy all User-Defined Attribute data from one object instance to another object instance of the same type (e.g., from one EGO_ITEM to another or one PA_PROJECTS to another).

EGO_USER_ATTRS_DATA_PUB.Process_User_Attrs_Data This API processes User-Defined Attribute data for one object instance.
INV_ITEM_CATEGORY_PUB.Create_Valid_Category This API is used to for assigning a category to a category set
INV_ITEM_CATEGORY_PUB.Create_Category This API is used to create a category.
INV_ITEM_CATEGORY_PUB.Create_Category_Assignment This API is used to create an item category assignment
INV_ITEM_CATEGORY_PUB.Delete_Category This API is used to delete a category
INV_ITEM_CATEGORY_PUB.Delete_Valid_Category This API is used to delete category assignment to its category set
INV_ITEM_CATEGORY_PUB.Delete_Category_Assignment This API is used to delete an item category assignment
INV_ITEM_CATEGORY_PUB.Update_Category This API is used to update a category.
INV_ITEM_CATEGORY_PUB.Update_Category_Description This API is used to update a category description
INV_ITEM_CATEGORY_PUB.Update_Valid_Category This API is used to for reassigning the parent category of a category in a given category set
INV_ITEM_CATEGORY_PUB.Update_Category_Assignment This API is used to for re-assigning an item to a new category in the given category set.
EGO_ITEM_PUB.Assign_Item_To_Org This API is used to assign one item to an organization
EGO_ITEM_PUB.Implement_Item_Pending_Changes This API is used to implement pending changes (phase and/or status) for an item/item revision.

The full parameter-list version of Process_Item

This API is used to create or update one item if you want to specify item attribute values that aren’t exposed in the wrapper version of Process_Item, or to create or update an item revision.

EGO_ITEM_PUB.Process_Item (Convenience wrapper)

A convenience wrapper to Process_Item

This API is used to create or update one item by passing only the most important and/or commonly-used item attributes.

EGO_ITEM_PUB.Process_Item_Cat_Assignment This API allows user to assign/remove a catalog/category to/from an item.
EGO_ITEM_PUB.Process_Item_Descr_Elements This API allows user to give the values of item catalog category descriptive elements.
EGO_ITEM_PUB.Process_Item_Org_Assignments Use this API to assign multiple items to organizations.
EGO_ITEM_PUB.Process_Item_Phase_And_Status Use this API to either change the status of an item or promote/demote the lifecycle of an item/item revision.
EGO_ITEM_PUB.Process_Item_Role Use this API to create, update, or delete one role grant on one item, or on one existing instance set.
EGO_ITEM_PUB.Process_Items Use this API to create or update multiple items at once.
EGO_ITEM_PUB.Process_User_Attrs_For_Item Use this API to perform DML operations (insert, update, or delete) on one or more rows of user-defined attributes data for one item.
ENG_ECO_PUB.Process_Eco This procedure allows user to create, update Issues, Change Requests (CRs), and Change Orders (COs) in Product Lifecycle Management (PLM) Product

Posted in 11i | No Comments »

« Previous Entries