Search Results dunning

The IEX_DUNNING_PLANS_B table is a critical component within Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2, specifically designed to support the functionality of the Collections module (part of Oracle Receivables). This table serves as the foundation for storing dunning plan definitions, which are essential for automating the collections process by defining escalation rules for overdue invoices. Below is a detailed technical breakdown of its structure, purpose, and integration within Oracle EBS.

1. Purpose and Functional Context

The IEX_DUNNING_PLANS_B table stores master data for dunning plans, which are used to systematically manage customer overdue payments. Dunning plans define the sequence of actions (e.g., reminders, letters, or calls) triggered at specific intervals based on invoice aging. This table is part of the Oracle Collections module (IEX), which integrates with Oracle Receivables (AR) to streamline collections workflows.

2. Key Columns and Structure

The table's structure includes columns that define the dunning plan's attributes, such as:

DUNNING_PLAN_ID: Primary key, uniquely identifying each dunning plan.
NAME: The display name of the dunning plan.
DESCRIPTION: A detailed explanation of the plan's purpose.
START_DATE_ACTIVE and END_DATE_ACTIVE: Define the plan's validity period.
ENABLED_FLAG: Indicates whether the plan is active (Y/N).
CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE: Audit columns tracking record creation/modification.

Additional columns may include ORG_ID (for multi-org support) and attributes for customization, such as ATTRIBUTE_CATEGORY and ATTRIBUTE1-15 (flexfield columns).

3. Integration with Other Modules

The table integrates with:

Oracle Receivables (AR): Dunning plans are assigned to customer profiles (RA_CUSTOMER_PROFILES) to automate collections.
IEX_DUNNING_STEPS_B: Child table storing escalation steps (e.g., letters or calls) linked via DUNNING_PLAN_ID.
IEX_STRATEGIES_B: Links dunning plans to broader collection strategies.

4. Technical Considerations

Indexes: Typically indexed on DUNNING_PLAN_ID, NAME, and ORG_ID for performance.
APIs: Managed via Oracle Collections' PL/SQL APIs (e.g., IEX_DUNNING_PLANS_PKG) for CRUD operations.
Multi-Org: Supports ORG_ID to segregate data by operating unit.

5. Customization and Extensions

The table supports flexfields and workflow integrations, allowing businesses to tailor dunning logic. For example:

Custom attributes can be added via descriptive flexfields.
Workflows can trigger external actions (e.g., SMS alerts) based on plan steps.

6. Data Flow Example

A typical workflow involves:

Creating a dunning plan in IEX_DUNNING_PLANS_B with steps (e.g., "Send Email at 15 days overdue").
Assigning the plan to a customer profile in AR.
Oracle Collections engine evaluates overdue invoices and executes steps per the plan.

7. Conclusion

The IEX_DUNNING_PLANS_B table is a cornerstone of Oracle Collections, enabling systematic management of overdue payments. Its design ensures flexibility, integration with core EBS modules, and scalability for complex collections scenarios. Understanding its structure and relationships is crucial for implementing effective collections strategies in Oracle EBS 12.1.1 or 12.2.2.

