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

Last updated on MARCH 02, 2023

Applies to:

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;


Steps to Reproduce
-------------------------

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

Cause

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