EEX 9.1+: Time Report BI Publisher EXC7500 PDF Report Not Following ISO Compliant Date Format On Several Fields (Doc ID 1960474.1)

Last updated on MARCH 16, 2016

Applies to:

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

Symptoms

ISSUE:

A problem has been detected on the Time Report printing process (EXC7500 BI Publisher), once the fix from PeopleTools <Bug 13364554> has been fully implemented (both via codeline application, as well as Application Server and Process Scheduler configuration files set up). The resulting PDF file from the Time Report Print program should always contain ISO compliant date formats on all date related Fields (Format: YYYY-MM-DD). However, this is no longer the case, as the system has generated a file with 2 different date formats:

        - YYYY-MM-DD : Creation Date, and Submission Date
        - MM/DD/YYYY : Period Ending, and Print Date

The XML Data String created by the system for EXC7500 process is already containing ISO compliant date values (YYYY-MM-DD format), but somehow, when the PDF is generated, the dates get all changed up.

REPLICATION STEPS:

  - Have an FSCM 9.1 Environment with PeopleTools 8.52.08 or above (To make sure the codeline contains the fix from PeopleTools <Bug 13364554>)
  - Follow the below instructions to enable the delivered validations from the fix of <Bug 13364554>
       a) Application Server configuration file (psappsrv.cfg): Add at the bottom of the file the below new lines.
[File Layout]
;=========================================================================
;File Layout Settings
;=========================================================================
IsoXmlOutput=Y
       b) Process Scheduler configuration file (pscprcs.cfg): Add at the bottom of the file the below new lines.
[File Layout]
;=========================================================================
;File Layout Settings
;=========================================================================
IsoXmlOutput=Y
       c) Delete all Cache, and restart the Application Server and Process Scheduler
  - Log into the FSCM Online Application as User ID VP1
  - Navigate to: Employee Self-Service > Travel and Expense Center > Time Report > Create
  - Define Employee ID KU0042
  - Create a brand new Time Report transaction, booking Project hours, and submit the transaction for approval
  - Navigate to: Travel and Expenses > Travel and Expense Center > Time Report > Print
  - Add a new Run Control ID 'GCS'
  - Select Version Number 1 for the newly created Time Report ID, and run the EXC7500 BI Publisher process
  - Find the resulting PDF file, and confirm that the system is using different date formats on the below fields:
       - YYYY-MM-DD : Creation Date, and Submission Date
       - MM/DD/YYYY : Period Ending, and Print Date

To gather more information concerning this scenario and its related problem, refer to the available Replication Steps Word Document here linked containing the complete configuration and the replication steps necessary to reproduce the issue.

BUSINESS IMPACT:

The difference on date formats among the different Date related Fields of the printed Time Report transaction leads to confusion of the users, as depending on the values displayed, users no longer know the order between Months and Days.

EXPECTED BEHAVIOR:

The system should create a PDF file with one single date format, consistent, and that is ISO compliant (YYYY-MM-DD).
 

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