You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Is it Possible to add parameter to the customised “Collections Send Dunning Letters” Report

Hello Team,

We have customised the seeded dunning letter data model in Oracle Fusion Advanced Collections and need to add one custom parameter. We are getting an error and would like to know whether this is supported, and if there is a recommended approach.

Data Model: /Shared Folders/Custom/Financials/Collections/Correspondence/Data Models/Collections Send Dunning Letters Data Model (customised copy of the seeded SendDunningBatchProcessDm)

What we did

  1. Added a new data model parameter p_trx_number (String, optional, no default value).
  2. Added an optional filter in the invoice data set (q_payment_history):
    AND (:p_trx_number IS NULL OR ct.trx_number = :p_trx_number)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!