Autoconfig failing with afcpctx.sh INSTE8_PRF -1

 Solution:

adrelink.sh force=y "fnd FNDCPUCF"

Call Oracle Stored Procedure from Shell Script

 #!/bin/bash

export ORACLE_HOME=/u01/app/oracle_home

export PATH=$PATH:$ORACLE_HOME/bin

export ORACLE_SID=ERPCDB1

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib

l_user='apps'

l_psw='Admin1234'

l_conn_string='mydb'

sql_error=`sqlplus -silent $l_user/$l_psw@$l_conn_string <<END

WHENEVER SQLERROR EXIT 1

begin

/* Call compute_sal stored procedure */

  XX_AP_PAY_BATCH_JOB_PRC;

exception

 when others then

  raise;

end;

/

 EXIT;

END`

Result=$?

echo $Result

if [[ $Result -ne 0 ]]

then

  echo "${sql_error}"

  echo "Error calling the PL/SQL procedure."

  exit $Result

else

  echo "PL/SQL Procedure executed successfully."

  exit 0

fi

EBS Workflow Mailer not sending mails mail_status failed solution

 

When a notification fails to be rendered or delivered from the Java tier (in this case due to an email server outage) then the notification will be placed into a FAILED state. The notifications that fails to be delivered to a user then has their notification preference set to DISABLED and any subsequent notifications will be automatically be set to FAILED either at the PL/SQL level or the java level depending on where the request for a notification is received. 

Run the following select statement to identify those users that are DISABLED:

select user_name from fnd_user_preferences where PREFERENCE_VALUE = 'DISABLED';

Below block update the user preferences

DECLARE

 l_disabled_count NUMBER;

 l_updated_count  NUMBER;

BEGIN

 DBMS_OUTPUT.PUT_LINE('Program to display updated row count');

 DBMS_OUTPUT.PUT_LINE('**************************************');

    SELECT count(*)

    INTO   l_disabled_count

    FROM fnd_user_preferences

    WHERE PREFERENCE_VALUE = 'DISABLED';

    dbms_output.put_line('Disabled Count :'||l_disabled_count);

     BEGIN

     update fnd_user_preferences

     set    preference_value = 'MAILHTML'

     where PREFERENCE_VALUE = 'DISABLED';

       

     dbms_output.put_line('Updated Row count: '||SQL%ROWCOUNT);

       COMMIT;

       

     EXCEPTION WHEN OTHERS THEN

     dbms_output.put_line('Error in Update - '||SUBSTR(SQLERRM,1,100));

     END;

       

 DBMS_OUTPUT.PUT_LINE('**************************************');

EXCEPTION WHEN OTHERS THEN

DBMS_OUTPUT.PUT_LINE('Error in Main - '||SUBSTR(SQLERRM,1,100));

END;

Linux 8 FRM-92101 in EBS R12.2 Post Cloning or New Install: There was a failure in the Forms Server during the start-up

 

# cd /usr/lib

# ln -s libXm.so.4.0.4 libXm.so.2

Install 19c on Linux 8

 

[root@primary01 ~]# cp -p /usr/bin/scp /usr/bin/scp-original
[root@primary01 ~]# echo "/usr/bin/scp-original -T \$*" > /usr/bin/scp
[root@primary01 ~]# cat /usr/bin/scp
/usr/bin/scp-original -T $*

Apply HRGLOBAL and DataInstall in R12.2

 Step 1 -Apply hrglobal.drv

a) Start an online patching cycle
Source the run edition Example: UNIX: $RUN_BASE/EBSapps/appl/APPS$CONTEXT_NAME.env
$ adop phase=prepare
b) Run DataInstall from PATCH edition
Run at $APPL_TOP available.For multi-node/RAC setups,DataInstall run on the primary node.
java oracle.apps.per.DataInstall <un> <pw> thin <host:port: sid >
where
< un > username of the apps
<pw> password of the apps
<host:port: sid > database connection information
example: java oracle.apps.per.DataInstall apps apps thin dbsvr1:1521:testdb
IMP 12.2: DataInstall run on Patch Edition Environment.
list in menu 1 followed by I for install or C for clear;
e.g. In menu 1, to install Global choose 1I, to cancel a selected operation, choose 1C etc.
Menu 4 to choose to save your changes when you are OK with them.
c) Apply hrglobal.drv
$PER_TOP/patch/115/driver/hrglobal.drv and should be run on the tier which has the $APPL_TOP available.
hrglobal.drv is a pure "database driver. For RAC/multi-node setups, it is only required to run the hrglobal.drv on one node.
IMP 12.2: applied via the adop patcing utility.
Example: adop phase=apply patchtop=$PER_TOP/patch/115 patches=driver:hrglobal.drv options=nocopyportion,nogenerateportion,forceapply
d) Complete the online patching cycle by running the following commands:
1. $ adop phase=finalize
2. $ adop phase=cutover
3. $ adop phase=cleanup
Step 2 - OPTIONAL
For customers using other languages than US and wishing to apply translated legislative seed data,please apply the relevant language specific version of the consolidated translation patch after successfully completing the hrglobal.drv.

ISGADMIN~~ failed to be authenticated while try to undeploy webservice

 When i trying to undeploy the REST service in UAT and deploy again, i am getting the below error.

 

ISGADMIN~~ failed to be authenticated 

Solution :

verify the asadmin given credential correct and roles using below queries, should be the same:

select FND_VAULT.get('ISG', 'ASADMIN') from dual;
select FND_VAULT.get('FND', 'ASADMIN') from dual;
Select fnd_web_sec.validate_login('ASADMIN','<ASADMIN password>')

Run the txkISGConfigurator.xml utility with “ebsSetup” argument.

 

ant -f $JAVA_TOP/oracle/apps/fnd/txk/util/txkISGConfigurator.xml ebsSetup -DforceStop=yes -DforceDataSourceExists=true -DforceAuthenticationProviderExists=true