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

Does the “Year End Close” is different than “Month end close” – Part -1

Posted on July 18th, 2007 by Sanjit Anand ||Email This Post Email This Post

Yes…slightly but how….

Similar to a Period End Close, however period 13 or some cases period 14 (Adjusting Period) is closed. This period is used for year end adjustments and once closed the Net Profit / (Loss) for the current year is transferred to the Reserve Account in the Balance Sheet

Which accounts get closed at the end of a fiscal year?

Normally during year end close most of the temporary accounts get closed. Typically temporary accounts are all of the income statement accounts (like revenues, expenses, gains, losses),the income summary account, and any other account that is used for keeping a balance of the current year amounts. These account begin with zero balance in each fiscal year.

Posted in Oracle General Ledger | 1 Comment »

Comparing Purchase Orders

Posted on July 17th, 2007 by Sanjit Anand ||Email This Post Email This Post

Here are the comparison of different purchase orders. The details of the different types can be discussed in my previous post.

compare pO

Posted in Oracle Purchasing | 3 Comments »

Is “Sequence” Important in Closing oracle Modules at Month end

Posted on July 14th, 2007 by Sanjit Anand ||Email This Post Email This Post

Yes.. It is important in Oracle application.

Lets start with period end sub ledger closing overview .
The period end process is performed at the end of each management accounting period in order to enable the reporting of the financial results for that period. This enables management to undertake accurate decision-making, and drives external reporting information. Normally there are 12 management accounting periods, each normally consist 5 or 4 weeks long, which are aligned and adjusted for the last week in the Year to coincide with the year end date (31st of December) and the first week in the year to coincide with in the start date of the Year Respectively. Apart from this there are 13th & 14th adjusting period for the year end set at the 31st of December.

In the period end process various steps are followed preparation, closure of sub-ledgers, the review of preliminary results, GL closure, production of reports and communication of information to users.

Is sequence important in month ending closure process

Lets start with a simple implementation site, the company has implemented Core financial products as well as entire manufacturing products in global instance and payroll is taken with another application which was interface with EBS product.

A typical data flow can be best understood as:


Normally the month end start sometime first Monday of week of the current month, Normal procedure is that the whole month end completes in 4-5 working days. Here are the sequence in which month end process performed.


Posted in 11i, Oracle General Ledger | No Comments »

Oracle API Availability – Cash Management

Posted on July 14th, 2007 by Sanjit Anand ||Email This Post Email This Post

In the Oracle API Availability, here is note for Availability in Oracle cash Management.

handBank Statement

Bank Statements Open Interface: Before reconciliation of transactions against a bank statement, information about the statement needs to be entered into the Cash Management system. If the bank provides this information in a flat file, the open interface is used to load the data. Data is loaded by programs written in SQL loader; one program for each type of file provided. The Oracle interface tables to be populated are CE_STATEMENT_HEADERS_INT_ALL, containing header information about the bank statement, and CE_STATEMENT_LINES_INTERFACE, containing the statement line information. The header file contains one record for every account in the bank statement.
Receipts and payments originating in non-Oracle systems can be reconciled in the Cash Management system using the Reconciliation open interface. However, the open interface view, CE_999_INTERFACE_ V, and open interface package, CE_999_PKG, provided by Oracle, need to be customized first. The Cash Management program automatically retrieves the necessary information from the open interface view for matching statement lines. (The Reconciliation Open Interface is not run as a separate program.)

Normally, the CE_999_INTERFACE_V is defined as a view to the legacy application’s database, and implemented to show all open interface transactions and their status. The view should include available transactions as well as reconciled transactions to bank statements that have not been purged or archived. The CE_999_PKG needs to be customized to access the non-oracle database, lock all transactions and perform any clearing functions so that the open transactions are in sync in both the Oracle and legacy databases. Once the view and package are modified and complete, the Reconciliation program is ready to be run. The reconciliation can be done automatically or manually, as required.

Auto reconciliation: The auto reconciliation program is used to automatically reconcile any bank statement in Oracle Cash Management, assuming the bank statement has been imported into the Cash Management system (a different version of this program does the import of the bank statement, if required). Once the reconciliation program is run, the auto reconciliation Execution Report is reviewed to identify any reconciliation errors that need to be corrected. This report is produced automatically, or can be run, whenever needed.

