Question

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

  • 5 November 2019
  • 9 replies
  • 1136 views
W
Rank
Userlevel 4
Badge +8

Hi,

For IFS10UPD6 version, whatever it’s new installation or upgrade environment, we have an error like this, Is there anyone know how to fix this issue? 

1.Press new button in Inventory Part window(any other window with Boolean value). The system will trigger an error “The database value TRUE is not part of the Enumeration ‘FndBoolean’. ”

2. even we query it in PL/SQl developer, the script will not return the value.

    Select Fnd_Boolean_Api.Decode(‘TRUE’) from dual;

 

 

 

9 replies

Safras Ahamed
Rank
Userlevel 2
Badge +2

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.

W
Rank
Userlevel 4
Badge +8

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.

 

 

E
Rank
Badge +2

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

 

Thank you,

 

durette
Rank
Userlevel 7
Badge +18

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

 

If you find this forum useful, please consider paying back to the community in your own areas of expertise. -- Kevin Durette - https://www.linkedin.com/in/kevindurette
E
Rank
Badge +2

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 :)

E
Rank
Badge +2

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.

W
Rank
Userlevel 4
Badge +8

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.

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.

E
Rank
Badge +2

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

S
Rank
Userlevel 6
Badge +12

@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 ?

Reply


Terms & ConditionsCookie settings