PO_TIMECARD.SQL: Script to Assist OTL Users to Follow Up on Timecard Flow and Related Receipts/Invoices (Doc ID 1472312.1)

Last updated on DECEMBER 15, 2016

Applies to:

Oracle Inventory Management - Version 12.1.1 and later
Oracle Purchasing - Version 12.1.1 and later
Information in this document applies to any platform.

Goal


The purpose of script PO_TIMECARD.sql is to list each timecard flow for a given Purchase Order and timecard start date. That information can assist Oracle Time and Labor users to review and validate timecards against receipts/invoices and determine if the timecard process is correct and timecards created have been fully received and/or invoiced without error. Script to be used on Release 12.1.x instances only.

DISCLAIMER: This script is developed and maintained by Oracle Support Services. It is provided for diagnostic purposes only "as is". It has been tested internally and should work as intended. This page and the script are updated periodically. Please download it from My Oracle Support every time you need to run it in order to have the latest version.

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms