Order Management - EBS (MOSC)

MOSC Banner

Problem with OE_ORDER_PUB

edited Jan 23, 2017 3:03PM in Order Management - EBS (MOSC) 12 commentsAnswered ✓

I have been asked to perform a mass change on all of our booked orders to either cancel or close them (depending on the state of the lines).  I have tried to use OE_ORDER_PUB to perform this mass change.  I called the following procedures in the OE_ORDER_PUB package:

Update_line

Update_header

For both these procedures, I pass in the header_id form oe_order_headers_all and line_id from oe_order_Lines_all for update_line.  I also pass in the cancelled_flag of 'Y' and also status of Cancelled.

I have also added the following to my code before each procedure call:

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