Skip to main content

We are currently using APPS10 update 20

We have a report rule working to generate a PDF file on a local server with an OutputFileName naming convention:

INV_6302_IFS[@CUSTOMER_ORDER_IVC_REP/CUSTOMER_NO]_[@CUSTOMER_ORDER_IVC_REP/INVOICE_NO].pdf

This works perfectly

I now want to add the invoice date as a string ‘YYYYDDMM’

When I try to add the field I get no error but also no output.

INV_6302_IFS[@CUSTOMER_ORDER_IVC_REP/CUSTOMER_NO]_[@CUSTOMER_ORDER_IVC_REP/INVOICE_NO]_[@CUSTOMER_ORDER_IVC_REP/INVOICE_DATE].pdf

 

Assuming this is because of the date format being pulled from the field but how do I change it.

 

Any help appreciated

Action properties:

 

@pknight You could format the file name using SQL. This would allow to you create any date format you need and convert it to a string.

[&SELECT 'INV_6302_IFS'||'[@CUSTOMER_ORDER_IVC_REP/CUSTOMER_NO]'||'_'||'[@CUSTOMER_ORDER_IVC_REP/INVOICE_NO]'||'_'||to_char(trunc('[@CUSTOMER_ORDER_IVC_REP/INVOICE_DATE]'), 'YYYYDDMM')||'.pdf' FROM dual]

 

 

 

Thanks for the prompt reply.

I didn’t realise SQL was allowed.

Tried the above though with no success but using SQL without the date works fine. So still an issue with format i assume.

[&SELECT 'INV_6302_IFS'||'[@CUSTOMER_ORDER_IVC_REP/CUSTOMER_NO]'||'_'||'[@CUSTOMER_ORDER_IVC_REP/INVOICE_NO]'||’.pdf' FROM dual]

Works perfectly but no date.

 

Thanks

@pknight This should work now.

[&select 'INV_6302_IFS'||'[@CUSTOMER_ORDER_IVC_REP/CUSTOMER_NO]'||'_'||'[@CUSTOMER_ORDER_IVC_REP/INVOICE_NO]'||'_'||to_char(to_date('[@CUSTOMER_ORDER_IVC_REP/INVOICE_DATE]', 'YYYY-MM-DD"T"HH24:MI:SS'), 'YYYYMMDD')||'.pdf' from dual]

The date was coming in as a string like this: 2009-06-29T00:00:00

So, we need to convert that to a date and then we can format it as YYYYMMDD.

to_char(to_date('2009-06-29T00:00:00', 'YYYY-MM-DD"T"HH24:MI:SS'), 'YYYYMMDD')

 

Perfect.

Thank you for the quick responses.

Much appreciated.

Terms & ConditionsCookie settingsAccessibility statement