My Oracle Support Banner

SAORDINVEXP Batch Fails Because Orig_tran_no Of A Pvoid Transaction Does Not Exist (Doc ID 2360241.1)

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.

Symptoms

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.

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.