How To Calculate Date Time In Selection Criteria For Cycle Count Task? (Doc ID 2722079.1)

Last updated on DECEMBER 05, 2022

Applies to:

Goal

How to Calculate Date Time in Selection Criteria for Cycle Count (CC) Task?

In UI: Task Creation >> Selection Criteria, user can add date time for location-last count time.
For example, with criteria 'location-last count time <= 2020-08-06 01:00:00',
system will be able to create CC tasks for locations that have not been counted since 2020 Aug 6.

Is there a way or expression to give criteria like ''location-last count time <= Today minus 90 days',
so that system will calculate the datetime for 'today minus 90 days' and create CC tasks based on the calculated date?

This is useful so that warehouse user does not need to manually change the date every time when they want to run a CC task template.

Details of the expected behavior.
1. Task creation UI
2. Select 'Cycle Count Tasks - A' task template
3. Select 'Selection Criteria'
4. Insert Basic Operation
    Sql operator:
    Column name: location-last count time
    Column value:
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.