Fixed Assets

Unique 'Tag Numbers' are assigned to a each asset in FA...Incase you need to group assets use 'Asset Key'.

Q. Why do I have journal entries for zero dollar amounts? (i.e. Debit 0 Credit 0)
A: The expense segment is part of a single distribution row which also contains the asset's owner and location.  Changes to any one of these items will result in the creation of a new distribution.  If a change is made in the location or owner, journal entries are posted to reflect the new distribution, even though there has been no accounting impact (thus the zero dollar accounting entries).

Q. 
A: 

DBA Basics

• View common db properties

SELECT Property_Name, Property_Value, Description
FROM Database_Properties

• Oracle Apps Release/Version from backend?

SELECT Release_name FROM Fnd_Product_Groups

• Multi-Org enabled?

SELECT Multi_Org_Flag FROM Fnd_Product_Groups

• Multilingual?

SELECT Multi_Lingual_Flag FROM Fnd_Product_Groups

• MRC Implemented?

SELECT Multi_Currency_Flag FROM Fnd_Product_Groups

• How do I find the tablespace name where I need to create the table in xyz schema?
  

Get the tablespace name using the below query:
SELECT * FROM dba_users WHERE username = 'xyz'
Tablespace details if required, can be viewed from dba_tablespaces table.

Oracle Value Chain Planning

Oracle Value Chain Planning (earlier called Oracle Advance Planning and Scheduling) is an integrated set of mules which enables companies to efficiently design, plan and service their value chains from 'factory to shelf'.

Fusion

Overview
Fussion Apps will fully leverage ADF for the UI