Oracle EBS Asset Model and Reporting

EBS FA is an old model and the application is widely deployed in most of EBS sites.

Almost all companies has assets and need to report their assets in their accounting reports.

While many people, including Oracle, has provide some reporting solutions for EBS FA, I think that doing it right in a most optimal way is often.  It affects the time required for monthly or year end period closing and a reporting solution that allows the deploying company to quickly see the change they made and continue working is essential for their business.

Historical Information

EBS FA stores asset historical information. 

Oracle Concurrent Program

Oracle Reports are executed as concurrent programs.

To find the executable used in the concurrent program:

Oracle Discoverer Metadata

Get a list of business area:

SELECT eb.ba_name business_area 
from  EUL_US.EUL5_BAS eb;

--

Oracle EBS Endeca Views

Oracle Financials Information Discovery Plus is a product built on Endeca.

The architecture is to load the data into a big flattened index used by Endeca tool.

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.

--

Organization Model in ERP (2)

Credit Control Area for credit management

SAP applications allows the user to manage the customer credit limits by credit control area.

"A credit control area is an organizational unit for specifying and controlling customer credit limits. A credit control area can include one or more company codes. It is not possible to divide a company code into several credit control areas."

Organization Model in ERP (1)

I am interested in study how various ERP models the organizations. I have been involved in designing this functional area for several years. I feel that I want to write something about it.

SAP Company Code and Oracle E-Business Suite