We keep our latest form in any source code repository like
Serena Dimension, subversion (SVN), CVS (concurrent Version system) or any
other available repository as per client requirement.
Requirement:
When you open form from front end Application i.e. Oracle E-
business suit,
·
It is possible to view the version of form
present in application (Latest Version taken from source code repository).
·
Date when last modification is done.
·
Name of the person who modified the form or name
of organization.
·
Application where form is register.
Solution:
To add information like version, last modified date, Name,
oracles provide one standard API which we can use in Pre form trigger of the
form. So before actual opening of the form this information is already
available.
We can do this in our Custom form in any way as per client
requirement.
API use to populate Details:
FND_STANDARD.FORM_INFO(VERSION => /* Mention
Version of the from */
,TITLE => /*
Register from name in oracle application*/
,APPLICATION_SHORT_NAME => /*
Application short name */
,DATE_LAST_MODIFIED => /* Modification Date */
,LAST_MODIFIED_BY => /*
Name of Developer or Organization */
);
(Note: It is possible
to provide any values for application short name and title, but is you provide
correct details then you can see all logs of this form in standard table i.e. fnd_login_resp_forms.
This table will provide all login information of form from backend.)
Where to see Details in Front end application:
To see information from front end, login to E- business suit
and open you form.
Follow below navigation,
Help ->About Oracle Application -> (See details in
newly open window under current form.)
