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 |
where do u specify in org_id?
How will u register concurrent request ?
What is procedure?
Plz anybody send me Technical specification for AP Interface
what are external tables? how can we use external table instead of sql * loader to load data from flat file to staging table?
what is tuning in oracle apps technical
what are the error tables in OM
IN WHICH MODULE THE LEGAL ENTITY COMES?
In a Standard form a DFF is disable?How we can Enable it?
35—how to create ldt lct files? 36—how to tranfor on file from one instance to another instance?
In custom.pll what are the events we can Not write.
is it possible to run the interface without using oracle apps?