Cloud ERP and Cloud Analytics

An interesting story I heard today.

People started using Cloud ERP and found that they are not satisfied with Oracle Cloud ERP.  The solution from Incorta helped saving the Cloud ERP implementation by providing an BICC based analytical solution.

Analytics and reporting capability is no longer a peripheral part of ERP.  It is an essential need.

Oracle Discoverer Metadata

Get a list of business area:

SELECT eb.ba_name business_area 
from  EUL_US.EUL5_BAS eb;

--

EBS Asset Reports

Here are the OOTB reports from EBS:

It looks like that the EBS FA team created a lot of OOTB reports!

FAS400 Journal Entry Reserve Ledger Report
FAS401 Responsibility Reserve Ledger Report
FAS402 Fully Reserved Assets Report
FAS403 Account Reconciliation Reserve Ledger Report
FAS410 Asset Inventory Report
FAS420 Asset Additions Report
FAS421 Asset Additions By Cost Center Report
FAS423 Conversion Assets Report
FAS430 Asset Transfers Report
FAS431 Asset Transfer Reconciliation Report
FAS440 Asset Retirements Report
FAS441 Asset Retirements By Cost Center Report
FAS442 Reinstated Assets Report

EBS EAM Resource Model

EBS EAM uses "WIP job" to model the service requests.
Each job can be done with a series of tasks that are modeled in the operation table.

The resources who are assigned to work on the jobs are stored in BOM RESOURCE.

BOM RESOURCE is not necessary in capturing the individuals.

WIP model was designed for Manufacturing, and was reused in EAM later.  EAM was added to Oracle E-Business Suite much later.

BOM Resources could labor or equipment.  When a BOM resource is created for labor, it can be created as a bucket.  The key is that the resources could be a constraint resource that you need to

• Identify the needs, in term of the skill requirements
• Estimate the demands, in term of labor efforts (hours)
• Measure whether you can sufficient resources to work on the jobs in the pipeline.

To identify the individual person who is part of the resource pool.  BOM RESOURCE EMPLOYEE can be used.  It links to the people records created in HR person table (PER_ALL_PEOPLE_F)

Run EBS on Window 10

It took me sometime to make EBS suite working on Window 10.

Oracle Applications: JDE, EBS, PSFT and ERP Cloud

Oracle shares a research note from Nucleus research.

Based on the matrix, from functionality perspective:

JDE > EBS > PSFT > ERP Cloud

From usability perspective:

JDE > ERP Cloud > EBS > PeopleSoft

Here are my observations:

Sales, Order, and AR integration

Many of the organizations want to track their revenue back to the sales organizations.

It is important to ensure that the data are collected in the upstream process, and the data can be passed into the downstream process.

I am recording the integration scenarios and customizations from a high tech company I am working with.

--