There Are No Active Responsibilities Available For This User

Problem:

While you are configuring DMZ Server on EBS you can some harmful changing
like 'Responsibility Trust Level’ profile
If  'Responsibility Trust Level’ status changed to 'external' from 'normal'
you may get this error below:

There are no active responsibilities available for this user


Solution:

1)

Run this procedure below with apps user:
--------------------------------------------------------------------
DECLARE
stat boolean;
BEGIN
stat := FND_PROFILE.SAVE('APPL_SERVER_TRUST_LEVEL', '2', 'SITE');
IF stat THEN
dbms_output.put_line( 'Stat = TRUE - profile updated' );
ELSE
dbms_output.put_line( 'Stat = FALSE - profile NOT updated' );
END IF;
commit;
END;
--------------------------------------------------------------------

2)Then shutdown application(adstpall.sh)

3)Then run autoconfig(autocfg.sh)

4)Finally startup your application(adstrtall.sh)

Login ebs and see your success:)


Pray and Tray:))

ORA-01565: error in identifying file

we get errors below while doing adcfgclone in test environment.

Problem:

ORA-01565: error in identifying file '/test1_db/sys/system11.dbf'
ORA-27048: skgfifi: file header information is invalid



Solution:

Resize dbfs which are full.


How to detect and fix a corruption in the datafile OS header/Block Zero - ORA-27047 (Doc ID 360032.1)
So please run the following command on the source database
dbfsize /test1_db/sys/system11.dbf

Done relinking module WSCMTM in product wsm

Problem:

While applying patch 12603409

Done relinking module WSCMTM in product wsm
Done with link of product 'wsm' on Fri Mar 29 19:34:26 EET 2013
adrelink is exiting with status 1


via adadmin relink WSM WSCMTI then 'An error occurred while relinking application programs.
Continue as if it were successful [No] :


Solution:

via adadmin relink WSM WSCMTI then 'An error occurred while relinking application programs.
Continue as if it were successful [No] :

adadmin-------->choose 2----->choose 1---->relink

Continue as if it were successful [No] :

Choose 'yes'

ORA-27048 skgfifi: file header information is invalid

Problem:

We got this error while running adcfgclone.pl

ORA-27048 skgfifi: file header information is invalid

Solution:

Check all the dbfs like this below:

dbfsize /test_db/sys/system01.dbf

If the output is 'Bad block'.This is dbf corruption.But don't worry.

You try to resize this dbf,then run see the dbsize again.

Ref:

R12: Rapidclone fails with error 'ORA-27048 skgfifi: file header information is invalid' [ID 1406053.1]

FRM-40735 On-Insert Trigger Raised Unhandled Exception ORA-04063

Problem:


FRM-40735 On-Insert Trigger Raised Unhandled Exception ORA-04063

Solution:

Apply the patch 13017245
Set ICX: Numeric characters = 10.000,00

Retest the issue