My Oracle Support Banner

Which BICC PVO can extract data related to PO Lines and ASN ? (Doc ID 2466037.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Fusion Procurement Contracts Cloud Service - Version 11.13.18.05.0 and later
Information in this document applies to any platform.

Goal

We want to do incremental extract using BICC VO for PO headers , PO Lines and ASN related information from SCM cloud.

Could you tell me what all BICC VO I need to use to extract,

PO Headers information like
PO_NBR
LOC_ID
VENDOR_ID
CURRENCY_CD
BUYER_ID
REBUYER_ID
ORDER_DT
SOURCE_CD
SHIP_DT
ARRIVAL_DT
CANCEL_DT
RVSN_FLG
LAST_RVSN_DT
LAST_SHPD_DT
LAST_RCVD_DT
TERMS_DISC_PCT
TERMS_DISC_DAYS
TERMS_NET_DAYS
ALLOW_BACKORD_FLG
FREIGHT_CD
NET_PO_TOTAL_COST
TOTAL_PO_LINES
TOTAL_UNITS_ORD
TOTAL_COST_ORD
TOTAL_UNITS_SHPD
TOTAL_COST_SHPD



PO Line information like:

PO_NBR
LOC_ID
PO_LINE_NBR
Item_number
VENDOR_PRODUCT_CD
UOM_CD
MERCH_DEPT_ID
MERCH_CLASS_ID
LAST_SHPD_DT
LAST_RCVD_DT
UNIT_WEIGHT
UNIT_COST
ORIG_UNITS_ORD
UNITS_ORD
UNITS_SHPD
UNITS_RCVD
NBR_OF_SHIPMENTS
FIRST_SHPD_DT


ASN Information like:
PO_NBR
Item Number
VENDOR_ID
LOC_ID
VENDOR_BOL_NBR
ASN_SHIP_NBR
ASN_SHIP_QTY
CARRIER_NAME
VENDOR_SHIP_DATE
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.