Retrieve Time From OTL Is Picking Up Time Cards Twice And Duplicating The Receipt (Doc ID 2195149.1)

Last updated on AUGUST 08, 2017

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------------
Retrieve Time from OTL is picking up time cards twice and duplicating the receipt amounts.

For some reason, the Retrieve Time from OTL is picking up time cards twice and duplicating the receipt amounts.

In Oracle Purchasing, 'Retrieve time from OTL' concurrent program is creating duplicate receipts(i.e., extra positive CORRECTION entry is posted in RT) for OTL Timecards.


The following SQL can be used to identify the duplicates:
select count(1) , timecard_id , TIMECARD_OVN from apps.rcv_transactions
where timecard_id is not null
group by timecard_id , TIMECARD_OVN
having count(1) > 2;


EXPECTED BEHAVIOR
-----------------------
The Retrieve time from OTL should only generate one receipts for OTL Timecards.

STEPS TO REPRODUCE
-------------------------
The issue can be reproduced at will with the following steps:

1. Run Concurrent Program - Retrieve Time From OTL
2. The concurrent program is completed
3. There's duplicate receipts for OTL timecards.


Cause

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