This appendix covers the following topics:
Table OAM Seeded Attributes for Oracle Quoting displays seeded, 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/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/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 |
OAM requires calling applications to populate specific mandatory attributes. All of these attributes are at the header level. Table OAM Mandatory Seeded Attributes lists seeded values and attribute types for these mandatory attributes.
| Attribute |
Attribute Type |
Value |
|---|---|---|
| ALLOW_DELETING_RULE_GENERATED_APPROVERS | Boolean | False |
| ALLOW_REQUESTOR_APPROVAL | Boolean | True |
| AT_LEAST_ONE_RULE_MUST_APPLY | Boolean | False |
| EFFECTIVE_RULE_DATE | Date | The date the quote is submitted for approval. |
| TRANSACTION_DATE | Date | The date the quote is submitted for approval. |
| TRANSACTION_GROUP_ID | Number | Null |
| TRANSACTION_ORG_ID | Number | Org ID of the quote |
| TRANSACTION_SET_OF_BOOKS_ID | Number | Null |
| TRANSACTION_ID | Number | Quote header ID |
| TRANSACTION_REQUESTOR_PERSON_ID | Number | Person_id/fnd_user id of the requestor |
The following seeded OAM attributes are not mandatory, but may be required under certain circumstances. Table Non-mandatory Seeded OAM Attributes displays the seeded values for Oracle Quoting.
| Attribute |
Attribute Type |
Value |
|---|---|---|
| INCLUDE_ALL_JOB_LEVEL_APPROVERS | Boolean | False |
| JOB_LEVEL_NON_DEFAULT_STARTING_POINT_PERSON_ID | Number | Null |