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

Get use of “Oracle Diagnostics” Available with Products

Posted on April 29th, 2008 by Sanjit Anand ||Email This Post Email This Post

Do you know :

  • Closing the accounting period within a specific timeframe for any business is Important
  • Sometime failing to close the accounting period due to accounting exceptions will delay the overall fiscal close process

Lets take a case, how many of us aware of these problem reported during month end or during normal daily activity by account department . Lets list some of the common problem them from payables:

  • Unable to Close Period
  • Accounting Fatal Error
  • Accounting Invalid Account Error
  • Unable to account invoice/payment
  • Journal Import Errors
  • Duplicate Accounting Entry Created For a Payment
  • Paid Invoices Appearing on the Trial Balance
  • Orphan Accounting Data
  • Can’t Confirm a payment batch
  • Invoice not selected for payment
  • Invoice does not have account
  • Balance AP to GL
  • Final Closing
  • Can’t Confirm a payment batch
  • Preliminary closing
  • Invalid account
  • Deadlock in Payables Accounting Process ORA-00060: deadlock detected while waiting for resource occurred in …AP_ACCOUNTING_MAIN_PKG.Create_Accounting_Entry
  • Accounting Exceptions Sweeping

What next …finding notes on metalink or raise a SR with Oracle,with the assumption they can fix this. Did you ever realized how many hours or days it takes in resolution. Therefore very similar to FirstAid in our daily life during emergency, why not utilize Oracle Diagnostics.

Payables currently has 15 diagnostics as part of Oracle Diagnostic based out of all common issues faced in earlier releases.

double-arrow About Oracle Diagnostic

Lets recap , based out of one earlier post regarding Oracle Support Diagnostics which designed to improve:

•Resolving configuration and data issues that would cause processes to fail
•Resolving problems without the need to contact Oracle Support
•Reduction in Resolution time by minimizing the time spent to resolve an issue

Typically Oracle Diagnostic consist of

  • Diagnostic tests : This provided as part of the Oracle Support Diagnostics patch gather and analyze information from your E-Business Suite
  • Results : This display the information gathered, the findings of the analysis and appropriate actions to take if necessary
  • Tests : The good is that these do not alter data or setup.
  • Purpose : These have clear purpose for automation that ensure after successful installation

double-arrow What are the Oracle Diagnostics Available in AP

Very similar to other products, Payable does have three major Diagnostics

  1. Setup Diagnostics
  2. Activity Diagnostics
  3. Data Collection Diagnostics

With in Setup Diagnostics of AP , these areas are covered:

  • 1099 -This test normally used to verify and display 1099 setup details in AP.
  • General -This test will verify and display basic setup details as outlined in the ‘Setting Up’ chapter of the Payables User Guide. If you are doing setup configuration, you try to take this test.
  • Internet Expense User Setup -If you are doing iexpense setup , then running this test will validate and display the Oracle Internet Expense setup for an employee and corresponding underline details.

With in Activity Diagnostics of AP , these areas are covered:

  • 1099 Missing Invoice -This test will verify why a particular invoice was not picked up in a 1099 report.
  • Accounting -This test will diagnose why an invoice, payment or payment clearing transaction will not account . This will also find some other conditions like dependent events.
  • Checkrun Selection -This test will assist in identifying why an invoice is not being selected in a checkrun
  • Data Integrity Analysis -This test provides a series of tests to check the data integrity of all supplier invoices and checks.
  • Internet Expense Report Status -This test will display details and identify problems for a specific expense report
  • Mass Additions -This test verifies if a given invoice or invoice distribution line meets the conditions to be transferred to Oracle Assets when running Mass Additions Create.
  • Payment Batch Status -This test will validate a payment batch .
  • Payment Document -This test will validate the setup for a specific payment document
  • Period Closing -This test will help in determining if a period can be closed and if not, why it cannot be closed.
  • Trial Balance -This test will identify and report common problems for invoice(s) appearing or not appearing on the trial balance

With in Data Collection Diagnostics of AP , these key areas are covered:

  • For Invoice-This diagnostic test will display ALL of the data for ALL of the tables used to process an invoice in Payables.
  • Open Interface -This test is designed to display all related interface data for a specified invoice interfaced from Oracle source applications or a 3rd-party (legacy) source.

