@astark Did you get this resolved?  If so, what was the resolution?

Thank you.

@johnw66  No, I had to reach out to IFS support.  I will update this thread when I get a resolution.

@astark Thank you for your reply.  We are also on IFS Apps10 Update 8.

Hope you have a good Christmas.

@astark I have just logged a support call as well and will update when I hear anything.

Great, that should help show that this is just not an isolated issue.  What oracle version are you on?  We are on 19c. 

Merry Christmas to you as well!

@astark Was this ever resolved? We are having the same exact issue, on IFS10 UPD10.

Hi @ChaMylesC ,

Unfortunately no, IFS is having a hard time figuring it out.  They think it might be due to an Oracle version issue (we are on 19c) so I don't know what you are running but I would definitely put up a ticket and you can reference our ticket number G2223598 so they know there is another customer with the same issue.

Hopefully with more customers experiencing the problem a resolution can be reached.  We just upgraded to IFS10 UPD10 as well.

Anne

Thank you for the quick response Anne!

I will be sure to bring this up with my team today, and try to get another ticket with IFS open.

Hi @astark,

Could you please have a look at the response which I posted on the following question,
You might be having a similar issue.

Cheers !
Dhananjaya.

Thank you to everyone that has responded to this post.  That has resulted in finally getting a solution.  Here is what has our query builder now running:

run the following:

--------------------------------------------
declare
  lu_name_ VARCHAR2(30);
  pck_ VARCHAR2(2000);
begin
  FOR rec_ IN (SELECT lu_name lu_name FROM dictionary_sys_tab) LOOP
    BEGIN
      lu_name_ := rec_.lu_name;
      pck_ := Dictionary_SYS.Get_Base_Package(lu_name_);
    EXCEPTION
      WHEN OTHERS THEN
        Dbms_Output.Put_line(lu_name_);
    END;
  END LOOP;
end;
-----------------------------------

If you get data back you have to change the LU name in the view in the comment section for all invalid lu names, 

i.e. FROM:

COMMENT ON TABLE AGRX1APP.AGR_RESOURCE_EMP_LOAD_CAPACITY IS 'LU=AGR_RESOURCE_EMP_LOAD_CAPACITY^PROMPT=AGR_RESOURCE_EMP_LOAD_CAPACITY^MODULE=CUSOBJ^';

TO:

COMMENT ON TABLE AGRX1APP.AGR_RESOURCE_EMP_LOAD_CAPACITY IS 'LU=AgrResrceEmpLoadCapacity^PROMPT=Agr Resrce Emp Load Capacity^MODULE=CUSOBJ^';

 
If you do not get anything, execute the following script 

-----------------------------
BEGIN

    Dictionary_SYS.Rebuild_Dictionary_Storage_(0,'FULL'); COMMIT;

END;
----------------------------

Then refresh all the caches in refresh server caches in IFS.