Best Of

As the response has provided you with an answer, please click Yes for the prompt ‘Did this answer the question? Yes No’ on the comment.

This helps identify effective solutions within threads and encourages community users to assist others by providing potential solutions.

Thanks

ShyamG-Oracle

1

Re: After execution of concurrent program, SQLException encounter while executing data trigger

Hi User_TA6AG,

Please log service request with EBS XML publisher product to validate Data definition setup and validate data.

Thanks,

Hari

Hari Kumar-Oracle

1

Re: Patch Wizard Credentials

Alexandru

Think this is definitely the issue as 37051792 has been superseded by 37059554:R12.ADO.C PASSWORD LIMITATIONS IN UPDATE MOS CREDENTIALS IN OAM.

Patrick

patrickrankin

1

Re: JDE user password

Hello,

The default change frequency from Processing Options is taken into consideration when a user is created.
It will populate the change frequency value for the user which is created.
Revise All shouldn't be greyed out. You should investigate why it is greyed out.

Thank you!

Best regards,
Cezar

CezarB-Oracle

1

Re: OL9 ORA 19C OJVM Patch Re-link fails on target "javavm_refresh"

This resolved the issue.

--MOS - Patching fails during relink , with error code 102 :: Fatal error: Command failed for target `javavm_refresh' (Doc ID 2002334.1)

CAUSE
PERL5LIB environment variable is not set

SOLUTION
Oracle provided Perl needs to be referenced at the beginning of the PATH and PERL5LIB for Patch apply or rollback.

Set PATH and PERL5LIB environment variable and apply patch again.

export PATH=$ORACLE_HOME/perl/bin:$PATH

export PERL5LIB=$ORACLE_HOME/perl/lib

=========================================================

$ORACLE_HOME/OPatch/opatch rollback -id 36199232

$ cd /orahome1/orainstalls/PATCHES/DB/OJVM/36199232

$ $ORACLE_HOME/OPatch/opatch apply

=========================================================

Marcelo Marques

1

Re: Performance issue due to index not being used

Index is on 4 columns and WHERE clause is on index first 3 columns. My guess would be optimizer can't properly access how many rows query returns. Is data skewed? If so, is stats collected with histograms? Also, what happens if you collect extended stats:

SELECT DBMS_STATS.CREATE_EXTENDED_STATS('<table-owner>','KCM_GRP_CONTRIBUTIONS','(POL_LINKED_POLICY_ID,STATUS,DATA_TYPE)')
  FROM DUAL;
EXEC DBMS_STATS.GATHER_TABLE_STATS('<table-owner>','KCM_GRP_CONTRIBUTIONS');

SY.

SolomonYakobson

1

Welcome to the My Oracle Support Community

Best Of