Skip to main content
Solved

IAL PREFIX

  • April 17, 2022
  • 6 replies
  • 313 views
ZTC ZTC JGOTA
Hero (Customer)
Forum|alt.badge.img+14

Hello IFS Community,

 

How do I know the username used to run an IAL?

Does IFS have a place where I could see the prefixes?

 

I am trying to run the query the following way 

select * from &IAL.PART_COST2 

(According to different posts I have read in the community) I need to add the prefix &IAL.

A pop-up window shows up asking for the value of IAL, and I input my AO, then the result is table or view does not exist. 

Fyi. The IAL was created correctly (See fig ). However, I do not know if I enter the correct username for IAL.

 

Best answer by sutekh137

Assuming permissions are OK, you have to look “up and over” into a different schema. In this case, “IFSINFO”. So, instead of using &IAL.<viewname>, use IFSINFO.<viewname>.

Hope that helps!

 

Joe Kaufman

JL

6 replies

S
Hero
Forum|alt.badge.img+12
  • sutekh137
  • Hero
  • 217 replies
  • April 17, 2022

By default the “info” user is IFSINFO. Look in Oracle for other schemas starting with “IFS”.

Where are you being prompted for “IAL”? When you write a Quick Report (for example) against an IAL, the &IAL should resolve without you needing to enter anything, as that is a globally defined parameter so IFS should not prompt you for input.

 

Joe Kaufman

Just because something is part of a plan doesn't make it right.
ZTC ZTC JGOTA
Hero (Customer)
Forum|alt.badge.img+14
  • ZTC ZTC JGOTA
  • Author
  • Hero (Customer)
  • 235 replies
  • April 17, 2022

Hello @sutekh137 

 

Thanks for your answer.

I am trying to use my PL/SQL developer tool to query the data.

 

How can I query an IAL view?

I am trying to do it this way => select * from &IAL.PART_COST2 

 

Thanks,

JL

 

JL
S
Hero
Forum|alt.badge.img+12
  • sutekh137
  • Hero
  • 217 replies
  • Answer
  • April 17, 2022

Assuming permissions are OK, you have to look “up and over” into a different schema. In this case, “IFSINFO”. So, instead of using &IAL.<viewname>, use IFSINFO.<viewname>.

Hope that helps!

 

Joe Kaufman

Just because something is part of a plan doesn't make it right.
ZTC ZTC JGOTA
Hero (Customer)
Forum|alt.badge.img+14
  • ZTC ZTC JGOTA
  • Author
  • Hero (Customer)
  • 235 replies
  • April 17, 2022

Thanks @sutekh137 

 

JL
S
Hero
Forum|alt.badge.img+12
  • sutekh137
  • Hero
  • 217 replies
  • April 18, 2022

No problem!

JoeK

Just because something is part of a plan doesn't make it right.
Charith Epitawatta
Ultimate Hero (Employee)
Forum|alt.badge.img+31
  • Charith Epitawatta
  • Ultimate Hero (Employee)
  • 1094 replies
  • April 20, 2022

Hi @ZTC ZTC JGOTA, 

How do I know the username used to run an IAL?

Does IFS have a place where I could see the prefixes?

You can find the name of the IAL Owner from “Information Access Layer (IAL) Oracle user” system parameter.

99% of the time, the IAL Owner is IFSINFO, but very rarely we have seen different names in some customer environments.

Hope this helps!

Charith - https://charith.pro


Terms & ConditionsCookie settingsAccessibility statement