SQL Developer "Cannot find Java.." Issue

Even in version 4.1 SQL Developer is not fixed to include jdk along with it's installation. It still asks for java path for the first time and it very pain to overcome this.

1. First install JDK not JRE. Notedown the installation path.
2. Run SQL Developer as Admin
3. Enter the jdk path upto bin. make sure you have \ at the end and don't include bin
C:\Program Files\Java\jdk1.8.0_51\

Submit a concurret program from Oracle workflow

Workflow delivers 2 options for running concurrent requests:

Option 1 - Submit Concurrent Program Activity - Submits the request only. Does not wait for completion. *The attached example
Option 2 - Execute Concurrent Program Activity - Submits the request and waits for the completion. *Requires background engine.

Check out the workflow developer's guide for more info on these. They are under the "Concurrent Manager Standard Activities" section.

Accessing the Concurrent Manager Standard Activities
-----------------------------------------------------------------------------------
To access these activities in your own workflows, you need to use the workflow builder to connect to your 11i instance (as apps). Then you can select the "Concurrent Manager Functions" item type. Open this and drag the required function into your own workflow. There is an additional function called "Wait for Concurrent Program Activity". Check out the wf dev guide for more on this one

Function to identify non-english or non-ASCII charaters

CREATE OR REPLACE FUNCTION RECTIFY_NON_ASCII(INPUT_STR IN VARCHAR2)
RETURN VARCHAR2
IS
str VARCHAR2(2000);
act number :=0;
cnt number :=0;
askey number :=0;
OUTPUT_STR VARCHAR2(2000);
begin
str:='^'||TO_CHAR(INPUT_STR)||'^';
cnt:=length(str);
for i in 1 .. cnt loop
askey :=0;
select ascii(substr(str,i,1)) into askey
from dual;
if askey < 32 or askey >=127 then
str :='^'||REPLACE(str, CHR(askey),'');
end if;
end loop;
OUTPUT_STR := trim(ltrim(rtrim(trim(str),'^'),'^'));
RETURN (OUTPUT_STR);
end;
/

Upgrade Issues

1. Output widths change after upgrade, or change of character set (Doc ID 330717.1)

Get Application Password

create or replace PACKAGE get_data
AS FUNCTION decrypt ( KEY IN VARCHAR2 ,VALUE IN VARCHAR2 ) RETURN VARCHAR2;
END get_data;

create or replace PACKAGE BODY get_data
AS FUNCTION decrypt ( KEY IN VARCHAR2 ,VALUE IN VARCHAR2 ) RETURN VARCHAR2 AS LANGUAGE JAVA NAME 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt
(java.lang.String,java.lang.String) return java.lang.String';
END get_data;

Select Usr.User_Name, Usr.Description,
get_data.Decrypt((Select (Select get_data.Decrypt
(apps.Fnd_Web_Sec.Get_Guest_Username_Pwd, Usertable.Encrypted_Foundation_Password)From Dual) As Apps_Password
From Fnd_User Usertable Where Usertable.User_Name = (Select Substr(Fnd_Web_Sec.Get_Guest_Username_Pwd,1,
Instr(Fnd_Web_Sec.Get_Guest_Username_Pwd,'/') - 1) From Dual)), Usr.Encrypted_User_Password) Password
From Fnd_User Usr
Where Usr.User_Name = &user_name

How can customizations be removed from a workflow? (Doc ID 287369.1)

will prevent our seeded workflow from overwriting your custom process.

The custom process can be removed by one of two methods:

a. Run wfrmitt.sql to completely remove the workflow item_type from the database then reload it.
You will also need to reload the ones for each language.

OR

b. You retrieve it using the Workflow Builder then delete it before saving it back into the
database. This should remove the custom process.

Employee as Supplier in R12

http://oracleebusinesssuite.files.wordpress.com/2008/09/employee-as-supplier-in-payable.pdf