Shipping Execution - EBS (MOSC)

MOSC Banner

How to validate the data?

edited Jan 13, 2016 10:03AM in Shipping Execution - EBS (MOSC) 1 commentAnswered

Hi Team,

I have  small doubt, can you please provide PL/SQL. logic

process

--------------

we need to transferred all pick confirm data to thrid party system. At their side they do the ship confirm and then we will do it oracle ship confirm .

validation

In case ,

1) if we do back order in oracle in that case we need to remove the data in third party system.based on delivery (done)

2)  If we have same data in both systems  and if delivery is open, we need to check fields like Quantity,delivery detail id,UOM in both systems.

Here , I have taken cursor but while comparing fields based on delivery how can i check all four fields data is same in both systems.if it is same no need to update on third party tables in case of

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