CUSTOM CWK NUMBERING ERRORING UNDER SELF SERVICE CONTINGENT WORKER PLACEMENT (Doc ID 978030.1)

Last updated on APRIL 03, 2011

Applies to:

Oracle Self-Service Human Resources - Version: 11.5.10.2 and later   [Release: 11.5.10 and later ]
Information in this document applies to any platform.

Symptoms


On : 12.1.1 version, Hire, CWK Placement, Appl Hire

When attempting to create Contingent Worker Placement with auto CWK numbering from Self Service,
the following error occurs.

ERROR
-----------------------
oracle.apps.fnd.framework.OAException: java.sql.SQLException:
ORA-01086: savepoint 'CREATE_PERSON_BEN_SS' never established
ORA-06512: at "APPS.HR_PROCESS_PERSON_SS", line 8775
ORA-01086: savepoint 'CREATE_PERSON_BEN_SS' never established
ORA-06512: at line 1

A custom Fast Formula is used to create automatic employee numbering. This works fine without any issue from core the application.
Custom CWK Numbering errors under Self Service Contingent Worker Placement. The custom Fast Formula is used to create a non-numeric value (C001, C002) automatically.
But from SSHR its a mandatory field needs to be entered manually even thought its set to automatic numbering.
When Contingent worker number is set to manual Java error does not occur from SSHR. Java error only occurs if the contingent worker numbering is set to automatic.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Manger Self-Service -> Contingent Worker Placement
2. Fill out details for Contingent Worker Placement
3. Last page shows error.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create Contingent Worker Placement records with auto CWK numbering. This affects all Managers. Would not be able to roll out this Self Service Feature.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms