Procurement - EBS (MOSC)

MOSC Banner

Need Oracle 12.1.3 API to UPDATE PO Release Shipment Promise Date, Need By Date and Attributes as we

edited Jul 1, 2020 5:04AM in Procurement - EBS (MOSC) 1 commentAnswered

We have a requirement to update the below. We are using PO_CHANGE_API1_S.UPDATE_PO API to update NEW_NEED_BY_DATE and NEW_PROMISED_DATE.  But there is no option to update the Release Shipment ATTRIBUTE1 values.  Below is my sample code. Do we need to use a different API to update the Release Shipment ATTRIBUTE1 ? Can anyone please help if a single API can do all the 3 UPDATES ?

DECLARE

CURSOR po_date_update

IS

SELECT porv.po_header_id              po_header_id

           ,porv.org_id

          ,porv.po_num                      po_number

          ,poha.authorization_status      po_status

          ,porv.revision_num                po_revision_num

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