SAORDINVEXP Batch Fails Because Orig_tran_no Of A Pvoid Transaction Does Not Exist
Last updated on FEBRUARY 14, 2018
Applies to:Oracle Retail Sales Audit - Version 13.2.8 and later
Information in this document applies to any platform.
SAORDINVEXP(Sales Audit Inventory EXport) batch fails with the below error because orig_tran_no of a Post Void(PVOID) transaction does not exist.
saordinvexp_9~20170924050238~processTransHead~sa_exported_rev~1403~ORA-01403: no data found~CURSOR FETCH: cursor=c_orig_tran, store_day_seq_no#=220004, tran_seq_no=27353149
Steps to reproduce:
1. Create a RTLOG file with PVOID transaction where orig_tran_no does not exist in Sa_tran_head.
2. Run SAGETREF, SAPREPOST, SAIMPTLOGI, SAIMPTLOGFIN, SAPREEXP, SAORDINVEXP.
3. SAORDINVEXP fails with the above error.
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