How to check tables of each screen?
How to check tables of each screen?
<font face="Arial"></font id="Arial"><font size="6"></font id="size6">
Hi,
Can anyone guide me on how can I know what is the table name associated in each screen in Oracle EBS? For example, Customers - Standard is referring to table "ra_customers", Customer Addresses is referring to "ra_addresses_all", etc.
Thanks in advance,
SW
Hi,
Can anyone guide me on how can I know what is the table name associated in each screen in Oracle EBS? For example, Customers - Standard is referring to table "ra_customers", Customer Addresses is referring to "ra_addresses_all", etc.
Thanks in advance,
SW
Hi,
Did you refer to Oracle Applications - Administration 11i document found under Tutorials section? I downloaded and viewed it but couldn't locate the relevant guides on checking the table name. Perhaps you may hint on which section in the doc I can locate the solution?
Appreciate your help. Thanks.
Regards,
SW
Did you refer to Oracle Applications - Administration 11i document found under Tutorials section? I downloaded and viewed it but couldn't locate the relevant guides on checking the table name. Perhaps you may hint on which section in the doc I can locate the solution?
Appreciate your help. Thanks.
Regards,
SW
What admin wrote was ok if the field you look is really in a table but won't do any good if it's a view.
For example, when I try to create report about purchase orders I look at purchase order module and it refers to po_headers_v when I searched for Purchase Order ID.
I used toad to look at the table and it returns a blank table. After trial and error I found out that the field I looked for was recorded in table po_headers_all and that's just one field.
About the "type" field drove me crazy, after again trial and error I found out that seems it parsed value based on org_id. So, for me as a newbie, just to create a single Purchase Orders header report took me about a day and that's just the header.
Now, is there any easier way to find the table and field? Thanks.
For example, when I try to create report about purchase orders I look at purchase order module and it refers to po_headers_v when I searched for Purchase Order ID.
I used toad to look at the table and it returns a blank table. After trial and error I found out that the field I looked for was recorded in table po_headers_all and that's just one field.
About the "type" field drove me crazy, after again trial and error I found out that seems it parsed value based on org_id. So, for me as a newbie, just to create a single Purchase Orders header report took me about a day and that's just the header.
Now, is there any easier way to find the table and field? Thanks.
If the form is based on any view then it will show the name of view. Now for reports development you can use another feature by opening any form and search a record. Then Menu: > Diagnostics > Examine
Block = SYSTEM
Field = LAST_QUERY
In the value query like below will appear so modify it and use it.
SELECT start_date, end_date, responsibility_application_id,
responsibility_id, security_group_id, last_update_date,
last_updated_by, created_by, creation_date, last_update_login,
user_id
FROM fnd_user_resp_groups_indirect
WHERE (responsibility_id, responsibility_application_id) IN (
SELECT responsibility_id, application_id
FROM fnd_responsibility
WHERE (VERSION = '4' OR VERSION = 'W' OR VERSION = 'M'
))
AND (user_id = 1167)
ORDER BY responsibility_application_id, responsibility_id, security_group_id
Block = SYSTEM
Field = LAST_QUERY
In the value query like below will appear so modify it and use it.
SELECT start_date, end_date, responsibility_application_id,
responsibility_id, security_group_id, last_update_date,
last_updated_by, created_by, creation_date, last_update_login,
user_id
FROM fnd_user_resp_groups_indirect
WHERE (responsibility_id, responsibility_application_id) IN (
SELECT responsibility_id, application_id
FROM fnd_responsibility
WHERE (VERSION = '4' OR VERSION = 'W' OR VERSION = 'M'
))
AND (user_id = 1167)
ORDER BY responsibility_application_id, responsibility_id, security_group_id
Unfortunately there is no shortcut to find your desired field.
If I were you I'll do following to get my desired field name.
1) Help --> Record History (to see what table/view involved)
2) Help --> Diagnostic -->Examine (this will give you idea about name of field)
If record history show name of View ,i'll type name of view in toad's sql editor and hit F4 key...It will describe the view. Go to script and look what tables/view involed..and name of field you got from step 2.
Please note field name from step 2 may not match 100% with view field name. But most of the cases it is mosre or less same name.
In form development you are not bound to have exact same name of field as it was in Table or view. You can have different display name. Here you need to use common sense to establish which field in form is associated with column in table or view.
Hope that make life bit easier for you.
Take care out there...
If I were you I'll do following to get my desired field name.
1) Help --> Record History (to see what table/view involved)
2) Help --> Diagnostic -->Examine (this will give you idea about name of field)
If record history show name of View ,i'll type name of view in toad's sql editor and hit F4 key...It will describe the view. Go to script and look what tables/view involed..and name of field you got from step 2.
Please note field name from step 2 may not match 100% with view field name. But most of the cases it is mosre or less same name.
In form development you are not bound to have exact same name of field as it was in Table or view. You can have different display name. Here you need to use common sense to establish which field in form is associated with column in table or view.
Hope that make life bit easier for you.
Take care out there...
Who is online
Users browsing this forum: No registered users and 0 guests