Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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 will happen If I am not giveing the Suspense accout while defineing the Set of Books in GL?

2 Answers   TCS,


Is that Possible To create package Overloading , If Yes Give any Examples

1 Answers   PWC,


While running the concurrent program we will get the status, we have to change the status. How it will be done.

2 Answers   Zensar,


Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

0 Answers  


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,


LOCKS?

1 Answers  


What is procedure?

3 Answers   IBM,


what u did after ur btech(2009) till now? why did u prefer oracle apps technical?

1 Answers   Intelligroup,


sourcing in GL

1 Answers   Convergys,


1. when we r doing interface/conversion which things u will take care to improve the perfrmonce?(except bulk collect) 2. In conversion,u r loading the data using sql*loader,I dnt want to use sql*loader,& i have millions of records,Id der any way to load the data withing fraction of time considering best performance. 3. When u r doing conversion,taht using sql*loader u r loading data into staging table,u r writing control file bt I dnt want to use sql*loader,when u r creating con prog that time can we pass all values from flat file using paramere,valuset?how? 4. In flat file u got 50 records,out of 50 ,30 records are proceesed & inserted into base table,after taht clien understood that 1 item having wrong name e.g insted of ABC he given DCE, so can we delete?hw?(client permission is der) i have lot of wrong item name randomly spreaded,can we delete it?hw? 5.after doing validation hw u will follow approach to error out records?if i want to send all the error out records to client daily,whats ur approach? 6. In outbound interface is der any way to load the data(large data-millions of records) except UTL_FILE package? 7. what is parsing? 8. In technical doc.s which section will mention?except code? 9. Do u have any idea about code depository tool? 10.whats is performance tunning,DB link? 11, How u will do RMA?

2 Answers   Cap Gemini,


what is the difference between request group and request security in oracle apps?

1 Answers  


Hi, can anybody tell me where is the requirement of Oracle Apps (functional+technical) in industry,Iwant to join there,If possible than call me---9313174232

0 Answers  


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)