ERPstuff - Oracle EBS Community

Use top Command To View resource utilization(When you Feel More Resource Utilization then normal also check your reports there might be probelms in report{more Links and Formula Columns You Used Report ill gone slower}). [quote]After 3 or 4 hours Oracle financial system works very slowly and user re...

<b>To Check Application--> Responsablity and Asssigned Menu</b> SELECT DISTINCT e.application_name, a.responsibility_name, a.LANGUAGE, b.responsibility_key, c.user_menu_name FROM apps.fnd_responsibility_tl a, apps.fnd_responsibility b, apps.fnd_menus_tl c, apps.fnd_menus d, apps.fnd_application_tl e...

<b>Check User --> Application and assigned responsiblity</b> select unique u.user_id, substr(u.user_name,1,30) user_name, SubStr(A.APPLICATION_NAME,1,50) Application, SubStr(R.RESPONSIBILITY_NAME,1,60) Responsiblity From fnd_user u, FND_USER_RESP_GROUPS G, fnd_application_tl A, FND_RESPONSIBILITY_TL...

<b>To Check Open inventory Periods</b> SELECT summary.organization_id organization_id, ood.organization_code organization_code, ood.organization_name organization_name, periods.period_name period_name, periods.OPEN_FLAG ,periods.PERIOD_CLOSE_DATE , periods.period_year period_year, periods.period_sta...

<b>To Check Period Status</b> This query will help to get information of periods status (open/close) of different Oracle Apps modules. SELECT ROWID, (SELECT application_short_name FROM fnd_application fa WHERE fa.application_id = gps.application_id) application, (SELECT NAME FROM gl_sets_of_books gs...

<b>Get Average Runtime of A Concurrent</b> SELECT fcp.description "Description", TRUNC (AVG ( ( TO_NUMBER (TO_CHAR (actual_completion_date, 'SSSSS')) - TO_NUMBER (TO_CHAR (actual_start_date, 'SSSSS')) ) / 60 ), 2 ) "Time in Min." FROM fnd_concurrent_programs_vl fcp, fnd_concurren...

<b>How To Check Current Status Of Request</b> SELECT r.request_id, r.phase_code, r.status_code, r.request_date, r.requested_start_date, r.hold_flag, r.parent_request_id, r.last_update_date, u1.user_name updated_by_name, r.actual_start_date, r.completion_text, r.actual_completion_date, u2.user_name r...

. <b>To check responsibility which contact given function</b> 1. To get form Id from database SELECT FUNCTION_ID, USER_FUNCTION_NAME FROM FND_FORM_FUNCTIONS_TL You can also use SELECT FUNCTION_ID, FUNCTION_NAME FROM FND_FORM_FUNCTIONS 2. Pass The obtained Function id or function name to following qu...

in form buider apply when_validate_item triger on name text item write code there

select count(name) into v_cnt variable name
from table name
where name = :text item name;

if v_cnt <> 0 then
raise form trigger failure


hope you can understand

add text field in canvas
set item property
conceal data = yes

Dear, there two things about this Q 1-oracle metalink will not support and recomand customization in standard reports 2-Oracle developer report builder used for customization 3-all standard report are text reports(output in text file) good practice is to design all customize reports in bitmap report...

Dear Kashif, Consider you have a date field in database at the time of insertion consider follwing If NLS_DATE_FORMAT="DD-MON-YY" 10-JAN-1822 raises an error in Oracle7. Inserts 10-JAN-1822 in Oracle8. 10-JAN-22 is inserted as 10-JAN-1922 10-JAN-95 is inserted as 10-JAN-1995 If NLS_DATE_FO...

It's expected that the E-Business Suite Release 12 will feature an updated user interface, codenamed <font color="pink">"Project Swan." </font id="pink"> Aside from the unfortunate implication that the existing 11i user interface is an ugly duckling, Project Swan has so...

Dear Fahad,
please visit
topic.asp?TOPIC_ID=109

feel free to contact for further support

have you check
1-tnsnames.ora at client end
2-init.ora global databasse name
3-port on which listner work