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 11, 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


NOTE: In the example below and/or the attached document, user assignment details / user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance) for better understanding. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

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.