Edi Yanto (何 萬 新)

Scenario: We want to disable “Sample No” parameter if “Type” parameter value is “Receipt“, otherwise disable “Receipt No” parameter if “Type” parameter value is “Sample” and the parameter must be mandatory if enable.

We have to define concurrent program with the following parameters:

  1. Type (value are Sample or Receipt, using value set independent (ex: “EY_TYPE”))
  2. Run_Mode_S (use SQL Statement with value “select ‘S’ from dual where :$FLEX$.EY_TYPE:null in (‘Sample’)“, and the parameter is  not display)
  3. Run_Mode_R (use SQL Statement with value “select ‘R’ from dual where :$FLEX$.EY_TYPE:null in (‘Receipt’)“, and the parameter is  not display)
  4. Sampe_No (value set “EY_SAMPLE” and set parameter required)
  5. Receipt_No (value set “EY_RECEIPT” and set parameter required)

Read the rest of this entry »


SELECT p.profile_option_name short_name, n.user_profile_option_name NAME,
DECODE (v.level_id,
10001, ‘Site’,
10002, ‘Application’,
10003, ‘Responsibility’,
10004, ‘User’,
10005, ‘Server’,
10006, ‘Org’,
10007, DECODE (TO_CHAR (v.level_value2), ‘-1’, ‘Responsibility’, DECODE (TO_CHAR (v.level_value), ‘-1’, ‘Server’, ‘Server+Resp’)),
) level_set,
DECODE (TO_CHAR (v.level_id),
‘10001’, ”,
‘10002’, app.application_short_name,
‘10003’, rsp.responsibility_key,
‘10004’, usr.user_name,
‘10005’, svr.node_name,
‘10006’, org.NAME,
‘10007’, DECODE (TO_CHAR (v.level_value2),
‘-1’, rsp.responsibility_key,
DECODE (TO_CHAR (v.level_value),
‘-1’, (SELECT node_name
FROM fnd_nodes
WHERE node_id = v.level_value2),
(SELECT node_name
FROM fnd_nodes
WHERE node_id = v.level_value2) || ‘-‘ || rsp.responsibility_key
v.profile_option_value VALUE
FROM fnd_profile_options p,
fnd_profile_option_values v,
fnd_profile_options_tl n,
fnd_user usr,
fnd_application app,
fnd_responsibility rsp,
fnd_nodes svr,
hr_operating_units org
WHERE p.profile_option_id = v.profile_option_id(+)
AND p.profile_option_name = n.profile_option_name
AND UPPER (p.profile_option_name) IN (SELECT profile_option_name
FROM fnd_profile_options_tl
WHERE UPPER (user_profile_option_name) LIKE UPPER (‘%&user_profile_name%’))
AND usr.user_id(+) = v.level_value
AND rsp.application_id(+) = v.level_value_application_id
AND rsp.responsibility_id(+) = v.level_value
AND app.application_id(+) = v.level_value
AND svr.node_id(+) = v.level_value
AND org.organization_id(+) = v.level_value
ORDER BY short_name, user_profile_option_name, level_id, level_set;

Oracle APEX 4 Tutorial


Oracle APEX 5 Tutorial

Purchasing Requisition notification with framework regions like “Approve Requisition Notification” can be viewed in the worklist but fails to be emailed by the Workflow Notification Mailer.

6-9-2015 1-55-30 PM

If you have this above problem, you can try the one of the below solutions:

  1. Change the WF Mailer configuration parameter for “Attach images to outbound emails (ATTACH_IMAGES)” from Y to N, restart the Workflow Notification Mailer and then try to resend the failed notification with concurrent request “Resend Failed/Error Workflow Notifications
  2. Apply  Patch 9868639:R12.OWF.B for releases 12.1.2 and 12.1.3

Reference: Doc ID 1107017.1

When you’re getting the following errors, please try the below solution:

  1. You are trying to access a page that is no longer active.
    – The referring page may have come from a previous session. Please select Home to proceed.
    Solution: set the profile “FND Validation Level” to “None”.
  2. You have insufficient privileges for the current operation. Please contact your System Administrator. You cannot run a page which is not SelfSecured when the MAC fails. JDev-1 Solution: set the below 3 profiles to None 1) FND Function Validation Level 2) FND Validation Level 3) Framework Validation Level JDev-2
  3. Unexpected URL parameters have been detected and will be ignored Solution: In JDeveloper, go to menu Tools–>Embedded OC4J Server Preferences–>Global–>Startup–>Select Default Local IP Address. JDev-3

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 1,378 other followers

Edi Yanto
Oracle Applications Technical Consultant
View Edi Yanto's profile on LinkedIn

My Certifications


September 2017
« Jan    

RSS Unknown Feed

  • An error has occurred; the feed is probably down. Try again later.



Blog Stats

  • 173,044 hits

Users Online

web counter