Q/A Session on EBS:

1.Differences between the DBA_OBJECTS, DBA_OBJECTS_AE, and AD_OBJECTS tables?

DBA_OBJECTS shows object information for the current edition, but the STATUS column in this view may show the object as VALID even if the object actually needs to be compiled before use.

DBA_OBJECTS_AE is similar to DBA_OBJECTS, but shows object information across all editions.

AD_OBJECTS is the Oracle E-Business Suite workaround to the unreliable STATUS column in DBA_OBJECTS. AD_OBJECTS shows the correct status for each object visible in the current edition. It also shows whether the object is “actual” (a real object) in the current edition, or a “stub” object (the object definition was inherited from a previous edition).

Query AD_OBJECTS to locate objects that need to be recompiled before use:
SQL>select owner, object_name, object_type
from ad_objects
where status = ‘INVALID’
order by 1,2,3;

2.What is fs_clone and how is it used?
Command adop phase=fs_clone is a special command that is used to copy the run file system to the patch file system.

3.How to validate application user password from back-end?

select fnd_web_sec.validate_login(‘<username>’,’<password>') from dual;