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 18.104.22.168 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