Showing posts with label E-Business Suite. Show all posts
Showing posts with label E-Business Suite. Show all posts

Monday, February 19, 2018

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. 

Friday, October 27, 2017

Oracle Concurrent Program


Oracle Reports are executed as concurrent programs.

To find the executable used in the concurrent program:

Wednesday, October 25, 2017

Oracle Discoverer Metadata

Get a list of business area:

SELECT eb.ba_name business_area 
from  EUL_US.EUL5_BAS eb;

--

Monday, October 23, 2017

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.


Friday, January 29, 2016

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

Wednesday, December 9, 2015

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)



Tuesday, November 24, 2015

Thursday, October 15, 2015

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:

Wednesday, October 14, 2015

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.

--

Sunday, March 13, 2011

EBS HR DateTrack (1)

This is my first posting about the EBS DateTrack feature.

E-Business Suite Human Resource Management apps allows us to track the historical person information. Both Person and Employee Assignment are the "DateTrack" tables.

Why do we need the DateTrack feature?

Monday, December 13, 2010

Oracle EBS Data Model

Oracle EBS provides the technical reference guide in eTRM. eTRM is a documentation service provided by Oracle to the customers that have the support contract - etrm.oracle.com.

Oracle EBS stores the tables and descriptions in FND_TABLES and FND_COLUMNS. If the table and columns are registered using AD_DD, the table and column descriptions will be stored in the above tables.

See Also:

Friday, March 19, 2010

Multiple Currencies in accounting systems

Almost all accounting systems support multiple currencies.

There are some key concepts about multiple currency support:

1. Revaluation
  • The purpose is to ensure the account balance held in foreign currencies are represented with an accurate value in the base currency for financial reporting. This is required by GAAP.
  • The amount needs to be adjusted because of the currency fluctuation.
  • Revalue the account balance for balance sheet accounts (Asset and Liability), not the individual transactions.
  • Currency revaluation typically happens in the period end, which is also considered as the reporting date.
  • The exchange rate to be used is the spot at the end of period although sometime the accounting rule does allow the use of the average rate.
  • Revaluation Gain or Lost adjusting entries should be posted to the base currency.
  • The account balance amount will be adjusted by the adjusting entries.
2. Translation
  • The purpose of translation is to translate the amount available from one base currency to the other base currency.
  • Translation is typically part of the consolidation process.
  • The account balances from the base currency of a company is 'translated' to the base currency of the parent company.
  • The currency exchange rate to be used are the spot rates at the translation date (period-end date) for asset and liability balances and are the average rates for revenue and expense balances

Friday, June 6, 2008

Oracle EBS - Flexfield: How to find the Flexfield available for a table?

I would like to extend the Oracle E-Business Suite Applications to capture additional attribute.

I know the name of the table I would like to extend. How do I find the descriptive Felxfield?

Wednesday, February 13, 2008

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


Tuesday, February 12, 2008

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