Payroll and OTL - EBS (MOSC)

MOSC Banner

Announcements for Payroll and OTL can now be found in the Announcements - Payroll and OTL - EBS (MOSC) subcategory. Follow to be sure you don't miss a thing!

Script to Identify OTL Time Sheet For Contingent Worker Interfaced to Purchasing For Receipt

edited Oct 3, 2019 2:38AM in Payroll and OTL - EBS (MOSC) 3 commentsAnswered

We have implemented Contingent Worker functionality in HR along with  Oracle Time and Labour with Integration to Oracle Project Accounting and Oracle Purchasing.

Contingent Worker Enter Time Sheet in OTL for Project , Task, Purchase Order Number and Purchase Order Line Number. This is approved by appropriate approver and once it is  approved, it gets interfaced to Oracle Projects, and on running  Retrieve Time from OTL Process  from Oracle Purchasing , it creates PO Receipts for the Purchase Order and PO Line number against which contractor has entered time in OTL. This is is all standard functionality.

It is working fine, but there are cases when time sheet is approved and it gets interfaced to Oracle Project Accounting, but some how due to genuine reasons like Amount Received so far on the Purchase Order and Line Number ( i.e. PO Receipts created so far for the PO and PO Line number) exceeded the original PO &PO Line Amount, due to which system doesn't create PO Receipts for the Time Card, ( these Time card is successfully interfaced to Project Accounting, because there is no such control to check done), and they remain in RCV_TRANSACTION_INTERFACE table in error

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center