Click or drag to resize

PO Receipt

When the goods are received at the receiving dock, the material handler just scans the Kanban ID and Ultriva initiates the receipt transactions. This interface will enable Ultriva to send all the required information to Oracle to complete the receipt transaction. Ultriva will provide the exact receipt quantity (before or after inspection as the case may be). This transaction brings the material to on-hand status within Ultriva. When the material is moved to on-hand, they are ready for consumption again. At the time the shipping label automatically morphs itself in to a Kanban card to be scanned at the point of use.

image 012

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

rcv_headers_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

'NEW'

transaction_type

NA

NA

NA

SYSDATE

last_update_date

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

1

last_update_login

VENDOR_CODE

apps.po_vendors

segment1 = vendor_code

vendor_id

vendor_id

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

NA

NA

NA

'DELIVER'

auto_transact_code

NA

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

NA

NA

NA

Y

validation_flag

NA

NA

NA

NULL

asn_type

GID

NA

NA

NA

SHIPMENT_NUM

PACKINGSLIP_NO

NA

NA

NA

packing_slip

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.NEXTVAL

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

1

last_update_login

NA

NA

NA

''RECEIVE'

transaction_type

TRANSACTION_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 =

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

po_lines_all.item_description%type

item_description

NA

NA

NA

''DELIVER'

auto_transact_code

NA

NA

NA

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

NA

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

SHIP_DATE

NA

NA

NA

expected_receipt_date

NA

NA

NA

'INVENTORY'

destination_type_code

NA

NA

NA

'Y'

validation_flag

NA

NA

NA

'Receipt Interfaced from UEK'

comments

TRACKING_NUMBER

NA

NA

NA

bill_of_lading

LocationCode

mtl_item_locations_kfv

organization_id = p_ship_to_org_id AND subinventory_code = p_subinventory AND nvl(disable_date,sysdate+1) > sysdate AND concatenated_segments = p_locator

inventory_location_id

locator_id

TRACKING_NUMBER

NA

NA

NA

WAYBILL_AIRBILL_NUM

LotNumber

NA

NA

NA

vendor_lot_num