Skip Headers

Oracle Advanced Collections Implementation Guide
Release 12.1
Part Number E13452-04
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

Lookups

This appendix lists the lookups used by Oracle Advanced Collections.

This appendix covers the following topics:

Collections Lookups

This appendix provides a table listing the lookups used by Oracle Advanced Collections in E-Business Suite applications. It includes lookups with three different levels of modification:

Collections Lookups

Responsibility: Collections Administrator

The following table lists lookups for Oracle Advanced Collections, their values or defaults, the areas they affect, and the access level.

Collections Lookups
Application Lookup Type Values Affects Level
AR CREDIT_MEMO_REASON   Dispute Reason  
IEX CODE_STATUS Active
Inactive
  S
IEX IEX_ALL_TYPE ALL   S
IEX IEX_ASSIST_TYPES PHONE_ASSIST
WEB_ASSIST
  S
IEX IEX_CNSLD Enabled
Not Enabled
Consolidated Leasing invoices U
IEX IEX_DISPOSTION_CODE APPROVED: Approved Full Contract
APPROVED_PARTIAL: Approved Partial Contract (means partially approved)
REJECTED: Rejected
  S
IEX IEX_DISPUTED_SECTION LINES_SUBTOTAL
SHIPPING
SPECIFIC_INVOICE_LINES
TAX
TOTAL
  S
IEX IEX_DISPUTE_REASONS A/R Error
Cancellation
A contact line has been terminated
Credit and Rebill
Duplicate Billing
Free Product
Freight Error
Late Payment
No Reason Entered
Order Entry Error
PA_Credit_Memo
PA_Write_Off
Return
Sales Tax Error
Shipping and Handling
Tax Exempt
VAT 0%
VAT 2%
VAT 6.5%
WF_TEST_REASON
Disputing Invoices S
IEX IEX_PAYMENT_TYPES BA (Electronic Funds Transfer)
CC (Credit Card)
Payments E
IEX IEX_PROMISE_STATUSES Broken
Fulfilled
In Question
Open
Promise to Pay S
IEX IEX_REPO_DISPOSITION APPROVED_PEND: Approved / Pending
CLOSED: Closed
COMPLETE: Complete
OPEN: Open
REQUESTED: Repossession Requested
REJECTED: Rejected
Repossession U
IEX IEX_REPO_DISP_REASON NOT_REPOSSESSED: Asset not repossessed
REJECTED: Management Rejected
REPOSSESSED: Asset repossessed
Repossession U
IEX IEX_TRANSACTION_TYPES CB (Charge Back)
CM (Credit Memo)
DEP (Deposit)
DM (Deposit Memo)
GUAR (Guarantee)
INV (Invoice)
  S
IEX IEX_UWQ_LABELS DELINQUENCY_WORK_CLASS_LABEL (My Delinquencies)
DUNNING_WORK_CLASS_LABEL (My Dunning)
PROMISES_WORK_CLASS_LABEL (My Broken Promises)
Universal Work Queue U
IEX IEX_UWQ_NODE_STATUS ACTIVE
PENDING
COMPLETE
Universal Work Queue S
IEX IEX_STRATEGY_WORK_STATUS Canceled
Closed
Complete
Created
In Error
Open
Pre-wait
Skip
Time-out
Strategy Work Items U
IEX IEX_WRITEOFF_DISPOSITION_CODE APPROVED: Approved
CANCELLED: Cancelled
PARTIALLY_APPROVED: Partially Approved
REJECTED: Rejected
REVERSED: Reversed
Write-off U
IEX IEX_WRITEOFF_DISP_REASON 3RD_PART_EXT: Third Party Assigned (External)
3RD_PART_INT: Third Party Assigned (Internal)
CONTINUE_COLLECTIONS: Continue Collections
CONTRACT_TERMINATED: Contract Terminated
CREDIT_MEMO_ISSUED: Credit Memo Issued
INSURANCE_CLAIM: File Insurance claim for lost asset
LOST_PROVISION_CREATED: Lost Provision Created
SKIP_TRACE: Send to Skip Trace
Write-off U