Oracle Cloud ERP Coach – Learning & Sharing with Shivmohan Purohit –


Hello Friends,

With this blog , I am starting Cloud Learning Channel on Facebook as Cloud ERP Coach.  This blog contain more formal and structure articles but there are times where I feel , we should communicate easily and faster on day to day topics and have interaction. So I am starting “Cloud ERP Coach” on Facebook – Let’s join and continue with our Learning & Sharing Journey.

https://www.facebook.com/CloudERPCoach/

Thanks – Shivmohan Purohit

Advertisements

FREE Oracle Cloud Training By Oracle Product Development team


https://eventreg.oracle.com/profile/form/index.cfm?PKformID=0x4612612b569

Oracle SaaS Implementation Workshops for EMEA Partners

This registration page is to be used by EMEA based Partners only to register to Product Development led SaaS implementation workshops.

Several new Workshops published: BI Business Intelligence for Oracle Fusion Applications at EMEA time zone in April 17th-19th, 2018 as Remote. CX Engagement Cloud at EMEA time zone in April 9th-12th, 2018 as Remote. CX Engagement Cloud at EMEA time zone in June 11th-14th, 2018 as Remote. CX Sales Cloud at EMEA time zone in March 19th-23rd, 2018 as Remote. CX Sales Cloud at EMEA time zone in June 18th-22nd, 2018 as Remote. CX Service Cloud – Functional at EMEA time zone in March 19th-23rd, 2018 as Remote. CX Service Cloud – Technical at EMEA time zone in March 5th-9th, 2018 as Remote. EPM Enterprise Planning and Budgeting Cloud at EMEA time zone in February 12th-13th, 2018 as Remote. EPM Enterprise Planning and Budgeting Cloud at EMEA time zone in April 9th-10th, 2018 as Remote. EPM Financial Consolidation and Close Cloud at EMEA time zone in February 14th-15th, 2018 as Remote. EPM Financial Consolidation and Close Cloud at EMEA time zone in April 11th-12th, 2018 as Remote. EPR Financials Cloud at EMEA time zone in February 26th-March 2nd, 2018 as Remote. EPR Financials Cloud at EMEA time zone in May 14th-18th, 2018 as Remote. ERP Procurement Cloud at EMEA time zone in February 12th-16th, 2018 as Remote. ERP Procurement Cloud at EMEA time zone in April 16th-20th, 2018 as Remote. ERP Project Portfolio Management Cloud at EMEA time zone in June 4th-8th 2, 2018 as Remote. ERP Revenue Management Cloud at EMEA time zone in February 5th-6th, 2018 as Remote. ERP Revenue Management Cloud at EMEA time zone in May 23rd-24th, 2018 as Remote. HCM Cloud – Workforce Management/Rewards at EMEA time zone in January 22nd-26th, 2018 as Remote. HCM Cloud – Workforce Management/Rewards at EMEA time zone in April 23rd-27th, 2018 as Remote. HCM Cloud at EMEA time zone in March 5th-9th, 2018 as Remote. HCM Cloud at EMEA time zone in June 4th-8th 2, 2018 as Remote. SCM Inventory & Manufacturing Cloud (Foundation) at EMEA time zone in January 8th-12th, 2018 as Remote. SCM Inventory & Manufacturing Cloud (Foundation) at EMEA time zone in April 9th-13th, 2018 as Remote. SCM Order Management, Pricing & Configurator Cloud (Order to Cash) at EMEA time zone in February 5th-9th, 2018 as Remote. SCM Order Management, Pricing & Configurator Cloud (Order to Cash) at EMEA time zone in May 28th-June 1st, 2018 as Remote. SCM Planning Central Cloud (Plan to Produce) at EMEA time zone in January 29th-February 2nd, 2018 as Remote. SCM Product Hub & Innovation Managament Cloud (Ideation to Commercialization) at EMEA time zone in April 16th-20th, 2018 as Remote. SCM Supply Chain Orchestration & Cost Management Cloud (Adv Fulfillment & Managerial Accounting) at EMEA time zone in March 5th-9th, 2018 as Remote.

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 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

FUSION_APPS_SEARCH_ENABLED

2017-10-30_1717