Fail To Add Customer To a Case (Doc ID 3078805.1)

Last updated on APRIL 03, 2025

Applies to:

Symptoms

Not able to add existing customer to the Entities->Customer tab-> Customer grid

Filename =ummService.log

See the following error:

[26-02-25 09:25:59,587 GMT AM] [DEBUG] [WEB] [UMM] [NA] [RDBMSDAOHANDLER] Stored Procedure query.......{ call pkg_cm_tabs.p_business_entity_ins( ?, ?, ?, ?, ? )}
[26-02-25 09:25:59,587 GMT AM] [DEBUG] [WEB] [UMM] [NA] [RDBMSDAOHANDLER] Stored Procedure input parameters.......{child_caseid=CA565376, Entity_Type=CUST, Id=(CCCCCCCCCC), ReviewId=CASEID, userId=ABCDEFG}
[26-02-25 09:25:59,593 GMT AM] [DEBUG] [WEB] [UMM] [NA] [RDBMSDAOHANDLER] SQLException occured while calling Database Stored Procedure...
ORA-01403: no data found
ORA-06512: at "STWOBJUSR_ATM.PKG_CM_ACTIONS", line 2042
ORA-06512: at "STWOBJUSR_ATM.PKG_CM_TABS", line 2648
ORA-06512: at line 1

[26-02-25 09:25:59,593 GMT AM] [ERROR] [WEB] [UMM] [NA] [LOGGER] ORA-01403: no data found
ORA-06512: at "STWOBJUSR_ATM.PKG_CM_ACTIONS", line 2042
ORA-06512: at "STWOBJUSR_ATM.PKG_CM_TABS", line 2648
ORA-06512: at line 1

java.sql.SQLException: ORA-01403: no data found
ORA-06512: at "STWOBJUSR_ATM.PKG_CM_ACTIONS", line 2042
ORA-06512: at "STWOBJUSR_ATM.PKG_CM_TABS", line 2648
ORA-06512: at line 1

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:265)

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.