ERPstuff - Oracle EBS Community

<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

Pl download the Apps admin doc seems it is already covered. thanks

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

Hi Admin,

it is not covered in the Apps Admin Document.

Rgds,
Uma

Open the form and click in the field and then Menu: Help > Record History (Table Name: FND_USER ). Thanks

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.

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

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...

Dear admin and Dinesh,

That's what I used to do to find tables name too. I'm trying to find easier way to do it though.

friends tell now no body answer how we can see the table ad the filed for the form i try examin but its not showing ant thing plz help

Hi malahmad, What do you mean with your message? Hope what I wrote down here can help you.

[quote]friends tell now no body answer how we can see the table ad the filed for the form i try examin but its not showing ant thing plz help

<i><div align="right">Originally posted by malahmad

Here is a example,

SELECT owner
FROM dba_tables
WHERE table_name = 'FND_USER'

and the owner of this table is APPLSYS.

Thanks

[quote]Here is a example,

SELECT owner
FROM dba_tables
WHERE table_name = 'FND_USER'

and the owner of this table is APPLSYS.

Thanks

<i><div align="right">Originally posted by admin

The Last_Query option is already discussed above in this topic with example and this is nice that your problem is solved. thanks

The Last_Query option is already discussed above in this topic with example and this is nice that your problem is solved. thanks

<i><div align="right">Originally posted by admin - 16/05/2007 : 02:07:06 AM</div id="right"></i>

ahahaha silly me. so that's what you mean. thanks anyway.