Hello There, Guest! RegistrateRegister La Hora Current time: 10-25-2014, 02:05 AM

Welcome to ORAERP.com Social Community. A community of Oracle Technology Professionals who believe that technology can ‘make the world a better place’. "If we would have new knowledge, we must get a whole world of new questions.
23-09-14: Already Registered Members: Please use 'User Name' for Log-In, due to upgrade of new forum version, we have faced bug which is not allowing to log-in with email
Oracle Forum, Tutorials, eBooks Post a question relating to set-up, development or support
Come and join the Oracle forum - the big Oracle discussion!

How to customize dunning letters in R12
Views 6540
Replies 0
Thread Rating:
  • 12 Vote(s) - 2.58 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Users browsing this thread: 1 Guest(s)
This is process need to do to customize the source of the dunning letters.
1) create xml publisher data definition under the application "Collections" ( no need for an xml that contains any SQL )

2) create xml publisher template under the application "Collectïons" and connect the data definition
3) (step 3 is only if you use Collections Dunning and not strategies) navigate to resp "Receivables Manager" path "/Setup/Collections/Setup Checklist" and click on "view existing" for create dunning plan. Then find an existing one or create a new one. In step 3 of the dunning plan connect your custom template to the dunning level that you want your custom template to be enabled for.
4) navigate to resp "Collections Administrator" path "/Administration/Manage Queries" and create a new query there that holds your custom SQL. I recommend to look at the seeded queries to see which bind variables are used for the query. They differ per level of query ( customer/account/etc ) and you will need to get them right or you end up with the wrong data or an error in the dunning program.
5) navigate to resp "Collections Administrator" path "/Administration/Manage Template Query" and connect your query to your template.

-- now you are ready to run : we are just using Advanced Collections Dunning (without strategies) so for me it is:
6) make an invoice on a cust that is past the due date
7) run IEX: Scoring Engine Harnass
8) run IEX: Send dunnings for Delinquent Customers
9) this starts : Oracle Collections Delivery XML Process (IEX: Bulk XML Delivery Manager) which will run your template, fetch the data and create the output.

Thanks given by:

Users browsing this thread: 1 Guest(s)
Get Oracle Tutorials, Tips! Post a Question!