Most important,the reports which appears after running the scripts also have the required patch set information. These diagnostics were created from manual/standalone SQL scripts that Oracle normally providing during data fixing and data collection process against a particular SR. Indeed really good collaborative approach.

double-arrow Best Practices

  • To prevent issues always check status of periods in sub ledgers
  • Clear all the exceptions
  • Get use of Period end Exception Report – If user want some additional column enhance the reports.

double-arrow Period Close Exception Report

This report will shows ALL exceptions that would prevent a period from being closed:

  • Unaccounted Transactions
  • Untransferred Journal Entries
  • Unconfirmed Payment Batches
  • Unmatured Future Dated Payments

You will notice this report got enhanced ( in 11.5.10/Family Pack F). The new improved Payables Accounting Process report covers the error message section. It has also added section to the end of the Payables Accounting Process Report output to show what transactions could not be accounted by the process. And included in that section a comment to see the corresponding transaction number in the log file to see why the accounting could not be created

Therefore.. Lets the end user/core user know how and when to use these tools to address such of problem on daily basis or during closure time and make a better experience with EBS.

double-arrow Similar Post

Posted in Oracle Payable | 1 Comment »

Beginners’ Books for Oracle e-Business Suite

Posted on April 29th, 2008 by Sanjit Anand ||Email This Post Email This Post

Long time back , I got a complementary copy of EBS books from author Roel Hogendoorn.

These six books, roughly have 175-200 pages each, covering some of key areas of EBS.

  • System Administration
  • Workflow
  • Flexfields
  • Alert
  • Reporting in E-Business Suite
  • BI Publisher


I am so delighted with the content in these BOOK that I thought to share to rest of community people.

“…Extremely well written book, enjoyable and informative reading!”

Truly an excellent book and definitely a must for EBS beginners. In a world of ERP , this book actually delivers a lot more than its cost. Roel, has provided an incredibly honest approach to some of key attributes essential for EBS Implementer.

The webshop for the books is:

Posted in Beginner, Misc | No Comments »

Oracle Workflow: Inside View

Posted on April 28th, 2008 by Sanjit Anand ||Email This Post Email This Post

Oracle Workflow routes information to various users based on certain rules.

  • Tracks the responses from the users and takes actions accordingly.
  • Enables people to receive E-Mail notifications ·
  • Allows incorporation of custom packages and procedures ·
  • E-Mail integration of choice.
  • Internet enabled workflow allows you to view Workflow notifications through any Internet browser.
  • One can also monitor the processes through a browser..

The are key Oracle Workflow components are:


  1. Workflow Builder : Work Flow builder is a Graphical interface to create and modify a business process with simple drag and drop operations. It has two components – Navigator Window and Process Window . A workflow builder would be used by a person to design and modify a workflow. It is more of a designer’s tool rather than an end-user’s tool.
  2. Workflow Definitions Loader : The Workflow Definitions Loader is a utility program that moves workflow definitions between database and corresponding flat file representations. It allows opening and saving workflow definitions in both a database and file.
  3. Workflow Engine : The Workflow Engine embedded in the Oracle server monitors workflow states and coordinates the routing of activities for a process. Changes in workflow state, such as the completion of workflow activities, are signaled to the engine via a PL/SQL API or a Java API. Based on flexibly-defined workflow rules, the engine determines which activities are eligible to run, and then runs them. The Workflow Engine supports sophisticated workflow rules, including looping, branching, parallel flows, and sub-flows.
  4. Notification System : Each notification includes a message that contains all the information a user needs to make a decision.
  5. Workflow Monitor : The Workflow Monitor displays an annotated view of the process diagram for a particular instance of a workflow process. Users can get a graphical depiction of their work item status. It also displays a separate status summary for the work item, the process, and each activity in the process.

Posted in Tool | No Comments »

OTN Article – Invoice Processing with SOA Options

Posted on April 21st, 2008 by Sanjit Anand ||Email This Post Email This Post

