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.


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,
      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)
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


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


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