This appendix covers the following topics:
Lookups provide the list of values (LOVs) that appear in Oracle Marketing user interface drop-down lists. Lookup values make choosing information quick and easy, they ensure that users enter only valid data into Oracle Marketing.
Most Lookups are predefined (seeded in the application), the seeded value can be left as is, or they can be customized to fit your business needs. Lookups are stored in the FND_LOOKUPS table which is part of the Application Object Library (AOL).
You can add new Lookups Values at any time. You can set the Enable Flag for a Value to No, so that it will no longer appear in the list of values, or you can use the Start and End Dates to control when a value will appear in a list.
When implementing Oracle Marketing you will be setting three types of Lookups:
System: System Lookups may not be modified or deleted, and may not have additional values added.
Extensible: Extensible Lookups may have additional values added to the list. Seeded extensible Lookups may not be deleted.
User: User Lookups are completely modifiable. They may be modified and/or added to. Seeded user Lookups, if any, may be modified or deleted.
Note: All levels of Lookups may have their visible values modified.
To create a new lookup type, add values to an existing lookup type, or prevent existing values from appearing in a lookup type, use the Application Utilities Lookups window.You must log out and log in again to see the effect of your changes.
To define a new Lookup type and Lookup value, log in to Oracle Forms with System Administrator Responsibility.
Navigation: Application > Lookups
Global Security Group: If you want to add lookup values specific to the security group/business group linked to your current responsibility, de-select the Global Security Group check box. Existing lookup values are available to all business groups.
Start Date: If you do not enter a start date, the new lookup is valid immediately. If you do not enter an end date, the new lookup is valid indefinitely.
To add a new value to an existing Lookup, query and find the existing lookup. Note that you may add values to Extensible and User lookups.
The following table lists the Lookup settings used by Oracle Marketing.
| Key | Type | Values | Meanings |
|---|---|---|---|
| AGGREGATE_BY | System | YEAR MONTH QTR INCREMENT |
Year Month Quarter Increment |
| AMS_ ACCESS_ TYPE | System | GROUP USER |
Group User |
| AMS_ ACCRUAL_ BASIS | System | CUSTOMER SALES |
Customer Sales |
| AMS_ ADJUSTMENT_TYPE | Extensible | DECREASE_ COMMITTED DECREASE_ COMM_ EARNED DECREASE_ EARNED STANDARD |
Decrease Committed Amount Decrease Committed and Earned Amounts Decrease Earned Amount Increase Earned Amount |
| AMS_ BUDGET_ SOURCE_ STATUS | System | APPROVED CLOSED NEW PENDING REJECTED |
Approved Closed Planning Pending Rejected |
| AMS_ BUDGET_ TRANS_TYPE | User | CREDIT DEBIT |
Credit Debit |
| AMS_CAMP_FULFILL_ON | System | ON_INVITE | On Invite |
| AMS_CAMP_ RELATED_ EVENT | System | EONE EVEH EVEO |
One-Off Event Event Event Schedule |
| AMS_ CAMPAIGN_PURPOSE | Extensible | AWARENESS LEAD LEAD_ MATURATION SALES_ READINESS |
Awareness Lead Generation (?) Lead Maturation Sales Readiness |
| AMS_ CAMPAIGN_ SCHEDULE_STATUS | System | ACTIVE ARCHIVED AVAILABLE CANCELLED CLOSED COMPLETED DENIED_BA NEW ON_HOLD SUBMITTED_ BA |
Active Archived Available Cancelled Closed Completed Denied Budget Approval New Active, but locked Pending Budget Approval |
| AMS_ CAMPAIGN_ STATUS | System | ACTIVE ARCHIVED AVAILABLE CANCELLED CLOSED COMPLETED DENIED_BA DENIED_TA NEW ON_HOLD PLANNING SUBMITTED_BUDGET APPROVAL SUBMITTED_THEME APPROVAL |
Active Archived Available Cancelled Closed Completed Denied Budget Approval Denied Theme Approval New Active, but locked Planned Submitted for Budget Approval Submitted for Theme Approval |
| AMS_CLAIM_ CLASS | System | CLAIM DEDUCTION |
Claim Deduction |
| AMS_CLAIM_ HISTORY_ EVENT | System | CHANGES LINE NEW SPLIT |
Changes Line New Split |
| AMS_CLAIM_ PAYMENT_ METHOD | System | CHECK CREDIT_MEMO DEBIT_MEMO |
Check Credit Memo Debit Memo |
| AMS_CLAIM_STATUS | System | APPROVED CANCELLED CLOSED COMPLETE DUPLICATE NEW OPEN PENDING PENDING_APPROVAL PENDING_CLOSE REJECTED |
Approved Cancelled Closed Complete Duplicate New Open Pending Pending Approval Pending Close Rejected |
| AMS_ CONTACT_ POINT_TYPE | Extensible | ADDRESS FAX INBOUND_ SCRIPT OUTBOUND_ SCRIPT PHONE WEBSITE PROPOSAL |
Address Fax Inbound Script Outbound Script Phone Website Proposal |
| AMS_ CONTENT_ TYPE | Extensible | HTML TEXT |
HTML Text Used for email schedules |
| AMS_ CREATION_ SIGN | System | + - |
Positive Negative |
| AMS_ DEDUCTION_ PAYMENT_ METHOD | System | ADJUSTMENT CHARGEBACK CONTRA_CHARGE CREDIT_MEMO DEBIT_MEMO REG_CREDIT_MEMO WRITE_OFF |
Adjustment Chargeback Contra Charge On Account Credit Debit Memo Invoice Credit Write Off |
| AMS_DELIV_STATUS | User | ARCHIVED AVAILABLE CANCELLED DENIED_BA NEW SUBMITTED_BA SUPERCEDED EXPIRED DENIED_TA BUDGET_APPR SUBMITTED_TA |
Archived Available Cancelled Denied - Budget Approval New Submitted - Budget Approval Superceded Expired Denied - Concept Approval Budget Approved Submitted - Concept Approval |
| AMS_DELIVERY_MEDIA_TYPE | Extensible | I SEMINAR ON_SITE SEMINAR WEB |
I Seminar On Site Seminar Web |
| AMS_DM_ MODEL_ STATUS | System | AVAILABLE DRAFT BUILDING SCHEDULED SCORING ARCHIVED EXPIRED CUSTOM PREVIEW QUEUED |
Available Draft Building Scheduled Scoring Archived Expired Custom Preview Queued |
| AMS_DM_ MODEL_ TYPE | System | EMAIL TELEMARKETING DIRECTMAIL LOYALTY CUSTOM |
Email Response Telemarketing Response Direct Mail Response Loyalty Custom |
| AMS_DM_ SCORE_ STATUS | System | DRAFT SCHEDULED SCORING COMPLETED ARCHIVED PREVIEW QUEUED |
Draft Scheduled Scoring Completed Archived Preview Queued |
| AMS_DM_ SOURCE_ TYPE | System | STANDARD CELL CSCH DIWB |
Generated List Segment Campaign Activity Discoverer Workbook |
| AMS_DM_ TARGET_ GROUP_ TYPE | System | BUSINESS CONSUMER |
Organization Contacts Persons |
| AMS_DM_ TARGET_ VALUE_ TYPE | System | BINARY CATEGORICAL CONTINUOUS |
Binary Categorical Continuous |
| AMS_EVENT_AGENDA_ STATUS | System | CONFIRMED UNCONFIRMED |
Confirmed Unconfirmed |
| AMS_EVENT_ATTENDANCE_FAILURE | System | AGENDA_CHANGE DISASTER PERSONAL_EMERGENCY SCHEDULE_CONFLICT SPEAKER_CHANGE VENUE_CHANGE WORK_EMERGENCY |
Agenda Change Natural Disaster Personal Emergency Schedule Conflict Speaker Change Venue Change Work Emergency |
| AMS_EVENT_CANCEL_ REASON | System | DISASTER INSUFFICIENT_REG POSTPONED SCHEDULE_CONFLICT SPEAKER_ UNAVAILABLE VENUE_UNAVAILABLE |
Natural Disaster Insufficient Registration Postponed Schedule Conflict Speaker not available Venue not avaialble |
| AMS_EVENT_CERT_ CREDIT_ TYPE | System | GENERAL SEED |
General Seed |
| AMS_EVENT_DAY | System | FIVE FOUR THREE TWO ONE |
5 4 3 2 1 |
| AMS_EVENT_FULFILL_ON | System | ON_CANCEL ON_ENROLL ON_REG |
On Cancellation On Enrollment On Registration |
| AMS_EVENT_FULFILL_ON | System | ON_CANCEL ON_ENROLL ON_REG |
On Cancellation On Enrollment On Registration |
| AMS_EVENT_LEVEL | System | MAIN SUB |
Main Sub |
| AMS_EVENT_PAYMENT_ STATUS | System | COMP FREE INVOICED PAID REFUNDED |
Complimentary Free Invoiced Paid Refunded |
| AMS_EVENT_PURPOSE | N/A | N/A | (Obsolete) |
| AMS_EVEH_PURPOSE | User | Organization defined values | Purpose for the Event. |
| AMS_EVENT_REG_CANCEL_REASON | System | AGENDA_CHANGE COST PERSONAL_EMERGENCY PRICE_CHANGE SCH_CONFLICT SPEAKER_CHANGE VENUE_CHANGE WORK_EMERGENCY |
Agenda Change Cost Personal Emergency Price Change Scheduling Conflict Speaker Change Venue Change Work Emergency |
| AMS_EVENT_REG_SOURCE | System | CALL_CENTER EXTERNAL ON_SITE PARTNER WEB |
Call Center External On Site Partner Web |
| AMS_EVENT_REG_STATUS | System | CANCELLED ENROLLED REGISTERED TARGETED WAITLISTED |
Cancelled Enrolled Registered Targeted Waitlisted |
| AMS_EVENT_RESOURCE_ TYPE | System | AMS_PEOPLE | People |
| AMS_EVENT_ SCHEDULE_OBJECTIVE | N/A | N/A | (Obsolete) |
| AMS_EVEO_OBJECTIVE | User | Organization defined values | Objective for the Event. |
| AMS_EVENT_SPEAKER_ STATUS | System | BOOKED CANCELLED CONFIRMED SCHEDULED |
Booked Cancelled Confirmed Scheduled |
| AMS_EVENT_STATUS | System | ACTIVE ARCHIVED AVAILABLE CANCELLED CLOSED COMPLETED DENIED_BA DENIED_TA NEW ON_HOLD Submitted_ Ba SUBMITTED_TA PLANNING |
Active Archived Available Cancelled Closed Completed Denied Budget Approval Denied Concept Approval New Active, but locked Pending Budget Approval Pending Concept Approval Planning |
| AMS_EVENT_STREAM_ TYPE | System | A B C D |
A B C D |
| AMS_EVENT_TYPE (Event Activities) |
System | BRIEFING CONFERENCE EXHIBITION HOSPITALITY INTERNAL_EVENT LAUNCH SEMINAR SPEAKING_ ENGAGEMENT SPONSORSHIP_EVENT TRADE_SHOW WEB_SEMINAR WORKSHOP |
Briefing Conference Exhibition Hospitality Internal Event Launch Seminar Speaking Engagement Sponsorship Trade Show Web Seminar Workshop |
| AMS_EVENT_WAITLIST_ ACTION | System | FIRST_COME_FIRST | First Come First Served |
| AMS_FUND_ SOURCE | System | CAMP EVEH EVEO FUND CSCH DELV EONE OFFR PTNR OPTN VEND USER |
Campaign Event Event Schedule Budget Campaign Activity Deliverable One Off Event Offer Partner Other Partner Vendor Person |
| AMS_FUND_ STATUS | System | ACTIVE ARCHIVED CANCELLED CLOSED DRAFT ON_HOLD PENDING REJECTED |
Active Archived Cancelled Closed Draft On Hold Pending Approval Rejected |
| AMS_FUND_ TYPE | System | FIXED FULLY_ ACCRUED |
Fixed Fully Accrued |
| AMS_GL_ DATE_TYPE | System | CLAIM_DATE DUE_DATE SYSTEM_DATE |
Claim Date Due Date System Date |
| AMS_GL_ EVENT_ LINE_TYPE | System | ACCRUAL_LIABILITY EXPENSE_ACCOUNT REC_CLEARING VEN_CLEARING |
Accrual Liability Expense Account Receivable Clearing Acct. Vendor Clearing Account |
| AMS_GL_ EVENT_ STATUS | System | ACCOUNTED ACCOUNTED_WITH_ERROR CREATED |
Accounted Accounted with Error Created a New Transaction |
| AMS_GL_ EVENT_TYPE | System | ACCRUAL ACCRUAL_ADJUSTMENT CONTRA_CHARGE SETTLE_BY_CREDIT SETTLE_BY_WO SETTLE_BY_CHECK |
Accrual Liability Accrual Adjustment Settle by Contra Charge Settle by Credit Memo Settle to Writing Off Settle by Payment Voucher |
| AMS_ HISTORY_ RULES_ OBJECT | System | CLAIM | Claim |
| AMS_ IMPORT_ STATUS | System | NEW STAGED SCHEDULED COMPLETED PURGED CANCELLED ERROR |
New Import Entries are imported and available for viewing Import is setup and ready to be completed at the scheduled time. Import completed. Imported entries have been purged from the Marketing Import Table. The list import has been cancelled and may not be reactivated. An error occurred during list import. |
| AMS_ IMPORT_ TYPE | System | CUSTOMER EVENT LEAD |
Organizations, Persons and TCA data. Event registration data. Leads data. |
| AMS_LIST_ ACT_TYPE | User | Employee List LIST |
Target group list selection type |
| AMS_LIST_ DEDUP_ TYPE | User | LIST IMPORT CONSUMERS IMPORT ORGANIZATIONS |
Type of Deduplication Rules to be applied. |
| AMS_LIST_GENERATION_TYPE | System | FULL REFRESH APPEND NEW RECORDS UPDATE ATTRIBUTES ONLY |
Full refresh of all the entries. New entries meeting the criteria added. Only the attributes of the entries updated. |
| AMS_LIST_ ROW_ SELECT_ TYPE | System | NTH RECORD RANDOM STANDARD |
How to select rows during list generation. Standard is top down selection. |
| AMS_LIST_ SEGMENT_ STATUS | User | ARCHIVED AVAILABLE CANCELLED DRAFT EXPIRED |
Archived Available Cancelled Draft Expired |
| AMS_LIST_ SEGMENT_ TYPE | System | WORKBOOK SQL |
Two types of segments supported. Based on a Discoverer workbook or an SQL statement. |
| AMS_LIST_ SELECTION_ ACTION | System | INCLUDE EXCLUDE INTERSECT |
How each selection is added to the list. Exclude means that all entries that exist in the excluded list are removed from the current list. Intersect causes the current list to become a list of only those entries which are on the intersected list and the current list. |
| AMS_LIST_ SELECTION_ TYPE | System | SEGMENT WORKBOOK IMPORT LIST LIST SQL |
Segment Workbook Import List List SQL |
| AMS_LIST_STATUS | System | ARCHIVED AVAILABLE CANCELLED DRAFT EXECUTED EXECUTING GENERATING LOCKED NEW PENDING RESERVED SCHEDULED VALIDATED VALIDATING DELETE PURGED |
Archived Available Cancelled Draft Executed Executing Generating Locked New Pending Reserved Scheduled Validated Validating Delete Purged |
| AMS_LIST_ TYPE | System | MANUAL LIST STANDARD LIST SUPPRESSION LIST TARGET GROUP |
List of possible list types. Note where these appear in the program. |
| AMS_ LUMPSUM_ DISTRIBUTION_ TYPE | System | % AMT QTY |
Percent Amount Quantity |
| AMS_ MASTER_ OBJECT_ TYPE | System | CAMP CSCH EONE EVEH |
Campaign Campaign Activity One-Off Event Event |
| AMS_ MEDIA_ TYPE | System | BROADCAST DEAL DIRECT_MARKETING EVENTS INTERNET IN_STORE PUBLIC_RELATIONS TRADE_PROMOTION |
Advertising Deal Direct Marketing Events Web Marketing In Store Press and Analyst Relations Trade Promotions |
| AMS_ OBJECT_ CLASS | System | INVOICE ORDER ORDER_LINE PCHO |
Invoice Order Order Line Purchase Order |
| AMS_OBJECT_USAGE_TYPE | System | CREATED USED_BY |
Created Used By |
| AMS_OFFER_ DEAL_ CUSTOMER_ TYPES | Extensible | BUYER CUSTOMER LIST SEGMENT |
Buyer Group Customer List Segment |
| AMS_OFFER_ LUMPSUM_ PAYMENT | System | ACCRUE CHECK |
Accrue Issue Check |
| AMS_OFFER_ STATUS | System | ACTIVE CLOSED DRAFT REJECTED CLOSED PENDING PENDING_ACTIVE ARCHIVED CANCELLED COMPLETED TERMINATED ONHOLD |
Active Closed Draft Budget Rejected Closed Pending budget approval Pending Active Archived Cancelled Completed Terminated On hold |
| AMS_OFFER_ TYPE | System | OID LUMPSUM ORDER ACCRUAL OFF_INVOICE DEAL TERMS |
Promotional Goods Lump sum Order value Accruals Off Invoice Trade Deal Terms Upgrade |
| AMS_OFFER_LUMP_CUST_ TYPES | System | BUYER CUSTOMER |
Buyer Customer |
| AMS_ PARTNER_ HOLDING_ TYPE (Holding Owner) |
System | PTNR VEND |
Partner Vendor Only used when Partners Online is implemented. |
| AMS_ PAYMENT_ STATUS | System | INCOMPLETE INTERFACED PAID PENDING |
Incomplete Interfaced Paid Pending |
| AMS_PLCE_ LOCATION_ CODE | Extensible | LEFT1, LEFT2…LEFT7 RIGHT1, RIGHT2 … RIGHT7 TOP BOTTOM |
Positions for placements |
| AMS_PLCE_ SITE_ CATEGORY | System | ORACLE_APPLICATIONS OTHER_APPLICATIONS AFFILIATES |
Oracle Applications Other Applications Affiliates |
| AMS_POST_ AUDIENCE_ TYPE | System | S L |
Segment List |
| AMS_POST_ BUSPRIOR (Business Priority) |
System | NONE RANDOM PROD_LIST_ PRICE CAMPAIGN_ START_DATE CAMPAIGN_ END_DATE CAMPAIGN_ PRIORITY |
None Random (for all) List Price (for products only) Start Date, End Date, or Priority (for campaign activities). |
| AMS_POST_ CATEGORY | System | UNIVERSAL RULEBASED |
Posting types: Universal or based on a rule. |
| AMS_POST_ CND_DATA_ TYPE | System | FLOAT STRING |
Data Types returnable by Custom Condition Class. |
| AMS_POST_ COMP_ OPERATOR | System | EQ GTE LTE |
Equal to Greater than or equal to Less than or equal to Used to compare shopping cart amount. |
| AMS_POST_ CONTENT_ TYPES | System | PRODUCT OFFER SCHEDULE |
Product Web Offer Web Advertisement |
| AMS_POST_ PREDEF_ PROD_ CONTEXT | System | PROD_VIEWED PROD_IN_CART |
The product context for relationship based strategy. |
| AMS_POST_ RELATIONSHIPS | System | Promoting Relationship Types Not Covered By istore | Promoting is a relationship not covered by iStore, as in promoting a product. |
| AMS_POST_ STATUS | System | ACTIVE INACTIVE |
- |
| AMS_POST_ STRATEGY_ TYPE | System | MANUAL_ SELECTION PRODUCT_ RELATIONSHIP INFERRED_OP CUSTOM |
Manually selected strategy Strategy based on product relationship Inferred based on Personalization Custom strategy |
| AMS_ PRICE LIST_ STATUS | System | ACTIVE DRAFT REJECTED PENDING CANCELLED |
Active Draft Rejected Pending Budget Approval Cancelled |
| AMS_PRIOR_ SORT_ ORDER | System | ASC DESC |
Ascending Descending |
| AMS_ PRIORITY | System | FAST_TRACK HIGH STANDARD |
Fast Track High Standard |
| AMS_ PRODUCT_ LEVEL | System | PRODUCT FAMILY |
Product Product Family |
| AMS_ PROGRAM_ OBJECTIVE | User | USER DEFINED | - |
| AMS_ PROGRAM_ STATUS | System | ACTIVE ARCHIVED CANCELLED COMPLETED NEW ON_HOLD |
Active Archived Cancelled Completed New Active, but locked |
| AMS_QP_ ARITHMETIC _OPERATOR | System | % AMT LUMPSUM NEWPRICE |
Percent Amount Lump sum New Price |
| AMS_QP_ VOLUME_ TYPE | System | PRICING_ATTRIBUTE10 PRICING_ATTRIBUTE12 |
Quantity Amount |
| AMS_QUARTERS | System | Q1 Q2 Q3 Q4 |
Q1 Q2 Q3 Q4 |
| AMS_ REASON_ CODE_TYPE | User | ADJUST_REASON INVOICING_REASON |
Adjustment Reason Invoicing Reason |
| AMS_ ROLLUP_ TYPE | Extensible | COLL DEAL ECAM EVCAM PARTNER RCAM TRDP |
Collection Deal Campaign Event Promotions Partner Program Trade Promotion |
| AMS_ SCHEDULE_ OBJECTIVE | User | User Defined | - |
| AMS_ TRANSFER_ REASON | User | SOURCING | Initial Sourcing |
| AMS_ TRANSFER_ TYPE | Extensible | RELEASE RESERVE TRANSFER REQUEST UTILIZED |
Release Reserve Transfer Request Utilized |
| AMS_ TRIGGER_ CHK_ METRIC_ TYPE | System | ACTUAL FORECAST |
Actual Value Forecast Value |
| AMS_ TRIGGER_ CHK_TYPE | System | DIWB METRIC STATIC_VALUE |
Workbook Metric Static Value |
| AMS_ TRIGGER_ FREQUENCY_TYPE | System | DAILY HOURLY MONTHLY NONE QUARTERLY WEEKLY YEARLY |
The frequency of trigger checking |
| AMS_ TRIGGER_ TYPE | System | METRIC_METRIC METRIC_VALUE METRIC_ WORKBOOK |
Metric to Metric type trigger Metric to Value type trigger Metric to Workbook type trigger |
| AMS_ UTILIZATION_ TYPE | System | ACCRUAL ADJUSTMENT SALES_ ACCRUAL UTILIZED |
Accrual Adjustment Sales Accrual (refers to the salesperson) Utilized |
| AMS_VALUE_ LIMIT | Extensible | BALANCE COMMITTED PAID PLANNED UTILIZED |
Balance Committed Paid Planned Utilized |
| AMS_YEARS | System | 1995 1996 1997 1998 1999 2000 2001 2002 |
1995 1996 1997 1998 1999 2000 2001 2002 |
| IBE_ RELATIONSHIP_TYPES | Extensible | Possible Relationships Between Products Like Cross Sell, Up Sell. | This is an iStore lookup type. |
| INVENTORY_ ITEM_ STATUS_ CODE | User | ACTIVE INACTIVE |
Active Inactive |
| ITEM_TYPE | Extensible | AI AOC ATO CONSULTING EDU FG FRT I K KIT M MEDIA NRI OC OP P PF PH PL POC PTO REF RI SA SI SW LIC TRAIN |
ATO Option Class ATO item ATO model Contracts - consulting Contracts - Education Contracts - KIT Contracts - Media Contracts - Software License Contracts - Training Finished good Freight Inventory Type Kit Model Non-recurring Option Class Outside Processing Item PTO Option Class PTO model Phantom item Planning Product Family Purchased Item Recurring Reference Item Subassembly supply item |
Additional Information: See also My Oracle Support Knowledge Document 2277369.1, Oracle E-Business Suite Support Implications for Discoverer 11gR1.