I found, one nice article on OTN, for Invoice processing within SOA environment .

Moreover, SOA (Service-Oriented Architecture) is still a hottest topic since past couple of years. SOA is still have confusing term because it describe two different things. The first two word(Service-Oriented) describe a software Development Methodology, where as word architecture , simply represent a pictorial drawing of all the pieces that used put together in formation of Business process. What you say..

Expert’s simply redefined SOA , as strategy that proclaims the intention to build all the software assets in the company using SOA methodology.

The ‘Services’ referred to in SOA are software Chunks or components , constructed so that they can easily linked with other software components. At the core of servicss concept is abstraction, the idea that you can assemble software code into chunk meaningful enough that it can be shared and reused in many different area with in company’s business process.

The benefits of SOA comes at two levels:

1. At the tactical level this includes

  • Software Reuse : As the bundle of code that constitutes a service can be reused.
  • Increased Productivity : Because of reuse service, that simply reduce number of man-has in development , this makes a faster deployment.
  • This Increase agility

2.At strategic Level, effective SOA adoption means better Alignment with the business : As this gives a big picture of all the business processes and flow.With this all kind of people(technical or funcational ) can visualize, for the first time , how there businesses are constructed in term of Technology.This will surly appreciated by business people for supporting IT projects.

Read this case study@OTN

Invoice Processing in a Service-Oriented Environment
by Ronald van Luttikhuizen

Posted in Emerging Technologies | No Comments »

R12 : AP Trail Balance

Posted on April 20th, 2008 by Sanjit Anand ||Email This Post Email This Post

double-arrow Background

Once the entries have been made and before any report are extracted from the accounts, a trail balance is drawn up.This is standard accounting practice. This is just what it says it is – a try at balancing the figure before the profit is worked out and the balance sheet drawn up. By rule of thumb,If the double entry is correct, ie all debit entry for every credit entry and viceversa, then the total of debit balance and total of the credit balances equal .

double-arrow In release 12:

o 11i Trial Balance is known as the Open Account Balances Listing report in R12
o It runs based on the Open Account Balances Listing Definition that you define.
o You can define the Listing Definition at a Ledger or Ledger Set level

It runs based on the Open Account Balances Listing Definition that you define then select as a parameter when you submit the Open Account Balances Listing report.

Trail Balance

As a prerequisite, you must run the Open Account Balances Data Manager and select the Open Account Balances Listing Definition in the parameter labeled “Trial Balance Definition”.


Now , you can define the Listing Definition at a Ledger or Ledger Set level such that when you run the report, you can view open liability balances for operating units belonging to a given ledger or ledgers within a ledger set as shown below:


double-arrow Similar Post

Posted in Oracle Payable, R12 | 6 Comments »

Receipt & Cash Managment

Posted on April 20th, 2008 by Sanjit Anand ||Email This Post Email This Post

In POS & Oracle integration , there was a need to unapply and reapply receipts which are already reconciled in Cash Management . The older SAP system, does work differently thus requirement was to achieve the same in oracle EBS.

Scenario input

To explore API availability to unapply and re-apply receipts which are already reconciled in cash management

Solution & Out of Box Functionlity

The receipt API’s work no matter what is the receipt status. A receipt that is confirmed can be applied or unapplied just the same as one that is already reconciled in Cash Management, there is no difference.

There is no connection between the application/unapply of a receipt and reconciliation in Cash management.

So you can unreconcile and then unapply or you can unapply and then unreconcile.

A receipt application refers to invoices/credit memos etc on which the amount sent by customer is closing the transaction balances.

A receipt reconciliation/unreconcile refers to the matching between a receipt and the statement sent by bank to confirm that the money paid by customer entered in your company account.

There is no link between these two business processes. A receipt can be applied/unapplied irrespective of its situation with Cash Management statement reconciliation.

The world of receipts API

As mention , in one of the post, there are 10+ API’s available to handle any scenarios of receipting process in oracle.

For transactions application and unapply

  • Ar_receipt_api_pub.Apply: Applies a cash receipt to a particular installment of a debit item. The application can also be a cross currency application.
  • Ar_receipt_api_pub.Unapply: Unapplies the application of a particular installment of a debit item against the specified cash receipt.

