The tables in this appendix detail the seed data entered to support each discrete manufacturing application integrated with Oracle E-Records.
This appendix covers the following topics:
| Name | Display Name | Description | Status | Owner Name | Owner Tag |
|---|---|---|---|---|---|
| oracle.apps.eng.ecoApproval | ECO Approval | ERES Event for ECO Approval | Enabled | Oracle Engineering | ENG |
| oracle.apps.eng.ecoCreate | ECO Creation | ERES Event for ECO Create | Enabled | Oracle Engineering | ENG |
| oracle.apps.eng.ecoUpdate | ECO Update | ERES Event for ECO Update | Enabled | Oracle Engineering | ENG |
| oracle.apps.eng.ecoSchedule | ECO Schedule | ERES Event for ECOSchedule | Enabled | Oracle Engineering | ENG |
| oracle.apps.eng.ecoReschedule | ECO Reschedule | ERES Event for ECOReschedule | Enabled | Oracle Engineering | ENG |
| oracle.apps.eng.ecoCancellation | ECO Cancellation | ERES Event for ECOCancellation | Enabled | Oracle Engineering | ENG |
| oracle.apps.eng.ecoImplementation | ECO Implementation | ERES Event for ECOImplementation | Enabled | Oracle Engineering | ENG |
| oracle.apps.eng.transferTo Manufacturing | Transfer To Manufacturing | ERES Event for Transfer To Manufacturing | Enabled | Oracle Engineering | ENG |
| oracle.apps.eng.copyTo Manufacturing | Copy To Manufacturing | ERES Event for Copy To Manufacturing | Enabled | Oracle Engineering | ENG |
| oracle.apps.eng.massChangeBill | Mass Change Bills | ERES Event for Mass Change Bills | Enabled | Oracle Engineering | ENG |
| Event Name | User Event Key (Identifier) |
|---|---|
| oracle.apps.eng.ecoApproval | Change ID |
| oracle.apps.eng.ecoCreate | Change ID |
| oracle.apps.eng.ecoUpdate | Change ID |
| oracle.apps.eng.ecoSchedule | Change ID |
| oracle.apps.eng.ecoReschedule | Change ID |
| oracle.apps.eng.ecoCancellation | Change ID |
| oracle.apps.eng.ecoImplement | Change ID |
| oracle.apps.eng.transferTo Manufacturing | Org, Item |
| oracle.apps.eng.copyToManufacturing | Org, Item |
| oracle.apps.eng.massChangeBill | Org, Change Notice |
Note: Enter User Event Keys with the given nomenclature but note that event keys may be case sensitive, separated by underscores and hyphens, and the event key values set off in carets.
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.eng.eco.approval | EDR_XML_MAP_CODE=oracle.apps.eng.ecoGeneric EDR_AME_TRANSACTION_TYPE=oracle.apps.eng.ecoApproval |
| oracle.apps.eng.eco.create | EDR_XML_MAP_CODE=oracle.apps.eng.ecoGeneric EDR_AME_TRANSACTION_TYPE=oracle.apps.eng.ecoCreate |
| oracle.apps.eng.eco.update | EDR_XML_MAP_CODE=oracle.apps.eng.ecoGeneric EDR_AME_TRANSACTION_TYPE=oracle.apps.eng.ecoUpdate |
| oracle.apps.eng.eco.schedule | EDR_XML_MAP_CODE=oracle.apps.eng.ecoGeneric EDR_AME_TRANSACTION_TYPE=oracle.apps.eng.ecoSchedule |
| oracle.apps.eng.eco.reschedule | EDR_XML_MAP_CODE=oracle.apps.eng.ecoGeneric EDR_AME_TRANSACTION_TYPE=oracle.apps.eng.ecoReschedule |
| oracle.apps.eng.eco.cancellation | EDR_XML_MAP_CODE = oracle.apps.eng.eco. genericEDR_AME_TRANSACTION_TYPE = oracle.apps.eng.eco.cancellation |
| oracle.apps.eng.eco.implement | EDR_XML_MAP_CODE=oracle.apps.eng.ecoGeneric EDR_AME_TRANSACTION_TYPE=oracle.apps.eng.ecoImplement oracle.apps.eng.copyToManufacturing=IGNORE_SIGNATURE oracle.apps.eng.transferToManufacturing=IGNORE_SIGNATURE oracle.apps.inv.itemRevisionEntry=IGNORE_SIGNATURE oracle.apps.bom.billUpdate=IGNORE_SIGNATURE oracle.apps.bom.billCreate=IGNORE_SIGNATURE oracle.apps.bom.routingUpdate=IGNORE_SIGNATURE oracle.apps.bom.routingCreate=IGNORE_SIGNATURE |
| oracle.apps.eng.transferTo Manufacturing | EDR_XML_MAP_CODE=oracle.apps.eng.manufact EDR_AME_TRANSACTION_TYPE=oracle.apps.eng.transferToManufacturing |
| oracle.apps.eng.copyTo Manufacturing | EDR_XML_MAP_CODE=oracle.apps.eng.manufact EDR_AME_TRANSACTION_TYPE=oracle.apps.eng.copyToManufacturing oracle.apps.inv.itemCreate=IGNORE_SIGNATURE oracle.apps.bom.billCreate=IGNORE_SIGNATURE oracle.apps.bom.routingCreate=IGNORE_SIGNATURE |
| oracle.apps.eng.massChangeBill | EDR_XML_MAP_CODE=oracle.apps.eng.massChangeBill EDR_AME_TRANSACTION_TYPE=oracle.apps.eng.massChangeBill oracle.apps.eng.ecoCreate=IGNORE_SIGNATURE |
All transaction types listed below belong to the Oracle Engineering application.
| Transaction Type ID | Transaction Type Description | Line Item Id Query String |
|---|---|---|
| oracle.apps.eng.ecoCreate | ENG ERES ECO Creation | N/A |
| oracle.apps.eng.ecoUpdate | ENG ERES ECO Update | N/A |
| oracle.apps.eng.ecoSchedule | ENG ERES ECO Schedule | N/A |
| oracle.apps.eng.ecoReschedule | ENG ERES ECO Reschedule | N/A |
| oracle.apps.eng.ecoCancellation | ENG ERES ECO Cancellation | N/A |
| oracle.apps.eng.ecoImplementation | ENG ERES ECO Implementation | N/A |
| oracle.apps.eng.transferToManufacturing | ENG ERES Transfer to Manufacturing | select category_id from mtl_item_categories where inventory_item_id = (select distinct INVENTORY_ITEM_ID from ENG_REVISED_ITEMS_TEMP where temp_id = :transactionId) and organization_id = (select distinct ORGANIZATION_ID from ENG_REVISED_ITEMS_TEMP where temp_id = :transactionId) order by category_id |
| oracle.apps.eng.copyToManufacturing | ENG ERES Copy to Manufacturing | select category_id from mtl_item_categories where inventory_item_id = (select distinct INVENTORY_ITEM_ID from ENG_REVISED_ITEMS_TEMP where temp_id = :transactionId) and organization_id = (select distinct ORGANIZATION_ID from ENG_REVISED_ITEMS_TEMP where temp_id = :transactionId) order by category_id |
| oracle.apps.eng.massChangeBills | ENG ERES Mass Change Bills | N/A |
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 Engineering 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 | TRANSACTION_DATE | date | date transaction occurred | No | SELECT ame_util.versionDateToString(CREATION_DATE) FROM ENG_ENG_CHANGES_INTERFACE_V WHERE organization_id = TO_NUMBER(SUBSTR(:transactionId,1,INSTR(:transactionId,'-') -1)) AND change_notice = SUBSTR(:transactionId,INSTR(:transactionId,'-')+1,(LENGTH(:transactionId) - INSTR(:transactionId,'-'))) |
| 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 last_updated_by FROM ENG_ENG_CHANGES_INTERFACE_V WHERE organization_id = TO_NUMBER(SUBSTR(:transactionId,1,INSTR(:transactionId,'-') -1)) AND change_notice = SUBSTR(:transactionId,INSTR(:transactionId,'-')+1,(LENGTH(:transactionId) - INSTR(:transactionId,'-'))) |
| Non-mandatory Header Attribute | TRANSACTION_SET_OF_BOOKS_ID | number | set-of-books ID in which transaction occurred | Yes | N/A |
ENG ERES ECO Creation (oracle.apps.eng.ecoCreate)
ENG ERES ECO Update (oracle.apps.eng.ecoUpdate)
ENG ERES ECO Implementation (oracle.apps.eng.ecoImplementation)
ENG ERES ECO Schedule (oracle.apps.eng.ecoSchedule)
ENG ERES ECO Reschedule (oracle.apps.eng.ecoReschedule)
ENG ERES ECO Cancellation (oracle.apps.eng.ecoCancellation)
| Attribute Category | Attribute Name | Attribute Type | Description | Static Usage | Usage |
|---|---|---|---|---|---|
| Non-Mandatory Header Attribute | ECO | string | ECO. Typically used for an ECO range, for example, trigger an event when an ECO is between ABC0001 and ABC1000 | No | select change_notice from ENG_ENGINEERING_CHANGES where change_id = to_number(:transactionId) |
| Non-Mandatory Header Attribute | ECO DEPARTMENT | string | ECO Department. For example, triggers an event when the ECO Department = Design Engineering. | No | SELECT ECO_DEPARTMENT FROM ENG_ENGINEERING_CHANGES_V WHERE change_id = to_number(:transactionId) |
| Non-mandatory Header Attribute | ECO TYPE | string | ECO Type. For example, trigger an event when the ECO Type = New Product. | No | select ecotvl.type_name from ENG_ENGINEERING_CHANGES eec, ENG_CHANGE_ORDER_TYPES_VL ecotvl where eec.change_id = to_number(:transactionId) and eec.CHANGE_ORDER_TYPE_ID = ecotvl.CHANGE_ORDER_TYPE_ID |
| 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 | ORGANIZATION_CODE | string | Organization Code. | No | select organization_code FROM mtl_parameters where organization_id = (select organization_id FROM ENG_ENGINEERING_CHANGES WHERE change_id = to_number(:transactionId)) |
| Non-mandatory Header Attribute | PRIORITY | string | Priority. For example, trigger an event when Priority = Urgent. | No | SELECT PRIORITY_CODE FROM ENG_ENGINEERING_CHANGES WHERE change_id = to_number(:transactionId) |
| Non-mandatory Header Attribute | PROJECT | string | Project. Use when under project/task control. | No | SELECT PROJECT_NUMBER FROM ENG_ENGINEERING_CHANGES_V WHERE change_id = to_number(:transactionId) |
| Non-mandatory Header Attribute | TASK | string | Task | No | SELECT TASK_NUMBER FROM ENG_ENGINEERING_CHANGES_V WHERE change_id = to_number(:transactionId) |
| 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 |
ENG ERES Transfer to Manufacturing (oracle.apps.eng.transferToManufacturing)
ENG ERES Copy to Manufacturing (oracle.apps.eng.copyToManufacturing)
| Attribute Category | Attribute Name | Attribute Type | Description | Static Usage | Usage |
|---|---|---|---|---|---|
| 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 | ORGANIZATION_CODE | string | Organization Code | No | SELECT ORGANIZATION_CODE FROM ENG_REVISED_ITEMS_TEMP WHERE TEMP_ID = :transactionId |
| Non-Mandatory Header Attribute | REVISED_ITEM | string | ITEM | No | SELECT ITEM_NUMBER FROM ENG_REVISED_ITEMS_TEMP WHERE TEMP_ID = :transactionId |
| 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 | No | select organization_id from qa_plans where plan_id = :transactionId |
| Non-Mandatory Line Item Attribute | ITEM CATEGORY | string | The category set defined for functional area 'Order Mgmt' in Inventory | No | select concatenated_segments from MTL_CATEGORIES_B_KFV where category_id in (select category_id from mtl_item_categories where inventory_item_id = (select distinct INVENTORY_ITEM_ID from ENG_REVISED_ITEMS_TEMP where temp_id = :transactionId) and organization_id = (select distinct ORGANIZATION_ID from ENG_REVISED_ITEMS_TEMP where temp_id = :transactionId) ) order by category_id |
ENG ERES Mass Change Bills (oracle.apps.eng.massChangeBills)
| Attribute Category | Attribute Name | Attribute Type | Description | Static Usage | Usage |
|---|---|---|---|---|---|
| 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 | 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 | No | select organization_id from qa_plans where plan_id = :transactionId |
No rules or approvers are seeded. As part of the implementation, you must complete these activities (see: Setting Up Oracle Approvals Management, Oracle E-Records Implementation Guide).
Use generic query attributes to search for e-records and their associated documents in the Evidence Store. For instructions on how to search, see Evidence Store, Oracle E-Records Implementation Guide. For all attributes listed below:
Query Element Type = Generic
| Application Code | XML Element Tag | Display Name | Comments |
|---|---|---|---|
| ENG | CHANGE_NOTICE | ECO | Used to query ECO-related events. |
| ENG | CHANGE_ORDER_TYPE | ECO Type | N/A |
| ENG | ECO_DEPARTMENT | ECO Department | N/A |
| ENG | REVISION | ECO Revision | N/A |
| ENG | PROJECT_NUMBER | Project | N/A |
| ENG | TASK_NUMBER | Task | N/A |
| ENG | REVISED_ITEM_NO | Item | For revised items, items transferred to manufacturing, and new manufacturing items copied to manufacturing. |
| ENG | NEW_ITEM_REVISION | Item Revision | For new item revisions. |
| ENG | NEW_ROUTING_REVISION | Routing Revision | For new routing revision. |
| ENG | ALTERNATE_BOM_DESIGNATOR | Alternate Designator | N/A |
| ENG | STANDARD_OPERATION_CODE | Operation Code | For a standard operation in a routing change. |
| BOM | RESOURCE_CODE | Resource Code | N/A |
| ENG | COMPONENT_ITEM_NO | Component | For components and substitute components of a bill change. |
| Application Code | XML Element Tag | Display Name | Comments |
|---|---|---|---|
| ENG | CHANGE_NOTICE | ECO | Used to query ECO-related events. |
| ENG | CHANGE_ORDER_TYPE | ECO Type | N/A |
| ENG | ECO_DEPARTMENT | ECO Department | N/A |
| ENG | REVISION | ECO Revision | N/A |
| ENG | PROJECT_NUMBER | Project | N/A |
| ENG | TASK_NUMBER | Task | N/A |
| Application Code | XML Element Tag | Display Name | Comments |
|---|---|---|---|
| ENG | NEW_ITEM_REVISION | Item Revision | For new item revisions. |
| ENG | NEW_ROUTING_REVISION | Routing Revision | For new routing revisions. |
| ENG | ALTERNATE_BOM_DESIGNATOR | Alternate Designator | N/A |
| ENG | CHANGE_NOTICE | ECO | N/A |
| Application Code | XML Element Tag | Display Name | Comments |
|---|---|---|---|
| ENG | NEW_ITEM_REVISION | Item Revision | For new item revisions. |
| ENG | NEW_ROUTING_REVISION | Routing Revision | For new routing revisions. |
| ENG | ALTERNATE_BOM_DESIGNATOR | Alternate Designator | N/A |
| ENG | CHANGE_NOTICE | ECO | N/A |
| Application Code | XML Element Tag | Display Name | Comments |
|---|---|---|---|
| ENG | ALTERNATE_BOM_DESIGNATOR | Alternate Designator | N/A |
| Name | Display Name | Description | Status | Owner Name | Owner Tag |
|---|---|---|---|---|---|
| oracle.apps.inv.itemCreatel | INV ERES Item Creation | INV ERES Item Creation | Enabled | Oracle Inventory | INV |
| oracle.apps.inv.itemUpdate | INV ERES Item Update | INV ERES Item Update | Enabled | Oracle Inventory | INV |
| oracle.apps.inv.itemRevisionEntry | INV ERES Item Revision Entry | INV ERES Item Revision Entry | Enabled | Oracle Inventory | INV |
| oracle.apps.inv.itemCrossRefEntry | INV ERES Item Cross Reference Entry | INV ERES Item Cross Reference Entry | Enabled | Oracle Inventory | INV |
| oracle.apps.inv.itemOrgAssignment | INV ERES Item Organization Assignment | INV ERES Item Organization Assignment | Enabled | Oracle Inventory | INV |
| Event Name | User Event Key (Identifier) |
|---|---|
| oracle.apps.inv.itemCreate | Org-Item |
| oracle.apps.inv.itemUpdate | Org-Item |
| oracle.apps.inv.itemRevisionEntry | Org-Item |
| oracle.apps.inv.itemCrossRefEntry | Item |
| oracle.apps.inv.itemOrgAssignment | Org-Item |
Note: Enter User Event Keys with the given nomenclature but note that event keys may be case sensitive, separated by underscores and hyphens, and the event key values set off in carets.
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 |
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)) |
No rules or approvers are seeded. As part of the implementation, you must complete these activities (see: Setting Up Oracle Approvals Management, Oracle E-Records Implementation Guide).
Use generic query attributes to search for e-records and their associated documents in the Evidence Store. For instructions on how to search, see Evidence Store, Oracle E-Records Implementation Guide. For all attributes listed below:
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 |
| ENG | ECO | ECO | Use this query element only when an Item Revisions e-record is part of an ECO. |
| Application Code | XML Element Tag | Display Name | Comments |
|---|---|---|---|
| INV | ITEM_CATALOG_GROUP | Catalog Group | N/A |
| INV | ITEM | Item | N/A |
| Name | Display Name | Description | Status | Owner Name | Owner Tag |
|---|---|---|---|---|---|
| oracle.apps.bom.billCreate | BOM Bill of Materials Create | ERES Event for BOM Bill of Materials Create | Enabled | Oracle Bills of Material | BOM |
| oracle.apps.bom.billUpdate | BOM Bill of Materials Update | ERES Event for BOM Bill of Materials Update | Enabled | Oracle Bills of Material | BOM |
| oracle.apps.bom.routingCreate | BOM Routing Create | ERES Event for BOM Routing Create | Enabled | Oracle Bills of Material | BOM |
| oracle.apps.bom.routingUpdate | BOM Routing Update | ERES Event for BOM Routing Update | Enabled | Oracle Bills of Material | BOM |
| Event Name | User Event Key (Identifier) |
|---|---|
| Oracle.apps.bom.billCreate | Org, Item, Alternate BOM Designator |
| Oracle.apps.bom.billUpdate | Org, Item, Alternate BOM Designator |
| Oracle.apps.bom.routingCreate | Org, Item, Alternate Routing Designator |
| Oracle.apps.bom.routingUpdate | Org, Item, Alternate Routing Designator |
Note: Enter User Event Keys with the given nomenclature but note that event keys may be case sensitive, separated by underscores and hyphens, and the event key values set off in carets.
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.bom.billCreate | EDR_XML_MAP_CODE=oracle.apps.bom.bill EDR_AME_TRANSACTION_TYPE=oracle.apps.bom.billCreate oracle.apps.bom.billUpdate=IGNORE_SIGNATURE |
| oracle.apps.bom.billUpdate | EDR_XML_MAP_CODE=oracle.apps.bom.bill EDR_AME_TRANSACTION_TYPE=oracle.apps.bom.billUpdate oracle.apps.bom.billUpdate=IGNORE_SIGNATURE |
| oracle.apps.bom.routingCreate | EDR_XML_MAP_CODE=oracle.apps.bom.routing EDR_AME_TRANSACTION_TYPE=oracle.apps.bom.routingCreate |
| oracle.apps.bom.routingUpdate | EDR_XML_MAP_CODE=oracle.apps.bom.routing EDR_AME_TRANSACTION_TYPE=oracle.apps.bom.routingUpdate |
All transaction types listed below belong to the Oracle Bills of Material application.
| Transaction Type ID | Transaction Type Description | Line Item Id Query String |
|---|---|---|
| Oracle.apps.bom.billCreate | BOM ERES Bill of Materials Creation | select category_id from mtl_item_categories where inventory_item_id = (select assembly_item_id from BOM_BILL_OF_MATERIALS WHERE bill_sequence_id = TO_NUMBER(:transactionId)) AND organization_id = (select organization_id from BOM_BILL_OF_MATERIALS WHERE bill_sequence_id = TO_NUMBER(:transactionId)) order by category_id |
| Oracle.apps.bom.billUpdate | BOM ERES Bill of Materials Update | select category_id from mtl_item_categories where inventory_item_id = (select assembly_item_id from BOM_BILL_OF_MATERIALS WHERE bill_sequence_id = TO_NUMBER(:transactionId)) AND organization_id = (select organization_id from BOM_BILL_OF_MATERIALS WHERE bill_sequence_id = TO_NUMBER(:transactionId)) order by category_id |
| Oracle.apps.bom.routingCreate | BOM ERES Operational Routing Creation | select category_id from mtl_item_categories where inventory_item_id = (select assembly_item_id from bom_operational_routings WHERE routing_sequence_id = TO_NUMBER(:transactionId)) AND organization_id = (select organization_id from bom_operational_routings WHERE routing_sequence_id = TO_NUMBER(:transactionId)) order by category_id |
| Oracle.apps.bom.routingUpdate | BOM ERES Operational Routing Update | select category_id from mtl_item_categories where inventory_item_id = (select assembly_item_id from bom_operational_routings WHERE routing_sequence_id = TO_NUMBER(:transactionId)) AND organization_id = (select organization_id from bom_operational_routings WHERE routing_sequence_id = TO_NUMBER(:transactionId)) 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 Bills of Material 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 | TOP_SUPERVISOR_PERSON_ID | number | person ID of the top person in the HR supervisory hierarchy | Yes | N/A |
| Non-mandatory Header Attribute | TRANSACTION_DATE | date | person ID of the top person in the HR supervisory hierarchy | No | SELECT ame_util.versionDateToString(CREATION_DATE) FROM bom_bill_of_materials WHERE bill_sequence_id = TO_NUMBER(:transactionId) |
| Non-mandatory Header Attribute | TRANSACTION_GROUP_ID | number | business-group ID in which transaction occurred | Yes | N/A |
| Non-mandatory Header Attribute | TRANSACTION_ORG_ID | number | org 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 last_updated_by FROM bom_bill_of_materials WHERE bill_sequence_id = TO_NUMBER(:transactionId) |
| Non-mandatory Header Attribute | TRANSACTION_SET_OF_BOOKS_ID | number | set-of-books ID in which transaction occurred | Yes | N/A |
BOM ERES Bill of Materials Creation (Oracle.apps.bom.billCreate)
BOM ERES Bill of Materials Update (Oracle.apps.bom.billUpdate)
| Attribute Category | Attribute Name | Attribute Type | Description | Static Usage | Usage |
|---|---|---|---|---|---|
| Non-Mandatory Header Attribute | ALTERNATE_DESIGNATOR | string | Alternate Designator. Triggers the event for certain alternate bill designators or for the primary bill, for example, when the Alternate Designator is null. | No | SELECT alternate_bom_designator FROM bom_bill_of_materials WHERE bill_sequence_id = TO_NUMBER(:transactionId) |
| Non-Mandatory Header Attribute | ASSEMBLY_ITEM | string | Assembly Item. | No | select assembly_item_no FROM BOM_BILL_OF_MATERIALS_ERV WHERE bill_sequence_id = TO_NUMBER(:transactionId) |
| Non-Mandatory Header Attribute | ORGANIZATION_CODE | string | Organization Code | No | select organization_code FROM mtl_parameters where organization_id = (select organization_id from BOM_BILL_OF_MATERIALS WHERE bill_sequence_id = TO_NUMBER(:transactionId)) |
| Non-mandatory Line Item Attribute | ITEM CATEGORY | string | The category set defined for functional area 'Order Mgmt' in Inventory | No | select concatenated_segments from MTL_CATEGORIES_B_KFV where category_id in (select category_id from mtl_item_categories where inventory_item_id = (select assembly_item_id from BOM_BILL_OF_MATERIALS WHERE bill_sequence_id = TO_NUMBER(:transactionId)) AND organization_id = (select organization_id from BOM_BILL_OF_MATERIALS WHERE bill_sequence_id = TO_NUMBER(:transactionId)) ) order by category_id |
BOM ERES Operational Routing Creation (Oracle.apps.bom.routingCreate)
BOM ERES Operational Routing Update (Oracle.apps.bom.routingUpdate)
| Attribute Category | Attribute Name | Attribute Type | Description | Static Usage | Usage |
|---|---|---|---|---|---|
| Non-Mandatory Header Attribute | ALTERNATE_DESIGNATOR | string | Alternate Designator. Triggers an event for certain alternate routing designators or triggers an event only for aprimary routing, for example, when the . Alternate Designator is null. | No | SELECT alternate_routing_designator FROM bom_operational_routings WHERE routing_sequence_id = to_number(:transactionId) |
| Non-Mandatory Header Attribute | ASSEMBLY_ITEM | string | Assembly Item. | No | select ASSEMBLY_ITEM FROM BOM_OPERATIONAL_ROUTINGS_ERV WHERE routing_sequence_id = TO_NUMBER(:transactionId) |
| Non-Mandatory Header Attribute | ORGANIZATION_CODE | string | Organization Code | No | select organization_code FROM mtl_parameters where organization_id = (select organization_id from bom_operational_routings WHERE routing_sequence_id = TO_NUMBER(:transactionId)) |
| Non-mandatory Line Item Attribute | ITEM CATEGORY | string | The category set defined for functional area 'Order Mgmt' in Inventory | No | select concatenated_segments from MTL_CATEGORIES_B_KFV where category_id in (select category_id from mtl_item_categories where inventory_item_id = (select assembly_item_id from bom_operational_routings WHERE routing_sequence_id = TO_NUMBER(:transactionId)) AND organization_id = (select organization_id from bom_operational_routings WHERE routing_sequence_id = TO_NUMBER(:transactionId)) ) order by category_id |
No rules or approvers are seeded. As part of the implementation, you must complete these activities (see: Setting Up Oracle Approvals Management, Oracle E-Records Implementation Guide).
Use generic query attributes to search for e-records and their associated documents in the Evidence Store. For instructions on how to search, see Evidence Store, Oracle E-Records Implementation Guide. For all attributes listed below:
Query Element Type = Generic
| Application Code | XML Element Tag | Display Name | Comments |
|---|---|---|---|
| BOM | ASSEMBLY_ITEM_NO | Item | N/A |
| BOM | ASSEMBLY_ITEM_REVISION | Item Revision | N/A |
| BOM | ALTERNATE_BOM_DESIGNATOR | Alternate Designator | N/A |
| BOM | COMPONENT_ITEM_NO | Component | For bill components and substitute components. |
| Application Code | XML Element Tag | Display Name | Comments |
|---|---|---|---|
| BOM | ASSEMBLY_ITEM | Item | N/A |
| BOM | CURRENT_REVISION | Item Revision | N/A |
| BOM | ALTERNATE_ROUTING_DESIGNATOR | Alternate Designator | N/A |
| BOM | PROCESS_REVISION | Routing Revision | N/A |
| BOM | STANDARD_OPERATION_CODE | Standard Operation Code | N/A |
| BOM | RESOURCE_CODE | Resource Code | For resources and alternate resource codes. |
| Name | Display Name | Description | Status | Owner Name | Owner Tag |
|---|---|---|---|---|---|
| oracle.apps.wip.job.assembly.complete | WIP Job Assembly Completion | WIP job assembly completion or assembly return | Enabled | Oracle Work in Process | WIP |
| oracle.apps.wip.job.assembly.move | WIP Job Assembly Move | WIP job operation move | Enabled | Oracle Work in Process | WIP |
| oracle.apps.wip.job.material.transact | WIP Job Material Transaction | WIP material issue, material return, negative issue, or negative return for a discrete job | Enabled | Oracle Work in Process | WIP |
| Event Name | User Event Key (Identifier) |
|---|---|
| oracle.apps.wip.job.assembly.complete | Job, Transaction Type |
| oracle.apps.wip.job.assembly.move | Job, Transaction Type |
| oracle.apps.wip.job.material.transact | Job, Transaction Type |
Note: Enter User Event Keys with the given nomenclature but note that event keys may be case sensitive, separated by underscores and hyphens, and the event key values set off in carets.
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.wip.job.assembly.complete | EDR_XML_MAP_CODE=wipcmpmp EDR_AME_TRANSACTION_TYPE=oracle.apps.wip.job.assembly.complete |
| oracle.apps.wip.job.assembly.move | EDR_XML_MAP_CODE=wipmovmp EDR_AME_TRANSACTION_TYPE=oracle.apps.wip.job.assembly.move |
| oracle.apps.wip.job.material.transact | EDR_XML_MAP_CODE=wipmtlmp EDR_AME_TRANSACTION_TYPE=oracle.apps.wip.job.material.transact |
All transaction types listed below belong to the Oracle Work in Process application.
| Transaction Type ID | Transaction Type Description | Line Item Id Query String |
|---|---|---|
| oracle.apps.wip.job.assembly.complete | WIP ERES Job Assembly Completion | select transaction_id from mtl_material_transactions where transaction_set_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and transaction_source_id = substr(:transactionId, (instr(:transactionId, '-')+1), (instr(:transactionId, '-', 1, 2)- (instr(:transactionId, '-')+1))) and transaction_type_id in (44,17) order by transaction_id |
| oracle.apps.wip.job.assembly.move | WIP ERES Job Assembly Move | N/A |
| oracle.apps.wip.job.material.transact | WIP ERES Job Material Transaction | select transaction_id from mtl_material_transactions where transaction_set_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and transaction_source_id = substr(:transactionId, (instr(:transactionId, '-')+1)) order by transaction_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 Work in Process 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 | TOP_SUPERVISOR_PERSON_ID | number | person ID of the top person in the HR supervisory hierarchy | Yes | N/A |
| Non-mandatory Header Attribute | TRANSACTION_GROUP_ID | number | business-group ID in which transaction occurred | Yes | N/A |
| Non-mandatory Header Attribute | TRANSACTION_ORG_ID | number | org 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_SET_OF_BOOKS_ID | number | set-of-books ID in which transaction occurred | Yes | N/A |
WIP ERES Job Material Transaction (oracle.apps.wip.job.material.transact)
| Attribute Category | Attribute Name | Attribute Type | Description | Static Usage | Usage |
|---|---|---|---|---|---|
| Non-mandatory Header Attribute | TRANSACTION_DATE | date | date transaction occurred | No | select ame_util.versionDateToString(LAST_UPDATE_DATE) from mtl_material_transactions where transaction_set_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and transaction_source_id = substr(:transactionId, (instr(:transactionId, '-')+1)) and rownum = 1 |
| Non-mandatory Header Attribute | TRANSACTION_REQUESTOR_USER_ID | number | user ID of user initiating transaction, if any | No | select fnd_number.number_to_canonical(last_updated_by) from mtl_material_transactions where transaction_set_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and transaction_source_id = substr(:transactionId, (instr(:transactionId, '-')+1)) and rownum = 1 |
| Non-Mandatory Header Attribute | WIP_ASSEMBLY | string | Approval based on assembly | No | select msik.concatenated_segments from mtl_system_items_kfv msik, mtl_material_transactions mmt, wip_discrete_jobs wdj where mmt.transaction_set_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and mmt.transaction_source_id = substr(:transactionId, (instr(:transactionId, '-')+1)) and mmt.transaction_source_id = wdj.wip_entity_id and wdj.organization_id = msik.organization_id and wdj.primary_item_id = msik.inventory_item_id and rownum = 1 |
| Non-Mandatory Header Attribute | WIP_JOB | string | Approval based on job. | No | select we.wip_entity_name from wip_entities we, mtl_material_transactions mmt where mmt.transaction_set_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and mmt.transaction_source_id = substr(:transactionId, (instr(:transactionId, '-')+1)) and we.wip_entity_id = mmt.transaction_source_id and rownum = 1 |
| Non-Mandatory Header Attribute | WIP_JOB_PROJECT | string | Approval based on job's project | No | select pjm_project.all_proj_idtonum(wdj.project_id) from mtl_material_transactions mmt, wip_discrete_jobs wdj where mmt.transaction_set_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and mmt.transaction_source_id = substr(:transactionId, (instr(:transactionId, '-')+1)) and mmt.transaction_source_id = wdj.wip_entity_id and rownum = 1 |
| Non-mandatory Header Attribute | WIP_JOB_TASK | string | Approval based on job's task | No | select pjm_project.all_task_idtonum(wdj.task_id) from mtl_material_transactions mmt, wip_discrete_jobs wdj where mmt.transaction_set_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and mmt.transaction_source_id = substr(:transactionId, (instr(:transactionId, '-')+1)) and mmt.transaction_source_id = wdj.wip_entity_id and rownum = 1 |
| Non-mandatory Header Attribute | WIP_MATERIAL_TRANSACTION_TYPE | string | Txn Type: WIP component issue,WIP Component Return,WIP Neg Comp Issue,WIP Neg Comp Return | No | select transaction_type_name from mtl_material_transactions mmt, mtl_transaction_types type where mmt.transaction_set_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and mmt.transaction_source_id = substr(:transactionId, (instr(:transactionId, '-')+1)) and type.transaction_type_id = mmt.transaction_type_id and rownum = 1 |
| Non-mandatory Line Item Attribute | WIP_COMPONENT | string | Approval based on component item | No | select msik.concatenated_segments from mtl_system_items_kfv msik, mtl_material_transactions mmt where mmt.transaction_set_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and mmt.transaction_source_id = substr(:transactionId, (instr(:transactionId, '-')+1)) and mmt.transaction_id in (select transaction_id from mtl_material_transactions where transaction_set_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and transaction_source_id = substr(:transactionId, (instr(:transactionId, '-')+1)) ) and mmt.organization_id = msik.organization_id and mmt.inventory_item_id = msik.inventory_item_id order by mmt.transaction_id |
| Non-mandatory Line Item Attribute | WIP_DEPARTMENT | string | Approval based on department | No | select bd.department_code from mtl_material_transactions mmt, bom_departments bd where mmt.transaction_set_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and mmt.transaction_source_id = substr(:transactionId, (instr(:transactionId, '-')+1)) and mmt.transaction_id in (select transaction_id from mtl_material_transactions where transaction_set_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and transaction_source_id = substr(:transactionId, (instr(:transactionId, '-')+1)) ) and bd.department_id = mmt.department_id order by mmt.transaction_id |
| Non-mandatory Line Item Attribute | WIP_LOCATOR | string | Approval based on locator | No | select inv_project.get_locator(locator_id, organization_id) from mtl_material_transactions mmt where mmt.transaction_id in (select transaction_id from mtl_material_transactions where transaction_set_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and transaction_source_id = substr(:transactionId, (instr(:transactionId, '-')+1)) ) order by mmt.transaction_id |
| Non-mandatory Line Item Attribute | WIP_OP_SEQ_NUM | number | Approval based on operation seq num | No | select fnd_number.number_to_canonical(mmt.operation_seq_num) from mtl_material_transactions mmt where mmt.transaction_set_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and mmt.transaction_source_id = substr(:transactionId, (instr(:transactionId, '-')+1)) and mmt.transaction_id in (select transaction_id from mtl_material_transactions where transaction_set_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and transaction_source_id = substr(:transactionId, (instr(:transactionId, '-')+1)) ) order by mmt.transaction_id |
| Non-mandatory Line Item Attribute | WIP_SUBINVENTORY | string | Approval based on subinventory | No | select mmt.subinventory_code from mtl_material_transactions mmt where mmt.transaction_id in (select transaction_id from mtl_material_transactions where transaction_set_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and transaction_source_id = substr(:transactionId, (instr(:transactionId, '-')+1)) ) order by mmt.transaction_id |
WIP ERES Job Assembly Move (oracle.apps.wip.job.assembly.move)
| Attribute Category | Attribute Name | Attribute Type | Description | Static Usage | Usage |
|---|---|---|---|---|---|
| Non-mandatory Header Attribute | TRANSACTION_DATE | date | date transaction occurred | No | select ame_util.versionDateToString(LAST_UPDATE_DATE) from wip_move_transactions where transaction_id = :transactionId |
| Non-mandatory Header Attribute | TRANSACTION_REQUESTOR_USER_ID | number | user ID of user initiating transaction, if any | No | select fnd_number.number_to_canonical(last_updated_by) from wip_move_transactions where transaction_id = :transactionId |
| Non-Mandatory Header Attribute | WIP_ASSEMBLY | string | Approval based on assembly | No | select msik.concatenated_segments from mtl_system_items_kfv msik, wip_move_transactions wmt where wmt.transaction_id = :transactionId and wmt.primary_item_id = msik.inventory_item_id and wmt.organization_id = msik.organization_id |
| Non-Mandatory Header Attribute | WIP_ASSEMBLY_LOCATOR | string | Approval based on locator for assembly completion/return | No | select inv_project.get_locator(wdj.completion_locator_id, wdj.organization_id) from wip_move_transactions wmt, wip_discrete_jobs wdj where wmt.transaction_id = :transactionId and wmt.wip_entity_id = wdj.wip_entity_id |
| Non-Mandatory Header Attribute | WIP_ASSEMBLY_SUBINVENTORY | string | Approval based on subinventory for assembly completion/return | No | select wdj.completion_subinventory from wip_move_transactions wmt, wip_discrete_jobs wdj where wmt.transaction_id = :transactionId and wmt.wip_entity_id = wdj.wip_entity_id |
| Non-Mandatory Header Attribute | WIP_FROM_DEPARTMENT | string | Approval based on department from which assembly was moved | No | select fm_department_code from wip_move_transactions_v wmt where wmt.transaction_id = :transactionId |
| Non-Mandatory Header Attribute | WIP_FROM_INTRAOPERATION_STEP | string | Approval based on intraoperation step from which assembly was moved | No | select wmt.fm_intraoperation_step_meaning from wip_move_transactions_v wmt where wmt.transaction_id = :transactionId |
| Non-Mandatory Header Attribute | WIP_FROM_OPERATION_CODE | string | Approval based on operation code from which assembly was moved | No | select fm_operation_code from wip_move_transactions_v wmt where wmt.transaction_id = :transactionId |
| Non-Mandatory Header Attribute | WIP_FROM_OPERATION_SEQ_NUM | number | Approval based on operation sequence from which assembly was moved | No | select fnd_number.number_to_canonical(fm_operation_seq_num) from wip_move_transactions wmt where wmt.transaction_id = :transactionId |
| Non-Mandatory Header Attribute | WIP_JOB | string | Approval based on job. | No | select we.wip_entity_name from wip_move_transactions wmt, wip_entities we where wmt.transaction_id = :transactionId and wmt.wip_entity_id = we.wip_entity_id |
| Non-Mandatory Header Attribute | WIP_JOB_PROJECT | string | Approval based on job's project | No | select pjm_project.all_proj_idtonum(wdj.project_id) from wip_move_transactions wmt, wip_discrete_jobs wdj where wmt.transaction_id = :transactionId and wmt.wip_entity_id = wdj.wip_entity_id |
| Non-mandatory Header Attribute | WIP_JOB_TASK | string | Approval based on job's task | No | select pjm_project.all_task_idtonum(wdj.task_id) from wip_move_transactions wmt, wip_discrete_jobs wdj where wmt.transaction_id = :transactionId and wmt.wip_entity_id = wdj.wip_entity_id |
| Non-mandatory Header Attribute | WIP_MOVE_TRANSACTION_TYPE | string | Transaction type: Move transaction,Move and completion transaction,Return and move transaction | No | select wip_move_validator.move_txn_type(wmt.transaction_id) from wip_move_transactions wmt where wmt.transaction_id = :transactionId |
| Non-mandatory Line Item Attribute | WIP_TO_DEPARTMENT | string | Approval based on department to which assembly was moved | No | select to_department_code from wip_move_transactions_v wmt where wmt.transaction_id = :transactionId |
| Non-mandatory Line Item Attribute | WIP_TO_INTRAOPERATION_STEP | string | Approval based on intraoperation step to which assembly was moved | No | select wmt.to_intraoperation_step_meaning from wip_move_transactions_v wmt where wmt.transaction_id = :transactionId |
| Non-mandatory Line Item Attribute | WIP_TO_OPERATION_CODE | string | Approval based on operation code to which assembly was moved | No | select to_operation_code from wip_move_transactions_v wmt where wmt.transaction_id = :transactionId |
| Non-mandatory Line Item Attribute | WIP_TO_OPERATION_SEQ_NUM | number | Approval based on operation sequence to which assembly was moved | No | select fnd_number.number_to_canonical(to_operation_seq_num) from wip_move_transactions wmt where wmt.transaction_id = :transactionId |
WIP ERES Job Assembly Completion (oracle.apps.wip.job.assembly.complete)
| Attribute Category | Attribute Name | Attribute Type | Description | Static Usage | Usage |
|---|---|---|---|---|---|
| Non-mandatory Header Attribute | TRANSACTION_DATE | date | date transaction occurred | No | select ame_util.versionDateToString(LAST_UPDATE_DATE) from mtl_material_transactions where transaction_set_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and transaction_source_id = substr(:transactionId, (instr(:transactionId, '-')+1), (instr(:transactionId, '-', 1, 2)- (instr(:transactionId, '-')+1))) and transaction_type_id in (44,17) and rownum = 1 |
| Non-mandatory Header Attribute | TRANSACTION_REQUESTOR_USER_ID | number | user ID of user initiating transaction, if any | No | select fnd_number.number_to_canonical(last_updated_by) from mtl_material_transactions where transaction_set_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and transaction_source_id = substr(:transactionId, (instr(:transactionId, '-')+1), (instr(:transactionId, '-', 1, 2)- (instr(:transactionId, '-')+1))) and transaction_type_id in (44,17) and rownum = 1 |
| Non-Mandatory Header Attribute | WIP_ASSEMBLY | string | Approval based on assembly | No | select msik.concatenated_segments from mtl_system_items_kfv msik, mtl_material_transactions mmt where transaction_set_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and transaction_source_id = substr(:transactionId, (instr(:transactionId, '-')+1), (instr(:transactionId, '-', 1, 2)- (instr(:transactionId, '-')+1))) and mmt.inventory_item_id=msik.inventory_item_id and mmt.organization_id = msik.organization_id and mmt.transaction_type_id in (44,17) and rownum = 1 |
| Non-Mandatory Header Attribute | WIP_COMPLETION_TRANSACTION_TYPE | string | Transaction type: WIP Assembly Completion,WIP Assembly Return | No | select transaction_type_name from mtl_material_transactions mmt, mtl_transaction_types type where transaction_set_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and transaction_source_id = substr(:transactionId, (instr(:transactionId, '-')+1), (instr(:transactionId, '-', 1, 2)- (instr(:transactionId, '-')+1))) and type.transaction_type_id = mmt.transaction_type_id and mmt.transaction_type_id in (44,17) and rownum = 1 |
| Non-Mandatory Header Attribute | WIP_JOB | string | Approval based on job. | No | select we.wip_entity_name from wip_entities we, mtl_material_transactions mmt where transaction_set_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and transaction_source_id = substr(:transactionId, (instr(:transactionId, '-')+1), (instr(:transactionId, '-', 1, 2)- (instr(:transactionId, '-')+1))) and we.wip_entity_id = mmt.transaction_source_id and mmt.transaction_type_id in (44,17) and rownum = 1 |
| Non-Mandatory Header Attribute | WIP_JOB_PROJECT | string | Approval based on job's project | No | select pjm_project.all_proj_idtonum(wdj.project_id) from mtl_material_transactions mmt, wip_discrete_jobs wdj where transaction_set_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and transaction_source_id = substr(:transactionId, (instr(:transactionId, '-')+1), (instr(:transactionId, '-', 1, 2)- (instr(:transactionId, '-')+1))) and mmt.transaction_source_id = wdj.wip_entity_id and rownum = 1 |
| Non-mandatory Header Attribute | WIP_JOB_TASK | string | Approval based on job's task | No | select pjm_project.all_task_idtonum(wdj.task_id) from mtl_material_transactions mmt, wip_discrete_jobs wdj where transaction_set_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and transaction_source_id = substr(:transactionId, (instr(:transactionId, '-')+1), (instr(:transactionId, '-', 1, 2)- (instr(:transactionId, '-')+1))) and mmt.transaction_source_id = wdj.wip_entity_id and rownum = 1 |
| Non-mandatory Line Item Attribute | WIP_LOCATOR | string | Approval based on locator | No | select inv_project.get_locator(mmt.locator_id, mmt.organization_id) from mtl_material_transactions mmt where transaction_id in (select transaction_id from mtl_material_transactions where transaction_set_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and transaction_source_id = substr(:transactionId, (instr(:transactionId, '-')+1), (instr(:transactionId, '-', 1, 2)- (instr(:transactionId, '-')+1))) and transaction_type_id in (44,17) ) order by mmt.transaction_id |
| Non-mandatory Line Item Attribute | WIP_SUBINVENTORY | string | Approval based on subinventory | No | select mmt.subinventory_code from mtl_material_transactions mmt where transaction_id in (select transaction_id from mtl_material_transactions where transaction_set_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and transaction_source_id = substr(:transactionId, (instr(:transactionId, '-')+1), (instr(:transactionId, '-', 1, 2)- (instr(:transactionId, '-')+1))) and transaction_type_id in (44,17) ) order by mmt.transaction_id |
No rules or approvers are seeded. As part of the implementation, you must complete these activities (see: Setting Up Oracle Approvals Management, Oracle E-Records Implementation Guide).
Use generic query attributes to search for e-records and their associated documents in the Evidence Store. For instructions on how to search, see Evidence Store, Oracle E-Records Implementation Guide. For all attributes listed below:
Query Element Type = Generic
| Application Code | XML Element Tag | Display Name | Comments |
|---|---|---|---|
| WIP | JOB | Job | N/A |
| WIP | JOB_TYPE | Job Type | N/A |
| WIP | TRANSACTION_TYPE | Transaction Type | N/A |
| Application Code | XML Element Tag | Display Name | Comments |
|---|---|---|---|
| WIP | ASSET_GROUP | Asset Group | N/A |
| WIP | ASSET_NUMBER | Asset Number | N/A |
| WIP | OP_STEP | Intraoperation Step | N/A |
| WIP | JOB | Job | N/A |
| WIP | JOB_TYPE | Job Type | N/A |
| WIP | MOVE_TRANSACTION_TYPE | Move Transaction Type | N/A |
| WIP | SCRAP_ACCOUNT_NUMBER | Scrap Account Number | N/A |
| WIP | TO_DEPARTMENT | To Department Code | N/A |
| WIP | TO_OP_STEP | To Intraoperation Step | N/A |
| WIP | TO_OP_CODE | To Operation Sequence Code | N/A |
| WIP | TO_OP_SEQ_NUM | To Operation Sequence Number | N/A |
| WIP | TRANSACTION_TYPE | Transaction Type | N/A |
| Application Code | XML Element Tag | Display Name | Comments |
|---|---|---|---|
| WIP | ASSET_GROUP | Asset Group | N/A |
| WIP | ASSET_NUMBER | Asset Number | N/A |
| WIP | JOB | Job | N/A |
| WIP | JOB_TYPE | Job Type | N/A |
| WIP | TO_DEPARTMENT | To Department Code | N/A |
| WIP | TO_OP_SEQ_NUM | To Operation Sequence Number | N/A |
| WIP | TRANSACTION_TYPE | Transaction Type | N/A |
| Name | Display Name | Description | Status | Owner Name | Owner Tag |
|---|---|---|---|---|---|
| oracle.apps.qa.element.create | QA ERES Collection Element Creation | ERES Event for the Creation of a Collection Element in Oracle Quality | Enabled | Oracle Quality | QA |
| oracle.apps.qa.element.update | QA ERES Collection Element Update | ERES Event for the Update of a Collection Element in Oracle Quality | Enabled | Oracle Quality | QA |
| oracle.apps.qa.plan.create | QA ERES Collection Plan Creation | ERES Event for the Creation of a Collection Plan in Oracle Quality | Enabled | Oracle Quality | QA |
| oracle.apps.qa.plan.update | QA ERES Collection Plan Update | ERES Event for the Update of a Collection Plan in Oracle Quality | Enabled | Oracle Quality | QA |
| oracle.apps.qa.spec.create | QA ERES Specification Creation | ERES Event for the Creation of a Specification in Oracle Quality | Enabled | Oracle Quality | QA |
| oracle.apps.qa.spec.update | QA ERES Specification Update | ERES Event for the Update of a Specification in Oracle Quality | Enabled | Oracle Quality | QA |
| oracle.apps.qa.result.create | QA ERES Result Creation | ERES Event for the Creation of a Result in Oracle Quality | Disabled | Oracle Quality | QA |
| oracle.apps.qa.result.update | QA ERES Result Update | ERES Event for the Update of a Result in Oracle Quality | Enabled | Oracle Quality | QA |
| oracle.apps.qa.ncm.create | QA ERES Nonconformance Creation | ERES Event for the Creation of a Nonconformance in Oracle Quality | Enabled | Oracle Quality | QA |
| oracle.apps.qa.ncm.update | QA ERES Nonconformance Update | ERES Event for the Update of a Nonconformance in Oracle Quality | Enabled | Oracle Quality | QA |
| oracle.apps.qa.ncm.master.approve | QA ERES Nonconformance Master Approval | ERES Event for the Approval of a Nonconformance Master in Oracle Quality | Enabled | Oracle Quality | QA |
| oracle.apps.qa.ncm.detail.approve | QA ERES Nonconformance Detail Approval | ERES Event for the Approval of a Nonconformance Detail in Oracle Quality | Enabled | Oracle Quality | QA |
| oracle.apps.qa.disp.create | QA ERES Disposition Creation | ERES Event for the Creation of a Disposition in Oracle Quality | Enabled | Oracle Quality | QA |
| oracle.apps.qa.disp.update | QA ERES Disposition Update | ERES Event for the Update of a Disposition in Oracle Quality | Enabled | Oracle Quality | QA |
| oracle.apps.qa.disp.header.approve | QA ERES Disposition Header Approval | ERES Event for the Approval of a Disposition Header in Oracle Quality | Enabled | Oracle Quality | QA |
| oracle.apps.qa.disp.detail.approve | QA ERES Disposition Detail Approval | ERES Event for the Approval of a Disposition Detail in Oracle Quality | Enabled | Oracle Quality | QA |
| oracle.apps.qa.car.create | QA ERES Corrective Action Creation | ERES Event for the Creation of a Corrective Action in Oracle Quality | Enabled | Oracle Quality | QA |
| oracle.apps.qa.car.update | QA ERES Corrective Action Update | ERES Event for the Update of a Corrective Action in Oracle Quality | Enabled | Oracle Quality | QA |
| oracle.apps.qa.car.approve | QA ERES Corrective Action Approval | ERES Event for the Approval of a Corrective Action in Oracle Quality | Enabled | Oracle Quality | QA |
| oracle.apps.qa.car.review.approve | QA ERES Corrective Action Review Approval | ERES Event for the Approval of a Corrective Action Review in Oracle Quality | Enabled | Oracle Quality | QA |
| oracle.apps.qa.car.impl.approve | QA ERES Corrective Action Implementation Approval | ERES Event for the Approval of a Corrective Action Implementation in Oracle Quality | Enabled | Oracle Quality | QA |
| oracle.apps.qa.spec.org.assign | QA ERES Specification Org Assignment | ERES Event for the Assignment of a Specification to one or more Organizations in Oracle Quality | Enabled | Oracle Quality | QA |
Note: You can only define a single event key for use with Oracle E-Records, but many of the Oracle Quality events require composite keys. The system creates composite keys for Oracle E-Records calls by combining multiple fields to form a unique key. This unique key identifies a single entity by concatenating the fields together with a hyphen delimiter (for example: key1-key2). The fields used to create the composite key are presented below in a comma separated list in the User Event Key column.
| Event Name | User Event Key (Identifier) |
|---|---|
| oracle.apps.qa.element.create | qa_chars.char_id |
| oracle.apps.qa.element.update | qa_chars.char_id |
| oracle.apps.qa.plan.create | qa_plans.plan_id |
| oracle.apps.qa.plan.update | qa_plans.plan_id |
| oracle.apps.qa.result.create | qa_results.plan_id, qa_results.colletion_id, qa_results.occurrence(user-controlled) |
| oracle.apps.qa.result.update | qa_results.plan_id, qa_results.colletion_id, qa_results.occurrence |
| oracle.apps.qa.ncm.create | qa_results.plan_id, qa_results.colletion_id, qa_results.occurrence |
| oracle.apps.qa.ncm.update | qa_results.plan_id, qa_results.colletion_id, qa_results.occurrence |
| oracle.apps.qa.ncm.master.approve | qa_results.plan_id, qa_results.colletion_id, qa_results.occurrence |
| oracle.apps.qa.ncm.detail.approve | qa_results.plan_id, qa_results.colletion_id, qa_results.occurrence |
| oracle.apps.qa.disp.create | qa_results.plan_id, qa_results.colletion_id, qa_results.occurrence |
| oracle.apps.qa.disp.update | qa_results.plan_id, qa_results.colletion_id, qa_results.occurrence |
| oracle.apps.qa.disp.header.approve | qa_results.plan_id, qa_results.colletion_id, qa_results.occurrence |
| oracle.apps.qa.disp.detail.approve | qa_results.plan_id, qa_results.colletion_id, qa_results.occurrence |
| oracle.apps.qa.car.create | qa_results.plan_id, qa_results.colletion_id, qa_results.occurrence |
| oracle.apps.qa.car.update | qa_results.plan_id, qa_results.colletion_id, qa_results.occurrence |
| oracle.apps.qa.car.approve | qa_results.plan_id, qa_results.colletion_id, qa_results.occurrence |
| oracle.apps.qa.car.review.approve | qa_results.plan_id, qa_results.colletion_id, qa_results.occurrence |
| oracle.apps.qa.car.impl.approve | qa_results.plan_id, qa_results.colletion_id, qa_results.occurrence |
| oracle.apps.qa.spec.org.assign | qa_specs.spec_id |
| oracle.apps.qa.spec.create | qa_specs.spec_id |
| oracle.apps.qa.spec. update | qa_specs.spec_id |
Note: Enter User Event Keys with the given nomenclature but note that event keys may be case sensitive, separated by underscores and hyphens, and the event key values set off in carets.
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.qa.element.create | EDR_XML_MAP_CODE =qa_elements EDR_AME_TRANSACTION_TYPE =oracle.apps.qa.element.create |
| oracle.apps.qa.element.update | EDR_XML_MAP_CODE =qa_elements EDR_AME_TRANSACTION_TYPE =oracle.apps.qa.element.update |
| oracle.apps.qa.plan.create | EDR_XML_MAP_CODE =qa_plans EDR_AME_TRANSACTION_TYPE =oracle.apps.qa.plan.create |
| oracle.apps.qa.plan.update | EDR_XML_MAP_CODE =qa_plans EDR_AME_TRANSACTION_TYPE =oracle.apps.qa.plan.update |
| oracle.apps.qa.spec.create | EDR_XML_MAP_CODE = qa_specs EDR_AME_TRANSACTION_TYPE =oracle.apps.qa.spec.create |
| oracle.apps.qa.spec.update | EDR_XML_MAP_CODE = qa_specs EDR_AME_TRANSACTION_TYPE =oracle.apps.qa.spec.update |
| oracle.apps.qa.result.create | EDR_XML_MAP_CODE =qa_results EDR_AME_TRANSACTION_TYPE =oracle.apps.qa.result.create |
| oracle.apps.qa.result.update | EDR_XML_MAP_CODE =qa_results EDR_AME_TRANSACTION_TYPE =oracle.apps.qa.result.update |
| oracle.apps.qa.ncm.create | EDR_XML_MAP_CODE = qa_ncm EDR_AME_TRANSACTION_TYPE =oracle.apps.qa.ncm.create |
| oracle.apps.qa.ncm.update | EDR_XML_MAP_CODE =qa_ncm EDR_AME_TRANSACTION_TYPE =oracle.apps.qa.ncm.update |
| oracle.apps.qa.ncm.master.approve | EDR_XML_MAP_CODE =qa_ncm EDR_AME_TRANSACTION_TYPE =oracle.apps.qa.ncm.master.approve |
| oracle.apps.qa.ncm.detail.approve | EDR_XML_MAP_CODE =qa_ncm EDR_AME_TRANSACTION_TYPE =oracle.apps.qa.ncm.detail.approve |
| oracle.apps.qa.disp.create | EDR_XML_MAP_CODE =qa_ncm EDR_AME_TRANSACTION_TYPE =oracle.apps.qa.disp.create |
| oracle.apps.qa.disp.update | EDR_XML_MAP_CODE =qa_ncm EDR_AME_TRANSACTION_TYPE =oracle.apps.qa.disp.update |
| oracle.apps.qa.disp.header.approve | EDR_XML_MAP_CODE =qa_ncm EDR_AME_TRANSACTION_TYPE =oracle.apps.qa.disp.header.approve |
| oracle.apps.qa.disp.detail.approve | EDR_XML_MAP_CODE =qa_ncm EDR_AME_TRANSACTION_TYPE =oracle.apps.qa.disp.detail.approve |
| oracle.apps.qa.car.create | EDR_XML_MAP_CODE =qa_ncm EDR_AME_TRANSACTION_TYPE =oracle.apps.qa.car.create |
| oracle.apps.qa.car.update | EDR_XML_MAP_CODE =qa_ncm EDR_AME_TRANSACTION_TYPE =oracle.apps.qa.car.update |
| oracle.apps.qa.car.approve | EDR_XML_MAP_CODE =qa_ncm EDR_AME_TRANSACTION_TYPE =oracle.apps.qa.car.approve |
| oracle.apps.qa.car.review.approve | EDR_XML_MAP_CODE =qa_ncm EDR_AME_TRANSACTION_TYPE =oracle.apps.qa.car.review.approve |
| oracle.apps.qa.car.impl.approve | EDR_XML_MAP_CODE =qa_ncm EDR_AME_TRANSACTION_TYPE =oracle.apps.qa.impl approve |
| oracle.apps.qa.spec.org.assign | EDR_XML_MAP_CODE=qa_spec_org_assignments EDR_AME_TRANSACTION_TYPE=oracle.apps.qa.spec.org.assign oracle.apps.qa.spec.create=IGNORE_SIGNATURE oracle.apps.qa.spec.update=IGNORE_SIGNATURE |
All transaction types listed below belong to the Oracle Quality application.
| Transaction Type ID | Transaction Type Description | Line Item Id Query String |
|---|---|---|
| oracle.apps.qa.element.create | QA ERES Collection Element Creation | N/A |
| oracle.apps.qa.element.update | QA ERES Collection Element Update | N/A |
| oracle.apps.qa.plan.create | QA ERES Collection Plan Creation | N/A |
| oracle.apps.qa.plan.update | QA ERES Collection Plan Update | N/A |
| oracle.apps.qa.spec.create | QA ERES Specification Creation | N/A |
| oracle.apps.qa.spec.update | QA ERES Specification Update | N/A |
| oracle.apps.qa.result.create | QA ERES Result Creation | select distinct mic.category_id from mtl_item_categories mic, (select organization_id, item_id from qa_results where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', -1)+1)), OCCURRENCE)) qr where qr.organization_id = mic.organization_id and qr.item_id = mic.inventory_item_id order by category_id asc |
| oracle.apps.qa.result.update | QA ERES Result Update | select distinct mic.category_id from mtl_item_categories mic, (select organization_id, item_id from qa_results where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', -1)+1)), OCCURRENCE)) qr where qr.organization_id = mic.organization_id and qr.item_id = mic.inventory_item_id order by category_id asc |
| oracle.apps.qa.ncm.create | QA ERES Nonconformance Creation | select distinct mic.category_id from mtl_item_categories mic, (select organization_id, item_id from qa_results where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE)) qr where qr.organization_id = mic.organization_id and qr.item_id = mic.inventory_item_id order by category_id asc |
| oracle.apps.qa.ncm.update | QA ERES Nonconformance Update | select distinct mic.category_id from mtl_item_categories mic, (select organization_id, item_id from qa_results where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE)) qr where qr.organization_id = mic.organization_id and qr.item_id = mic.inventory_item_id order by category_id asc |
| oracle.apps.qa.ncm.master.approve | QA ERES Nonconformance Master Approval | select distinct mic.category_id from mtl_item_categories mic, (select organization_id, item_id from qa_results where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE)) qr where qr.organization_id = mic.organization_id and qr.item_id = mic.inventory_item_id order by category_id asc |
| oracle.apps.qa.ncm.detail.approve | QA ERES Nonconformance Detail Approval | select distinct mic.category_id from mtl_item_categories mic, (select organization_id, item_id from qa_results where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE)) qr where qr.organization_id = mic.organization_id and qr.item_id = mic.inventory_item_id order by category_id asc |
| oracle.apps.qa.disp.create | QA ERES Disposition Creation | select distinct mic.category_id from mtl_item_categories mic, (select organization_id, item_id from qa_results where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE)) qr where qr.organization_id = mic.organization_id and qr.item_id = mic.inventory_item_id order by category_id asc |
| oracle.apps.qa.disp.update | QA ERES Disposition Update | select distinct mic.category_id from mtl_item_categories mic, (select organization_id, item_id from qa_results where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE)) qr where qr.organization_id = mic.organization_id and qr.item_id = mic.inventory_item_id order by category_id asc |
| oracle.apps.qa.disp.header.approve | QA ERES Disposition Header Approval | select distinct mic.category_id from mtl_item_categories mic, (select organization_id, item_id from qa_results where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE)) qr where qr.organization_id = mic.organization_id and qr.item_id = mic.inventory_item_id order by category_id asc |
| oracle.apps.qa.disp.detail.approve | QA ERES Disposition Detail Approval | select distinct mic.category_id from mtl_item_categories mic, (select organization_id, item_id from qa_results where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE)) qr where qr.organization_id = mic.organization_id and qr.item_id = mic.inventory_item_id order by category_id asc |
| oracle.apps.qa.car.create | QA ERES Corrective Action Creation | select distinct mic.category_id from mtl_item_categories mic, (select organization_id, item_id from qa_results where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE)) qr where qr.organization_id = mic.organization_id and qr.item_id = mic.inventory_item_id order by category_id asc |
| oracle.apps.qa.car.update | QA ERES Corrective Action Update | select distinct mic.category_id from mtl_item_categories mic, (select organization_id, item_id from qa_results where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE)) qr where qr.organization_id = mic.organization_id and qr.item_id = mic.inventory_item_id order by category_id asc |
| oracle.apps.qa.car.approve | QA ERES Corrective Action Approval | select distinct mic.category_id from mtl_item_categories mic, (select organization_id, item_id from qa_results where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE)) qr where qr.organization_id = mic.organization_id and qr.item_id = mic.inventory_item_id order by category_id asc |
| oracle.apps.qa.car.review.approve | QA ERES Corrective Action Review Approval | select distinct mic.category_id from mtl_item_categories mic, (select organization_id, item_id from qa_results where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE)) qr where qr.organization_id = mic.organization_id and qr.item_id = mic.inventory_item_id order by category_id asc |
| oracle.apps.qa.car.impl.approve | QA ERES Corrective Action Implementation Approval | select distinct mic.category_id from mtl_item_categories mic, (select organization_id, item_id from qa_results where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE)) qr where qr.organization_id = mic.organization_id and qr.item_id = mic.inventory_item_id order by category_id asc |
| oracle.apps.qa.spec.org.assign | QA ERES Specification Org Assignment | select child_spec_id from qa_spec_org_assignments_v where spec_id = :transactionId and assign_flag = 1 order by child_spec_id asc |
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 Quality 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 | TRANSACTION_DATE | date | date transaction occurred | No | select ame_util.versionDateToString(CREATION_DATE) from qa_chars where char_id = :transactionId |
| 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 Last_updated_by from qa_chars where char_id = :transactionId |
| Non-mandatory Header Attribute | TRANSACTION_SET_OF_BOOKS_ID | number | set-of-books ID in which transaction occurred | Yes | N/A |
QA ERES Collection Element Creation (oracle.apps.qa.element.create)
QA ERES Collection Element Update (oracle.apps.qa.element.update)
| Attribute Category | Attribute Name | Attribute Type | Description | Static Usage | Usage |
|---|---|---|---|---|---|
| Non-Mandatory Header Attribute | QA_ELEMENT_NAME | string | Approval based on the Collection Element Name | No | select name from qa_chars_v where char_id = :transactionId |
| Non-Mandatory Header Attribute | QA_ELEMENT_TYPE | string | Approval based on the Collection Element Type | No | select char_type_meaning from qa_chars_v where char_id = :transactionId |
| Non-mandatory Header Attribute | TOP_SUPERVISOR_PERSON_ID | number | person ID of the top person in the HR supervisory hierarchy | Yes | N/A |
QA ERES Collection Plan Creation (oracle.apps.qa.plan.create)
QA ERES Collection Plan Update (oracle.apps.qa.plan.update)
| Attribute Category | Attribute Name | Attribute Type | Description | Static Usage | Usage |
|---|---|---|---|---|---|
| Non-Mandatory Header Attribute | QA_ORGANIZATION_CODE | string | Approval based on the Organization Code | No | select organization_code from qa_eres_plans_v where plan_id = :transactionId |
| Non-Mandatory Header Attribute | QA_PLAN_NAME | string | Approval based on the Collection Plan Name | No | select name from qa_eres_plans_v where plan_id = :transactionId |
| Non-Mandatory Header Attribute | QA_PLAN_TYPE | string | Approval based on the Collection Plan Type | No | select plan_type_meaning from qa_eres_plans_v where plan_id = :transactionId |
| 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 | No | select organization_id from qa_plans where plan_id = :transactionId |
QA ERES Specification Creation (oracle.apps.qa.spec.create)
QA ERES Specification Update (oracle.apps.qa.spec.update)
| Attribute Category | Attribute Name | Attribute Type | Description | Static Usage | Usage |
|---|---|---|---|---|---|
| Non-Mandatory Header Attribute | QA_CUSTOMER | string | Approval based on the Customer | No | select customer_name from qa_eres_specs_v where spec_id = :transactionId |
| Non-Mandatory Header Attribute | QA_ITEM | string | Approval based on the Item | No | select item from qa_eres_specs_v where spec_id = :transactionId |
| Non-Mandatory Header Attribute | QA_ITEM_CATEGORY | string | Item Category of the Specification | No | select category_name from qa_eres_specs_v where spec_id = :transactionId |
| Non-Mandatory Header Attribute | QA_ITEM_CATEGORY_SET | string | Approval based on the Item's Category Set | No | select category_set_name from qa_eres_specs_v where spec_id = :transactionId |
| Non-Mandatory Header Attribute | QA_ORGANIZATION_CODE | string | Approval based on the Organization Code | No | select organization_code from qa_eres_specs_v where spec_id = :transactionId |
| Non-Mandatory Header Attribute | QA_SPECIFICATION_TYPE | string | Approval based on the Specification Type | No | select assignment_type_meaning from qa_eres_specs_v where spec_id = :transactionId |
| Non-Mandatory Header Attribute | QA_SUPPLIER | string | Approval based on the Supplier | No | select vendor_name from qa_eres_specs_v where spec_id = :transactionId |
| 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 | No | select organization_id from qa_specs where spec_id = :transactionId |
QA ERES Result Creation (oracle.apps.qa.result.create)
QA ERES Result Update (oracle.apps.qa.result.update)
| Attribute Category | Attribute Name | Attribute Type | Description | Static Usage | Usage |
|---|---|---|---|---|---|
| Non-Mandatory Header Attribute | QA_ASSET_NUMBER | string | Approval based on the Asset Number | No | select qa_eres_pkg.get_result_column_value(:transactionId, 163) from dual |
| Non-Mandatory Header Attribute | QA_COMPONENT_ITEM | string | Approval based on the Component Item | No | select qa_eres_pkg.get_result_column_value(:transactionId, 60) from dual |
| Non-Mandatory Header Attribute | QA_ITEM | string | Approval based on the Item | No | select qa_eres_pkg.get_result_column_value(:transactionId, 10) from dual |
| Non-Mandatory Header Attribute | QA_LOT_NUMBER | string | Approval based on the Lot Number | No | select qa_eres_pkg.get_result_column_value(:transactionId, 16) from dual |
| Non-Mandatory Header Attribute | QA_ORGANIZATION_CODE | string | Approval based on the Organization Code | No | select organization_code from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', -1)+1)), OCCURRENCE) and rownum < 2 |
| Non-Mandatory Header Attribute | QA_PLAN_NAME | string | Approval based on the Collection Plan Name | No | select name from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', -1)+1)), OCCURRENCE) and rownum < 2 |
| Non-Mandatory Header Attribute | QA_PLAN_TYPE | string | Approval based on the Collection Plan Type | No | select plan_type from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', -1)+1)), OCCURRENCE) and rownum < 2 |
| Non-Mandatory Header Attribute | QA_SERIAL_NUMBER | string | Approval based on the Serial Number | No | select qa_eres_pkg.get_result_column_value(:transactionId, 17) from dual |
| Non-Mandatory Header Attribute | QA_SUPPLIER | string | Approval based on the Supplier | No | select qa_eres_pkg.get_result_column_value(:transactionId, 26) from dual |
| 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 | No | select organization_id from qa_results where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', -1)+1)), OCCURRENCE) and rownum < 2 |
| Non-Mandatory Line Attribute | QA_ALL_ITEM_CATEGORIES | string | Approval based on all possible Categories for an Item | No | select concatenated_segments from mtl_categories_kfv where category_id in (select distinct mic.category_id from mtl_item_categories mic, (select organization_id, item_id from qa_results where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', -1)+1)), OCCURRENCE)) qr where qr.organization_id = mic.organization_id and qr.item_id = mic.inventory_item_id ) order by category_id |
| Non-Mandatory Header Attribute | QA_INCIDENT_TYPE | string | Name of the Collection Element | No | select qa_eres_pkg.get_result_column_value(plan_id, collection_id, occurrence, 116) from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_PROBLEM_CODE | String | Element Type of the Collection Element | No | select qa_eres_pkg.get_result_column_value(plan_id, collection_id, occurrence, 118) from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_RESOLUTION_CODE | String | Name of the Collection Element | No | select qa_eres_pkg.get_result_column_value(plan_id, collection_id, occurrence, 117) from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_ITEM_INSTANCE | String | Element Type of the Collection Element | No | select item_instance from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, ‘-’)-1)) and collection_id = substr(:transactionId, (instr(:transactionId, ‘-’, 1, 1)+1), ((instr(:transactionId, ‘-’, 1, 2)-1) - (instr(:transactionId, ‘-’, 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, ‘-’, -1)+1)), OCCURRENCE) |
QA ERES Nonconformance Creation (oracle.apps.qa.ncm.create)
QA ERES Nonconformance Update (oracle.apps.qa.ncm.update)
QA ERES Nonconformance Master Approval (oracle.apps.qa.ncm.master.approve)
| Attribute Category | Attribute Name | Attribute Type | Description | Static Usage | Usage |
|---|---|---|---|---|---|
| Non-Mandatory Header Attribute | QA_ASSET_NUMBER | string | Approval based on the Asset Number | No | select asset_number from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_COMPONENT_ITEM | string | Approval based on the Component Item | No | select comp_item from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_COMPONENT_LOT_NUMBER | string | Approval based on the Component Lot Number | No | select comp_lot_number from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_COMPONENT_SERIAL_NUMBER | string | Approval based on the Component Serial Number | No | select comp_serial_number from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_ITEM | string | Approval based on the Item | No | select item from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_LOT_NUMBER | string | Approval based on the Lot Number | No | select lot_number from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_NONCONFORMANCE_PRIORITY | string | Approval based on the Nonconformance Priority | No | select nonconform_priority from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_NONCONFORMANCE_SEVERITY | string | Approval based on the Nonconformance Severity | No | select nonconform_severity from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_NONCONFORMANCE_SOURCE | string | Approval based on the Nonconformance Source | No | select nonconformance_source from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_NONCONFORMANCE_TYPE | string | Approval based on the Nonconformance Type | No | select nonconformance_type from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_ORGANIZATION_CODE | string | Approval based on the Organization Code | No | select organization_code from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_PLAN_NAME | string | Approval based on the Collection Plan Name | No | select name from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_PLAN_TYPE | string | Approval based on the Collection Plan Type | No | select plan_type from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_SERIAL_NUMBER | string | Approval based on the Serial Number | No | select serial_number from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_SUPPLIER | string | Approval based on the Supplier | No | select vendor_name from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| 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 | No | select organization_id from qa_results where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Line Attribute | QA_ALL_ITEM_CATEGORIES | string | Approval based on all possible Categories for an Item | No | select concatenated_segments from mtl_categories_kfv where category_id in (select distinct mic.category_id from mtl_item_categories mic, (select organization_id, item_id from qa_results where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE)) qr where qr.organization_id = mic.organization_id and qr.item_id = mic.inventory_item_id ) order by category_id |
QA ERES Nonconformance Detail Approval (oracle.apps.qa.ncm.approve.detail)
| Attribute Category | Attribute Name | Attribute Type | Description | Static Usage | Usage |
|---|---|---|---|---|---|
| Non-Mandatory Header Attribute | QA_ACTION_EXECUTED | string | Approval based on the Action Executed | No | select qa_eres_pkg.get_result_column_value(plan_id, collection_id, occurrence, 195) from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_COMPONENT_ITEM | string | Approval based on the Component Item | No | select comp_item from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_COMPONENT_LOT_NUMBER | string | Approval based on the Component Lot Number | No | select comp_lot_number from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_COMPONENT_SERIAL_NUMBER | string | Approval based on the Component Serial Number | No | select comp_serial_number from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_ITEM | string | Approval based on the Item | No | select item from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_LOT_NUMBER | string | Approval based on the Lot Number | No | select lot_number from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_NONCONFORMANCE_SOURCE | string | Approval based on the Nonconformance Source | No | select nonconformance_source from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_ORGANIZATION_CODE | string | Approval based on the Organization Code | No | select organization_code from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_PLAN_NAME | string | Approval based on the Collection Plan Name | No | select name from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_PLAN_TYPE | string | Approval based on the Collection Plan Type | No | select plan_type from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_SERIAL_NUMBER | string | Serial Number of the Collection Result Row | No | select serial_number from qa_results_full_v select serial_number from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| 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 | No | select organization_id from qa_results where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Line Attribute | QA_ALL_ITEM_CATEGORIES | string | Approval based on all possible Categories for an Item | No | select concatenated_segments from mtl_categories_kfv where category_id in (select distinct mic.category_id from mtl_item_categories mic, (select organization_id, item_id from qa_results where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE)) qr where qr.organization_id = mic.organization_id and qr.item_id = mic.inventory_item_id ) order by category_id |
QA ERES Disposition Creation (oracle.apps.qa.disp.create)
QA ERES Disposition Update (oracle.apps.qa.disp.update)
QA ERES Disposition Header Approval (oracle.apps.qa.disp.header.approve)
| Attribute Category | Attribute Name | Attribute Type | Description | Static Usage | Usage |
|---|---|---|---|---|---|
| Non-Mandatory Header Attribute | QA_DISPOSITION | string | Approval based on the Disposition | No | select disposition from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_DISPOSITION_SOURCE | String | Approval based on the Disposition Source | No | select disposition_source from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_ITEM | String | Approval based on the Item | No | select item from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_ORGANIZATION_CODE | String | Approval based on the Organization Code | No | select organization_code from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_PLAN_NAME | String | Approval based on the Collection Plan Name | No | select name from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_PLAN_TYPE | String | Approval based on the Collection Plan Type | No | select plan_type from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| 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 | No | select organization_id from qa_results where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Line Attribute | QA_ALL_ITEM_CATEGORIES | string | Approval based on all possible Categories for an Item | No | select concatenated_segments from mtl_categories_kfv where category_id in (select distinct mic.category_id from mtl_item_categories mic, (select organization_id, item_id from qa_results where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE)) qr where qr.organization_id = mic.organization_id and qr.item_id = mic.inventory_item_id ) order by category_id |
QA ERES Disposition Detail Approval (oracle.apps.qa.disp.detail.approve)
| Attribute Category | Attribute Name | Attribute Type | Description | Static Usage | Usage |
|---|---|---|---|---|---|
| Non-Mandatory Header Attribute | QA_COMPONENT_ITEM | string | Approval based on the Component Item | No | select comp_item from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_COMPONENT_LOT_NUMBER | string | Approval based on the Component Lot Number | No | select comp_lot_number from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_COMPONENT_SERIAL_NUMBER | string | Approval based on the Component Serial Number | No | select comp_serial_number from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_DISPOSITION | string | Approval based on the Disposition | No | select disposition from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_DISPOSITION_ACTION | String | Approval based on the Disposition Action | No | select disposition_action from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_DISPOSITION_SOURCE | string | Approval based on the Disposition Source | No | select disposition_source from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_ITEM | String | Approval based on the Item | No | select item from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_JOB | string | Approval based on the Job | No | select job_name from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_LOT_NUMBER | string | Approval based on the Lot Number | No | select lot_number from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_ORGANIZATION_CODE | string | Approval based on the Organization Code | No | select organization_code from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_PLAN_NAME | string | Approval based on the Collection Plan Name | No | select name from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_PLAN_TYPE | string | Approval based on the Collection Plan Type | No | select plan_type from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_PO_NUMBER | string | Approval based on the PO Number | No | select po_number from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_SERIAL_NUMBER | string | Approval based on the Serial Number | No | select serial_number from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| 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 | No | select organization_id from qa_results where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Line Attribute | QA_ALL_ITEM_CATEGORIES | string | Approval based on all possible Categories for an Item | No | select concatenated_segments from mtl_categories_kfv where category_id in (select distinct mic.category_id from mtl_item_categories mic, (select organization_id, item_id from qa_results where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE)) qr where qr.organization_id = mic.organization_id and qr.item_id = mic.inventory_item_id ) order by category_id |
QA ERES Corrective Action Creation (oracle.apps.qa.car.create)
QA ERES Corrective Action Update (oracle.apps.qa.car.update)
QA ERES Corrective Action Approval (oracle.apps.qa.car.approve)
| Attribute Category | Attribute Name | Attribute Type | Description | Static Usage | Usage |
|---|---|---|---|---|---|
| Non-Mandatory Header Attribute | QA_CUSTOMER | string | Approval based on the Customer | No | select customer_name from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_DEPARTMENT | String | Approval based on the Department | No | select department from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_ITEM | String | Approval based on the Item | No | select item from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_ORGANIZATION_CODE | String | Approval based on the Organization Code | No | select organization_code from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_PLAN_NAME | String | Approval based on the Collection Plan Name | No | select name from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_PLAN_TYPE | String | Approval based on the Collection Plan Type | No | select plan_type from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_PO_NUMBER | String | Approval based on the PO Number | No | select po_number from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_REQUEST_PRIORITY | String | Approval based on the Request Priority | No | select request_priority from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_REQUEST_SEVERITY | String | Approval based on the Request Severity | No | select request_severity from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_REQUEST_SOURCE | String | Approval based on the Request Source | No | select request_source from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_SUPPLIER | String | Approval based on the Supplier | No | select vendor_name from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| 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 | no | select organization_id from qa_results where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_ALL_ITEM_CATEGORIES | String | Approval based on all possible Categories for an Item | No | select concatenated_segments from mtl_categories_kfv where category_id in (select distinct mic.category_id from mtl_item_categories mic, (select organization_id, item_id from qa_results where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE)) qr where qr.organization_id = mic.organization_id and qr.item_id = mic.inventory_item_id ) order by category_id |
QA ERES Corrective Action Review Approval (oracle.apps.qa.car.approve.review)
QA ERES Corrective Action Implementation Approval (oracle.apps.qa.car.approve.impl)
| Attribute Category | Attribute Name | Attribute Type | Description | Static Usage | Usage |
|---|---|---|---|---|---|
| Non-Mandatory Header Attribute | QA_ITEM | String | Approval based on the Item | No | select item from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_ORGANIZATION_CODE | String | Approval based on the Organization Code | No | select organization_code from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_PLAN_NAME | String | Approval based on the Collection Plan Name | No | select name from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_PLAN_TYPE | String | Approval based on the Collection Plan Type | No | select plan_type from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_REQUEST_PRIORITY | String | Approval based on the Request Priority | No | select request_priority from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_REQUEST_SEVERITY | String | Approval based on the Request Severity | No | select request_severity from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| Non-Mandatory Header Attribute | QA_REQUEST_SOURCE | String | Approval based on the Request Source | No | select request_source from qa_results_full_v where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE) |
| 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 Line Item Attribute | QA_ALL_ITEM_CATEGORIES | String | Approval based on all possible Categories for an Item | No | select concatenated_segments from mtl_categories_kfv where category_id in (select distinct mic.category_id from mtl_item_categories mic, (select organization_id, item_id from qa_results where plan_id = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and collection_id = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1), ((instr(:transactionId, '-', 1, 2)-1) - (instr(:transactionId, '-', 1, 1)))) and occurrence = NVL(substr(:transactionId, (instr(:transactionId, '-', 1, 2)+1), (DECODE((instr(:transactionId, '-', 1, 3)-1), -1, length(:transactionId), (instr(:transactionId, '-', 1, 3)-1)) - (instr(:transactionId, '-', 1, 2)))), OCCURRENCE)) qr where qr.organization_id = mic.organization_id and qr.item_id = mic.inventory_item_id ) order by category_id |
QA ERES Specification Org Assignment (oracle.apps.qa.spec.org.assign)
| Attribute Category | Attribute Name | Attribute Type | Description | Static Usage | Usage |
|---|---|---|---|---|---|
| Non-Mandatory Header Attribute | QA_CUSTOMER | String | Approval based on the Customer | No | select customer_name from qa_eres_specs_v where spec_id = :transactionId |
| Non-Mandatory Header Attribute | QA_ITEM | String | Approval based on the Item | No | select item from qa_eres_specs_v where spec_id = :transactionId |
| Non-Mandatory Header Attribute | QA_ITEM_CATEGORY | String | Approval based on the Item's Category | No | select category_name from qa_eres_specs_v where spec_id = :transactionId |
| Non-Mandatory Header Attribute | QA_ITEM_CATEGORY_SET | String | Approval based on the Item's Category Set | No | select category_set_name from qa_eres_specs_v where spec_id = :transactionId |
| Non-Mandatory Header Attribute | QA_MASTER_SPEC_ORG_CODE | String | Approval based on the Master Specification's Organization Code | No | select organization_code from qa_eres_specs_v where spec_id = :transactionId |
| Non-Mandatory Header Attribute | QA_SPECIFICATION_TYPE | String | Approval based on the Specification Type | No | select assignment_type_meaning from qa_eres_specs_v where spec_id = :transactionId |
| Non-Mandatory Header Attribute | QA_SUPPLIER | String | Approval based on the Supplier | No | select vendor_name from qa_eres_specs_v where spec_id = :transactionId |
| 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 | No | select organization_id from qa_specs where spec_id = :transactionId |
| Non-Mandatory Line Item Attribute | QA_ALL_ASSIGNED_SPEC_ORG_CODES | String | Approval based on the Organization Codes to which the Master Specification has been Assigned | No | select organization_code from qa_eres_specs_v where spec_id in (select child_spec_id from qa_spec_org_assignments_v where spec_id = :transactionId and assign_flag = 1 ) order by spec_id |
No rules or approvers are seeded. As part of the implementation, you must complete these activities (see: Setting Up Oracle Approvals Management, Oracle E-Records Implementation Guide).
| XML Element Tag | Display Name |
|---|---|
| REVISION | Revision |
| COMP_ITEM | Component Item |
| PROJECT_NUMBER | Project |
| TASK_NUMBER | Task |
| JOB_NAME | Job |
| VENDOR_NAME | Supplier |
| CUSTOMER_NAME | Customer |
| Name | Display Name | Description | Status | Owner Name | Owner Tag |
|---|---|---|---|---|---|
| oracle.apps.po.rcv.inspect | PO ERES Receiving Inspection | ERES Event for an Inspection in the Receiving component of Oracle Purchasing | Enabled | Oracle Purchasing | PO |
| oracle.apps.po.rcv.transfer | PO ERES Receiving Transfer | ERES Event for a Transfer in the Receiving component of Oracle Purchasing | Enabled | Oracle Purchasing | PO |
| oracle.apps.po.rcv.deliver | PO ERES Receiving Delivery | ERES Event for a Delivery in the Receiving component of Oracle Purchasing | Enabled | Oracle Purchasing | PO |
| oracle.apps.po.asl.create | PO ERES ASL Creation | ERES Event for the Creation of an ASL in Oracle Purchasing | Enabled | Oracle Purchasing | PO |
| oracle.apps.po.asl.update | PO ERES ASL Update | ERES Event for the Update of an ASL in Oracle Purchasing | Enabled | Oracle Purchasing | PO |
Note: You can only define a single event key for use with Oracle E-Records, but many of the Oracle Purchasing events require composite keys. The system creates composite keys for Oracle E-Records calls by combining multiple fields to form a unique key. This unique key identifies a single entity by concatenating the fields together with a hyphen delimiter (for example: key1-key2). The fields used to create the composite key are presented below in a comma separated list in the User Event Key column.
| Event Name | User Event Key (Identifier) |
|---|---|
| oracle.apps.po.rcv.inspect | rcv_transactions_interface.parent_transaction_id, rcv_transactions_interface.qa_collection_id |
| oracle.apps.po.rcv.transfer | rcv_transactions_interface.parent_transaction_id, rcv_transactions_interface.qa_collection_id |
| oracle.apps.po.rcv.deliver | rcv_transactions_interface.parent_transaction_id, rcv_transactions_interface.qa_collection_id |
| oracle.apps.po.asl.create | po_approved_supplier_list_v.asl_id |
| oracle.apps.po.asl.update | po_approved_supplier_list_v.asl_id |
Note: Enter User Event Keys with the given nomenclature but note that event keys may be case sensitive, separated by underscores and hyphens, and the event key values set off in carets.
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.po.rcv.inspect | EDR_XML_MAP_CODE=po_eres_rcv_transactions EDR_AME_TRANSACTION_TYPE=oracle.apps.po.rcv.inspect |
| oracle.apps.po.rcv.transfer | EDR_XML_MAP_CODE=po_eres_rcv_transactions EDR_AME_TRANSACTION_TYPE=oracle.apps.po.rcv.transfer |
| oracle.apps.po.rcv.deliver | EDR_XML_MAP_CODE=po_eres_rcv_transactions EDR_AME_TRANSACTION_TYPE=oracle.apps.po.rcv.deliver |
| oracle.apps.po.asl.create | EDR_XML_MAP_CODE=po_eres_asl EDR_AME_TRANSACTION_TYPE=oracle.apps.po.asl.create |
| oracle.apps.po.asl.update | EDR_XML_MAP_CODE=po_eres_asl EDR_AME_TRANSACTION_TYPE=oracle.apps.po.asl.update |
All transaction types listed below belong to the Oracle Purchasing application.
| Transaction Type ID | Transaction Type Description | Line Item Id Query String |
|---|---|---|
| oracle.apps.po.rcv.inspect | PO ERES Receiving Inspection | select mic.category_id from mtl_item_categories mic, (select organization_id, item_id from qa_eres_rcv_trans_interface_v where PARENT_TRANSACTION_ID = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and QA_COLLECTION_ID = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1)) and rownum = 1) qrti where qrti.organization_id = mic.organization_id(+) and qrti.item_id = mic.inventory_item_id(+) order by category_id asc |
| oracle.apps.po.rcv.transfer | PO ERES Receiving Transfer | select mic.category_id from mtl_item_categories mic, (select organization_id, item_id from qa_eres_rcv_trans_interface_v where PARENT_TRANSACTION_ID = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and QA_COLLECTION_ID = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1)) and rownum = 1) qrti where qrti.organization_id = mic.organization_id(+) and qrti.item_id = mic.inventory_item_id(+) order by category_id asc |
| oracle.apps.po.rcv.deliver | PO ERES Receiving Delivery | select mic.category_id from mtl_item_categories mic, (select organization_id, item_id from qa_eres_rcv_trans_interface_v where PARENT_TRANSACTION_ID = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and QA_COLLECTION_ID = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1)) and rownum = 1) qrti where qrti.organization_id = mic.organization_id(+) and qrti.item_id = mic.inventory_item_id(+) order by category_id asc |
| oracle.apps.po.asl.create | PO ERES ASL Creation | select mic.category_id from mtl_item_categories mic, (select owning_organization_id, item_id from po_approved_supplier_list_v where asl_id = :transactionId) paslv where paslv.owning_organization_id = mic.organization_id(+) and paslv.item_id = mic.inventory_item_id(+) order by category_id asc |
| oracle.apps.po.asl.update | PO ERES ASL Update | select mic.category_id from mtl_item_categories mic, (select owning_organization_id, item_id from po_approved_supplier_list_v where asl_id = :transactionId) paslv where paslv.owning_organization_id = mic.organization_id(+) and paslv.item_id = mic.inventory_item_id(+) order by category_id asc |
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 Purchasing 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 | TOP_SUPERVISOR_PERSON_ID | number | person ID of the top person in the HR supervisory hierarchy | Yes | N/A |
| 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_SET_OF_BOOKS_ID | number | set-of-books ID in which transaction occurred | Yes | N/A |
PO ERES Receiving Inspection (oracle.apps.po.rcv.inspect)
PO ERES Receiving Transfer (oracle.apps.po.rcv.transfer)
PO ERES Receiving Delivery (oracle.apps.po.rcv.deliver)
| Attribute Category | Attribute Name | Attribute Type | Description | Static Usage | Usage |
|---|---|---|---|---|---|
| Non-Mandatory Header Attribute | PO_ERES_CATALOG_GROUP | string | Approval based on the Catalog Group | No | select micgk.concatenated_segments from MTL_ITEM_CATALOG_GROUPS_KFV micgk, MTL_SYSTEM_ITEMS msi, qa_eres_rcv_trans_interface_v qertiv where qertiv.PARENT_TRANSACTION_ID = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and qertiv.QA_COLLECTION_ID = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1)) and rownum = 1 and qertiv.item_id = msi.inventory_item_id(+) and qertiv.organization_id = msi.organization_id(+) and msi.item_catalog_group_id = micgk.item_catalog_group_id(+) |
| Non-Mandatory Header Attribute | PO_ERES_CUSTOMER | string | Approval based on the Customer | No | select customer from qa_eres_rcv_trans_interface_v where PARENT_TRANSACTION_ID = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and QA_COLLECTION_ID = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1)) and rownum = 1 |
| Non-Mandatory Header Attribute | PO_ERES_CUSTOMER_ITEM | string | Approval based on the Customer Item | No | select customer_item from qa_eres_rcv_trans_interface_v where PARENT_TRANSACTION_ID = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and QA_COLLECTION_ID = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1)) and rownum = 1 |
| Non-Mandatory Header Attribute | PO_ERES_HAZARD_CLASS | string | Approval based on the Hazard Class | No | select hazard_class from qa_eres_rcv_trans_interface_v where PARENT_TRANSACTION_ID = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and QA_COLLECTION_ID = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1)) and rownum = 1 |
| Non-Mandatory Header Attribute | PO_ERES_ITEM | string | Approval based on the Item | No | select item from qa_eres_rcv_trans_interface_v where PARENT_TRANSACTION_ID = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and QA_COLLECTION_ID = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1)) and rownum = 1 |
| Non-Mandatory Header Attribute | PO_ERES_ITEM_REVISION | string | Approval based on the Item Revision | No | select item_revision from qa_eres_rcv_trans_interface_v where PARENT_TRANSACTION_ID = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and QA_COLLECTION_ID = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1)) and rownum = 1 |
| Non-Mandatory Header Attribute | PO_ERES_LOCATOR | string | Approval based on the Locator | No | select locator from qa_eres_rcv_trans_interface_v where PARENT_TRANSACTION_ID = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and QA_COLLECTION_ID = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1)) and rownum = 1 |
| Non-Mandatory Header Attribute | PO_ERES_PROJECT | string | Approval based on the Project | No | select project_number from qa_eres_rcv_trans_interface_v where PARENT_TRANSACTION_ID = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and QA_COLLECTION_ID = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1)) and rownum = 1 |
| Non-Mandatory Header Attribute | PO_ERES_RECEIPT_ROUTING | string | Approval based on the Receipt Routing | No | select receipt_routing from qa_eres_rcv_trans_interface_v where PARENT_TRANSACTION_ID = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and QA_COLLECTION_ID = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1)) and rownum = 1 |
| Non-Mandatory Header Attribute | PO_ERES_SUBINVENTORY | string | Approval based on the Subinventory | No | select subinventory from qa_eres_rcv_trans_interface_v where PARENT_TRANSACTION_ID = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and QA_COLLECTION_ID = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1)) and rownum = 1 |
| Non-Mandatory Header Attribute | PO_ERES_SUPPLIER | string | Approval based on the Supplier | No | select supplier from qa_eres_rcv_trans_interface_v where PARENT_TRANSACTION_ID = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and QA_COLLECTION_ID = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1)) and rownum = 1 |
| Non-mandatory Header Attribute | PO_ERES_SUPPLIER_ITEM | string | Approval based on the Supplier Item | No | select supplier_item from qa_eres_rcv_trans_interface_v where PARENT_TRANSACTION_ID = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and QA_COLLECTION_ID = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1)) and rownum = 1 |
| Non-mandatory Header Attribute | PO_ERES_TASK | string | Approval based on the Task | No | select task_number from qa_eres_rcv_trans_interface_v where PARENT_TRANSACTION_ID = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and QA_COLLECTION_ID = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1)) and rownum = 1 |
| Non-mandatory Header Attribute | PO_ERES_TRANSACTION_TYPE | string | Approval based on the Transaction Type | No | select order_type from qa_eres_rcv_trans_interface_v where PARENT_TRANSACTION_ID = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and QA_COLLECTION_ID = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1)) and rownum = 1 |
| Non-mandatory Header Attribute | PO_ERES_UN_NUMBER | string | Approval based on the UN Number | No | select un_number from qa_eres_rcv_trans_interface_v where PARENT_TRANSACTION_ID = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and QA_COLLECTION_ID = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1)) and rownum = 1 |
| Non-mandatory Header Attribute | TRANSACTION_DATE | date | date transaction occurred | No | select ame_util.versionDateToString(CREATION_DATE) from QA_ERES_RCV_TRANS_INTERFACE_V where PARENT_TRANSACTION_ID = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and QA_COLLECTION_ID = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1)) and rownum = 1 |
| Non-mandatory Header Attribute | TRANSACTION_ORG_ID | number | org ID in which transaction occurred | No | select organization_id from QA_ERES_RCV_TRANS_INTERFACE_V where PARENT_TRANSACTION_ID = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and QA_COLLECTION_ID = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1)) and rownum = 1 |
| Non-mandatory Header Attribute | TRANSACTION_REQUESTOR_USER_ID | number | user ID of user initiating transaction, if any | No | select Last_updated_by from QA_ERES_RCV_TRANS_INTERFACE_V where PARENT_TRANSACTION_ID = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and QA_COLLECTION_ID = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1)) and rownum = 1 |
| Non-mandatory Line Item Attribute | PO_ERES_ALL_ITEM_CATEGORIES | string | Approval based on all possible Categories for an Item | No | select concatenated_segments from mtl_categories_kfv where category_id in (select mic.category_id from mtl_item_categories mic, (select organization_id, item_id from qa_eres_rcv_trans_interface_v where PARENT_TRANSACTION_ID = substr(:transactionId, 1, (instr(:transactionId, '-')-1)) and QA_COLLECTION_ID = substr(:transactionId, (instr(:transactionId, '-', 1, 1)+1)) and rownum = 1) qrti where qrti.organization_id = mic.organization_id(+) and qrti.item_id = mic.inventory_item_id(+) ) order by category_id |
PO ERES ASL Creation (oracle.apps.po.asl.create)
PO ERES ASL Update (oracle.apps.po.asl.update)
| Attribute Category | Attribute Name | Attribute Type | Description | Static Usage | Usage |
|---|---|---|---|---|---|
| Non-Mandatory Header Attribute | PO_ERES_ITEM | string | Approval based on the Item | No | select item_num from PO_APPROVED_SUPPLIER_LIST_V where asl_id = :transactionId |
| Non-Mandatory Header Attribute | PO_ERES_MANUFACTURER | string | Approval based on the Manufacturer | No | select asl_manufacturer from PO_APPROVED_SUPPLIER_LIST_V where asl_id = :transactionId |
| Non-Mandatory Header Attribute | PO_ERES_SUPPLIER | string | Approval based on the Supplier | No | select vendor_name from PO_APPROVED_SUPPLIER_LIST_V where asl_id = :transactionId |
| Non-mandatory Header Attribute | PO_ERES_SUPPLIER_ITEM | string | Approval based on the Supplier Item | No | select primary_vendor_item from PO_APPROVED_SUPPLIER_LIST_V where asl_id = :transactionId |
| Non-mandatory Header Attribute | TRANSACTION_DATE | date | date transaction occurred | No | select ame_util.versionDateToString(CREATION_DATE) from PO_APPROVED_SUPPLIER_LIST_V where asl_id = :transactionId |
| Non-mandatory Header Attribute | TRANSACTION_ORG_ID | number | org ID in which transaction occurred | No | select owning_organization_id from PO_APPROVED_SUPPLIER_LIST_V where asl_id = :transactionId |
| Non-mandatory Header Attribute | TRANSACTION_REQUESTOR_USER_ID | number | user ID of user initiating transaction, if any | No | select Last_updated_by from PO_APPROVED_SUPPLIER_LIST_V where asl_id = :transactionId |
| Non-mandatory Line Item Attribute | PO_ERES_ALL_ITEM_CATEGORIES | string | Approval based on all possible Categories for an Item | No | select concatenated_segments from mtl_categories_kfv where category_id in (select mic.category_id from mtl_item_categories mic, (select owning_organization_id, item_id from po_approved_supplier_list_v where asl_id = :transactionId) paslv where paslv.owning_organization_id = mic.organization_id(+) and paslv.item_id = mic.inventory_item_id(+) ) order by category_id |
No rules or approvers are seeded. As part of the implementation, you must complete these activities (see: Setting Up Oracle Approvals Management, Oracle E-Records Implementation Guide).
Use generic query attributes to search for e-records and their associated documents in the Evidence Store. For instructions on how to search, see Evidence Store, Oracle E-Records Implementation Guide. The Query Element Type equals Generic for all attributes listed below.
| Application Code | XML Element Tag | Display Name |
|---|---|---|
| QA | VENDOR_NAME | Supplier |
| Application Code | XML Element Tag | Display Name |
|---|---|---|
| PO | RECEIPT_ROUTING | Receipt Routing |
| PO | TRANSACTION_DATE | Transaction Date |
| PO | SUPPLIER | Supplier |
| PO | SUPPLIER_ITEM | Supplier Item |
| PO | CUSTOMER | Customer |
| PO | CUSTOMER_ITEM | Customer Item |
| PO | HAZARD_CLASS | Hazard Class |
| QA | VENDOR_NAME | Supplier |
| QA | JOB_NAME | Job |
| QA | CUSTOMER_NAME | Customer |
| QA | COMP_ITEM | Component Item |
| Name | Display Name | Description | Status | Owner Name | Owner Tag |
|---|---|---|---|---|---|
| oracle.apps.wsh.eres.delivery.shipment | WSH ERES Delivery Shipment | ERES Event for Deliveries in a Closed or In-Transit Status in Oracle Shipping | Enabled | Oracle Quality | QA |
| Event Name | User Event Key (Identifier) |
|---|---|
| oracle.apps.wsh.eres.delivery.shipment | wsh_new_deliveries_v.delivery_id |
Note: Enter User Event Keys with the given nomenclature but note that event keys may be case sensitive, separated by underscores and hyphens, and the event key values set off in carets.
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.wsh.eres.delivery.shipment | EDR_XML_MAP_CODE=qa_wsh_eres_delivery_shipment EDR_AME_TRANSACTION_TYPE=oracle.apps.wsh.eres.delivery.shipment |
All transaction types listed below belong to the Oracle Shipping application.
| Transaction Type ID | Transaction Type Description | Line Item Id Query String |
|---|---|---|
| oracle.apps.wsh.eres.delivery.shipment | WSH ERES Delivery Shipment | select delivery_detail_id from qa_eres_wsh_deliverables_v where delivery_id = :transactionId order by delivery_detail_id asc |
Although the user can define their own attributes for the transaction type listed above, the more commonly used attributes are seeded.
| 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 | TOP_SUPERVISOR_PERSON_ID | number | person ID of the top person in the HR supervisory hierarchy | Yes | N/A |
| Non-mandatory Header Attribute | TRANSACTION_DATE | date | date transaction occurred | No | select ame_util.versionDateToString(CREATION_DATE) from qa_eres_wsh_new_deliveries_v where delivery_id = :transactionId |
| Non-mandatory Header Attribute | TRANSACTION_GROUP_ID | number | business-group ID in which transaction occurred | Yes | N/A |
| Non-mandatory Header Attribute | TRANSACTION_ORG_ID | number | org ID in which transaction occurred | No | select organization_id from qa_eres_wsh_new_deliveries_v where delivery_id = :transactionId |
| 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 Last_updated_by from qa_eres_wsh_new_deliveries_v where delivery_id = :transactionId |
| Non-mandatory Header Attribute | TRANSACTION_SET_OF_BOOKS_ID | number | set-of-books ID in which transaction occurred | Yes | N/A |
| Non-mandatory Header Attribute | WSH_DELIVERY_NAME | string | Approval based on the Delivery Name | No | select delivery_name from qa_eres_wsh_new_deliveries_v where delivery_id = :transactionId |
| Non-mandatory Header Attribute | WSH_SHIP_TO_LOCATION | string | Approval based on the Ship To Location | No | select ultimate_ship_to from qa_eres_wsh_new_deliveries_v where delivery_id = :transactionId |
| Non-mandatory Line Item Attribute | WSH_CATALOG_GROUPS | string | Approval based on all possible Catalog Groups for all Items in the Delivery | No | select micgk.concatenated_segments from MTL_ITEM_CATALOG_GROUPS_KFV micgk, MTL_SYSTEM_ITEMS msi, (select organization_id, item_id from qa_eres_wsh_deliverables_v where delivery_detail_id in (select delivery_detail_id from qa_eres_wsh_deliverables_v where delivery_id = :transactionId ) order by delivery_detail_id ASC) dl where dl.organization_id = msi.organization_id(+) and dl.item_id = msi.inventory_item_id(+) and msi.item_catalog_group_id = micgk.item_catalog_group_id(+) |
| Non-mandatory Line Item Attribute | WSH_ITEMS | string | Approval based on all Items in the Delivery | No | select item from qa_eres_wsh_deliverables_v where delivery_detail_id in (select delivery_detail_id from qa_eres_wsh_deliverables_v where delivery_id = :transactionId ) order by delivery_detail_id ASC |
| Non-mandatory Line Item Attribute | WSH_ITEM_REVISIONS | string | Approval based on the Revisions of all Items in the Delivery | No | select item_revision from qa_eres_wsh_deliverables_v where delivery_detail_id in (select delivery_detail_id from qa_eres_wsh_deliverables_v where delivery_id = :transactionId ) order by delivery_detail_id ASC |
| Non-mandatory Line Item Attribute | WSH_LOCATORS | string | Approval based on all Locators in the Delivery | No | select locator from qa_eres_wsh_deliverables_v where delivery_detail_id in (select delivery_detail_id from qa_eres_wsh_deliverables_v where delivery_id = :transactionId ) order by delivery_detail_id ASC |
| Non-mandatory Line Item Attribute | WSH_SUBINVENTORIES | string | Approval based on all Subinventories in the Delivery | No | select subinventory from qa_eres_wsh_deliverables_v where delivery_detail_id in (select delivery_detail_id from qa_eres_wsh_deliverables_v where delivery_id = :transactionId ) order by delivery_detail_id ASC |
No rules or approvers are seeded. As part of the implementation, you must complete these activities (see: Setting Up Oracle Approvals Management, Oracle E-Records Implementation Guide).
There are no generic query attributes to use while searching for Oracle Shipping e-records.