My Oracle Support Banner

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 03, 2019

Applies to:

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


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.

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

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.


 If employee is  converted from full time employee to contingent worker and to a different organization this  is  not covered by this  document. This is intended functionality.


To view full details, sign in with your My Oracle Support account.

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

In this Document

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