Suggested Reading

Posted in Oracle Receivable | No Comments »

Oracle E-Business Suite Sizing

Posted on April 19th, 2008 by Sanjit Anand ||Email This Post Email This Post

This is bit off-line topic(DBA Track) for sizing process in new EBS installation. Line managers, infrastructure heads, IS team, DBA and Implementation Leads must have to understand some key points for sizing as:

  • Sizing is a complex, iterative process and must be treated with care during the implementation.
  • It should not get conflicted as Sizing a mere calculation rather it a process.
  • Sizing is a project in its own right (PC, network, middle-tier and database-tier). Network is often forgotten in sizing projects.
  • System sizing and architecture goes a long way in determining the TCO of the software
  • It potentially means ability to grow vertically(Module wise) and Horizontally (Data)’
  • Customer, hardware vendor and the consulting patner should work together to find the best sizing strategy.
  • Your database Size should be based on benchmarks and collective experience of Oracle, H/W vendor and knowledge gained from existing customers.
  • Sizing process should not be confused with capacity planning, as both are different parameters.
  • Scaling & load balancing requirements can influence the architecture landscape
  • Validation of assumptions is key.
  • Predicting the batch processing load should not be ignored during an ERP sizing study. Batch loads may be a more important a factor than online requirements.

handFactors which decide some key drivers for sizing are:

  • Number of named users
  • Number of concurrent Users
  • Number of Concurrent Manager (CM) Process
  • Business Event
  • Business Intelligence (BIS)
  • Reporting
  • Number of years online data retention
  • Business volumes
  • Platform & H/W preference

Those who are looking some more granular details for sizing, there is one nice document from Oracle.

handMetalink Note

  • Note 399362.1 :Oracle Applications Release 12 Upgrade Sizing and Best Practices

Posted in Misc | 10 Comments »

R12 AOL : ‘Server-Responsibility Profile Hierarchy Type’

Posted on April 19th, 2008 by Sanjit Anand ||Email This Post Email This Post

In Release 12, profile options can now be defined to have a hierarchy type of server-responsibility.

  1. Site
  2. Server + Responsibility
  3. User

What does it mean?

…Simply you can understand like ,when you are choosing this type, the profile can be set at Site level, User level, or a new combination Server+Responsibility. This hierarchy type is set in the profile definition, and cannot be changed at runtime.

At the Server+Responsibility level, both the server and responsibility are considered as a pair. Profile values can be set for combinations of a specific server with a specific responsibility, or for only a server or responsibility with a default for the other.

Oracle documentation clearly states “at runtime, the profile value is determined by looking for the value set at the most specific level”

  1. A value set at the user level over-rides all others
  2. If no user level value is set, look for value matching the current server and responsibility.
  3. If no value is set matching both the current server and responsibility, look for a value matching the responsibility with a default server.
  4. If no value is found there, look next for a value matching the server with a default responsibility.
  5. Finally, if no value is set at any lower level, look for a site level value.

You can also do this in the hierarchy type can be chosen on the Profile Definition page. On this page, you can see that a type of “Server+Responsibility” is chosen. Once this hierarchy type is chosen, the profile can be made visible and updatable at the Site, Server+Responsibility, and User level. In this example, the profile could be set for Site or Server+Responsibility, but not User.


Posted in AOL | No Comments »

R12 SLA: Transaction Account Builder

Posted on April 17th, 2008 by Sanjit Anand ||Email This Post Email This Post

In R12 apart from AWB,there is yet another toolset which is called Transaction Account Builder aka TAB which normally used to derive default accounts for a particular transactions using sources , which is defined in the Accounting Methods Builder (AMB).

Normally this derives accounting codes from the TAB which internally driven the AMB setup attributes.

This is used derive default accounts for transactions before they are accounted and then it is used the AMB to generate the accounts that appear in the accounting.

TAB only derives default accounts for transactions. These accounts may not be the ones that appear on the subledger journal entries since these are generated by the Create Accounting program based on the application accounting definitions.

double-arrow What are key components

The TAB Components figure below shows the components