Manual reconciliation: Manual reconciliation can be used to reconcile any bank statement, whether imported or entered manually. In addition, new bank statement lines can be created while reconciling transactions, as well as update the reconciliation information for a previously manually-or automatically-reconciled statement

handCash Forecasting
Cash forecasting is a planning tool that helps in anticipating the flow of cash in and out of the business, allowing the projection of cash needs and evaluating the company’s liquidity. The Cash Management Forecasting Open Interface allows the utilization of external sources of data as cash inflow and outflow data for flexible cash forecasting.

Two cash forecast source transaction types, Open Interface Inflow and Open Interface Outflow, allow inclusion of external application transaction sources for cash forecasting. Having two separate source transaction types for external source transactions gives an easy way to indicate whether the transaction source consists of cash receipts (inflow) or disbursements (outflow). The Forecasting Open Interface collects cash flow amounts from the external systems, and the Cash Forecasting module summarizes and calculates the data to be included in the cash forecasts along with other Oracle Applications data.

Posted in API Integration, Finance | 2 Comments »

Understand Date Tracking in HRMS

Posted on July 14th, 2007 by Sanjit Anand ||Email This Post Email This Post

Irrespective of installation , whether it’s full or shared, it is important to understand the “date tracking” concept that oracle utilizing in HRMS.

Effective Dates
Date Tracking is a means of maintaining a history of changes to personnel records. It applies to the following parts of a person’s record in Oracle HR: People, Assignments. Each of the areas that are date tracked within a record are date tracked independently.

We can ‘date track’ by setting an Effective Date. An effective date is the date at a particular point in time when a person’s record is effective. When you set an effective date for your work, DateTrack ensures that only information effective on that day is used for any processing,
validation, enquiries and reporting you carry out.

Lets understand this in this simple diagram , which is consider as timeline of a personal record.

Persoanl record

It shows how the person’s Status has changed over time to reflect their changing circumstances. As the changes are made in Oracle, the system keeps a record of each change. These records can be thought of as different slices – or different pages in a file that show each change. Date tracking allows you to visit each slice or page at any time. If you set the effective date to 17 July 2001.. for example, the record would show that this individual is Married. Reset back to today and the marital status would show as divorced.

Take a another example for employee Assignment


In this example the assignment record shows how this person’s Position changes over time.

When this person originally started in company , their position was Programmer 1. Over time their position get changed and Oracle keep maintaining the history of this. In addition, this individual has been told that they have a new position which will take effect as of the 01 Jan 2008. Using date tracking you can record that this position change will take effect in advance of it happening – simply by setting the Effective Date to 01 Jan 2008 and making the change. Until that date actually arrives, the position will still show as the current one.

If there are future dated entries in the system (as in the assignment example above), and you wish to record a new change that will occur prior to the forthcoming change then Oracle will prompt you to Insert the record as part of the update. In this scenario, Oracle will insert a new ‘slice’ of history up to the date of the future change only.



In above diagram example, a future dated change was entered to record that this individual’s position is changing from Programmer Level 3 to Analyst on 1 Jan 2007. However, subsequent to this change being entered and saved in Oracle, this person will have a new supervisor from July 1st – i.e. before taking up the new position. If you now record the new supervisor change, Oracle will prompt you to ‘insert’ it. As such, a further slice of history will exist from 1 July 2007 to 1 Jan 2008.

Which columns in Oracle hold these values

To control these date tracking rows, every DateTracked table must include these columns:


Posted in 11i, Technical | 3 Comments »

Understanding Multi-Organization Structure in EBS(Technical) – Part II

Posted on July 14th, 2007 by Sanjit Anand ||Email This Post Email This Post

The multiple organization support feature uses native database features to build a security layer on top of a single installation of Oracle Applications. This layer of security provides the necessary data partitioning; while at the same time minimizes the number of potentially destabilizing changes to the application code itself. The security layer is provided using database views, which allow access to the partitioned data without any changes to the applications code.

For ERP applications, data partitioning is performed by database views. These views reside in the APPS Oracle schema and derive the appropriate operating unit context from an RDBMS variable.

All applications code is run against the APPS schema. The Applications database architecture is now the same for a Multiple Organizations and non-Multiple Organizations implementation.



