Edi Yanto (何 萬 新)


We can enable attachment link in Oracle Forms with below steps:

  • Navigate to “Application Developer” Responsibility and choose the menu Attachments > Document Entities. Identify Document Entity exists or not. If exists then do nothing otherwise create new.
  • You can create a new Document Categories or use the existing categories assign to the Oracle Forms (Attachments > Document Categories)
  • Setup attachment at Form or Function Level and make sure Enabled checkbox is checked (Attachments > Attachment Functions
  • Assign categories (ex: Miscellaneous), click button Categories on Attachment Functions Form

Read the rest of this entry »

Advertisements

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’)),
‘UnDef’
) 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
)
),
‘UnDef’
) “CONTEXT”,
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

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

Join 1,459 other followers


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

My Certifications






Follow me on Twitter

Archives

January 2018
M T W T F S S
« Dec    
1234567
891011121314
15161718192021
22232425262728
293031  

RSS Unknown Feed

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

RSS Unknown Feed

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

Visitors

Categories

Blog Stats

  • 183,848 hits

Users Online

web counter

Pages