Date Format for Risk management Imported Objects — Cloud Customer Connect
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

Date Format for Risk management Imported Objects

in Risk Management and Compliance 2 comments

We have a requirement to check if any Manual Invoice Payment is done on the Last Working of a day of the month. To Achieve this, i have created an imported object and provided last working days for each month.

I am able to import object and the date looks same as the Payment Date which i want to compare. However, when i write the equals condition of Payment Date equals to Last working day, oracle is not able to give results though we have payments on the date as per last working day. Looks like there is some data type issue when oracle is comparing dates of imported object vs Payment date/payment creation date.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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