Moreover you can see the source and account derivation rules(ADD) are shared with the AMB which was discussed in one of the last post.


Will discuss some more details for this utility in some another post and we will try to compare how its different from Autoaccounting?

double-arrowSimilar Post

  1. R12 SLA: Analyzing Subledger Accounting
  2. R12 SLA: From Product Accounting to Subledger Accounting
  3. R12 SLA: Accounting Methods Builder
  4. R12 SLA: Transaction Account Builder

Posted in R12, Subledger Accounting | 8 Comments »

R12 SLA: Accounting Methods Builder

Posted on April 17th, 2008 by Sanjit Anand ||Email This Post Email This Post

In Subledger Accounting, have you heard something called Accounting Methods Builder, which is sort of toolset to define journal entry rules for the transactions and events of a subledger application . This allows us defining multiple sets of rules to be used concurrently for different requirements.

How AMB work?

Lets try to understand on the basis of Journal entry. Normally a journal are split into three main components:

  • Descriptions
  • Line Types
  • Account Derivation rules

A particular Journal can be best described as figure 1.0(adopted) as below.

1-6 Description : Description can be on the entry or its individual lines. You set up descriptions, as many as you want, by using pieces of data from the transaction and constant values.

Purposely it identify the journal line types, descriptions, and account derivation rules that will be used to create a journal entry for a particular event type

2-6 Type :The Line Type is another component, actually one of the two main components of the entry. The line type defines whether this is a debit or a credit, what the accounting class is, where the amount should come from etc. Again, you set up as many as you need of these for a particular entry. You can have a single invoice line or distribution create as many debits or credits as needed.

  • Under type you can identify the natural side of entry like Debit,Credit,Gain/Loss
  • This will determine the accounting class
  • You can set under which conditions the rule will create a line
  • This can be tighten by defining the values needed for entry line generation, such as amount, currency, conversion rate information

3-5 Account derivation rule : This determines to which GL account a line should be booked. You can have lot of flexibility around the account derivation rules. You can also set up a rule for each flexfield to be used, or you can make it more complex and build each flexfield segment by segment by combining multiple rules.

Normally these rules can be setup to derive the accounts or segment values from transactional data, including conditions of when to use a particular rule versus another.

You can also note,this will:

  • Determine which rule will be generic or specific for a given chart of accounts
  • This will identify what will be derived like Accounting flexfield or there respective segment or qualifier value or Value from a value set
  • This will also have a provision to define how the value will be derived for defaulting some Constant values or any Source value or any mapping set

double-arrowAccounting Methods Builder
The transaction objects and the sources carry transaction information into the rules defined for each component of an entry.

These components, for example, journal line type, account derivation rule, journal entry descriptions, are attached together as a journal line definition for a particular event.


Take a case if you set up a Journal line description for an invoice validation event, another one for a payment creation, another one for payment clearing. The set of such rules for a particular sub ledger application is called the application accounting definition. And the set of application accounting definition for multiple applications is called the sub ledger accounting method.

In reality this accounting methods is assigned to each ledger, which determines which rules are applied when accounting is being generated for a particular ledger. If you have a setup with a primary and a secondary ledger, you could have different accounting methods attached to and used for each. Sounds good.


double-arrow Your Navigation

  • Setup – Application Accounting Definition (Navigation)
    • Setup > Accounting Setups > Subledger Accounting Setup > Accounting Methods Builder > Methods and Definitions > Application Accounting Definitions
  • Setup – Subledger Accounting Method (Navigation)
    • Setup > Accounting Setups > Subledger Accounting Setup > Accounting Methods Builder > Methods and Definitions > Subledger Accounting Methods
  • Setup – Account Derivation Rule (Navigation)
    • Setup > Accounting Setups > Subledger Accounting Setup > Accounting Methods Builder > Journal Entry Setups > Account Derivation Rules

double-arrowSimilar Post

  1. R12 SLA: Analyzing Subledger Accounting
  2. R12 SLA: From Product Accounting to Subledger Accounting
  3. R12 SLA: Accounting Methods Builder

Posted in R12, Subledger Accounting | 4 Comments »

« Previous Entries