R11i/12: OIE: Unable To Raise Per Diem Or Mileage Expense For User In Previous Active Assignment Period
Last updated on JANUARY 25, 2018
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.
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