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:Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.
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.
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