Installing fedora tool groups in fedora 23

In fedora they have grouped packages according the needs like for an example if a person is interested in he has to download a distribution or he has to get a fedora lab of his choice for example Audio Editing or he can go for some other distro which has Audio Editing  tools and now he is also interested in security tools so he has to search all the tools and then he will install with audio editing tools. So to simplify this fedora provides group. So there are many groups users can get specialized tools in the groups.

Now type the below command to search the list of groups in fedora

$ dnf groups list

Now Install the needed group to your system by firing the below command

# dnf groups install “Security Lab”

Note: this command will not support the versions below fedora 21



Creating Role and attaching role in Oracle Workflow

If there is requirement that you have to send a notification to some users in a group you can use this AdHocRole concept so you can stitch a group of users and attach to one role.

In the below code wf_directory.CreateAdHocRole creates a new role and we loop the users and send it to wf_directory.AddUsersToAdHocRole so that users will b attached to the particular role

lc_adhoc_role3 := ‘DPC_MAITENANCE_SUPERVISOR’||itemkey;
wf_directory.CreateAdHocRole(       role_name                 => lc_adhoc_role3,
role_display_name         => lc_adhoc_role3);

for i in c1(‘DPC Maintenance Engineer’) loop
wf_directory.AddUsersToAdHocRole(   role_name                 => lc_adhoc_role3,
role_users                => i.USER_NAME
end loop;
wf_engine.setitemattrtext (itemtype   => itemtype,itemkey    => itemkey,aname      => ‘DPC_MAITENANCE_SUPERVISOR’,avalue     => lc_adhoc_role3);

Make sure the attribute type is ROLE instead of text and call the above line to assign the role programmatically

Creating attribute at runtime

Below is script to Create attribute at run time in Oracle apps Workflow.

if ( funmode = ‘RESPOND’ OR funmode = ‘TIMEOUT’) then
end if;

Responding a response from backend

To programatically respond to a Notification use the below script replacing with the appropriate notification Id and status


wf_notification.setattrtext ( nid => i.notification_id
, aname => ‘RESULT’
, avalue => ‘RETRY’ );
wf_notification.respond( nid => i.notification_id
, respond_comment =>’Approved from our end’
, responder =>fnd_profile.value (‘USERNAME’));


Changing the Prefix key of Tmux(Terminal Multiplexer)

Edit the file tmux.conf If it is a new Installation you will not have this file so create a new file in home directory by firing the below command

vi ~/.tmux.conf

Now enter the three lines for changing the default Ctrl-b to ` symbol as prefix key

unbind C-b

set-option -g prefix ‘`’

bind-key ‘`’ send-prefix

For this change to happen for all users write the config file to /etc folder so resulting your tmux file will be in /etc/tmux.conf


3 ways to get .wft file from server

To get the definition you have 3 options:

1. Connect to the instance via The Oracle Workflowbuilder Client
From the menu bar, choose File/Open
Downloading from the database:
· Click on Database
· Enter the following:
User GWYUID, eg apps
Password FNDNAM, eg.apps
Effective You can leave this null.

Then save the file on your desktop via File/Save As and upload it via Metalink

2. Log on to the system Administrator responsibility
Navigate to Concurrent Requests and submit the Workflow Definitions Loader with the following parameters:
Mode: Download
File: <directory path on the server><filename.wft>
e.g. /user/tmp/fa_accounts.wft
Item Type: FA Account Generator

ftp the wft file to your desktop

3. On the server in Unix go to $FND_TOP/bin, ie cd $FND_TOP/BIN
The download command to enter then at the OS prompt is as follows:

WFLOAD apps/<apps pwd> 0 Y DOWNLOAD <filename>.wft ITEMTYPE
WFLOAD -u apps/apps 0 Y DOWNLOAD /usr/tmp/fa_accounts.wft FAFLEXWF

Move the wft file to you desktop


Source :

Script for AME parallelization configuration error


Script to resolve the below error in AME

ORA-20001: Oracle Approvals Management has found parallelization configuration details. The context in which ame_api has been invoked does not support parallelization.

set variable_value = ‘no’
where variable_name in (‘allowAllApproverTypes’,’allowAllItemClassRules’,’allowFyiNotifications’)
and sysdate < nvl(end_date,sysdate + 1)
and nvl(application_id,0) = 0;

AME with 2 conditions with amount

In this case we will just have 2 conditions and approvers groups with a condition of Amount.

If Amount >= 1 million then send to SH(Share holder approver) approver group

If Amount < 1 million then send notification 3 level approver group.

Creating Attribute

So for this we define a attribute and then we get the amount from our Query

select price_in_usd from xxdpc_penality_details_v where item_key = :transactionId


In the below picture the price_in_usd is the determining amount for our condition.

Creating Conditions


On condition creation we have to select the Attribute amount and then we will have the condition whether it is equal or less or greater and then we can have our amount.

Take the Approval type with the below option

approval-group chain of authority Chain of authority includes an approval group

Approver Groups

Define 2 seperate approver group and I have defined here a dynamic approver group


We can have a stacked users in one query in the below Query

select ‘person_id:’||agent_id from xxdpc_penality_pro where item_key = :transactionId


select ‘person_id:’||(agent_id+1) from xxdpc_penality_pro where item_key = :transactionId


select ‘person_id:’||(agent_id+2) from xxdpc_penality_pro where item_key = :transactionId


Define 2 rules for amount less than and amount greater than equal to

So in one rule


So we have attached Action type which consists of 3 level approver group and condition which is linked with attribute.


Create a another rule with the amount greater condition.

So to Test this we have to Test Workbench → Run real transaction test


So we have linked the transaction Id and from that we have taken the data from the table so I give a test data.

Now we will go with running test case so select Run Test Case


So we will now be able to see the approvers.

API for Value Set in Oracle apps(Independent and Dependent)

API for Value Set in Oracle apps


Below is the API to upload the values in the value set as shown in below screenshot


A Value set must be already exist in the system as commented in API. The Below is Independent

 Independent Values

l_enabled_flag varchar2 (2);
l_summary_flag varchar2 (2);
l_who_type fnd_flex_loader_apis.who_type;
l_user_id number := fnd_global.user_id;
l_login_id number := fnd_global.login_id;
l_value_set_name fnd_flex_value_sets.flex_value_set_name%type;
l_value_set_value fnd_flex_values.flex_value%type;
l_value_set_desc varchar2 (500);
l_value_set_name := ‘XX_ITEM_CATEGORY_VALUE_T’; –This Value set should already exist in the system as Independent
l_enabled_flag := ‘Y’;
l_summary_flag := ‘N’;
l_who_type.created_by := 6532;
l_who_type.creation_date := sysdate;
l_who_type.last_updated_by := 6532;
l_who_type.last_update_date := sysdate;
l_who_type.last_update_login := 6532; –l_value_set_name
l_value_set_value :=60123; –l_value_set_value
l_value_set_desc := ‘Under Testing check’;
fnd_flex_loader_apis. –API to upload the value set
up_value_set_value (
p_upload_phase => ‘BEGIN’,
p_upload_mode => null,
p_custom_mode => ‘FORCE’,
p_flex_value_set_name => l_value_set_name,
p_parent_flex_value_low => null,
p_flex_value => l_value_set_value,
p_owner => null,
p_last_update_date => to_char (sysdate, ‘YYYY/MM/DD HH24:MI:SS’),
p_enabled_flag => l_enabled_flag,
p_summary_flag => l_summary_flag,
p_start_date_active => to_char (sysdate, ‘YYYY/MM/DD HH24:MI:SS’),
p_end_date_active => null,
p_parent_flex_value_high => null,
p_rollup_flex_value_set_name => null,
p_rollup_hierarchy_code => null,
p_hierarchy_level => null,
p_compiled_value_attributes => null,
p_value_category => ‘VALUE_SET_NAME’,
p_attribute1 => null,
p_attribute2 => null,
p_attribute3 => null,
p_attribute4 => null,
p_attribute5 => null,
p_attribute6 => null,
p_attribute7 => null,
p_attribute8 => null,
p_attribute9 => null,
p_attribute10 => null,
p_attribute11 => null,
p_attribute12 => null,
p_attribute13 => null,
p_attribute14 => null,
p_attribute15 => null,
p_attribute16 => null,
p_attribute17 => null,
p_attribute18 => null,
p_attribute19 => null,
p_attribute20 => null,
p_attribute21 => null,
p_attribute22 => null,
p_attribute23 => null,
p_attribute24 => null,
p_attribute25 => null,
p_attribute26 => null,
p_attribute27 => null,
p_attribute28 => null,
p_attribute29 => null,
p_attribute30 => null,
p_attribute31 => null,
p_attribute32 => null,
p_attribute33 => null,
p_attribute34 => null,
p_attribute35 => null,
p_attribute36 => null,
p_attribute37 => null,
p_attribute38 => null,
p_attribute39 => null,
p_attribute40 => null,
p_attribute41 => null,
p_attribute42 => null,
p_attribute43 => null,
p_attribute44 => null,
p_attribute45 => null,
p_attribute46 => null,
p_attribute47 => null,
p_attribute48 => null,
p_attribute49 => null,
p_attribute50 => null,
p_flex_value_meaning => l_value_set_value,
p_description => l_value_set_desc);
when others
dbms_output.put_line (‘Error is ‘ || substr (sqlerrm, 1, 1000));


The below screenshot once the API is Executed.

API - After Exe Independent


For Dependent values





l_enabled_flag     varchar2 (2);

l_summary_flag     varchar2 (2);

l_who_type         fnd_flex_loader_apis.who_type;

l_user_id           number := fnd_global.user_id;

l_login_id         number := fnd_global.login_id;

l_value_set_name   fnd_flex_value_sets.flex_value_set_name%type;

l_value_set_value   fnd_flex_values.flex_value%type;

l_value_set_desc   varchar2 (500);


l_value_set_name := ‘XXDPC_ITEM_CATEGORY_VALUE_T1’;

l_enabled_flag := ‘Y’;

l_summary_flag := ‘N’;

l_who_type.created_by := 6532;

l_who_type.creation_date := sysdate;

l_who_type.last_updated_by := 6532;

l_who_type.last_update_date := sysdate;

l_who_type.last_update_login := 6532;       –l_value_set_name

l_value_set_value :=1263;                       –l_value_set_value

l_value_set_desc := ‘Under Testing check’;

fnd_flex_loader_apis.                   –API to upload the value set

up_value_set_value (

p_upload_phase                 => ‘BEGIN’,

p_upload_mode                 => null,

p_custom_mode                 => ‘FORCE’,

p_flex_value_set_name         => l_value_set_name,

p_parent_flex_value_low       => 60255,                                                             –Independent Value

p_flex_value                   => l_value_set_value,

p_owner                       => null,

p_last_update_date             => to_char (sysdate, ‘YYYY/MM/DD HH24:MI:SS’),

p_enabled_flag                 => l_enabled_flag,

p_summary_flag                 => l_summary_flag,

p_start_date_active           => to_char (sysdate, ‘YYYY/MM/DD HH24:MI:SS’),

p_end_date_active             => null,

p_parent_flex_value_high       => null,

p_rollup_flex_value_set_name   => ‘XXDPC_ITEM_CATEGORY_VALUE_T’,                 –Independent Value set

p_rollup_hierarchy_code       => null,

p_hierarchy_level             => null,

p_compiled_value_attributes   => null,

p_value_category               => null,

p_attribute1                   => null,

p_attribute2                   => null,

p_attribute3                   => null,

p_attribute4                   => null,

p_attribute5                   => null,

p_attribute6                   => null,

p_attribute7                   => null,

p_attribute8                   => null,

p_attribute9                   => null,

p_attribute10                 => null,

p_attribute11                 => null,

p_attribute12                 => null,

p_attribute13                  => null,

p_attribute14                 => null,

p_attribute15                 => null,

p_attribute16                 => null,

p_attribute17                 => null,

p_attribute18                 => null,

p_attribute19                 => null,

p_attribute20                 => null,

p_attribute21                 => null,

p_attribute22                 => null,

p_attribute23                 => null,

p_attribute24                  => null,

p_attribute25                 => null,

p_attribute26                 => null,

p_attribute27                 => null,

p_attribute28                 => null,

p_attribute29                 => null,

p_attribute30                 => null,

p_attribute31                 => null,

p_attribute32                 => null,

p_attribute33                 => null,

p_attribute34                 => null,

p_attribute35                  => null,

p_attribute36                 => null,

p_attribute37                 => null,

p_attribute38                 => null,

p_attribute39                 => null,

p_attribute40                 => null,

p_attribute41                 => null,

p_attribute42                 => null,

p_attribute43                 => null,

p_attribute44                 => null,

p_attribute45                 => null,

p_attribute46                  => null,

p_attribute47                 => null,

p_attribute48                 => null,

p_attribute49                 => null,

p_attribute50                 => null,

p_flex_value_meaning           => l_value_set_value,

p_description                 => l_value_set_desc);



when others


dbms_output.put_line (‘Error is ‘ || substr (sqlerrm, 1, 1000));


API - After Exe Dependent



Originally posted on BITTER REALITIES:

By: J.M.

Poverty means a state of constant stress, a feeling of being powerless, helpless, a kind of hopelessness causing life expectancy to drop for many who struggle throughout their lives, to access basic needs which although were provided free by nature, were made inaccessible by those who defined and enforced the way the world works, while this way has been accepted and passed on through generations, by parents to children.

A holocaust that happens every year, not by the hands of a dictator, rather by the hands of starvation that kills more than 6 million children every year. Six million children die each year yet no one even notices? Is that apathy or is it desensitization? 

We have collectively agreed upon and accepted an economic paradigm, constructed upon predatory values,  having a clear basic flaw which restricts the system to support only a small sector of the world’s population, keeping the majority deprived and…

View original 1,874 more words


Get every new post delivered to your Inbox.

Join 365 other followers