PC_EX_TO_PC.40000000.Step01 (Action SQL) -- RC = 8601 Incorrect Syntax Near 'TIME1'

(Doc ID 2386078.1)

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