REP-0771: After Form trigger failed.

REP-0771: After Form trigger failed.

The above error occurred when I ran the concurrent program.

The program will insert the data in to temp table. so that temp table has huge data, so this error occurred.

Later I deleted data and commit, then ran the program, now it's completed normal.

Where to enter Person's Phone number in Oracle Apps R12 in HRMS

When ever you enter Person's phone number one record will populate in PER_PHONES table.

To enter person's phone number, go to HRMS manager enter and maintain people, query the person.

Then go to others button, phones and there give type as work for office purpose and give enter and save,.

If you want to enter email then before others button office details tab email field.

How to get ledger name?

Hi,

In Oracle you can get ledger name by using below query.

select mo_utils.Get_Ledger_Name(P_ORG_ID) from dual

Org_id from profile.

select mo_utils.Get_Ledger_Name( fnd_profile.value('ORG_ID')) from dual;

you can use above query in conc prg parameters default value for sql statement.

How to do Reclassification in Fixed Assets in R12?

Go to asset work bench, query the asset and click open.

Then directly change the category and click Done.

That's all.

If you want to do unit adjustments then

go to asset work bench and query the asset.

then Click assignments and then in first line give units in minus in units change (to decrease)

then click done.

Same way you can change the location. in same screen just give another location with some units.

How to select the column from Hr_employees table in R12?

Hi All,

HR_EMPLOYEES table have pgb.name column.

But while writing it in select, we are getting error. So How to use it in Select?

If you want answer drop a mail to kommarajashekarreddy@gmail.com

so while querying that column you should write like this only....

select he."PBG.NAME" from hr_employees he

Password Related Profiles in Oracle Applications R12

Hi,

In Oracle applications R12 we have some profile options regarding password. To set password case, length, No Reuse ..etc.

 

Signon Password Case

Signon Password Length

Signon Password No Reuse

Signon Password Hard To Guess

Signon Password Failure Limit

Signon Password Custom

 

These are all system profiles.

Hi All,

Here we gave some interview questions. If you have any answer comment here...

1) Write full architecture of PO like PO then Receipt Then payment...

2) Also write full linkage with tables and joins

3) Difference between Application developer and System Administrator

4) How to restrict the user after some days?

5) How to screw up the entire oracle apps through Front end?

6) What is 3 way matching in PO?

7) If matching failed, then what will happen?

8) If it goes to hold, then how will you resolve?

9) Report registration process?

10) Forms development and canvas types?

11) What is the challenge work you have done?

12) DFF?

13) What is BR-100?

For more info Contact: kommarajashekarreddy@gmail.com

How to send all records in a single mail through Periodic Alert?

Hi All,

While creating Periodic Alert, in Actions give action type as a Summary. And the in Email text don't remove the standard template. Otherwise it will send multiple emails for each record.

Fore More Information Feel free to contact kommarajashekarreddy@gmail.com

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