ETL9.1: After Bundles 11-15 TA ABENDS At Step TL_TA000900.TA000951.Step51 (SQL) In Sql Server - Bad Syntax
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.
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
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.
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