Apps Technical - How can we tell the difference between seeded tables, static tables and the main transaction tables?

GeekInterview.com > Interview Questions > Oracle Apps > Apps Technical

Go To First | Previous Question | Next Question

Apps Technical | Question 61 of 129

How can we tell the difference between seeded tables, static tables and the main transaction tables?

Total Answers and Comments: 3

Last Update: October 25, 2007 Asked by: sbagai2001

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

October 17, 2006 17:49:34

shitul

RE: How can we tell the difference between seeded tabl...

difference between seeded table static table and transactinal table...let's use term seeded data instead of table to simplify..1) seeded data : it comes with oracle application...exa. countries teritorries ..2)system or static data : user defined default values exa. customer default values..3)Transactional data : more frequencly used data... exa . invoice order details...shitul.Oracle Apps Cosultant.

Is this answer useful? Yes | No

January 18, 2007 09:38:44

sudheer12d

Member Since: January 2007 Contribution: 11

RE: How can we tell the difference between seeded tabl...

Seeded Tables - Fnd_table name are the seeded tables in apps

Static Tables - Static tables are one that are updated using some scripts or triggers.

Transactions tables - Tables that link the trasactions between modules (Eg: PO & AP) or Tables in which a transaction data gets stored.

Cheers

Sudheer

Is this answer useful? Yes | No

October 25, 2007 09:43:12

Andy Noble

RE: How can we tell the difference between seeded tabl...

You can tell based on the TABLESPACE the table belongs to - this is the new Oracle Applications Tablespace Model (OATM)

Run the following code to see:

SELECT tablespace_name table_name
FROM all_tables
WHERE tablespace_name LIKE ' SEED ' -- seeded data
AND table_name LIKE 'FND '

SELECT tablespace_name table_name
FROM all_tables
WHERE tablespace_name LIKE ' TX ' -- transaction data
AND table_name LIKE 'FND '

SELECT tablespace_name table_name
FROM all_tables
WHERE tablespace_name LIKE ' ARCHIVE ' -- static data
AND table_name LIKE 'FND '

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank