Receivables & Collections

Get Involved. Join the Conversation.

Topic

    Juan Miguel Isip
    Dunning Letters won't re-run in Draft Mode
    Topic posted September 8, 2019 by Juan Miguel IsipSilver Medal: 2,000+ Points, last edited September 9, 2019, tagged Collections, Financials, Receivables, Reports, Sample Reports 
    26 Views, 1 Comment
    Title:
    Dunning Letters won't re-run in Draft Mode
    Summary:
    Dunning Letters won't re-run in Draft Mode
    Content:

    I successfully ran the Aged Dunning Letters in Draft Mode but when I re-ran it, it results into an Error and has the error message: 

    "No Dunning Site Found, Looping through delinquent Bill-to Sites."

    Why can't I re-run Aged Dunning Letters in Draft Mode? I've already run the following in sequence:

    • Collections Delinquency Management
    • Update Collections Summary Data
    • Send Dunning Letters 

    I've already confirmed that the said Customer has an Active Site with "Send Dunning" ticked at the profile level and has an active Contact with a Dunning Responsibility.  This is also true since I was also able to generate a Dunning sample once, but wasn't able to do it again. I've also confirmed that all executions of the ESS job "Send Dunning" was set to "Draft Mode".

     

    Also, I noticed that the other job (“Collections Delinquency Management”) that before "Send Dunning Letters" has different outputs pertaining to delinquent customers:

    Log of Successful Run of “Collections Delinquency Management” ESS Job:

    P_ORG_ID=300000001361190

    P_MODE=ORA_FULL

    Scored 3717 objects of type IEX_INVOICES

    Number Of Delinquencies Updated..>> 0

    Number Of Delinquencies Created..>> 1776

    STARTING GATHER STATS for IEX_DELINQUENCY:IEX_DELINQUENCIES_ALL

    367 Rows updated in ar_trx_bal_summary with reference_1 = 1

    To diagnose, run Scoring Diagnostic and Collections Setup Diagnostic

    Output of Successful run of “Collections Delinquency Management” ESS Job:

    Number of Transactions scored: 3717

    Number of delinquencies updated with Status Current: 0

    Number of delinquencies created with Status Delinquent: 1776

    Log of UnSuccessful Run of “Collections Delinquency Management” ESS Job:

    P_ORG_ID=300000001361190

    P_MODE=ORA_FULL

    Scored 3717 objects of type IEX_INVOICES

    Number Of Delinquencies Updated..>> 0

    Number Of Delinquencies Created..>> 0

    STARTING GATHER STATS for IEX_DELINQUENCY:IEX_DELINQUENCIES_ALL

    To diagnose, run Scoring Diagnostic and Collections Setup Diagnostic

    Output of UnSuccessful run of “Collections Delinquency Management” ESS Job:

    Number of Transactions scored: 3717

    Number of delinquencies updated with Status Current: 0

    Number of delinquencies created with Status Delinquent: 0

    How can I generate data again for Delinquent Customers? Any other items I need to check? Am I missing out some steps?

    please advise. Thank you!

    Comment

     

    • Sudhakara Rao Kovuru

      Hi Juan,

      Seeded ess job will not support for your requirement hence you need to create custom BIP report then you can run on ad-hoc basis. 

      Thanks,

      -Sudha.