ERP Journey : From Software to Cloud System

The Enterprise Resource Planning (ERP) revolution dates back at least to the 1960s, when manufacturers first used integrated software systems to manage raw material inventories and to reconcile balances between inventory and finished goods.

Through the 1970s and 1980s, software developers added accounting and human resources function into ERP systems. Those systems exploded in the 21st Century as developers incorporated sales force automation, marketing, and ecommerce functions into ERP systems. This gave managers a global perspective of their organizations and business intelligence that improved strategic planning and enabled better projections for business growth and development.

Cloud-based systems have become the next wave in the ERP revolution. Yes, those systems are leading the transformation of business intelligence from being confined to traditional physical brick-and-mortar business operations into the virtual presences that are the hallmark of modern connected businesses.


KnowOracle – 2017 Valuable Contribution – Member Recognition

2017 Members Appreciation :
Lets have acknowledgment and appreciation. Recommend your friends or member who helped you in something this year and we will highlight them as our appreciation.
Your Name :
Nominating to : ( Name )
Oracle Area : ( Functional / Technical / tool / Module ) :
Your recommendation/ appreciation Note :

No automatic alt text available.

Oracle – Meaning for different table names ending with (_B,_TL,_VL,_F)

Note that there are quite a few exceptions to the rules. It’s just a convention:

_B – base table. It holds the main details of the object in question and it implies that there is also a _TL table for it. You’d never find a _B table without a _TL table. the primary key is the id column.

_TL – translatable table. Holds the translated names/descriptions for base objects. will have one row per installed language. linked to the base table by the _id column. Doesn’t always imply that there is a _B as its base data could also be in a _F table or a table without postfix. The primary key is the id column plus the language column.

_F – date effective table. Tends to exist only in HR and it holds objects that are date effective. It means the primary key is the combination of the ID column, effective start date and effective end date. there is only 1 row per ID for any date, but you can have multiple rows for the same id over time. Some _F columns come with a matching _TL column, too.

_VL – translatable view. It’s not a table, but the view that represents the join of the base table and the TL table using the user’s session language. You can assume that almost all _TL tables come paired with a _VL view.

_M – multiple changes per date table. Like a _F table, but it allows rows to start and end on the same day. There is only one such table per_all_assignments_m, and it has additionally the effective_sequence in the primary key.

_DN – denormalised table: usually just a simplification of another table that holds hierarchies or trees of some kind. The denormalised tables are populated by ESS processes and hold the flattened hierarchy that has direct links between all nodes and their distance. Those are used e.g. for security profiles based on the manager hierarchy.


Oracle Cloud ERP – Multi Period Accounting in Oracle Fusion ERP Cloud

A detailed tour of the newly released Multiperiod Accounting functionality in Oracle Fusion ERP Cloud



Oracle ERP / Fusion – How to enable Global Search in Fusion Applications

How to enable Global Search in Fusion Applications

1) Login To Fusion

2) Navigate to ‘Setup and Maintenance’

3) Search for task: “Manage Administrator Profile Values”

4) In the ‘Profile Option Code’ Field input value: “FUSION_APPS_SEARCH_ENABLED”

5) Select Search

6) Under workspace: ‘FUSION_APPS_SEARCH_ENABLED: Profile Values’ set the value for ‘Site’ to “Yes” by clicking the drop down and toggling the value.

7) Save and Close




Happy Diwali – From KnowOracle

Happy Diwali – From KnowOracle & Shivmohan Purohit

Image may contain: text


KnowOracle – 3rd most read Blog on ERP by Feedspot.

KnowOracle – is highlighted 3rd most read Blog on ERP by Feedspot.


These blogs are ranked based on following criteria

  • Google reputation and Google search ranking
  • Influence and popularity on Facebook, twitter and other social media sites
  • Quality and consistency of posts.
  • Feedspot’s editorial team and expert review