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
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
Good way to explain Oracle Forms Environment and Basic Navigation. using the above information any beginner can navigate to oracle apps.
ReplyDeletesap support costs