Internal Requisition/Internal Sales Order (IR/ISO) |
This transaction is triggered when Kanban card has been released to another sister plant and if the item to supplier relationship in Ultriva is marked as IR/ISO. The internal requisition process is similar to Blanket Purchase Order Release. Ultriva inserts the data into Oracle’s Requisition Interface table. Ultriva Invokes the concurrent program immediately after inserting record into the requisition table. So, the internal requisition gets created.
 Note |
|---|
Ultriva does not invoke the concurrent program for Internal Sales Order creation. This ISO concurrent job must be scheduled separately by the Oracle DBA. |
Once ISO is created then Ultriva publishes both Requisition Number and Sales Order details back to Ultriva.
The following table(s) illustrate(s) the data mapping between Ultriva and Oracle.
ULTRIVA field | Oracle Lookup | Lookup Field | Field/Value | Oracle Field |
|---|---|---|---|---|
NA | NA | NA | mtl_material_transactions_s.NEXTVAL | TRANSACTION_INTERFACE_ID |
NA | NA | NA | 'UEK BPA' | interface_source_code |
NA | NA | NA | 'INVENTORY' | destination_type_code |
NA | NA | NA | 'APPROVED' | authorization_status |
BUYER_CODE (Buyer’s Login Name in Ultriva) | APPS.FND_USER | user_name = buyer_code | EMPlOYEE_ID | preparer_id |
KANBAN_RELEASE_ID | NA | NA | NA | req_number_segment1 |
Staging Record GID (Primary Key) | NA | NA | NA | Reference_num |
QUANTITY | NA | NA | NA | Quantity |
NA | apps.mtl_parameters_view | cost_organization_id = ship_to_organization_id (resolved using DESTINATION_ORGANIZATION_CODE) | material_account | charge_account_id |
NA | apps.gl_sets_of_books | fsp.set_of_books_id = sob.set_of_books_id and fsp.org_id = org_id | currency_code | currency_code |
ITEM_NUM | APPS.MTL_SYSTEM_ITEMS_KFV | concatenated_segments = ITEM_NUM AND organization_id = l_ship_to_organization_id | INVENTORY_ITEM_ID | item_id |
DESTINATION_ORGANIZATION_CODE (plant business 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 | destination_organization_id |
DESTINATION_SUBINVENTORY | NA | NA | NA | DESTINATION_SUBINVENTORY |
DELIVER_TO_LOCATION_CODE (From Ultriva’s Business Unit Configuration) | apps.hr_locations | location_code = TRIM(deliver_to_location_code) and inventory_organization_id = l_ship_to_organization_id and ship_to_site_flag = 'Y' | location_id | deliver_to_location_id |
BUYER_CODE (Buyer’s Login Name in Ultriva) | APPS.FND_USER | user_name = buyer_code | EMPLOYEE_ID | deliver_to_requestor_id |
NA | NA | NA | NULL | UNIT_PRICE |
NA | NA | NA | 'INVENTORY' | source_type_code |
NEED_BY_DATE (Required Receive Date) | NA | NA | NA | NEED_BY_DATE |
ORG_ID (From Ultriva’s business Unit configuration) | apps.hr_operating_units | organization_id = ORG_ID | organization_id | ORG_ID |
UNIT_OF_MEASURE | apps.mtl_units_of_measure | unit_of_measure = UNIT_OF_MEASURE | uom_code | unit_of_measure |
VENDOR_CODE | apps.org_organization_definitions | organization_code = VENDOR_CODE | organization_id | source_organization_id |
NEED_BY_DATE (Required Receive Date) | NA | NA | NA | gl_date |
BUYER_CODE (Buyer’s Login Name in Ultriva) | APPS.FND_USER | user_name = buyer_code | EMPLOYEE_ID | suggested_buyer_id |
ACTION_BY | APPS.FND_USER | user_name = Action_By | EMPLOYEE_ID | created_by |
NA | NA | NA | sysdate | Creation_Date |
ACTION_BY | APPS.FND_USER | user_name = Action_By | EMPLOYEE_ID | last_updated_by |
NA | NA | NA | Sysdate | last_update_date |
NA | NA | NA | 'INTERNAL' | requisition_type |