NAME: IEX: Send Dunnings for Delinquent Customers
SHORT CODE: IEX_SEND_DUNNING
MODULE: Oracle Collections

Description: This will generate a fulfillment from a template to send to a delinquent customer
Navigation: Oracle Collections Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

• DUNNING_PLAN_ID : Select dunning plan ID
• STAGED_DUNNING_DUMMY : Is it staged Dunning?
• CORRESPONDENCE_DATE : Correspondence Date
• PARENT_REQUEST_ID : Select parent request ID
• DUNNING_MODE : Select Dunning Mode
• PROCESS_ERRORS_DUMMY : Process errors dummy
• PROCESS_ERRORS : Process Errors
• WORKERS : Number of Workers
• SINGLE_STAGED_LETTER : Single Staged Letter?
• COLL_BUSINESS_LEVEL_DUMMY : Collection business level
• CUSTOMER_NAME_LOW : Customer Name Low
• CUSTOMER_NAME_HIGH : Customer Name High
• ACCOUNT_NUMBER_LOW : Account Number Low
• ACCOUNT_NUMBER_HIGH : Account Number High
• BILLTO_LOCATION_DUMMY : Billto location dummy
• BILLTO_LOCATION_LOW : Billto Location Low
• BILLTO_LOCATION_HIGH : Billto Location High

NAME: IEX: Scoring Engine Harness
SHORT CODE: IEX_SCORE_OBJECTS
MODULE: Oracle Collections

Description: Scoring Engine Harness to score/ process objects
Navigation: Oracle Collections Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

• p_org_id : ID for Operating Unit
• p_score_id1 : ID for scoring engine to execute
• p_score_id2 : ID for scoring engine to execute
• p_score_id3 : ID for scoring engine to execute
• p_score_id4 : ID for scoring engine to execute
• p_score_id5 : ID for scoring engine to execute
• p_show_output : Yes/No to show diagnostic ouput
• p_object_id : ID for objects like Party_Id,Account_Id,Site_Use_Id,Payment_Sch_Id
• p_limit_rows : Max rows to fetch

NAME: IEX: Purge Score History Table
SHORT CODE: IEX_SCORE_HISTORY_PURGE
MODULE: Oracle Collections

Description: Deletes records from table IEX_SCORE_HISTORIES
Navigation: Oracle Collections Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

• P_TRUNCATE : Truncate Table
• P_SCORE_OBJECT_ID : Object ID for deletion
• P_SCORE_OBJECT_CODE : Object Code for deletion
• P_FROM_DATE : Delete From this date
• P_TO_DATE : Delete to this date
• P_REQUEST_ID : Delete this request
• P_SAVE_LAST_RUN : Y or N Flag to save last run (default is Y)
• P_BATCH_SIZE : Batch size for record deletion