HOW CAN U KNOW TABLE IS REGISTERD IN APPS?

Answers were Sorted based on User's Feedback



HOW CAN U KNOW TABLE IS REGISTERD IN APPS?..

Answer / kumar

use the following query to check the same:

select table_name from fnd_tables
where table_name = <table name>

table name = mention the table name, which u want to know
whether it is registered in APPS.

Is This Answer Correct ?    12 Yes 3 No

HOW CAN U KNOW TABLE IS REGISTERD IN APPS?..

Answer / kranthi kumar

U CAN KNOW FROM FRONT END ALSO
NAV: APPLICATION DEVELOPER-->APPLICATION-->DATABASE-->TABLE

QUERY FOR THE TABLE WHICH U WANT TO TEST.

IF IT IS REGISTERED THEN U CAN SEE THAT TABLE THERE.

Is This Answer Correct ?    7 Yes 0 No

HOW CAN U KNOW TABLE IS REGISTERD IN APPS?..

Answer / venkat kolla

Using ad_dd package.
Example:
First register the table:
EXECUTE ad_dd.register_table
('FND','TABLE_NAME','T',pct_free,pct_used)

Then register the columns:
EXECUTE ad_dd.register_columns
('FND','TABLE_NAME','COLUMN_NAME',
sequence, 'DATATYPE',col_width,nullable,translate)

Is This Answer Correct ?    4 Yes 7 No

Post New Answer

More Oracle Apps Technical Interview Questions

what is pay run id ?

0 Answers  


What is the maximum number of statements that can be specified in a trigger statement?

1 Answers   Oracle,


in sql loader,i have 100 records in my flatefile, i want to skip the 80 to 90 records .please help me

4 Answers   CTS, iGate,


Hi all I am in big career dilemma. I am currently working as Oracle Apps functional consultant scm with 1 yr of exp. I am thinking to do mba. Hos it will work to di MBA in scm or operations. Please guide .

1 Answers   TCS,


Can u define operating units inplace of inventory?

2 Answers  






please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in

0 Answers   Satyam,


what is instead of trigger in where u will use?

2 Answers   TCS,


If the flat file is having the duplicate records in the interface how can you restrict while transferring the flat file data in to interface tables?

3 Answers   Accenture,


what r the objects u have to do in u experiance

1 Answers  


In interface how u find errors and how to solve. How to fix it?

3 Answers  


how to get the on hand quantity of an item across all organizations? name the underlying tables.

2 Answers   Ranves IT Solutions, Scan Steel,


How many typres of Purchase order and what are those.

2 Answers   Accenture,


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)