R11i/12: OIE: Unable To Raise Per Diem Or Mileage Expense For User In Previous Active Assignment Period (Doc ID 846236.1)

Last updated on FEBRUARY 22, 2017

Applies to:

Oracle Internet Expenses - Version 11.5.10.2 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
AP_WEB_POLICY_UTILS


Symptoms

When attempting to create a Per Diem expense for a period when the user had an Active Assignment but not the current Assignment,  the following error occurs.

Error
oracle.apps.fnd.framework.OAException: java.SQLException: ORA-01403: no data found
ORA-06512: at "APPS.AP_WEB_POLICY_UTILS", line 40
ORA-06512: at "APPS.AP_WEB_POLICY_UTILS", line 101
ORA-06512: at "APPS.AP_WEB_POLICY_UTILS", line 147
ORA-06512: at line 1

Example
The user has an Active Assignment from 1-Dec-2008 to 19-Dec-2008 .
He got terminated from 20-Dec-08 to 1-Jan-09 and later he is under active assignments from
5-Jan-09 to 31-Dec-4712.
The user tries to raise a Per Diem expense on 6th Jan 09 to claim the expenses that were incurred when he was previously employed (1-Dec-08 to 19-Dec-08). When the user clicks on the Generate Per Diem button it throws an error.

Tried raising a normal expense report for those periods its working fine but not able to raise a Per Diem expense.


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