Multi Organization Tables

  • Multiple Organizations in Oracle Applications is enabled by partitioning some database tables by operating unit. Other tables are shared across operating units (and thus across sets of books).
  • In general, the following criteria determine if a table would be partitioned:
    • The table contains a GL Account Code (code combination ID).
    • There is a business reason for the table to be partitioned (for example, the entity should not be shared).
    • The table contains transaction data.
    • The table is an interface table where data being loaded is partitioned.

Applications with Partitioned tables

o Oracle Cash Management
o Oracle Order Management and Shipping Execution
o Oracle Payables
o Oracle Property Manager
o Oracle Projects
o Oracle Purchasing
o Oracle Release Management
o Oracle Receivables
o Oracle Sales Compensation
o Oracle Sales and Marketing
o Oracle Service
o European Localizations
o Latin America Localizations
o Regional Localizations

RDBMS Variable
A global variable exists in the Oracle database called CLIENT_INFO, which is 64 bytes long. The first 10 bytes are used to store the operating unit ID (or ORG_ID) for the Multiple Organization Support feature. The CLIENT_INFO context is derived from a profile option that the user sets for each responsibility as part of the Multi-Org setup steps.

  • Org_id column in the warehouse contains the Operating Unit ID
  • Organization_id column contains the warehouse / Inventory Org.

select * from <table name>_ALL

Posted in Oracle Application | 4 Comments »

Understanding Multi-Organization Structure in EBS – Part 1

Posted on July 14th, 2007 by Sanjit Anand ||Email This Post Email This Post

In order to allow use of the system by multiple business units, accommodating differing requirements for functional currencies, accounting structures and security, whilst at the same time ensuring a central core design Oracle provides functionality known as “Multiple Organizations” in short is called ” multi-Org”.This allows different business units to have their own view of the applications, in particular for the financials AP ( Payables), AR ( Receivables), FA (Fixed Assets), CE (Case Management) and INV ( Inventory).

Multi-Org is an important feature of Oracle Applications for several reasons:

  • Allows multiple sets of books and multiple legal entities to be configured and to operate in the same instance
  • Provides support for data security between business units within a single applications installation
  • Permits users to sell and ship products from different legal entities (in different sets of books) with automatic intercompany accounting
  • Supports internal requisitions and purchasing/receiving products from different inventory organizations (within the same set of books)
  • Enables an enterprise to be housed in one database instance of Oracle, spanning multiple countries, currencies, and legal entities without a reduction in response times (architecture-related)
  • Multiple Organizations Reporting enhances the reporting capabilities of Oracle Applications products by allowing you to report at the:Set of Books level, Legal entity level or Operating unit level



Multiple Organization in Oracle Applications depends primarily on defining your organizational structure in the multi-level hierarchy used by Oracle Applications. The levels are:

  • Business groups
  • Accounting sets of books
  • Legal entities
  • Operating units]
  • Inventory organizations

Business Groups: Oracle Applications secures human resources information, including organization definition, by business group. At least one Business Group will be required for every country since the employee legislation is specific for each country and employee profile is set up at the Business Group level. Security access to the sensitive Human Resources data is secured at the highest level at the Business Group. In short Business Group partitions Human Resources information in a multi-organization structure. Organization Structures and Organization Hierarchy is defined within the Business Group.

Multiple sets of books can share the same business group if they share the same business group attributes, including HR flex-field structures (Grade, positions flex-fields etc).

Accounting sets of books: A General Ledger concept for having separate financial reporting entities for which chart of accounts, calendar, or functional currency differs. In addition for scalability and ensuring independent numbering system for all the accounting transactions as well as the ability to open and close each of the legal entities period independently a separate set of books will be configured for each legal entity.

Legal entities: An organization that represents a legal company for which you prepare fiscal or tax reports. You assign tax identifiers and other relevant legal company information to this entity.

Operating units: An organization that partitions and uses data for Payables, Purchasing, Order Management, Cash Management, Fixed Assets and Receivables. Operating Units allow for configuration of the Oracle Applications across Multiple Business Groups using a single installation of the software.

Inventory organizations: An organization that tracks inventory transactions and balances, and/or that manufactures or distributes products or components. Segregate Item data objects for Inventory, Purchasing, Order Entry, and the Manufacturing Applications (Organization_Id).

Examples could be manufacturing plants, warehouses, distribution centers, and sales offices

The following applications secure information by inventory organization: Oracle Inventory, Bills of Material, Engineering, Work in Process, Master Scheduling/MRP, Capacity, and Purchasing receiving functions. To run any of these applications, you must choose an organization that has been classified as an inventory organization.

