Skip to main content

We have an issue where IFS APPS 9 is not populating lists of values.

Example: on the Supplier screen, the “Form of business” field uses a list.  NOTHING appears in the list.

However, if I type the value eg CHARITY, the lookup works fine. If I ZOOM to the LOV, that works also.

Using debug, we can see that the sql to populate the list never gets run,  but only on the test instance.

This is only happening on a test instance, Live is OK (luckily),  but we are about to migrate to new hardware, and obviously a bit concerned that this may happen there.. (test data is an old copy of live)

Does anyone have any experience of this happening, and even better, a solution?

 

 

UPDATE:

 

Here’s what “Populate” tries to run on the offending instance: 

select from &AO.CORPORATE_FORM where COUNTRY_CODE = 'GB'

 

and here’’s what it runs elsewhere:

select CORPORATE_FORM,CORPORATE_FORM_DESC from &AO.CORPORATE_FORM where ( COUNTRY_CODE = :p0 ) and COUNTRY_CODE = 'GB'..

 

So the other one is missing field list AND where clause. But why?

 

 

 

I had this issue recently in IFS 9 with custom menus on certain screens.  We fixed it doing the following… maybe this can fix your issue as well:

In the Tools menu (press “Alt” on the keyboard if the File/View/Tools/Window/Help columns aren’t there), choose Options. Go to the Regional Settings tab and check the language.  If it reads “English (United Kingdom)”, change it just to “English” and then restart the application.

That repopulated all of our custom menus, since it wasn’t seeking a translation.

 

We are on IFS APPS10 and it works.

Do you have any customizations there or installed a new PG?

It works fine on our live system (and another test one).  Both Apps 9.

The instance is a copy of our live system. Except that works.

I have already tried changing the regional Settings, with no luck. 

It seems to be a technical issue.

Maybe a prod to test copy will help.

It seems to be a technical issue.

Maybe a prod to test copy will help.

We are doing a copy in a couple of days.  Fingers crossed.

Someone suggested that there may be a regional setting in the reconfigure, so we’ll have a look at that in the meantime.. 

It seems to be a technical issue.

Maybe a prod to test copy will help.

We are doing a copy in a couple of days.  Fingers crossed.

Someone suggested that there may be a regional setting in the reconfigure, so we’ll have a look at that in the meantime.. 

Great. Maybe you can post the result here. 🙂

We have a ticket open with IFS support.

In the meantime, I’ve found:

  1. If I try and view the custom fields on an affected screen, I get “The view for this page and logical unit do not match. It is not possible to add a Custom Field to this page”..
  2. LOVs on CUSTOM fields still work.

So far,  the search results I’ve found point to updates and/or patch level.

Ongoing

Terms & ConditionsCookie settingsAccessibility statement