Lookup Type: IEX_COST_ITEM_TYPE 12.1.1
product: IEX - Collections , meaning: IEX: COST_ITEM_TYPE , description: Cost Item Types ,
Concurrent Program: IEX_DATA_MIG_FOR_STAGE_DUNNING 12.2.2
execution_filename: IEX_DUNNING_PUB.STG_DUNNING_MIG_CONCUR , product: IEX - Collections , user_name: IEX_DATA_MIG_FOR_STAGE_DUNNING , description: IEX: Data migration for staged dunning , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Lookup Type: IEX_COLLECTIONS_METHODS_DUN_ST 12.2.2
product: IEX - Collections , meaning: IEX_COLLECTIONS_METHODS_DUN_ST ,
Lookup Type: IEX_AR_DUNNING 12.2.2
product: IEX - Collections , meaning: IEX: From AR Dunning ,
Lookup Type: IEX_COST_ITEM_TYPE 12.2.2
product: IEX - Collections , meaning: IEX: COST_ITEM_TYPE , description: Cost Item Types ,
Lookup Type: IEX_AR_DUNNING 12.1.1
product: IEX - Collections , meaning: IEX: From AR Dunning ,
Lookup Type: IEX_DUNNING_CONTACT_SEL_MTH_OP 12.1.1
product: IEX - Collections , meaning: Dunning Contact Selection Method Options ,
Lookup Type: IEX_DUNNING_CONTACT_SEL_MTH_OP 12.2.2
product: IEX - Collections , meaning: Dunning Contact Selection Method Options ,
Lookup Type: IEX_COLLECTIONS_METHODS 12.1.1
product: IEX - Collections , meaning: IEX_COLLECTIONS_METHODS ,
Lookup Type: IEX_COLLECTIONS_METHODS 12.2.2
product: IEX - Collections , meaning: IEX_COLLECTIONS_METHODS ,
Lookup Type: IEX_DUNNING_PLAN_TYPE 12.2.2
product: IEX - Collections , meaning: Dunning types ,
Lookup Type: IEX_HIS_TAB_CORS_MNU_OPT 12.2.2
product: IEX - Collections , meaning: IEX History Tab Correspondance Menu Options , description: IEX History Tab Correspondance Menu Options ,
Concurrent Program: IEX_CALLBACK 12.1.1
execution_filename: IEX_DUNNING_PUB.CALLBACK_CONCUR , product: IEX - Collections , user_name: IEX_CREATE_CALLBACK , description: Creates a callback for a dunning on a deliquent customer , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: IEX_CALLBACK 12.2.2
execution_filename: IEX_DUNNING_PUB.CALLBACK_CONCUR , product: IEX - Collections , user_name: IEX_CREATE_CALLBACK , description: Creates a callback for a dunning on a deliquent customer , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Lookup Type: IEX_TRANS_TAB_MNU_OPT 12.2.2
product: IEX - Collections , meaning: Transaction Tab Right Click Menu Options ,
Table: IEX_DUNNING_PLANS_B 12.2.2
owner:IEX, object_type:TABLE, fnd_design_data:IEX.IEX_DUNNING_PLANS_B, object_name:IEX_DUNNING_PLANS_B, status:VALID, product: IEX - Collections , description: Collections dunning base table , implementation_dba_data: IEX.IEX_DUNNING_PLANS_B ,
Table: IEX_DUNNING_TRANSACTIONS 12.2.2
owner:IEX, object_type:TABLE, fnd_design_data:IEX.IEX_DUNNING_TRANSACTIONS, object_name:IEX_DUNNING_TRANSACTIONS, status:VALID, product: IEX - Collections , description: Collections dunning transaction table , implementation_dba_data: IEX.IEX_DUNNING_TRANSACTIONS ,
Table: IEX_DUNNING_PLANS_TL 12.2.2
owner:IEX, object_type:TABLE, fnd_design_data:IEX.IEX_DUNNING_PLANS_TL, object_name:IEX_DUNNING_PLANS_TL, status:VALID, product: IEX - Collections , description: Collections dunning plan translated table , implementation_dba_data: IEX.IEX_DUNNING_PLANS_TL ,
Lookup Type: IEX_DUNNING_MODE 12.2.2
product: IEX - Collections , meaning: Dunning mode ,
Table: IEX_DUNNING_PROFILES 12.2.2
owner:IEX, object_type:TABLE, fnd_design_data:IEX.IEX_DUNNING_PROFILES, object_name:IEX_DUNNING_PROFILES, status:VALID, product: IEX - Collections , description: OBSOLETED - Profile to save dunning info , implementation_dba_data: IEX.IEX_DUNNING_PROFILES ,
Lookup Type: IEX_DUNNING_STATUS 12.1.1
product: IEX - Collections , meaning: IEX: Dunning Status ,
Table: IEX_AG_DN_XREF 12.2.2
owner:IEX, object_type:TABLE, fnd_design_data:IEX.IEX_AG_DN_XREF, object_name:IEX_AG_DN_XREF, status:VALID, product: IEX - Collections , description: Cross reference between aging/dunning/Fulfillment , implementation_dba_data: IEX.IEX_AG_DN_XREF ,
Lookup Type: IEX_RUNNING_LEVEL 12.2.2
product: IEX - Collections , meaning: IEX_RUNNING_LEVEL , description: Collections Dunning Running Level ,
Table: IEX_DUNNINGS 12.2.2
owner:IEX, object_type:TABLE, fnd_design_data:IEX.IEX_DUNNINGS, object_name:IEX_DUNNINGS, status:VALID, product: IEX - Collections , description: Holds data on all dunning transactions sent by the system. , implementation_dba_data: IEX.IEX_DUNNINGS ,
Lookup Type: IEX_DELIVER_DUNNING 12.2.2
product: IEX - Collections , meaning: IEX: Deliver Dunning ,
Lookup Type: IEX_DUNNING_STATUS 12.2.2
product: IEX - Collections , meaning: IEX: Dunning Status ,
Lookup Type: IEX_DUN_CUST_PRF_CHK_LKP 12.2.2
product: IEX - Collections , meaning: IEX: Dunning Customer Profile Check Lookup ,
Lookup Type: IEX_RUNNING_LEVEL 12.1.1
product: IEX - Collections , meaning: IEX_RUNNING_LEVEL , description: Collections Dunning Running Level ,
Lookup Type: IEX_HISTORY_TYPE 12.1.1
product: IEX - Collections , meaning: History Type ,
Lookup Type: IEX_HISTORY_TYPE 12.2.2
product: IEX - Collections , meaning: History Type ,
Concurrent Program: IEX_BULK_XML_DELIVERY 12.2.2
execution_filename: IEXXmlDelivery , product: IEX - Collections , user_name: IEXXMLGEN , description: To generated and delivery document from xml publisher , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Lookup Type: IEX_UWQ_LABELS 12.1.1
product: IEX - Collections , meaning: IEX: Uwq Lookup Nodes , description: Uwq Collection Nodes ,
Lookup Type: IEX_UWQ_LABELS 12.2.2
product: IEX - Collections , meaning: IEX: Uwq Lookup Nodes , description: Uwq Collection Nodes ,