When attempting to run the API –  HR_PERSONAL_PAY_METHOD_API  to create a personal payment methods, the following error occurs:

ORA-01403: No Data Found

Find that when using the API HR_Personal_payment_Methods_API.Update.US_Personal_Pay_Method, that the API fails with the following error:

ORA-01403: no data found
ORA-06512: at “APPS.HR_PERSONAL_PAY_METHOD_API”, line 2759
ORA-06512: at “APPS.HR_PERSONAL_PAY_METHOD_API”, line 3114
ORA-06512: at line 11

Script Terminated on line 1.

Cause :

The issue is caused by the following setup:

• There is no row in fnd_sessions table during the call of the API.

The following statement was not executed prior to the call of the API

• insert into FND_SESSIONS values (USERENV(‘SESSIONID’), <effective_date>);

Where effective_date should be the same date as the one passed as parameter p_effective_date in the API.  Since the effective date is available from within the application session the api does not error when called from within the PUI.

Solution :

To implement the solution, please execute the following steps:

1- Update the API call to include the following prior to the call of the api (before the declare)

insert into FND_SESSIONS
values (USERENV('SESSIONID'), trunc(sysdate));
commit;

2- Retest the issue and confirm on the results.

hope this helpful.