This appendix covers the following topics:
Table AME Predefined Attributes for Oracle Quoting displays predefined, commonly used attributes, display level (header or line), attribute description, and attribute type.
Note: Oracle Quoting does not support currency conversion in its integration with Oracle Approval Management. Hence, the conditions defined in Oracle Approvals Management must have the same currency as the one in which the quotes are being created. This will avoid the currency conversion errors when the quote is submitted for approval.
| Attribute | Level | Description | Attribute Type |
|---|---|---|---|
| Quote Total | Header | Total quote amount. Includes shipping and freight charges and taxes. | Currency |
| Quote Line Total | Line | Total quote line amount prior to shipping and freight charges and taxes. | Currency |
| Unit List Price | Line | Unit list price | Currency |
| Unit Net Price | Line | Unit net price | Currency |
| Manual Adjustment Amount | Line | Sum of the header and line manual adjustment or amounts | Currency |
| Manual Adjustment Percent | Line | Sum of the header and line manual adjustment percentages | Number |
| Quantity | Line | Quantity | Number |
| Unit of Measure | Line | Unit of measure | String (List of Values, when available) |
| Pricing Agreement | Header | Pricing agreement | String (List of Values, when available) |
| Line | Line | Price list | String (List of Values, when available) |
| Item Category (Derived from ASO: Default Category Set or if the profile is null, from the Order Management functional area defined in Inventory) | Line | Item category | String (List of Values, when available) |
| Item Number | Line | Item number | String (List of Values, when available) |
| Customer Name | Header | Name of the sold to customer | String (List of Values, when available) |
| Account Number | Header | Account number of the sold to customer | String (List of Values, when available) |
| Credit Update Date | Header | Date and time of most recent automatic sales credit update | Date |
| Non-Standard Terms | Header | Clauses that have been newly authored or standard clauses modified from the contract library | String (List of Values, when available) |
| Clauses Changes from the Contract Template | Header | Clauses manually added or removed from a Quote or new clauses added to a template after instantiation | String (List of Values, when available) |
| Contract Terms Source | Header | Determines if the Terms and Conditions on the quote are derived from an attached document | String |
| Contract Authoring Party | Header | Determines whether the Terms and Conditions have been authored internally or by the Customer | String |
AME requires calling applications to display specific mandatory attributes. All of these attributes are at the header level. Table AME Mandatory Predefined Attributes lists predefined values and attribute types for these mandatory attributes.
| Attribute | Attribute Type | Description | Value |
|---|---|---|---|
| ALLOW_DELETING_RULE_GENERATED_APPROVERS | Boolean | Determines whether AME enables the integrating application to suppress from a transaction's approver list the approvers required by the transaction type's rules. | False |
| ALLOW_REQUESTOR_APPROVAL | Boolean | Determines whether AME enables a requestor to approve their own transaction, if they have sufficient signing authority. | True |
| AT_LEAST_ONE_RULE_MUST_APPLY | Boolean | Determines whether AME raises an exception when no rules apply to a transaction at run time. | False |
| EFFECTIVE_RULE_DATE | Date | Determines which rules are active for a given transaction. | select ame_util.versionDateToString(sysdate) from dual |
| TRANSACTION_DATE | Date | Indicates the date the quote is submitted for approval. | select ame_util.versionDateToString(sysdate) from dual |
| TRANSACTION_GROUP_ID | Number | Determines the business group ID in which transaction occurred. | Null |
| TRANSACTION_ORG_ID | Number | Indicates the organization ID of the quote. | select org_id from aso_quote_headers_all where quote_header_id = :transactionId |
| TRANSACTION_SET_OF_BOOKS_ID | Number | Indicates the set of books ID in which transaction occurred. | Null |
| TRANSACTION_ID | Number | Indicates the quote header ID. | Not set |
| EVALUATE_PRIORITIES_PER_ITEM | Boolean | Determines whether AME evaluates the applicable rules' use priorities per item. | False |
| REJECTION_RESPONSE | String | Determines how AME responds when an approver rejects an item. | Stop all processing |
| REPEAT_SUBSTITUTIONS | Boolean | Determines if AME must apply substitution rules on ad hoc insertions and surrogate approvers | False |
| USE_RESTRICTIVE_ITEM_EVALUATION | Boolean | Determines whether AME requires a single subordinate- level item to satisfy all conditions on attributes belonging to the subordinate item class, in a given rule, for the rule to apply. | True |
| USE_WORKFLOW | Boolean | Indicates whether AME should log the transaction type's exceptions to the Workflow exception stack. | True |
| WORKFLOW_ITEM_TYPE | String | Indicates the item type of the integrating application's workflow. | select fnd_profile.value('ASO_APPR_WF_ITEM_TYPE') from dual |
| WORKFLOW_ITEM_KEY | String | Indicates a transaction's item key in the integrating application's workflow. | select object_approval_id||'HED' from aso_apr_obj_approvals where object_id=:transactionId\n\ and approval_status='PEND' |
The following predefined AME attributes are not mandatory, but may be required under certain circumstances. Table Nonmandatory Predefined AME Attributes displays the predefined values for Oracle Quoting.
| Attribute | Attribute Type | Description | Value |
|---|---|---|---|
| INCLUDE_ALL_JOB_LEVEL_APPROVERS | Boolean | Determines if all approvers with the same job level should be included when building the chain of authority for the action types that depend on Job Level. | False |
| JOB_LEVEL_NON_DEFAULT_STARTING_POINT_PERSON_ID | Number | If this attribute is not null, the approver it identifies will be used as the starting point for action types that depend on Job Level. | Null |
| ALLOW_EMPTY_APPROVAL_GROUPS | Boolean | Determines whether to allow approval groups to have no members. | True |
| TOP_SUPERVISOR_PERSON_ID | Number | Indicates the person ID of the employee at the top in the HR supervisory hierarchy. | Not set |
| TRANSACTION_REQUESTOR_PERSON_ID | Number | Indicates the person or FND user ID of the requestor. | select employee_id from fnd_user where sysdate between start_date and nvl(end_date,sysdate) and user_id = nvl ((select requester_userid from aso_apr_obj_approvals where object_id = :transactionId and approval_status = 'PEND'), FND_GLOBAL.USER_ID ) |