Maximum Number of Sections in RDA

Zoltan_Gyimesi

Zoltan_Gyimesi

Legendary Poster
Hi JDEList,

Is there a limitation for number of Sections in RDA?
I am interested on XE SP23.

I searched the List, GOOGLE-d the web, but what I found was very old.
(Maybe I wasn't clever enough to search.)

Thanks & Regards,

Zoltán
 
Sorry, I don't have the answer but am definitely interested in knowing what you are trying to accomplish. Will be something interesting for sure
smile.gif
 
Hi Null Value,

[ QUOTE ]
Sorry, I don't have the answer but am definitely interested in knowing what you are trying to accomplish. Will be something interesting for sure

[/ QUOTE ]

Hmmm, a bit hard to describe it in details.
blush.gif

NOTE: it is not my first year in JDE Development and had made a lot simple and very complex APPLs, UBEs, BSFNs, TBLEs, etc.

Our Domestic Currency (CRCD of CO) generally our national currency HUF (Hungarian Forint). Most of our customers (currently at one of them raised this issu) has more bank accounts in foreign currenvy (mainly in EUR, rarely in USD or other).

There is here a local economy/financial accounting law, how to determine the Exchange Rate of Outgoings based of Exhange Rates of Incomings - in a FIFO order (brrrrr).

This is a complex task, including (just briefly):
- the partner has 60+ company and each can has one or more bank account in foreign currency
- I have to revaluate the Exchange Rates and domestic amount on AA ledger
- Update AA and CRR on AA ledger and CRR on CA ledger on all branch of accounting in F0911
- Do handle Account Open Amount, CRR, etc. by bank accounts
- Deal with manual Currency Inventory Revaluations by bank accounts
- Deal with rounding differences on all branch of accounting in F0911 (our HUF has 0 decimals) to keep it in balance
- Making accountings on Exchange Rate differencies, when balance go under zero and come back to zero
- Making Archives of "very" originally posted AA, CRR in AA from AA ledger
- Making Histories, how had been calculated the new CRR, AA in AA ledger
- If the UBE run again on the same or previous GL Date From, then delete all history and accountigs from that date, before new session start to work
- Display detailed information on a "well" designed and clear to read PDF about all related information (IN/OUT

I am lazy, so I created separate sections for these tasks, but currently I am at the 23th section, so I am afraid, I will face with a limit. If yes, then I will have a lot of extra job, to move some logic from Sections to Select/Find (insert/delete/Update) or to BSFNs.

Sections are:
- Page Header
- Processing Options (Conditional)
- Column Header 1,2 (Condtional)
- Driver Section (Invisible) + a Level Break (invisible)
- a lot of invisible/conditional sections for different tasks
- a lot of visible/conditional section for PDF output
- global and audit variables (invisible, conditional)
- etc., etc., etc.
...and I will have more - at least ten, or more.

I would like to keep this process in a single UBE (REASON: global RV and ER Variables, Processing Options, etc.)

Was it enough?
cool.gif


Regards,

Zoltán
 
Not sure if there is a limit on the number of sections but as per the Oracle support website document ID 626563.1
a report cannot be over 45 inches in either width or height . When a report is designed with a Parent and Child sections, the last Child section must start before 22.5 inches or the report sections may print out of sequence in the output.

Thanks,
Matt
 
Zoltán,

The biggest one I have has 21 sections and sub sections. Most of them are conditional off the a driver section, but a couple are basic business views which report data with sub totals and final totals. This report has everything, headers, footer, conditional sections, page footers, level break footer. This ube is huge.

This is the biggest one I have and I can tell that there is a minor problem. When you got back into the design after pulling to your desktop. Some of the sections move around. Yes that is right. Therefore after I make the changes I need. I have to got back and put the sections back in the right order.

I have another one which only has 12 sections but has a LOT of ER code. I would expect this one to give me more problems but it does not. It works great and I maintain it all the time. It is a commission system and finance is always wanting changes to it.

The UBE is in E8.10 tools 8.98.1.4. I still had this problem on tools 8.96 also.

Good Luck.
Rob
 
Back
Top