• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Generate Delinquency Fees Invoices

Kekeni67

Member
Any Smarties out there that can help with my query please?
I am trying to generate delinquency fees document type RF via UBE R03B525. In Proof mode, I can see the fees by customer, but in final mode, the invoice (doc type RF) is not been created.
Any advise/assistance is greatly appreciated.

Many Thanks,
Kekeni67
 

SarahMaeMills

Active Member
What errors are the Work Center when you run it in final mode? Is this your first time generating doc type RF in your JDE system? Without more information, I am completely guessing, but it sounds like your RFD AAI is not set up OR your Next Numbers defined for the RF doc type are already used in your database F03B11.
 

Kekeni67

Member
Sarah - no errors coming through to WC. Only message is that R03B22 completed normally. Company's first time trying to generate type RF and company is new to JDE E9.1. AAIs RFD and RFC are set up for Co 00000 and 00001 with corresponding BU and Object accounts.
NN is set up in sys 03B for Finance Charge to 2871. Am I looking in wrong screen for the NN? Person before ha supposedly done the configuration and I'm trying to figure out what's being missed. Is there another NN screen for doc types?


Jim - yes it is kicking off R0322 in Proof mode displaying the fees on journal report

Thank you in advance for your input.
 

Kekeni67

Member
Yes Peter.
I'm able to generate fees with correct calculations and # of reminders is also working fine. Everything seems fine except when you run it in Final mode, doc type RF is not created in F03B11.
 

peterbruce

Legendary Poster
Kekeni67,

Select one address book ID that should have fees calculated and printed and run the R03B525 for that single address number (in the data selection) with debugging on. Then review the debug log for the reason it was not printed.
 

Alex Blasenheim

Well Known Member
I had a similar issue a few years ago with the R03B525. It turned out the version was corrupt and still processing in proof rather than final mode. We created a new version and all was good!
 

Kekeni67

Member
Hi Alex,
copying version or UBEs still don't work. Would you by any chance have a copy of the AR config for Delinquency document type RF please? Many Thanks
 

peterbruce

Legendary Poster
Kekeni67,

I have just finished two days of debug log analysis of a problem we are having with delinquencies. Looking at the code of a business function and along with the debug log, it looked like a bug. I did a search in the Oracle Support site and found it was a bug. Now I need to apply an AR baseline ESU.

I couldn't see where you had identified your configuration, so I don't know if any if the other bugs I saw during my search would apply to your situation. There were bugs relating to fees and finance charges.
 

Mike Mackinnon

Well Known Member
GL Date?? Is the date entered in a closed period?
Have the 'Finance People' closed the period for the date you are entering in process options for delinquency fees?
 

Kekeni67

Member
Hi Peter,
Yeah, I did a debug all day yesterday pretty much and yes there's a bug. R03B525 spawns R03B505 which contains another piece of coding(Nxxxxxx) that seems to be referring to an AAI RF when I have AAI RFC & RFD already setup. My issue could b the same as yours. I'm using E1 9.1
You wouldn't t happen to know the ESU number, would you?
Thanks
 

peterbruce

Legendary Poster
Kekeni67,

The problem I was having with the delinquencies was that the “Print Non-Delinquent Invoices” processing option is set NOT to print Non-Delinquent Invoices. The bug prints some (not all) Non-Delinquent Invoices.

Bug and fix details:

Bug 15899546 : R03B525 - R03B20 NON- DELINQUENT INVOICES PRINTING
Bug 16029750 : R03B525 - R03B20 NON- DELINQUENT INVOICES PRINTING

Code Change/ESU: SAR:16029750

BaseLine ESU_JM13600_5/14/13

Special Information
===================
JM13600 is an Accounts Receivable baseline ESU. All 9.1 customers will need to download and install this ESU before receiving fixes for subsequent ESUs that contain the same objects.

If you have already downloaded and installed JM13600 it is not necessary for you to download and install it again. You will be given credit for the baseline once the ESU has been installed.


- OBJECT LIST
B03B0012F03B14 Apply Receipt to Invoice03B08.31.20128:31:21
B03B0029Calculate Finance Charge from Rules03B02.19.20133:12:48
B03B0062Calculate Account Action03B04.18.201212:46:03
B03B0112F03B21 - Write Notification Detail from Cache03B02.01.20139:43:12
D03B0029Calculate Finance Charge from Rules03B04.30.20126:07:05
D03B0046Finance Charge Journal Processing03B04.30.20126:07:06
N03B0046Finance Charge Processing03B09.14.20126:04:13
R03B221Late Payment Delinquency Fees03B10.30.20127:46:32
R03B525Credit Analysis Refresh03B04.19.20139:18:10
T03B221Late Payment Fee Processing03B04.30.20126:07:27
V03B14KLate Payment Delinquency Fees - F03B1403B10.30.20127:46:


