INVENTORY_ITEM_ID

Identifier for the Inventory item on which the role is to be granted. The value is obtained from MTL_SYSTEM_ITEMS_B for a given item. This column is also for internal use, but the user may enter the inventory item ID if known. If the inventory item ID is passed for a given item number, it will save conversion time from item number into inventory item ID; the inventory item ID will still be validated internally.

ORGANIZATION_ID

The item ID and the organization ID form the unique key combination on which the role is to be granted.

GRANTEE_PARTY_ID

The person ID, group ID or part ID that gets the grant on the item ID and organization ID.

INTERNAL_ROLE_ID

The identifier of the role to be granted.

INTERNAL_ROLE_NAME

The internal role definition name; this name is unique.

LAST_UPDATE_DATE

One of the five standard "WHO" columns.

LAST_UPDATED_BY

One of the five standard "WHO" columns.

CREATION_DATE

One of the five standard "WHO" columns.

CREATED_BY

One of the five standard "WHO" columns.

LAST_UPDATE_LOGIN

One of the five standard "WHO" columns.

REQUEST_ID

The concurrent program submission request ID.

PROGRAM_APPLICATION_ID

The concurrent program application ID. This column is for internal use to record the application ID of the concurrent program that processed this row.

PROGRAM_ID

The concurrent program ID. This column is for internal use to record the ID of the concurrent program that processed this row.

PROGRAM_UPDATE_DATE

The concurrent program update date. This column is for internal use to record the time the concurrent program processed this row.

ITEM_NUMBER

The inventory item number (such as, concatenated segments) for the item. The INVENTORY_ITEM_ID is derived from the ITEM_NUMBER.

ORGANIZATION_CODE

The Inventory Organization Code. Should be one of the values in the MTL_PARAMETERS table column ORGANIZATION_CODE.

DISPLAY_ROLE_NAME

The display name for the role; this is one of the values in the FND_MENUS_VL table column USER_MENU_NAME.

GRANTEE_TYPE

The type of grantee. Has one of the following values: USER, GROUP, or GLOBAL.

GRANTEE_NAME

The name of the grantee. This name can be a user name, group name, or all users, depending on the grantee type specified (PERSON, GROUP or GLOBAL).

START_DATE

The grant start date. The grantee gains access to the item on this date.

END_DATE

The grant end date. The grantee loses access to the item on this date.

TRANSACTION_TYPE

The type of transaction. Valid values are: CREATE, SYNC, UPDATE, or DELETE.

TRANSACTION_ID

The unique identifier of the line. The value is retrieved from EGO_IPI_TRANSACTION_ID_S.

PROCESS_STATUS

Indicates the status of the line. Values are:

1 - To Be Processe, 2 - In Process, 3 - Error, 4 - Success, 5 - Warning

DATA_SET_ID

Unique identifier that indicates the subset of data to be processed (like the job ID). Each line that is newly uploaded in the interface table needs to be assigned a unique ID that is be used during the concurrent program request submission. The value is selected from the PL/SQL API: EGO_ITEM_PEOPLE_IMPORT_PKG.get_curr_dataset_id.