Procurement - EBS (MOSC)

MOSC Banner

A strange issue of Purchase Document Open Interface (POXPDOI)

edited Dec 16, 2016 4:00AM in Procurement - EBS (MOSC) 1 commentAnswered

I tried to use PDOI to update an existing Blanket Purchae Agreement line price.

I inserted a BPA data into PO_HEADERS_INTERFACE and PO_LINES_INTERFACE tables, and submit the concurrent program POXPDOI.

I got error 「Column ITEM_DESCRIPTION should not be NULL.」in PO_INTERFACE_ERRORS table after POXPDOI completed.

But what maked me confused is that whether I populated PO_LINES_INTERFACE.ACTION with "UPDATE" or nothing, the column was populated with "ADD" by POXPDOI , and PO_LINES_INTERFACE.PO_LINE_ID was populated with a new value.

DECLARE

   l_iface_rec         po.po_headers_interface%ROWTYPE;

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