Last updated on FEBRUARY 22, 2017
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms