My Oracle Support Banner

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

Last updated on FEBRUARY 07, 2019

Applies to:

PeopleSoft Enterprise FIN Project Costing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


PC_EX_TO_PC fails at Step PC_EX_TO_PC.40000000.Step01 (Action SQL) -- RC = 8601.

Incorrect syntax near 'TIME1'

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.




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.