Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities

Full Version: How to customize dunning letters in R12
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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.



Здравствуйте, форумчане! Уже некоторое время ищу интернет-магазин, где можно приобрести качественную вещи по адекватной цене.
Подскажите, в каких местах вы берёте фирменные вещи? Есть ли проверенные магазины?
Буду благодарен за советы!


________________
https://zeustrahub.osloop.com/read-blog/2948
Hello everyone!

I'm interested what timepieces you opt for.
Do you lean towards luxurious watches, or do you go for more affordable ones?
Also, do you stick with authentic pieces, or are you open to imitations?
Excited to read your thoughts!


_______
https://friendza.enroles.com/read-blog/37621
Hey forum members,
I've been thinking about getting a new watch, and I’d love to hear your thoughts! Which timepiece is your daily choice?
Also, I’ve been wondering — are Swiss watches really worth it? Do they justify the price?
And another question — is it always necessary to buy an original, or are alternative brands sometimes a reasonable option?
Looking forward to your replies!



_______
https://webyourself.eu/blogs/854913/Wher...-And-Catch
Привет, форумчане! Хочу узнать у знатоков: в каких местах вы покупаете оригинальные вещи?

Вижу разных сайтов, но важно выбрать безопасный сервис, чтобы не нарваться на подделку.
Может, у кого-то есть хорошие адреса, куда есть смысл смотреть с гарантией?
Интересуют и люкс, так и не слишком дорогие марки.
Очень жду подсказки и советы! Может, поделитесь личным опытом?



_______
https://lepodium.by
Привет, форумчане! Интересно, где вы покупаете фирменные вещи?

Сейчас так много магазинов: торговые центры, маркеты, но где реально выгодно?
Мне важно, чтобы не нарваться на подделку, и цены адекватными.
Может, кто-то заказывает за границей? Это реально выгодно?
Буду рад советов! Оставляйте свои отзывы, давайте обсудим!
Hello folks, I’d love to know where you usually buy your prescription drugs.

Do you shop at a local pharmacy, or do you prefer ordering from an internet pharmacy?
Are there any reliable online drugstores that are safe to use?
I’m looking for suggestions on where to find safe medications.
By the way, do you think getting medicine from non-local sources?
Looking forward to your replies!




_______
https://arstechnica.com/uncategorized/20...o-be-done/