BUG NumberDescriptionSystem CodeCompletion Date
13105546LATE PYT FEE NOT GENERATED IF03B2012-05-15
13111710E1 FINANCE CHARGES NO REMARK03B2012-10-02
13323808RB TAKES WRONG PAYMENT INST -03B2012-04-03
13340063FOREIGN FEE AMOUNTS INCORRECT03B2012-04-24
13340088LATE FEE NOT COMPUTED FOR PART03B2012-05-08
13340126FOR. FEE CALC. OVER DOM. AMT.03B2012-04-24
13344978TEMPORARY CREDIT MESSAGE BEING03B2012-05-01
13345014WRONG OUTSTANDING AMOUNT CALCU03B2012-04-03
13347848FEES FOR CREDITS DON'T USE GRA03B2013-03-05
13347916DEL. NOTICE MSG NOT SUSPENDED03B2012-04-24
14006462R03B22 FEES NOT GENERATED03B2012-08-21
14117777CHARGEBACK CREATED IN F03B11 D03B2012-09-11
14822709LATE PAYMENT FEES NOT CALCULAT03B2012-11-27
16029750R03B525 - R03B20 NON- DELINQUE03B2013-02-26
16298430F03B20.RNID IS 3 CHARACTERS, B03B2013-04-02
16656847DELINQUENCY NOTICES DO NOT PRI03B2013-05-21
 

Alex Blasenheim

Well Known Member
Found this on Oracle Support:

When I run A/R Delinquency Fee Journal (R03B22) in Proof mode, invoices are being selected. However, when it runs in Final with exactly the same Data Selection and Processing Options behind R03B525 Credit Analysis Refresh and R03B22 A/R Delinquency Fee Journal , the PDF shows the message “No Data Selected”. Why?

When Manager Approval is set up for the Policy (P03B2501) and there is a Collection Manager set up in the Customer Master (P03013 – Collection’s tab), the first time R03B22 is run in Final Mode, they fees are only created as Pending status, they need to be Approved by the manager before the Fees can be created in Final mode.

The steps are:

(this is optional) you will run R03B525 set to call R03B22 in PROOF just so the user can see what will be picked up.
R03B22 is run in FINAL mode, since manager approval is required, “no data selected” is shown in R03B22. However, the fee is already available in P03B22 at Pending status
The Collection's Manager goes to P03B22 and Approves the fee. When exiting this program, the R03B22 is called automatically and in FINAL. The report can be seen in Work With Submitted jobs.

If the above does not help:

I'm at a client that is not using the delinquency fee option so I'm going by memory and I can't find anything in my archive. There is not much in the configuration. Here is what I would probably do with my current client who is thinking of charging fees in the near future: The R03B525 is in update mode (Update Tab), Fees Tab: Final, new version, GL date: blank, 1=calculate, new version, , payment terms is blank, 2= customer.

R03B22 create new version (no data selection and blanks for processing options) on FAT client and promote.
R03B221 (no data selection, Processing Options: Final, same version for R03B22, blank, blank, 2=customer, and blanks) create new version and promote

Be sure the customer Master currency code is setup properly if using this option.

Because calls to the delinquency objects are made you need to be sure they are properly built. Also, don't trust that the JDE versions are built correctly.
 

Kekeni67

Member
Thank you Peter for the detailed information on ESU and SARs etc. I got a Developer to check and yes we didn't have the baseline ESU already installed. I'll have to now inform the CNC (Outsourced Support) to look into. Cheers
 

Kekeni67

Member
Big Thankyou Alex,

I ended up re-configuring the R03B525 through to the other UBEs/Versions being called with bits you've provided to what I already knew and had done. I have now created my document type RF in F03B11 and will monitor user when generating the fees just to ensure that there is no difference in the setup of P03B22 vs R03B22 during the approving of the fees.
Again, thankyou so much for the brainstorming.

Cheers
Kekeni67
 

Kekeni67

Member
Does anyone know how I can get my RF (Finance Charges) documents to default to Approved (Customer Ledger) in the Pay Status when created through the P03B22 program please?

Thanks in Advance,
Kekei67
 
Top