HOW CAN U KNOW TABLE IS REGISTERD IN APPS?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
What will happen If I am not giveing the Suspense accout while defineing the Set of Books in GL?
Is that Possible To create package Overloading , If Yes Give any Examples
While running the concurrent program we will get the status, we have to change the status. How it will be done.
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
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?
LOCKS?
What is procedure?
what u did after ur btech(2009) till now? why did u prefer oracle apps technical?
sourcing in GL
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?
what is the difference between request group and request security in oracle apps?
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