Procurement - EBS (MOSC)

MOSC Banner

Import contract purchase agreement:INTERFACE_HEADER_ID defining

edited Sep 5, 2015 10:00AM in Procurement - EBS (MOSC) 3 commentsAnswered

Hi, I try to create WEB ADI integrator for import contract purchase agreement.

I create  table interface, table is po_headers_interface. I need INTERFACE_HEADER_ID attribute was filled automatically with sequence PO_HEADERS_INTERFACE_S.NEXTVAL. I define this attribute: default type - SQL Query, default value - SELECT PO_HEADERS_INTERFACE_S.NEXTVAL from dual, but in Excel file all lines have the same value INTERFACE_HEADER_ID. Reccomend me please how can I difine this attribute INTERFACE_HEADER_ID  then PO_HEADERS_INTERFACE_S.NEXTVAL value was generated for every line in Excel file.

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