You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Formatted Date is not displayed in the customized standard template

edited Oct 30, 2024 8:13PM in Enterprise Contracts 1 comment

Hi,

We have a requirement to customize the contract approval template to display contract notes details in the approval notification.

So i added the below query and linked and see all the columns data when ran from BIP.

I see all fields in the fusion approval notification except CD_DATE. it is coming empty.

I guess the date formation is not recognized at run time from fusion, hence it is showing empty.

Is there solution or fix or workaround available for this issue ??

Query:

select TO_CHAR(FROM_TZ(zn.CREATION_DATE, DBTIMEZONE) at time zone (select :xdo_user_timezone from dual),'DD-MM-YYYY HH:MI AM') "CD_DATE",

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!