Thanks all for one lakh views

Thanks all for your contineous support. Today our blog crossed one lakh views

Rounding issue in XMLP Report output

Hi Friends,

I have a xmlp report which is giving excel output.

Opening Balance
-----------------
208,708,625.62
11,896,120.30
55,886,126.41
57,103,938.52
9,529,484.00
----------------
343,124,295.00 :Total
-------------------

When we sum all 5 values it shows 343,124,294.85 but it is rounded of why?

Opening balance is rounded in query. and total is summary column of that column.

In rtf used same format for both. #,##0.00

Query:

SELECT fc.segment2 asset_major_category,round(sum(a.cost),2) opening_balance ,round(sum(a.deprn_reserve),2) depreciation_reserve
FROM xxst_FA_RESERVEr_LEDGER_GT a
,FA_ADDITIONS b
,fa_categories fc
,(select max(b.request_id) req_id from xxst_fa_reserver_ledger_gt b) sq
where a.asset_id(+)=b.asset_id
and fc.category_id=b.asset_category_id(+)
and (a.request_id=sq.req_id or a.request_id is null)
and a.request_id(+)!=-1
group by fc.segment2
order by 1;

This will display opening_balance.
Then in rdf I took one summary column CS_OPENING_BALANCE
which is data type Number and source as opening_balance.

In rtf i took two form fields and put type as Number and format is #,##0.00 

Solution
------------

After trying lot of times Finally I find the mistake.

For CS_OPENING_COST width is 10. that's why it displays only 343,124,295.00

now i increased it to 20. now it showing 343,124,294.85


Hope this will help you...

Let me know if I am wrong...

Caused by: java.lang.ClassCastException: oracle.xdo.parser.v2.XSLNode cannot be cast error in xmlp

Dear All,

When I click on Preview --> Excel in rtf I got below error.


java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknow n Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Un known Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at oracle.apps.xdo.common.xml.XSLT10gR1.invokeNewXSLS tylesheet(Unknown Source)
at oracle.apps.xdo.common.xml.XSLT10gR1.transform(Unk nown Source)
at oracle.apps.xdo.common.xml.XSLTWrapper.transform(U nknown Source)
at oracle.apps.xdo.template.fo.util.FOUtility.generat eFO(Unknown Source)
at oracle.apps.xdo.template.fo.util.FOUtility.generat eFO(Unknown Source)
at oracle.apps.xdo.template.FOProcessor.createFO(Unkn own Source)
at oracle.apps.xdo.template.FOProcessor.generate(Unkn own Source)
at RTF2PDF.runRTFto(RTF2PDF.java:629)
at RTF2PDF.runXDO(RTF2PDF.java:470)
at RTF2PDF.main(RTF2PDF.java:289)
Caused by: java.lang.ClassCastException: oracle.xdo.parser.v2.XSLNode cannot be cast to oracle.xdo.parser.v2.XSLSort
at oracle.xdo.parser.v2.XSLProcessor.reportException( XSLProcessor.java:806)
at oracle.xdo.parser.v2.XSLProcessor.newXSLStylesheet (XSLProcessor.java:571)
... 14 more

In rtf i used <?if:CF_INDIA_RESP='Y'?>
Data tags
<?end if?>

And after that I used another condition.

<?if: CF_INDIA_RESP= 'N'?>
Data tags
<?end if?>



Solution
----------------


I changed the END tag place, Now it is coming fine. 

How to Display Responsibility Name in Report Output?

Hi All,

Recently I came across a requirement to display Responsibility Name in Report Output.

For that in rdf I took one place holder column (CP_RESP_NAME) and in before report trigger I wrote below code.

CP_RESP_NAME:=FND_PROFILE.VALUE('RESP_NAME');

 So through profile value we are getting.

Then place <?CP_RESP_NAME?> tag in rtf to display responsibility name dynamically.

Assume that there 3 responsibilities XX Payables Resp1, XX Payables Resp2, XX Payables Resp3

So If you run this report through XX Payables Resp1 then we can see XX Payables Resp1 in output,
If you run this report through XX Payables Resp3 then we can see XX Payables Resp3 in output.

Hope this will useful for you....

How to create Short Cuts in SQL Developer?

Like toad we can have lot of short cuts in Sql Developer tool also. Here we can create our own short cuts. For this just you have to follow below steps.

Open Sql Developer and Connect. Then go to Tools à Preferences.

 

Then click on Database à SQL Editor Code Templates

  

Here in right side click add template button then add your short cut words in ID column then give what it need to do in Template column.

Ex: write sf in ID column and SELECT * FROM in template column.

Like that we can create many short cuts.

After creating templates click ok. Then in sql developer give sf and click on Shift + F4 button to execute these short cuts. But in toad we just give short cut name then press space bar then the full code will come. Like this we can active code after pressing control+Space. But for this we need to do below steps.

Go to Tools à Preferences

Click on Accelerators

Select Code template

Here in new Accelerator put cursor and in key board type control and space at a time. Then it will show as Ctrl+Space then click on Add button and then OK. Now you can enjoy with short cuts.

Just type any short cut key and press Ctrl+Space then you will get full code.

Ex: write sf then press Ctrl+Space then you will get below code.

SELECT * FROM

SELECT * FROM rct

SELECT * FROM ra_customer_trx_all rct