PC_EX_TO_PC.40000000.Step01 (Action SQL) -- RC = 8601 Incorrect Syntax Near 'TIME1'
Last updated on APRIL 13, 2018
Applies to:
PeopleSoft Enterprise FIN Project Costing - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
PC_EX_TO_PC fails at Step PC_EX_TO_PC.40000000.Step01 (Action SQL) -- RC = 8601.
ERROR
-----------------------
Incorrect syntax near 'TIME1'
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Set Up Financials/Supply Chain > Common Definitions > Units of Measure > Units of Measure and for MDY set 7.5 hours instead of 8.
2. Create a project.
3. Go to Program Management tab and set the Hours Per Day to 8 MHR.
4. Add an activity.
5. Add a resource and associate it with the activity.
6. At the Resources by activity, Work tab, select the unit of measure MDY.
7. Create a time report (Travel and Expenses > Time Report > Create/Modify) for 40 hours.
8. Stage the time report.
9. Run the engine PC_EX_TO_PC.
Changes
Cause
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