Click or drag to resize

ASN

When the supplier is ready with the goods, he uses Ultriva to do his shipment. Ultriva allows the supplier to print the shipping label in which ever format the customer has recommended. This label can contain customized information including the dedicated storage location or the line side where the material should be delivered. Another key information that is included is the bar coded Kanban ID (or Release ID). Supplier sticks the label to the box or pallet and ships it to the customer. Ultriva provides the in transit information to the customer and if necessary can generate the ASN (Advanced Shipment Notice).

image 013

The following table(s) illustrate(s) the data mapping between Ultriva and Oracle.

Send Shipment Notification Using Receipt Open Interface

Ultriva Field Name

Oracle Lookup Table

Lookup Field

Field/Value

Oracle Open Interface Field Name

NA

NA

NA

rcv_headers_interface_s.NEXTVAL

header_interface_id

NA

NA

NA

rcv_interface_groups_s.NEXTVAL

group_id

NA

NA

NA

''PENDING'

processing_status_code

NA

NA

NA

''VENDOR'

receipt_source_code

NA

NA

NA

''ASN'

asn_type

NA

NA

NA

''SHIP'

auto_transact_code

NA

NA

NA

''NEW'

TRANSACTION_TYPE

NA

NA

NA

SYSDATE

creation_date

NA

NA

NA

SYSDATE

last_update_date

NA

NA

NA

0

last_update_login

NA

NA

NA

Y

validation_flag

BUYER_LOGIN_NAME

APPS.FND_USER

UPPER(user_name) = UPPER(p_user_name)

USER_ID

last_updated_by

BUYER_LOGIN_NAME

APPS.FND_USER

UPPER(user_name) = UPPER(p_user_name)

USER_ID

created_by

VENDOR_CODE

apps.po_vendors

segment1 = vendor_code

vendor_id

vendor_id

VENDOR_SITE_CODE

apps.po_vendor_sites_all

vendor_site_code = vendor_site_code AND org_id = ORG_ID AND vendor_id = vendor_id

VENDOR_SITE_ID

vendor_site_id

SHIPPED_DATE

NA

NA

NA

SHIPPED_DATE

Expect_Recv_Date

NA

NA

NA

expected_receipt_date

DESTINATION_ORGANIZATION_CODE

apps.org_organization_definitions

organization_code = DESTINATION_ORGANIZATION_CODE AND apps.financials_system_params_all.set_of_books_id = apps.org_organization_definitions.set_of_books_id AND apps.financials_system_params_all.ORG_ID = ORG_ID

organization_id

ship_to_organization_id

BUYER_LOGIN_NAME

APPS.FND_User

UPPER(user_name) = UPPER(p_user_name)

employee_id

employee_id

GID

NA

NA

NA

SHIPMENT_NUM

releaseid

NA

NA

NA

comments

rcv_transactions_interface

Ultriva Field Name

Oracle Lookup Table

Lookup Field

Field/Value

Oracle Open Interface Field Name

NA

NA

NA

rcv_transactions_interface_s.NEXTVAL

interface_transaction_id

NA

NA

NA

rcv_interface_groups_s.currval

group_id

NA

NA

NA

SYSDATE

last_update_date

BUYER_LOGIN_NAME

APPS.FND_USER

UPPER(user_name) = UPPER(p_user_name)

user_id

last_updated_by

NA

NA

NA

SYSDATE

creation_date

BUYER_LOGIN_NAME

APPS.FND_USER

UPPER(user_name) = UPPER(p_user_name)

user_id

created_by

NA

NA

NA

0

last_update_login

NA

NA

NA

SHIP

transaction_type

SHIPPED_DATE

NA

NA

NA

transaction_date

NA

NA

NA

'PENDING'

transaction_status_code

NA

NA

NA

'PENDING'

processing_status_code

NA

NA

NA

'BATCH'

processing_mode_code

QUANTITY

NA

NA

NA

quantity

unit_of_measure

mtl_units_of_measure

UOM_CODE = TRIM(p_unit_of_measure) OR unit_of_measure = TRIM(p_unit_of_measure)

unit_of_measure

unit_of_measure

item_num

mtl_system_items_kfv

concatenated_segments = TRIM(p_item_num) AND organization_id = p_ship_to_organization_id

NA

item_id

NA

NA

NA

''SHIP'

auto_transact_code

NA

NA

ORG_ID

NA

ship_to_location_id

NA

NA

NA

'VENDOR'

receipt_source_code

NA

NA

NA

VENDOR_ID

vendor_id

NA

NA

NA

VENDOR_SITE_ID

vendor_site_id

NA

NA

NA

'PO'

source_document_code

ERP_PO_NUMBER

NA

NA

NA

po_header_id

NA

NA

NA

HEADER_INTERFACE_ID

header_interface_id

ERP_PO_LINE_NUM

NA

NA

NULL OR PO_LINE_ID

po_line_id

ERP_PO_RELEASE_LINE_NUM

NA

NA

Null or LINE_LOCATION_ID

po_line_location_id

ERP_PO_RELEASE_NUM

NA

NA

NULL OR PO_RELEASE_ID

po_release_id

BUYER_LOGIN_NAME

APPS.FND_User

UPPER(user_name) = UPPER(p_user_name)

employee_id

employee_id

SUBINVENTORY

NA

NA

NA

subinventory

Expect_Recv_Date

NA

NA

NA

expected_receipt_date

NA

NA

NA

''Y'

validation_flag

NA

NA

NA

''ASN Interfaced from UEK'

comments