Advanced Collections - EBS (MOSC)

MOSC Banner

How to retrieve the Finance Charges , Interest Rate and Days Late on the Staged Dunning Letter in Or

edited Mar 15, 2016 5:00AM in Advanced Collections - EBS (MOSC) 3 commentsAnswered

Currently the Dunning Letter printed by Dunning Letter Generate concurrent program is based on the Oracle report ARDLP . This is the standard Oracle report and it prints such fields as Interest Rate, Finance Charges and Days Late but in Oracle R12 Advanced Collections none of the Dunning layouts/queries has these fileds.

How can we retreive exactly the Interest Rate, Finance Charges and Days Late on the Staged Dunning letters in R12?

Are the same tables can be used as in 11i - Finance Charges by totaling values of columns amount_accrue and amount_unaccrue from the receivables table ar_correspondence_pay_sched and  Interest Rate is retreived for a particular customer site from the receivables table hz_cust_profile_amts?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Collections Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center