My Oracle Support Banner

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 NOVEMBER 19, 2020

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.


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.


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

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