Autoconfig fails

[big]

Hi,
On R12.2.9 DB 19c on AIX
Autoconfig fails with:
  afwebprf.sql            INSTE8_PRF         1
      amswebprf.sql           INSTE8_PRF         1
      csfadmprf.sql           INSTE8_PRF         1
      txkappsprf.sql          INSTE8_PRF         1
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Error encountered while running /u01/admin/install/afwebprf.sql
ERRORCODE = 1 ERRORCODE_END
ERROR at line 1:
ORA-01403: no data found
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Error encountered while running /u01/admin/install/amswebprf.sql
ORA-01403: no data found
ERRORCODE = 1 ERRORCODE_END
.end std out.
csfadmprf.sql
ORA-01403: no data found
I have already tried:
AutoConfig Fails during Execution of ADEXECSQL.PL on Applications Tier (Doc ID 2703264.1) <== sans résultat

AutoConfig Fails On Applications Tier In R12.2.0 EBS (Doc ID 1912332.1)
select LEVEL_VALUE2  from apps.ADX_PRE_AUTOCONFIG;
six lignes avec valeur "null"

http://shamkumardba.blogspot.com/2017/06/rc-50014-fatal-execution-of-autoconfig.html
Cause:

NLS_LANG parameter was already set on server.
To check $env|grep NLS
But no result.
Thanks for help.

[ErmanArslansOracleBlog]

You have ORA-01403 there..
You got the following scripts failing;

afwebprf.sql        
amswebprf.sql    
csfadmprf.sql    
txkappsprf.sql  

There may be a single common cause for all of that and it is probably a missing value in a standard table which is related with the configuration..
We need to start with the adwebprf.sql.

what is the the query that is given in the adwebprf.sql?
What do you get when you execute that query by connecting to the database manually?
What is the tables and columns visited in that query?

As I say, probably some value is missing .. maybe a profile value .. maybe another thing.. We need to investigate..