My Oracle Support Banner

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

Last updated on OCTOBER 26, 2020

Applies to:

Oracle Warehouse Management Enterprise Edition Cloud Service - Version 20.3 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


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