This appendix covers the following topics:
Although your system administrator may have customized your navigator, typical navigational paths are presented in the following table:
Note: Note: [B] indicates a button and [M] indicates a menu.
| Window or Page Name | Navigation Path |
|---|---|
| Organization Item | Inventory > Items > Organization Items |
Use the Manufacturing and Distribution Manager responsibility when performing these business events. Although your system administrator may have customized your navigator, typical navigational paths are presented in the following table:
Note: Note: [B] indicates a button and [M] indicates a menu.
| Business Event | Navigation Path |
|---|---|
| Item Creation Item Update |
|
| Item Organization Assignment |
|
| Item Revision |
|
| Item Cross Reference | Inventory > Items > Master/Organization Items [M}Tools > Cross References |
| Name | Display Name | Description | Status | Owner Name | Owner Tag |
|---|---|---|---|---|---|
| oracle.apps.inv.itemCreatel | INV ERES Item Creation | INV ERES Item Creation | Disabled | Oracle Inventory | INV |
| oracle.apps.inv.itemUpdate | INV ERES Item Update | INV ERES Item Update | Disabled | Oracle Inventory | INV |
| oracle.apps.inv.itemRevisionEntry | INV ERES Item Revision Entry | INV ERES Item Revision Entry | Disabled | Oracle Inventory | INV |
| oracle.apps.inv.itemCrossRefEntry | INV ERES Item Cross Reference Entry | INV ERES Item Cross Reference Entry | Disabled | Oracle Inventory | INV |
| oracle.apps.inv.itemOrgAssignment | INV ERES Item Organization Assignment | INV ERES Item Organization Assignment | Disabled | Oracle Inventory | INV |
| oracle.apps.inv.gradeChange | Grade Change | ERES Event for Grade Change | Enabled | Oracle Inventory | INV |
| oracle.apps.inv.subinvStatus | Subinventory Status Change | ERES Event for Subinventory Status Change | Enabled | Oracle Inventory | INV |
| oracle.apps.inv.loctStatus | Locator Status Change | ERES Event for Locator Status Change | Enabled | Oracle Inventory | INV |
| oracle.apps.inv.lotStatus | Lot Status Change | ERES Event for Lot Status Change | Enabled | Oracle Inventory | INV |
| oracle.apps.inv.serialStatus | Serial Status Change | ERES Event for Serial Status Change | Enabled | Oracle Inventory | INV |
| oracle.apps.inv.uomConvCreate | Item/Lot UOM Conv create | ERES Event for Item or Lot uom conversion | Enabled | Oracle Inventory | INV |
| oracle.apps.inv.uomConvUpdate | Item/Lot UOM Conv update | ERES Event for Item or Lot uom update | Enabled | Oracle Inventory | INV |
| oracle.apps.inv.lotCreate | Create Lot | ERES event raised when a new lot is created | Enabled | Oracle Inventory | Inv |
| oracle.apps.inv.lotUpdate | Update Lot | ERES event raised when a new is updated | Enabled | Oracle Inventory | Inv |
| oracle.apps.inv.subinvTransfer | Subinventory Transfer | ERES Event for Subinventory Transfers | Enabled | Oracle Inventory | Inv |
| oracle.apps.inv.interorgTransfer | Inter Organization Transfer | ERES Event for Inter Org Transfers | Enabled | Oracle Inventory | Inv |
| Event Name | Event Key | User Event Key (Identifier) |
|---|---|---|
| oracle.apps.inv.itemCreate | Org ID-Item ID | Org-Item |
| oracle.apps.inv.itemUpdate | Org ID-Item ID | Org-Item |
| oracle.apps.inv.itemRevisionEntry | Org ID-Item ID | Org-Item |
| oracle.apps.inv.itemCrossRefEntry | Item ID | Item |
| oracle.apps.inv.itemOrgAssignment | Org ID-Item ID | Org-Item |
| oracle.apps.inv.gradeChange | Grade Update Id | Grade Update Id |
| oracle.apps.inv.subinvStatus | Status_update_id | Status_update_id |
| oracle.apps.inv.loctStatus | Status_update_id | Status_update_id |
| oracle.apps.inv.lotStatus | Status_update_id | Status_update_id |
| oracle.apps.inv.serialStatus | Status_update_id | Status_update_id |
| oracle.apps.inv.uomConvCreate | Event_id | Item-From UOM- To UOM |
| oracle.apps.inv.uomConvUpdate | Event_id | Item-From UOM- To UOM |
| Oracle.apps.inv.lotCreate | Organization_id-Iten_id-Lot_number | Organization_code-Item_number-Lot_number |
| Oracle.apps.inv.lotUpdate | Organization_id-Iten_id-Lot_number | Organization_code-Item_number-Lot_number |
| oracle.apps.inv.subinvTransfer | Original_transaction_temp_id | Transaction_id |
| oracle.apps.inv.interorgTransfer | Original_transaction_temp_id | Transaction_id |
All events subscriptions have the same values for the following fields:
System = HM001
Source Type = Local
Phase = 0
Status = Disabled
Rule Data = Key
Rule Function = EDR_PSIG_RULE.PSIG_RULE
Priority = Normal
| Event Filter | Parameters |
|---|---|
| oracle.apps.inv.itemCreate | EDR_XML_MAP_CODE=inviditm EDR_AME_TRANSACTION_TYPE=oracle.apps.inv.itemCreate |
| oracle.apps.inv.itemUpdate | EDR_XML_MAP_CODE=inviditm EDR_AME_TRANSACTION_TYPE=oracle.apps.inv.itemUpdate oracle.apps.inv.itemUpdate=IGNORE_SIGNATURE |
| oracle.apps.inv.itemRevisionEntry | EDR_XML_MAP_CODE=invidrev EDR_AME_TRANSACTION_TYPE=oracle.apps.inv.itemRevisionEntry |
| oracle.apps.inv.itemCrossRefEntry | EDR_XML_MAP_CODE=invidxrf EDR_AME_TRANSACTION_TYPE=oracle.apps.inv.itemCrossRefEntry |
| oracle.apps.inv.itemOrgAssignment | EDR_XML_MAP_CODE=invidasn EDR_AME_TRANSACTION_TYPE=oracle.apps.inv.itemOrgAssignment oracle.apps.inv.itemCreate=IGNORE_SIGNATURE |
| oracle.apps.inv.gradeChange | EDR_XML_MAP_CODE = ‘oracle.apps.inv.gradeChange’; EDR_AME_TRANSACTION_TYPE = ‘oracle.apps.inv.gradeChange; |
| oracle.apps.inv.subinvStatus | EDR_XML_MAP_CODE = ‘oracle.apps.inv.subinvStatus’; EDR_AME_TRANSACTION_TYPE = ‘oracle.apps.inv.subinvStatus’; |
| oracle.apps.inv.loctStatus | EDR_XML_MAP_CODE = ‘oracle.apps.inv.loctStatus’; EDR_AME_TRANSACTION_TYPE = ‘oracle.apps.inv.loctStatus’; |
| oracle.apps.inv.lotStatus | EDR_XML_MAP_CODE = ‘oracle.apps.inv.lotStatus’ EDR_AME_TRANSACTION_TYPE = ‘oracle.apps.inv.lotStatus’; |
| oracle.apps.inv.serialStatus | EDR_XML_MAP_CODE = ‘oracle.apps.inv.serialStatus’; EDR_AME_TRANSACTION_TYPE = ‘oracle.apps.inv.serialStatus’; |
| oracle.apps.inv.uomConvCreate | EDR_XML_MAP_CODE = ‘oracle.apps.inv.uomConvCreate’; EDR_AME_TRANSACTION_TYPE = ‘oracle.apps.inv.uomConvCreate’; |
| oracle.apps.inv.uomConvUpdate | EDR_XML_MAP_CODE = ‘oracle.apps.inv.uomConvUpdate’; EDR_AME_TRANSACTION_TYPE = ‘oracle.apps.inv.uomConvUpdate’; |
| oracle.apps.inv.lotCreate | EDR_XML_MAP_CODE = ‘oracle.apps.inv.lotCreate’; EDR_AME_TRANSACTION_TYPE = ‘oracle.apps.inv.lotCreate’; |
| oracle.apps.inv.lotUpdate | EDR_XML_MAP_CODE = ‘oracle.apps.inv.lotUpdate’; EDR_AME_TRANSACTION_TYPE = ‘oracle.apps.inv.lotUpdate’; |
| oracle.apps.inv.subinvTransfer | EDR_XML_MAP_CODE = ‘oracle.apps.inv.subinvTransfer’; EDR_AME_TRANSACTION_TYPE = ‘oracle.apps.inv.subinvTransfer’;‘oracle.apps.inv.lotCreate’=ERECORD_ONLY;‘oracle.apps.inv.uomConvCreate’=ERECORD_ONLY; |
| oracle.apps.inv.interorgTransfer | EDR_XML_MAP_CODE = ‘oracle.apps.inv.interorgTransfer’; EDR_AME_TRANSACTION_TYPE = ‘oracle.apps.inv.interorgTransfer’; ‘oracle.apps.inv.lotCreate’=ERECORD_ONLY;‘oracle.apps.inv.uomConvCreate’=ERECORD_ONLY; |
All transaction types listed below belong to the Oracle Inventory application.
| Transaction Type ID | Transaction Type Description | Line Item Id Query String |
|---|---|---|
| oracle.apps.inv.itemCreate | INV ERES Item Creation | select category_id from mtl_item_categories where inventory_item_id = to_number(substrb(:transactionId,(instrb(:transactionId,'-') +1))) and organization_id = to_number(substrb(:transactionId,1, instrb(:transactionId,'-') -1)) order by category_id |
| oracle.apps.inv.itemUpdate | INV ERES Item Update | select category_id from mtl_item_categories where inventory_item_id = to_number(substrb(:transactionId,(instrb(:transactionId,'-') +1))) and organization_id = to_number(substrb(:transactionId,1, instrb(:transactionId,'-') -1)) order by category_id |
| oracle.apps.inv.itemRevisionEntry | INV ERES Item Revision Entry | select category_id from mtl_item_categories where inventory_item_id = to_number(substrb(:transactionId,(instrb(:transactionId,'-') +1))) and organization_id = to_number(substrb(:transactionId,1, instrb(:transactionId,'-') -1)) order by category_id |
| oracle.apps.inv.itemCrossRefEntry | INV ERES Item Cross Reference Entry | select distinct category_id from mtl_item_categories where inventory_item_id = to_number(:transactionId) order by category_id |
| oracle.apps.inv.itemOrgAssignment | INV ERES Item Organization Assignment | select category_id from mtl_item_categories where inventory_item_id = to_number(substrb(:transactionId,(instrb(:transactionId,'-') +1))) and organization_id = to_number(substrb(:transactionId,1, instrb(:transactionId,'-') -1)) order by category_id |
Although the user can define their own attributes for the transaction types listed above, the more commonly used attributes are seeded. The following attributes apply to all Oracle Inventory transaction types. Attributes specific to certain transaction types are listed in later tables, by transaction type.
| Attribute Category | Attribute Name | Attribute Type | Description | Static Usage | Usage |
|---|---|---|---|---|---|
| Mandatory Attribute | ALLOW_DELETING_RULE_GENERATED_APPROVERS | boolean | whether to let the calling application (or its end users) delete approvers generated by the rules | Yes | false |
| Mandatory Attribute | ALLOW_REQUESTOR_APPROVAL | boolean | whether to allow requestors to approve their own transactions (when the rules do so) | Yes | false |
| Mandatory Attribute | AT_LEAST_ONE_RULE_MUST_APPLY | boolean | whether to require that at least one rule apply to each transaction | Yes | false |
| Mandatory Attribute | EFFECTIVE_RULE_DATE | date | the date that determines which rules are active | Yes | N/A |
| Mandatory Attribute | EVALUATE_PRIORITIES_PER_ITEM | boolean | whether to evaluate rule priorities per item under strict item evaluation | Yes | false |
| Mandatory Attribute | REJECTION_RESPONSE | string | how AME responds to a rejection | Yes | STOP_ALL_ITEMS |
| Mandatory Attribute | USE_RESTRICTIVE_ITEM_EVALUATION | boolean | whether to require that the same item satisfy all item conditions in a given rule | Yes | false |
| Mandatory Attribute | USE_WORKFLOW | boolean | whether OAM should log exceptions to the Workflow context stack | Yes | true |
| Mandatory Attribute | WORKFLOW_ITEM_KEY | string | the transaction's Workflow item key | Yes | N/A |
| Mandatory Attribute | WORKFLOW_ITEM_TYPE | string | the transaction's Workflow item type | Yes | N/A |
| Non-mandatory Header Attribute | ALLOW_EMPTY_APPROVAL_GROUPS | boolean | whether to allow approval groups to have no members | Yes | false |
| Non-mandatory Header Attribute | INCLUDE_ALL_JOB_LEVEL_APPROVERS | boolean | whether to include all approvers at a given job level | Yes | false |
| Non-Mandatory Header Attribute | JOB_LEVEL_NON_DEFAULT_STARTING_POINT_PERSON_ID | number | person ID of non-default first approver for job-level authority approval types | No | select null from dual |
| Non-mandatory Header Attribute | TRANSACTION_DATE | date | date transaction occurred | No | select ame_util.versionDateToString(sysdate) from dual |
| Non-mandatory Header Attribute | TRANSACTION_GROUP_ID | number | business-group ID in which transaction occurred | Yes | N/A |
| Non-mandatory Header Attribute | TRANSACTION_REQUESTOR_PERSON_ID | number | person ID of person initiating transaction, if any | Yes | N/A |
| Non-mandatory Header Attribute | TRANSACTION_REQUESTOR_USER_ID | number | user ID of user initiating transaction, if any | No | select fnd_global.user_id from dual |
| Non-mandatory Header Attribute | TRANSACTION_SET_OF_BOOKS_ID | number | set-of-books ID in which transaction occurred | Yes | N/A |
NV ERES Item Creation (oracle.apps.inv.itemCreate)
INV ERES Item Update (oracle.apps.inv.itemUpdate)
| Attribute Category | Attribute Name | Attribute Type | Description | Static Usage | Usage |
|---|---|---|---|---|---|
| Non-Mandatory Header Attribute | INVENTORY_ITEM | string | Inventory item. Use individually or as a range. For example, trigger an event when an item is between ALUM0001 and ALUM1000. | No | select item FROM mtl_system_items_er3_v where inventory_item_id =to_number(substrb(:transactionId,(instrb(:transactionId,'-') +1))) |
| Non-Mandatory Header Attribute | IS_BOM_ALLOWED_ITEM | string | Whether the Inventory Item is a BOM Allowed Item. For example, trigger the event only when BOM Allowed = Yes. | No | select bom_enabled_flag from mtl_system_items_b where inventory_item_id = to_number(substrb(:transactionId,(instrb(:transactionId,'-') +1))) and organization_id = to_number(substrb(:transactionId,1, instrb(:transactionId,'-') -1)) |
| Non-mandatory Header Attribute | IS_BUILD_IN_WIP_ITEM | string | Whether the Inventory Item is a Build in WIP Item | No | select build_in_wip_flag from mtl_system_items_b where inventory_item_id = to_number(substrb(:transactionId,(instrb(:transactionId,'-') +1))) and organization_id = to_number(substrb(:transactionId,1, instrb(:transactionId,'-') -1)) |
| Non-mandatory Header Attribute | IS_CUSTOMER_ORDER_ITEM | string | Whether the Inventory Item is a Customer Order item | No | select customer_order_flag from mtl_system_items_b where inventory_item_id = to_number(substrb(:transactionId,(instrb(:transactionId,'-') +1))) and organization_id = to_number(substrb(:transactionId,1, instrb(:transactionId,'-') -1)) |
| Non-Mandatory Header Attribute | IS_ENGINEERING_ITEM | string | Whether the Inventory Item is a Engineering item | No | select eng_item_flag from mtl_system_items_b where inventory_item_id = to_number(substrb(:transactionId,(instrb(:transactionId,'-') +1))) and organization_id = to_number(substrb(:transactionId,1, instrb(:transactionId,'-') -1)) |
| Non-Mandatory Header Attribute | IS_INVENTORY_ITEM | string | Whether the Item is a Inventory Item | No | select inventory_item_flag from mtl_system_items_b where inventory_item_id = to_number(substrb(:transactionId,(instrb(:transactionId,'-') +1))) and organization_id = to_number(substrb(:transactionId,1, instrb(:transactionId,'-') -1)) |
| Non-Mandatory Header Attribute | IS_PURCHASING_ITEM | string | Whether the Inventory Item is a Purchasing Item | No | select purchasing_item_flag from mtl_system_items_b where inventory_item_id = to_number(substrb(:transactionId,(instrb(:transactionId,'-') +1))) and organization_id = to_number(substrb(:transactionId,1, instrb(:transactionId,'-') -1)) |
| Non-Mandatory Header Attribute | IS_SHIPPABLE_ITEM | string | Whether the Inventory Item is a Shippable Item | No | select shippable_item_flag from mtl_system_items_b where inventory_item_id = to_number(substrb(:transactionId,(instrb(:transactionId,'-') +1))) and organization_id = to_number(substrb(:transactionId,1, instrb(:transactionId,'-') -1)) |
| Non-Mandatory Header Attribute | IS_STOCKABLE_ITEM | string | Whether the Inventory Item is a Stockable Item | No | select stock_enabled_flag from mtl_system_items_b where inventory_item_id = to_number(substrb(:transactionId,(instrb(:transactionId,'-') +1))) and organization_id = to_number(substrb(:transactionId,1, instrb(:transactionId,'-') -1)) |
| Non-Mandatory Header Attribute | IS_TRANSACTABLE_ITEM | string | Whether the Inventory Item is a Transactable Item | No | select mtl_transactions_enabled_flag from mtl_system_items_b where inventory_item_id = to_number(substrb(:transactionId,(instrb(:transactionId,'-') +1))) and organization_id = to_number(substrb(:transactionId,1, instrb(:transactionId,'-') -1)) |
| Non-Mandatory Header Attribute | ITEM_CATALOG_GROUP | string | Catalog group for the inventory item | No | select item_catalog_group from mtl_system_items_er3_v where inventory_item_id =to_number(substrb(:transactionId,(instrb(:transactionId,'-') +1))) |
| Non-mandatory Header Attribute | ORGANIZATION_CODE | string | Organization Code. | No | select organization_code FROM mtl_parameters where organization_id = to_number(substrb(:transactionId,1, instrb(:transactionId,'-') -1)) |
| Non-mandatory Header Attribute | TOP_SUPERVISOR_PERSON_ID | number | person ID of the top person in the HR supervisory hierarchy | Yes | N/A |
| Non-mandatory Header Attribute | TRANSACTION_ORG_ID | number | org ID in which transaction occurred | Yes | N/A |
| Non-mandatory Line Item Attribute | ITEM_CATEGORY | string | Item Category | No | select concatenated_segments from MTL_CATEGORIES_B_KFV where category_id in (select category_id from mtl_item_categories where inventory_item_id = to_number(substrb(:transactionId,(instrb(:transactionId,'-') +1))) and organization_id = to_number(substrb(:transactionId,1, instrb(:transactionId,'-') -1)) ) order by category_id |
INV ERES Item Revision Entry (oracle.apps.inv.itemRevisionEntry)
| Attribute Category | Attribute Name | Attribute Type | Description | Static Usage | Usage |
|---|---|---|---|---|---|
| Non-Mandatory Header Attribute | INVENTORY_ITEM | string | Inventory item. Use individually or as a range. For example, trigger an event when an item is between ALUM0001 and ALUM1000. | No | select item FROM mtl_system_items_er3_v where inventory_item_id =to_number(substrb(:transactionId,(instrb(:transactionId,'-') +1))) |
| Non-Mandatory Header Attribute | IS_ENGINEERING_ITEM | string | Whether the Inventory Item is a Engineering item | No | select eng_item_flag from mtl_system_items_b where inventory_item_id = to_number(substrb(:transactionId,(instrb(:transactionId,'-') +1))) and organization_id = to_number(substrb(:transactionId,1, instrb(:transactionId,'-') -1)) |
| Non-Mandatory Header Attribute | ITEM_CATALOG_GROUP | string | Catalog group for the inventory item | No | select item_catalog_group from mtl_system_items_er3_v where inventory_item_id =to_number(substrb(:transactionId,(instrb(:transactionId,'-') +1))) |
| Non-mandatory Header Attribute | ORGANIZATION_CODE | string | Organization Code. | No | select organization_code FROM mtl_parameters where organization_id = to_number(substrb(:transactionId,1, instrb(:transactionId,'-') -1)) |
| Non-mandatory Header Attribute | TOP_SUPERVISOR_PERSON_ID | number | person ID of the top person in the HR supervisory hierarchy | Yes | N/A |
| Non-mandatory Header Attribute | TRANSACTION_ORG_ID | number | org ID in which transaction occurred | Yes | N/A |
| Non-mandatory Line Item Attribute | ITEM_CATEGORY | string | Item Category | No | select concatenated_segments from MTL_CATEGORIES_B_KFV where category_id in (select category_id from mtl_item_categories where inventory_item_id = to_number(substrb(:transactionId,(instrb(:transactionId,'-') +1))) and organization_id = to_number(substrb(:transactionId,1, instrb(:transactionId,'-') -1)) ) order by category_id |
INV ERES Item Cross Reference Entry (oracle.apps.inv.itemCrossRefEntry)
| Attribute Category | Attribute Name | Attribute Type | Description | Static Usage | Usage |
|---|---|---|---|---|---|
| Non-Mandatory Header Attribute | INVENTORY_ITEM | string | Inventory item. Use individually or as a range. For example, trigger an event when an item is between ALUM0001 and ALUM1000. | No | select item FROM mtl_system_items_er3_v where inventory_item_id = to_number(:transactionId) |
| Non-Mandatory Header Attribute | ITEM_CATALOG_GROUP | string | Catalog group for the inventory item | No | select item_catalog_group from mtl_system_items_er3_v where inventory_item_id =to_number(:transactionId) |
| Non-mandatory Header Attribute | TRANSACTION_ORG_ID | number | org ID in which transaction occurred | Yes | N/A |
| Non-mandatory Line Item Attribute | ITEM_CATEGORY | string | Item Category | No | select concatenated_segments from MTL_CATEGORIES_B_KFV where category_id in (select distinct category_id from mtl_item_categories where inventory_item_id = to_number(:transactionId) ) order by category_id |
INV ERES Item Organization Assignment (oracle.apps.inv.itemOrgAssignment)
| Attribute Category | Attribute Name | Attribute Type | Description | Static Usage | Usage |
|---|---|---|---|---|---|
| Non-Mandatory Header Attribute | INVENTORY_ITEM | string | Inventory item. Use individually or as a range. For example, trigger an event when an item is between ALUM0001 and ALUM1000. | No | select item FROM mtl_system_items_er3_v where inventory_item_id = to_number(substrb(:transactionId,(instrb(:transactionId,'-') +1))) |
| Non-Mandatory Header Attribute | ITEM_CATALOG_GROUP | string | Catalog group for the inventory item | No | select item_catalog_group from mtl_system_items_er3_v where inventory_item_id = to_number(substrb(:transactionId,(instrb(:transactionId,'-') +1))) |
| Non-mandatory Header Attribute | ORGANIZATION_CODE | string | Organization Code. | No | select organization_code from mtl_parameters where organization_id = to_number(substrb(:transactionId,1, instrb(:transactionId,'-') -1)) |
| Non-mandatory Header Attribute | TOP_SUPERVISOR_PERSON_ID | number | person ID of the top person in the HR supervisory hierarchy | Yes | N/A |
| Non-mandatory Header Attribute | TRANSACTION_ORG_ID | number | org ID in which transaction occurred | Yes | N/A |
| Non-mandatory Line Item Attribute | ITEM_CATEGORY | string | Item Category | No | select concatenated_segments from MTL_CATEGORIES_B_KFV where category_id in (select category_id from mtl_item_categories where inventory_item_id = to_number(substrb(:transactionId,(instrb(:transactionId,'-') +1))) and organization_id = to_number(substrb(:transactionId,1, instrb(:transactionId,'-') -1)) |
Grade Change oracle.apps.inv.gradeChange
| Attribute Category | Attribute Name | Attribute Type | Description | Static Usage | Usage |
|---|---|---|---|---|---|
| Mandatory Attribute | ALLOW_DELETING_RULE_GENERATED_APPROVERS | boolean | whether to let the calling application (or its end users) delete approvers generated by the rules | Yes | False |
| Mandatory Attribute | ALLOW_REQUESTOR_APPROVAL | boolean | whether to allow requestors to approve their own transactions (when the rules do so) | Yes | False |
| Mandatory Attribute | AT_LEAST_ONE_RULE_MUST_APPLY | boolean | whether to require that at least one rule apply to each transaction | Yes | True |
| Mandatory Attribute | EFFECTIVE_RULE_DATE | date | the date that determines which rules are active | Yes | N/A |
| Mandatory Attribute | TRANSACTION_DATE | date | date transaction occurred | No | Select distinct ame_util.versionDateToString(GRADE_UPDATE_DATE) from mtl_lot_grade_historywhere grade_update_id=:transactionId |
| Mandatory Attribute | TRANSACTION_GROUP_ID | number | business-group ID in which transaction occurred | Yes | N/A |
| Mandatory Attribute | TRANSACTION_ORG_ID | number | org ID in which transaction occurred. | Yes | N/A |
| Mandatory Attribute | TRANSACTION_REQUESTOR_PERSON_ID | number | person ID of person initiating transaction | Yes | N/A |
| Mandatory Attribute | TRANSACTION_REQUESTOR_USER_ID | number | user ID of person initiating transaction | No | select Last_updated_by from mtl_lot_grade_historywhere grade_update_id=:transactionId |
| Mandatory Attribute | TRANSACTION_SET_OF_BOOKS_ID | number | set-of-books ID in which transaction occurred | Yes | |
| Mandatory Attribute | USE_RESTRICTIVE_LINE_ITEM_EVALUATION | N/A | N/A | Yes | False |
| Mandatory Attribute | WORKFLOW_ITEM_KEY | string | the transaction's Workflow item key | Yes | N/A |
| Mandatory Attribute | WORKFLOW_ITEM_TYPE | string | the transaction's Workflow item type | Yes | N/A |
Material Status Change for Subinventory oracle.apps.inv.subinvStatus
| Attribute Category | Attribute Name | Attribute Type | Description | Static Usage | Usage |
|---|---|---|---|---|---|
| Mandatory Attribute | ALLOW_DELETING_RULE_GENERATED_APPROVERS | boolean | whether to let the calling application (or its end users) delete approvers generated by the rules | Yes | False |
| Mandatory Attribute | ALLOW_REQUESTOR_APPROVAL | boolean | whether to allow requestors to approve their own transactions (when the rules do so) | Yes | False |
| Mandatory Attribute | AT_LEAST_ONE_RULE_MUST_APPLY | boolean | whether to require that at least one rule apply to each transaction | Yes | True |
| Mandatory Attribute | EFFECTIVE_RULE_DATE | date | the date that determines which rules are active | Yes | N/A |
| Mandatory Attribute | TRANSACTION_DATE | date | date transaction occurred | No | Select distinct ame_util.versionDateToString(CREATION_DATE) from mtl_status_change_historywhere status_update_id=:transactionId |
| Mandatory Attribute | TRANSACTION_GROUP_ID | number | business-group ID in which transaction occurred | Yes | N/A |
| Mandatory Attribute | TRANSACTION_ORG_ID | number | org ID in which transaction occurred. | Yes | N/A |
| Mandatory Attribute | TRANSACTION_REQUESTOR_PERSON_ID | number | person ID of person initiating transaction | Yes | N/A |
| Mandatory Attribute | TRANSACTION_REQUESTOR_USER_ID | number | user ID of person initiating transaction | No | select Last_updated_by from mtl_status_change_historywhere status_update_id=:transactionId |
| Mandatory Attribute | TRANSACTION_SET_OF_BOOKS_ID | number | set-of-books ID in which transaction occurred | Yes | N/A |
| Mandatory Attribute | USE_RESTRICTIVE_LINE_ITEM_EVALUATION | Yes | False | ||
| Mandatory Attribute | WORKFLOW_ITEM_KEY | string | the transaction's Workflow item key | Yes | N/A |
| Mandatory Attribute | WORKFLOW_ITEM_TYPE | string | the transaction's Workflow item type | Yes | N/A |
| Non-Mandatory Header Attribute | INCLUDE_ALL_JOB_LEVEL_APPROVERS | boolean | whether to include all approvers at a given job level | Yes | False |
| Non-Mandatory Header Attribute | JOB_LEVEL_NON_DEFAULT_STARTING_POINT_PERSON_ID | number | person ID of non-default first approver for job-level authority approval types | No | select null from dual |
| Non-Mandatory Header Attribute | ALLOW_EMPTY_APPROVAL_GROUPS | boolean | whether to allow approval groups to have no members | Yes | False |
Create Item/Lot UOM Create oracle.apps.inv.uomConvCreate
Update Item/Lot UOM oracle.apps.inv.uomConvUpdate
| Attribute Category | Attribute Name | Attribute Type | Description | Static Usage | Usage |
|---|---|---|---|---|---|
| Mandatory Attribute | ALLOW_DELETING_RULE_GENERATED_APPROVERS | boolean | whether to let the calling application (or its end users) delete approvers generated by the rules | Yes | False |
| Mandatory Attribute | ALLOW_REQUESTOR_APPROVAL | boolean | whether to allow requestors to approve their own transactions (when the rules do so) | Yes | False |
| Mandatory Attribute | AT_LEAST_ONE_RULE_MUST_APPLY | boolean | whether to require that at least one rule apply to each transaction | Yes | True |
| Mandatory Attribute | EFFECTIVE_RULE_DATE | date | the date that determines which rules are active | Yes | N/A |
| Mandatory Attribute | TRANSACTION_DATE | date | date transaction occurred | No | Select distinct ame_util.versionDateToString(CREATION_DATE) from mtl_item_lot_conv_ervwhere event_id =:transactionId |
| Mandatory Attribute | TRANSACTION_GROUP_ID | number | business-group ID in which transaction occurred | Yes | N/A |
| Mandatory Attribute | TRANSACTION_ORG_ID | number | org ID in which transaction occurred | Yes | N/A |
| Mandatory Attribute | TRANSACTION_REQUESTOR_PERSON_ID | number | person ID of person initiating transaction | Yes | N/A |
| Mandatory Attribute | TRANSACTION_REQUESTOR_USER_ID | number | user ID of person initiating transaction | No | select Last_updated_by from mtl_status_change_historymtl_item_lot_conv_ervwhere event_id =:transactionId |
| Mandatory Attribute | TRANSACTION_SET_OF_BOOKS_ID | number | set-of-books ID in which transaction occurred | Yes | N/A |
| Mandatory Attribute | USE_RESTRICTIVE_LINE_ITEM_EVALUATION | N/A | N/A | Yes | False |
| Mandatory Attribute | WORKFLOW_ITEM_KEY | string | the transaction's Workflow item key | Yes | N/A |
| Mandatory Attribute | WORKFLOW_ITEM_TYPE | string | the transaction's Workflow item type | Yes | N/A |
| Non-Mandatory Header Attribute | INCLUDE_ALL_JOB_LEVEL_APPROVERS | boolean | whether to include all approvers at a given job level | Yes | False |
| Non-Mandatory Header Attribute | JOB_LEVEL_NON_DEFAULT_STARTING_POINT_PERSON_ID | number | person ID of non-default first approver for job-level authority approval types | No | select null from dual |
| Non-Mandatory Header Attribute | ALLOW_EMPTY_APPROVAL_GROUPS | boolean | whether to allow approval groups to have no members | Yes | False |
Lot Create oracle.apps.inv.lotCreate
Lot Update oracle.apps.inv.lotUpdate
| Attribute Category | Attribute Name | Attribute Type | Description | Static Usage | Usage |
|---|---|---|---|---|---|
| Mandatory Attribute | ALLOW_DELETING_RULE_GENERATED_APPROVERS | boolean | whether to let the calling application (or its end users) delete approvers generated by the rules | Yes | False |
| Mandatory Attribute | ALLOW_REQUESTOR_APPROVAL | boolean | whether to allow requestors to approve their own transactions (when the rules do so) | Yes | False |
| Mandatory Attribute | AT_LEAST_ONE_RULE_MUST_APPLY | boolean | whether to require that at least one rule apply to each transaction | Yes | True |
| Mandatory Attribute | EFFECTIVE_RULE_DATE | date | the date that determines which rules are active | Yes | N/A |
| Mandatory Attribute | TRANSACTION_DATE | date | date transaction occurred | No | Select distinct ame_util.versionDateToString(CREATION_DATE) from mtl_lot_numberswhere To_char(organizationid)||’-‘||to_char(inventory_item_id)||’-‘||lot_number =:transactionId |
| Mandatory Attribute | TRANSACTION_GROUP_ID | number | business-group ID in which transaction occurred | Yes | N/A |
| Mandatory Attribute | TRANSACTION_ORG_ID | number | org ID in which transaction occurred. | Yes | N/A |
| Mandatory Attribute | TRANSACTION_REQUESTOR_USER_ID | number | user ID of person initiating transaction | No | select Last_updated_by from mtl_status_change_historymtl_lot_numberswhere To_char(organizationid)||’-‘||to_char(inventory_item_id)||’-‘||lot_number =:transactionId |
| Mandatory Attribute | TRANSACTION_SET_OF_BOOKS_ID | number | set-of-books ID in which transaction occurred | Yes | N/A |
| Mandatory Attribute | USE_RESTRICTIVE_LINE_ITEM_EVALUATION | N/A | N/A | Yes | False |
| Mandatory Attribute | WORKFLOW_ITEM_KEY | string | the transaction's Workflow item key | Yes | N/A |
| Mandatory Attribute | WORKFLOW_ITEM_TYPE | string | the transaction's Workflow item type | Yes | N/A |
| Non-Mandatory Header Attribute | INCLUDE_ALL_JOB_LEVEL_APPROVERS | boolean | whether to include all approvers at a given job level | Yes | False |
| Non-Mandatory Header Attribute | JOB_LEVEL_NON_DEFAULT_STARTING_POINT_PERSON_ID | number | whether to include all approvers at a given job level | Yes | select null from dual |
| Non-Mandatory Header Attribute | ALLOW_EMPTY_APPROVAL_GROUPS | boolean | whether to allow approval groups to have no members | Yes | False |
Subinventory Transfer oracle.apps.inv.subinvTransfer
Interorg Transfer oracle.apps.inv.interorgTransfer
| Attribute Category | Attribute Name | Attribute Type | Description | Static Usage | Usage |
|---|---|---|---|---|---|
| Mandatory Attribute | ALLOW_DELETING_RULE_GENERATED_APPROVERS | boolean | whether to let the calling application (or its end users) delete approvers generated by the rules | Yes | False |
| Mandatory Attribute | ALLOW_REQUESTOR_APPROVAL | boolean | whether to allow requestors to approve their own transactions (when the rules do so) | Yes | False |
| Mandatory Attribute | AT_LEAST_ONE_RULE_MUST_APPLY | boolean | whether to require that at least one rule apply to each transaction | Yes | True |
| Mandatory Attribute | EFFECTIVE_RULE_DATE | date | the date that determines which rules are active | Yes | N/A |
| Mandatory Attribute | TRANSACTION_DATE | date | date transaction occurred | No | SELECT ame_util.versionDateToString(CREATION_DATE)FROM MTL_MATERIAL_TRANSACTIONS_TEMPWHERE ORIGINAL_TRANSACTION_TEMP_ID =to_number(:transactionId) |
| Mandatory Attribute | TRANSACTION_GROUP_ID | number | business-group ID in which transaction occurred | Yes | N/A |
| Mandatory Attribute | TRANSACTION_ORG_ID | number | org ID in which transaction occurred. | Yes | N/A |
| Mandatory Attribute | TRANSACTION_REQUESTOR_PERSON_ID | number | person ID of person initiating transaction | Yes | N/A |
| Mandatory Attribute | TRANSACTION_REQUESTOR_USER_ID | number | user ID of person initiating transaction | No | SELECT LAST_UPDATED_BYFROM MTL_MATERIAL_TRANSACTIONS_TEMPWHERE ORIGINAL_TRANSACTION_TEMP_ID =to_number(:transactionId) |
| Mandatory Attribute | TRANSACTION_SET_OF_BOOKS_ID | number | set-of-books ID in which transaction occurred | Yes | N/A |
| Mandatory Attribute | USE_RESTRICTIVE_LINE_ITEM_EVALUATION | N/A | N/A | Yes | False |
| Mandatory Attribute | WORKFLOW_ITEM_KEY | string | the transaction's Workflow item key | Yes | N/A |
| Mandatory Attribute | WORKFLOW_ITEM_TYPE | string | the transaction's Workflow item type | Yes | N/A |
| Non-Mandatory Attribute Header | INCLUDE_ALL_JOB_LEVEL_APPROVERS | boolean | whether to include all approvers at a given job level | Yes | False |
| Non-Mandatory Attribute Header | JOB_LEVEL_NON_DEFAULT_STARTING_POINT_PERSON_ID | number | person ID of non-default first approver for job-level authority approval types | No | select null from dual |
| Non-Mandatory Attribute Header | ALLOW_EMPTY_APPROVAL_GROUPS | boolean | whether to allow approval groups to have no members | Yes | False |
No rules or approvers are seeded. As part of the implementation, you must complete these activities.
Use generic query attributes to search for e-records and their associated documents in the Evidence Store.
Query Element Type = Generic
| Application Code | XML Element Tag | Display Name | Comments |
|---|---|---|---|
| INV | ITEM_CATALOG_GROUP | Catalog Group | N/A |
| INV | ITEM | Item | For items and new items. |
| INV | INVENTORY_ITEM_FLAG | Inventory Item Flag | Shared by item creation and item update events. |
| INV | STOCK_ENABLED_FLAG | Stockable | Shared by item creation and item update events. |
| INV | MTL_TRANSACTIONS_ENABLED_FLAG | Transactable | Shared by item creation and item update events. |
| INV | BOM_ENABLED_FLAG | BOM Allowed | Shared by item creation and item update events. |
| INV | PURCHASING_ITEM_FLAG | Purchased | Shared by item creation and item update events. |
| INV | BUILD_IN_WIP_FLAG | Build in WIP | Shared by item creation and item update events. |
| INV | CUSTOMER_ORDER_FLAG | Customer Ordered | Shared by item creation and item update events. |
| Application Code | XML Element Tag | Display Name | Comments |
|---|---|---|---|
| INV | ITEM_CATALOG_GROUP | Catalog Group | N/A |
| INV | ITEM | Item | N/A |
| INV | ITEM_REVISION | Item Revision | N/A |
| Application Code | XML Element Tag | Display Name | Comments |
|---|---|---|---|
| INV | ITEM_CATALOG_GROUP | Catalog Group | N/A |
| INV | ITEM | Item | N/A |
| Application Code | XML Element Tag | Display Name | Comments |
|---|---|---|---|
| INV | ORGANIZATION_CODE | Organization Code | N/A |
| INV | ITEM | Item | N/A |
| INV | LOT | Lot | N/A |
| INV | FROM_GRADE | From Grade | N/A |
| INV | TO_GRADE | To Grade | N/A |
| Application Code | XML Element Tag | Display Name | Comments |
|---|---|---|---|
| INV | ORGANIZATION_CODE | Organization Code | N/A |
| INV | SUBINVENTORY | Subinventory | N/A |
| INV | LOCATOR | Locator | N/A |
| INV | ITEM | Item | N/A |
| INV | LOT | Lot | N/A |
| INV | SERIAL | Serial | N/A |
| INV | FROM_STATUS | From Status | N/A |
| INV | TO_STATUS | To Status | N/A |
| Application Code | XML Element Tag | Display Name | Comments |
|---|---|---|---|
| INV | ITEM | Item | N/A |
| INV | LOT | Lot | N/A |
| INV | FROM_UNIT_OF_MEASURE | From Unit of Measure | N/A |
| INV | TO_UNIT_OF_MEASURE | To Unit of Measure | N/A |
| Application | XML Element Tag | Display Name | Comments |
|---|---|---|---|
| INV | ITEM | Item | N/A |
| INV | LOT | Lot | N/A |
| INV | ORGANIZATION | Organization | N/A |
| Application | XML Element Tag | Display Name | Comments |
|---|---|---|---|
| NV | ITEM | Item | N/A |
| INV | ITEM_REVISION | Item Revision | N/A |
| INV | SUBINVENTORY | Subinventory | N/A |
| INV | LOCATOR | Locator | N/A |
| INV | ACCOUNT | Account | N/A |
| INV | ORGANIZATION | Organization | N/A |