Wednesday, June 22, 2011

Oracle Forms Environment and Basic Navigations

Last posts explains you responsibility and functions.
Navigate to this in oracle apps
Responsibility - > Payables , Vision Operations(USA)

















Function         ->  Invoice


 Click Run when you are prompt for this warning.


Java Run Time(JRE) is loaded to display the forms.

 Once the JRE loaded you will get this find invoices form as shown below


Query for any invoice_num
Use this query to get any invoice_num( select invoice_num from ap_invoices_all )
Then click find button
You will able to see a form like this



To know where these records are fetched  from click help-> Record History



You will get this form



From this information you can able to know these informations coming from a view called AP_INVOICES_V

NOTE: The tables ending with _V or _VL are views
            The tables ending with _ALL are multi org tables ( it means there will be a column called org_id) we can discuss later about multiorg concept.

To know from which column the TYPE(Standard) is coming from



click Help -> Diagnostics -> Examine







From this you can come to conclusion that the data "STANDARD" comes from column name INVOICE_TYPE.
 Block Name is oracle internally given block name for each field to refer internally.

Switch Responsibility



To change the responsibility you no need to go to the browser and change.you can use the black color cap like symbol at tool bar to change the responsibility.

Please watch this video to know the basic navigation into oracle apps
http://www.youtube.com/watch?v=t4e2CHFMWDQ 


1 comment:

  1. Good way to explain Oracle Forms Environment and Basic Navigation. using the above information any beginner can navigate to oracle apps.
    sap support costs

    ReplyDelete