Procurement - EBS (MOSC)

MOSC Banner

Query to find return to vendor missing entries

edited Mar 23, 2017 5:00AM in Procurement - EBS (MOSC) 2 commentsAnswered

Hello Experts

We have problems with receipts API and due to this system created only half of the entry for returns, due to this we are having reconciliation problems with receiving inspection account and GRN control account. My technical team are in the process of fixing the code but mean while I want to know how many returns we have with the missing entries. I wrote the below script but it is not working if there are multiple returns. I want my query to bring all the returns which has only return to receiving entry with out return to vendor or vice

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center