ETL9.1: After Bundles 11-15 TA ABENDS At Step TL_TA000900.TA000951.Step51 (SQL) In Sql Server - Bad Syntax (Doc ID 1921115.1)

Last updated on JULY 13, 2016

Applies to:

PeopleSoft Enterprise HRMS Time and Labor - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

On : 9.1 version, Time Administration

When attempting to process Time Administration in a SQL Server environment it abends at Step TL_TA000900.TA000951.Step51, due to alias. After Bundles 11-15 ABENDED at Step TL_TA000900.TA000951.Step51 (SQL) in Sql Server - Bad Syntax

ERROR
-----------------------
Supplied SQL code at step TL_TA000900.TA000951.Step51 is as follows.
DELETE FROM %Table(TL_IPT1) B WHERE B.PROCESS_INSTANCE = %Bind(PROCESS_INSTANCE) AND (B.TL_QUANTITY >= 0 AND B.TL_QUANTITY < 0.01) AND B.TL_RULE_ID <> ' '

Sql Server complains about the alias B in the delete statement. There should not be an alias in the SQL. It should have been as follows. Please correct the SQL.


The issue can be reproduced at will with the following steps:
1. Report Time
2. Run Time Administration in Sql Server Environment.

The issue has the following business impact:
Due to this issue, users cannot run Time Administration to create payable time.

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