HR Organization
Internal Departments to which Employees are Assigned.

Asset Organizations
An asset organization is an organization that allows you to perform asset–related activities for a specific Oracle Assets corporate depreciation book. Oracle Assets uses only organizations designated as asset organizations

Posted in Beginner, JumpStart | 28 Comments »

CSC Aquired Convansys

Posted on July 10th, 2007 by Sanjit Anand ||Email This Post Email This Post


News is that my ex-company completes Acquisition of Covansys last week.Since five years CSC has hardly have any acquisition or merger. If i am not wrong they brought some companies under there umbrella some time early 2000. It is expected , with the merger of convansys, the Indian presence will increases.And guess GTS customers are finding new delivery centers…or is this a threat to others MNC like IBM,EDS, Accenture …who have seen bit aggresive in at least in India…

Links to others news;

Posted in News | No Comments »

What is “Order To Cash” in Oracle?

Posted on July 5th, 2007 by Sanjit Anand ||Email This Post Email This Post

Order to cash normally refer to the process in which taking customer sale order via different sales channel like email, internet, sales person, fax or by some other means like EDI, and then fulfilling the order, shipping, logistic and then generating an invoice and collecting payment for that invoice and then receipt. if we consider the flow ,this can be further categorize into seven sub-process like

  • Customer
  • Order entry (creation of order /booking of order )
  • Order fulfillment
  • Distribution
  • Invoicing
  • Customer payments /Collection
  • Receipt

A typical flow can be best represented as:


Posted in Beginner | 16 Comments »

Understand “Drop Shipment” in Order Management?

Posted on July 4th, 2007 by Sanjit Anand ||Email This Post Email This Post

Order Management allows you to enter drop-ship sales orders as well as standard sales orders.

It means you can receive orders for items that you do not stock or for which you lack sufficient inventory, and have a supplier provide the items directly to your customer.



The best can be described as:


These are the following activity takes place when you have drop shipment

  • Supplier
    • Warehouse Item
    • Ship order
    • Shipment notification
  • Order Entry
    • Enter customer
    • Enter order
    • Demand order (optional)
    • Cancel order (optional)
    • Close order
  • Purchasing
    • Create and send Purchase Order
    • Enter shipment notification in system
  • Receivables
    • Create invoice
    • Collection of payment
    • Receipt

hence, drop ship order items ship directly from a supplier to the customer of the order processing company. A purchase requisition, then a purchase order, is generated to notify the supplier of the requirement. After the supplier ships the order, it notifies Purchasing to enter this information in the Purchasing module.

What are the advantages of Drop Shipment Orders?

These are the benefits:

  • No inventory is required
  • Reduced order fulfillment processing costs
  • Reduced flow times
  • Elimination of losses on non-sellable goods
  • Elimination of packing and shipping costs
  • Reduced inventory space requirements
  • Reduced shipping time to your customer
  • Allows you to offer a variety of products to your customers

How to understand the dataflow for Drop shipment Orders?

To understand, here are the processes divided in sub process and the underline activity is highlighted here:

DpshipmentflowHere are the Details as per Mark

1.Order Entry

Here the activity is entering process where oe_order_headers_all (flow_status_code as entered) oe_order_lines_all . The order is booked as DROP SHIP

2. Order Booking

3. The Purchase Release program passes information about eligible drop-ship order lines to Oracle Purchasing.The interface table which gets populated is

4. After Purchase Release has completed successfully, run Requisition Import in Oracle Purchasing to generate purchase requisitions for the processed order lines. The Requisition Import program reads the table po_requisitions_interface_all validates your data, derives or defaults additional information and writes an error message for every validation that fails into the po_interface_errors table.The validated data is then inserted into the requisition base tables po_requisition_headers_all,po_requisition_lines_all,po_requisition_distributions_all.Then use autocreate PO fuctionality to create purchase orders and then perform receipts against these purchase orders

7. After the goods are successfully received invoices for vendors are created in accounts payables as in normal purchase orders.

8. Invoices are generated for customers In account receivables.

9. oe_order_lines_all (flow_status_code ‘shipped’, open_flag “N”)

10. oe_order_lines_all (flow_status_code ‘closed’, open_flag “N”)

Hope this is great help to understand the flow.

Posted in Beginner, Oracle Order Management | 29 Comments »

« Previous Entries Next Entries »