Skip to content

Invoice validation pending standby

One of the request running long time with pending standby. so it will conflict with some request

Solution :

select * from fnd_concurrent_requests where concurrent_program_id in
(SELECT p.concurrent_program_id FROM FND_CONCURRENT_PROGRAM_SERIAL s, fnd_concurrent_programs_tl p WHERE
(s.to_run_application_id in (select application_id from fnd_concurrent_programs_tl where user_concurrent_program_name=’Invoice Validation’))
and
(s.to_run_concurrent_program_id in (select concurrent_program_id from fnd_concurrent_programs_tl where user_concurrent_program_name=’Invoice Validation’))
and s.running_concurrent_program_id=p.concurrent_program_id)
and phase_code <> ‘C’;

Kill the blocking concurrent request. then it will work

update fnd_concurrent_requests set phase_code=’C’ , status_code=’X’ where request_id=’10358051′;

ORA-29024: Certificate validation failure

After import end user certificate using oracle wallet manager to database server (19c) still we’re facing the below errors

SQL> select utl_http.request (‘https:// URL FULL PATH’,NULL,’file:/u01/app/oracle/product/19c/orahome_1/owm/wallets/orauat’,’Password’) from dual;
select utl_http.request (‘https:// URL FULL PATH ‘,NULL,’file:/u01/app/oracle/product/19c/orahome_1/owm/wallets/orauat’,’Password’) from dual
*
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-06512: at “SYS.UTL_HTTP”, line 1530
ORA-29024: Certificate validation failure
ORA-06512: at “SYS.UTL_HTTP”, line 380
ORA-06512: at “SYS.UTL_HTTP”, line 1470
ORA-06512: at line 1

Solution :

remove end user certificate, import only root and intermediate certificates

SQL> select utl_http.request (‘ URL FULL PATH ‘,NULL,’file:/u01/app/oracle/product/19c/orahome_1/owm/wallets/orauat’,’Password’) from dual;

Output comes

{ “error”: “missing_client”, “description”: “client_id is missing”

*URL FULL PATH means — certificates url

Unable to connect to the mail account. Check the host, user name, password and connection security

When we trying to configure workflow, the following error we’re getting

Unable to connect to the mail account. Check the host, user name, password and connection security

We checked that IMAP, SMTP port opened already. but still we’re getting the issue

Solution :

Functional Administrator – Clear cache and then bounce the service. its working now.

Database frequently stop connecting after upgrade 19c

We’re facing the issue database frequently stop connecting after upgrade to 19c (19.3). this database which is running on windows server 2016.

Errors in listener.log file

TNS-12518: TNS:listener could not hand off client connection
TNS-12546: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00516: Permission denied
64-bit Windows Error: 5: Input/output error

Core dump should created on somewhere in your database server locations.

Solution :

Apply database 19.7 or latest patches. the issue will be fixed

ORA-07445: exception encountered: core dump [ph2sf_scan_fields()+594] [ACCESS_VIOLATION] [ADDR:0x8] [PC:0x7FFA9B633C52] [UNABLE_TO_READ] []

We’re getting the below error while running utlrp.sql script after we applied 19.9 patch to database 19.3 which is running on windows server 2016.

2021-01-05T23:16:39.538245+03:00
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x8] [PC:0x7FFA9B633C52, ph2sf_scan_fields()+594]
Errors in file D:\APP\ORACLE\diag\rdbms\ezymir\ezymir\trace\ezymir_j000_94264.trc (incident=136519):
ORA-07445: exception encountered: core dump [ph2sf_scan_fields()+594] [ACCESS_VIOLATION] [ADDR:0x8] [PC:0x7FFA9B633C52] [UNABLE_TO_READ] []
Incident details in: D:\APP\ORACLE\diag\rdbms\ezymir\ezymir\incident\incdir_136519\ezymir_j000_94264_i136519.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.

Initially we thinking that its seems to be bug. But After we analyzed the trace file, there is one package body having issue for compilations.

Trace file :

name=XXXXX.CLK_CLM_PROCESS
Symbol file D:\app\WINDOWS.X64_193000_db_home\BIN\orasql19.SYM does not match binary.
Symbol TimeStamp=5cef5a1d, Module TimeStamp=5f8f4599 are different
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x8] [PC:0x7FFA9B633C52, ph2sf_scan_fields()+594]
Encountered exception while getting args for function:0x00007FFA9B685811
Symbol file D:\app\WINDOWS.X64_193000_db_home\BIN\orasql19.SYM does not match binary.
Symbol TimeStamp=5cef5a1d, Module TimeStamp=5f8f4599 are different
Encountered exception while getting args for function:0x00007FFA9B690D40
Encountered exception while getting args for function:0x00007FFA9B685811

*** 2021-01-05T23:16:40.272618+03:00
2021-01-05T23:16:40.272618+03:00
Incident 136519 created, dump file: D:\APP\ORACLE\diag\rdbms\ezymir\ezymir\incident\incdir_136519\ezymir_j000_94264_i136519.trc
ORA-07445: exception encountered: core dump [ph2sf_scan_fields()+594] [ACCESS_VIOLATION] [ADDR:0x8] [PC:0x7FFA9B633C52] [UNABLE_TO_READ] []

Solution :

We found that we have master schema there . this schema having lot of objects. those objects having read/write permission to other schemas. But we have missed some permission to some particular schema when we’re creating or importing. once we provided the particular privilege to the schema. we can able to compile the packages using utlrp.sql as well.

permission given like

GRANT ALTER, DELETE, INDEX, INSERT, REFERENCES, SELECT, UPDATE, ON COMMIT REFRESH, QUERY REWRITE, READ, DEBUG, FLASHBACK ON MASTERSCHEMA.table to xxxxx;

Unable to load resource jar files in ebs 12.2

We’re facing the some of the users are trying to open the forms after login ebs 12.2.9 with jre1.8.0_271, the forms are not pop up and says ” unable to load resource fndforms.jar and like other jar files”.

we have checked the group policy for trusted websites added, yes its added

We have checked the java exception site list policy, yes its there.

But still we’re facing the issues for some of the users. so its not a problem of java. it should be something blocking the site to reach servers whenever load jar files.

Yes finally, we got it. Our company firewall blocking rule is blocking JAR files by default. For EBS we have to allow JAR files.

Flexfield role assign to user in EBS 12.2

User Management

select user

assign the below role to user

code : UMX|FND_FLEX_VSET_ALL_PRIVS_ROLE

run workflow background engine after assigned

antivirus running on oracle database server

Read this article

https://pmdba.wordpress.com/2020/02/11/antivirus-for-my-database-server/

How To Configure Anti-Virus On Oracle Database Server (Doc ID 782354.1)

ORA-65036: pluggable database HRPDB not open in required mode

when i trying to clone the pluggable database, i am getting below error

SQL> CREATE PLUGGABLE DATABASE salespdb FROM hrpdb;
CREATE PLUGGABLE DATABASE salespdb FROM hrpdb
*
ERROR at line 1:
ORA-65036: pluggable database HRPDB not open in required mode

Solution :

If a PDB is in local undo mode, then the source PDB can be open in read/write mode during the operation, referred to as hot cloning.

local undo mode
The use of a separate set of undo data files for each PDB in a CDB.

hot cloning
Cloning a PDB while the source PDB is open in read/write mode.

SQL> show pdbs;

CON_ID CON_NAME                       OPEN MODE  RESTRICTED

     2 PDB$SEED                       READ ONLY  NO
     3 ORAPDB                         READ WRITE NO
     4 HRPDB                          MOUNTED

SQL> alter pluggable database hrpdb open;

Pluggable database altered.

SQL> show pdbs;

CON_ID CON_NAME                       OPEN MODE  RESTRICTED

     2 PDB$SEED                       READ ONLY  NO
     3 ORAPDB                         READ WRITE NO
     4 HRPDB                          READ WRITE NO

SQL> CREATE PLUGGABLE DATABASE salespdb FROM hrpdb;

Pluggable database created.

TNS-12557 TNS-12560 TNS-00527

While doing upgrade to 19c, dbua getting failed during netca listener creation in windows with following error

TNS-12557: TNS:protocol adapter not loadable
TNS-12560: TNS:protocol adapter error
TNS-00527: Protocol Adapter not loadable

Solution :

Before you start DBUA, please check the windows oracle_home & tns_admin environment set with old home & tns admin path. remove the old path from environment variables and start with 19c oracle home & path.