JBO-27122 Error Page When Contingent Workers Apply Template

(Doc ID 2040521.1)

Last updated on JULY 15, 2016

Applies to:

Oracle Time and Labor - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On :  12.1.3 version, Integration Issues

When contingent worker try to create a timecard with a template, Error Page is displayed, when user clicks on 'apply Template'

You have encountered an unexpected error. Please contact the System Administrator for assistance.  Click here for exception details.
Exception Details
---------------------
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.  Statement: SELECT * FROM (SELECT DISTINCT PO_Number PONumber,
      po_header_id POHeaderId,
      Description,
      operating_unit_name Operating_Unit_Name
 FROM po_sp_val_v
WHERE fnd_date.canonical_to_date (:1)   <= pol_expiration_date
  AND fnd_date.canonical_to_date (:2)   >= pol_start_date
  AND person_id = :3
  AND fnd_date.canonical_to_date (:4)   <= assignmt_effective_end_date
  AND fnd_date.canonical_to_date (:5)   >= assignmt_effective_start_date
  AND business_group_id = hr_general.get_business_group_id
  AND org_id = hxc_timecard_properties.setup_mo_global_params(person_id)
UNION
SELECT  poh.segment1 PONumber       ,
       poh.po_header_id POHeaderId ,
       poh.comments Description,
       hroutl.name  operating_unit_name
FROM    po_headers_all poh              ,
       hxc_time_building_blocks DAY    ,
       hxc_time_building_blocks detail ,
       hxc_time_attributes hta         ,
       hxc_time_attribute_usages htau  ,
       hr_all_organization_units hrou  ,
       hr_all_organization_units_tl hroutl
WHERE   poh.po_header_id                 = TO_NUMBER (hta.attribute8)
   AND day.parent_building_block_id    =:6
   AND day.parent_building_block_ovn   =:7
   AND detail.parent_building_block_id  = day.time_building_block_id
   AND detail.parent_building_block_ovn = day.object_version_number
   AND htau.time_building_block_id      = detail.time_building_block_id
   AND htau.time_building_block_ovn     = detail.object_version_number
   AND htau.time_attribute_id           = hta.time_attribute_id

  

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into Self Service Time
2. Click on 'Create Timecard'
3. Select desired template and hit 'Apply Template' button


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