This appendix lists the lookups used by Oracle Advanced Collections.
This appendix covers the following topics:
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:
System (S): The implementer can only change the wording of a list of values (LOV) choices the user sees on the screen. No deletions or additions are allowed.
Extensible (E): The implementer can change both the wording of the LOV choices and add new choices for the user.
User (U): The implementer can change the lookup completely, deleting and adding LOV choices at will.
Responsibility: Collections Administrator
The following table lists lookups for Oracle Advanced Collections, their values or defaults, the areas they affect, and the access level.
| 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 |