"ORA-28365: wallet is not open" Error When Clicking "Add To Cart" for Non Catalog and Punchout Items (Doc ID 2804232.1)

Last updated on SEPTEMBER 03, 2023

Applies to:

Oracle iProcurement - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.9 version, Catalog Shopping

ACTUAL BEHAVIOR

After upgrade from R12.1.3 to R12.2.9 and when user click on "Add to Cart" of items from Non Catalog or Punching out from Supplier site ends with following error

ERROR

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT apc.card_id,
  ibycc.masked_cc_number as card_number
FROM ap_cards apc,
  ap_card_programs apcp,
  iby_creditcard ibycc
WHERE apc.employee_id = :1
  and apc.card_program_id = apcp.card_program_id
  and apcp.card_type_lookup_code = 'PROCUREMENT'
  and apc.card_reference_id = ibycc.instrid
  and nvl(apc.card_expiration_date, sysdate+1) > sysdate
  and nvl(apc.inactive_date, sysdate+1) >= sysdate
  and nvl(apcp.inactive_date, sysdate+1) >= sysdate
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:998)

## Detail 0 ##
java.sql.SQLException: ORA-28365: wallet is not open

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

STEPS TO REPLICATE

The issue can be reproduced at will with the following steps:
1. iProcurement Responsibility