Protected by Copyscape Web Copyright Protection Software

Search This Blog

Tuesday, April 4, 2017

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?


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.