SQL Query For Correction Events Where Only 1 Step Has Been Done (Receipt Into Inspection) Not Deliver To Expense
Last updated on MARCH 12, 2017
Applies to:Oracle Fusion Receipt Accounting - Version 18.104.22.168.0 and later
Oracle Fusion Cost Management Cloud Service - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
Is there any SQL script that will identify all the CORRECT transactions that are done to RECEIVE transactions, but do not have a matching CORRECT on DELIVER transaction and list the PO distribution field (code combination actual value)?
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