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.
The following table(s) illustrate(s) the data mapping between Ultriva and Oracle.
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 |
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 |