Technology Stack - EBS (MOSC)

MOSC Banner

Display org name base on resp id in Form

edited Aug 20, 2021 10:54AM in Technology Stack - EBS (MOSC) Question

HI :  I am new using oracle Form 6i to support EBS 11.5.10.2.   I use template.fmb to create a simple form.  I was able to use fnd_profile.value(org_id ) to get the org_id.  here is my questions

1) I need to use this org_id to display the organization name on the form.  Then also save the org_id into a custom table.  The organization name is display only.  and should not affect anything.  How to do that?

2) the org_id is different.  I need to save it back to custom table.  not a issue.  But I have to use it as a filter when I do the Find/F11 to retrieve record from custom table.  For example.  if user login as US responsibility, the org_Id = 1 ( assume org_id = 1 mean US organization ).  when user do the F11 to find all record, it should only returns the record with org_id = 1 ( select * from custom_table where org_id = 1 ).  Now the thing is the org_id is not a display field.  So user

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center