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 is the database size you used?
can u explain which situation automonus transaction is used
What are the files you have used in the part of Conversion and Interfaces?
How can u populate data into po_headers_all segment2 column?
what is meant by bind parameter?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
tell me the scenarios of the independent in reports
wht r the basetables of customer interface?
You are working with interfaces if client doesnot give any flat then what will u do?
In developer Reports::there are 3 parameters.can you pass the paramter1+paratmeter2 value to the third parameter??
how can develope the po variance and po summary report? with tables mandatory columns and query please?
Exception Handilings?