The database value TRUE is not part of the Enumeration ‘FndBoolean’.

Looks like an issue with the Language File installation. Please check if you get a result when you run the following query.

select domain_sys.get_translated_values('FndBoolean', 'en') from dual;

If you do not get any results then you would probably need to import the language file fndbas_lu_logicalunit-core.lng and the corresponding translation files to the particular environment.

Hi Safras,

Thanks for your information!  According to our investigation,  it looks not a language issue.

sometimes the method Domain_SYS.Get_Translated_Values(lu_name_) doesn’t return any value. 

The system will return the value from PROG even there is no any language.

Hi, I encountered the same issue on fresh install of IFS10. Where you able to solve it?

Thank you,

Does the source code of FND_BOOLEAN_API.GET_DB_VALUES___ look sane?

This handy little diagnostic was introduced in Apps 10. (I don’t know which update.)

DECLARE
   client_values_ VARCHAR2(32767);
   db_values_     VARCHAR2(32767);
BEGIN
   fnd_boolean_api.enumerate_client_and_db(
      client_values_ => client_values_,
      db_values_     => db_values_);
   dbms_output.put_line('client_values_ = ' || client_values_);
   dbms_output.put_line('db_values_     = ' || db_values_);
END;
/

client_values_ = FalseTrue
db_values_     = FALSETRUE

Hi Durette, thank you for the fast response.

To be entirely honest, this is my first IFS installation. Not sure if the source code of 

FND_BOOLEAN_API.GET_DB_VALUES___

looks “sane”. Is this what you are looking for?

"-----------------------------------------------------------------------------
"
"-------------------- IMPLEMENTATION METHOD DECLARATIONS ---------------------
"
"-----------------------------------------------------------------------------
"

FUNCTION Get_Db_Values___ RETURN VARCHAR2 DETERMINISTIC;
FUNCTION Get_Client_Values___ RETURN VARCHAR2 DETERMINISTIC;

But here’s the output of the diagnostic you send above.

IFSAPP> DECLARE
           client_values_ VARCHAR2(32767);
           db_values_     VARCHAR2(32767);
        BEGIN
           fnd_boolean_api.enumerate_client_and_db(
              client_values_ => client_values_,
              db_values_     => db_values_);
           dbms_output.put_line('client_values_ = ' || client_values_);
           dbms_output.put_line('db_values_     = ' || db_values_);
        END;
[2020-12-16 21:52:50] completed in 1 s 122 ms
[2020-12-16 21:52:53] client_values_ = 
[2020-12-16 21:52:54] db_values_     = FALSETRUE

Indeed, 

client_values

differs from the expected result. Any idea about how to fix this?

Thank you very much :)

Fixed the issue by re-running the installer (Reconfigure). Output is now

IFSAPP> DECLARE
           client_values_ VARCHAR2(32767);
           db_values_     VARCHAR2(32767);
        BEGIN
           fnd_boolean_api.enumerate_client_and_db(
              client_values_ => client_values_,
              db_values_     => db_values_);
           dbms_output.put_line('client_values_ = ' || client_values_);
           dbms_output.put_line('db_values_     = ' || db_values_);
        END;
[2020-12-17 11:11:10] completed in 131 ms
[2020-12-17 11:11:11] client_values_ = FalseTrue
[2020-12-17 11:11:11] db_values_     = FALSETRUE

Not sure what happened.

IFSAPP> DECLARE
           client_values_ VARCHAR2(32767);
           db_values_     VARCHAR2(32767);
        BEGIN
           fnd_boolean_api.enumerate_client_and_db(
              client_values_ => client_values_,
              db_values_     => db_values_);
           dbms_output.put_line('client_values_ = ' || client_values_);
           dbms_output.put_line('db_values_     = ' || db_values_);
        END;
[2020-12-17 11:11:10] completed in 131 ms
[2020-12-17 11:11:11] client_values_ = FalseTrue
[2020-12-17 11:11:11] db_values_     = FALSETRUE

Sorry about my late response! We were made a mistake last year to share one CDB with PDBs of two database instance. It’s not IFS supported. In this case, one of database instance has such a problem. After we installed database separately, the issue was gone.

Makes sense, made the same mistake. Thank you WilliamRun!

@eric.schaal In order to fix the above problem, did you install the delivery with reconfiguration or did you do only a reconfiguration without any other options ?