Since 2010, OraERP is a Oracle Forums, Community of Oracle Professionals including Fusion/Cloud Application Consultants, Enterprise Architects, ERP Cloud, HCM Cloud, CX Cloud and OCI Experts, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, Digital Architect, PaaS Experts, IaaS, OCI Architects, Technical Consultants, Fusion Middleware Experts, SQL, PL/SQL Developers and Project Managers. Welcome to OraERP.com Social Community, a friendly and active community of Oracle Technology Professionals who believe that technology can ‘make the world a better place’. By joining Oracle ERP Community you will have the ability to Post Topics, Receive our Newsletter, subscribe to threads and access many other special features. Registration is Quick and Simple. Get unlimited access to Oracle Tutorials, Articles, eBooks, Tools and Tips .
Oracle Forum - The Knowledge Center for Oracle Professionals - Looking Beyond the Possibilities
›
Oracle Applications
›
Oracle E-Business Suite (EBS)
›
Oracle Reports (e-business suite reports)
How to customize dunning letters in R12

How to customize dunning letters in R12
|
08-13-2011, 01:15 AM,
|
|||
|
|||
How to customize dunning letters in R12
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. |
|||
03-27-2025, 09:36 PM,
|
|||
|
|||
Где стоит приобретать оригинальную одежду и обувь?
Подскажите, в каких местах вы берёте фирменные вещи? Есть ли проверенные магазины? Буду благодарен за советы! ________________ https://zeustrahub.osloop.com/read-blog/2948 |
|||
03-28-2025, 06:15 PM,
|
|||
|
|||
Timepiece Discussion
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 |
|||
03-28-2025, 09:12 PM,
|
|||
|
|||
Favorite Watch: What’s on Your Wrist?
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 |
|||
03-29-2025, 05:27 AM,
|
|||
|
|||
Делимся местами для покупки брендовой одежды!
Вижу разных сайтов, но важно выбрать безопасный сервис, чтобы не нарваться на подделку. Может, у кого-то есть хорошие адреса, куда есть смысл смотреть с гарантией? Интересуют и люкс, так и не слишком дорогие марки. Очень жду подсказки и советы! Может, поделитесь личным опытом? _______ https://lepodium.by |
|||
03-29-2025, 05:53 AM,
(This post was last modified: 03-29-2025, 06:48 AM by Michaelutera.)
|
|||
|
|||
Где вы покупаете брендовую одежду?
Сейчас так много магазинов: торговые центры, маркеты, но где реально выгодно? Мне важно, чтобы не нарваться на подделку, и цены адекватными. Может, кто-то заказывает за границей? Это реально выгодно? Буду рад советов! Оставляйте свои отзывы, давайте обсудим! |
|||
03-31-2025, 07:40 AM,
|
|||
|
|||
Where to purchase 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/ |
|||
« Next Oldest | Next Newest »
|
Users browsing this thread: 2 Guest(s)
Current time: 04-02-2025, 07:16 AM
Powered By MyBB, © 2002-2025 MyBB Group.