My Oracle Support Banner

How can OTL Time Card Batch Processes be Processed in Parallel Without Receiving an Interlock Error? (Doc ID 2513017.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Time and Labor - Version 12.1.3 and later
Oracle Payroll - Version 12.1.3 and later
Information in this document applies to any platform.


One requirement, will be automating the OTL processing which includes the three below basic concurrent programs (CP)

1. Transfer Time from OTL to BEE (This one is OLT)
2. BEE Batch Process (Validate) (This one is Payroll/Batch Element Entry (BEE) and causes the error).
3. BEE Batch Process (Transfer) (Also Payroll/Batch Element Entry (BEE))

From a solution point of view, created a wrapper package which will invoke above Concurrent Programs one by one with wait_for_request (Next CP won't start until current CP is completed).

As far the Batch Processing is considered, how to make each batch process in parallel which eventually will enhance the overall timing performance.
Suppose 100 batches are created, processing these batches one by one will consume a considerable amount of time. So, how to submit batch processing requests in parallel.
The problem we are facing here is, interlocking of batches if two batches contain same assignment id in the batch lines.

The following error is presented to the user:
APP-PER-289714: Problem: Assignment Number xx is referenced within batches RETRO and non-retro.
This might cause interlocks between batches.

Solution: Do not submit multiple batches with overlapping assignments

How can we handle this?



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.