Wednesday, March 25, 2020

'Java was started but returned exit code 1' Error

Please check the correct java version is installed and java environment is set correctly.

'java -version' in command prompt (cmd) will show you the java version installed
'where java' will show you the java location








Ensure proper version of JDK is installed, you can download JDK from here.
Set the JAVA_HOME environment variable.




Oracle SQL Developer - Increase size of GUI/Font

When you are running SQL Developer on Windows 10, you need to change the compatibility accordingly to get the proper GUI size.

With default compatibility mode 























Change the compatibility mode

1> Right Click on SQL Developer icon and select Properties.
     > Go to the Compatibility tab
     > Compatibility mode change it to windows 7
         > Check the option of Override high DPI scaling behaviour
         > Select "System" in drop down below
6> Apply 

Re-Launch the application


Friday, March 6, 2020

How to use Parameters - Web ADI

Many friends commented about parameter use while importing pl/sql API or concurrent program. Sorry for very late post but here you go.

You can create parameters in the 'Uploader' section.

It can be of four types:
None
Value Set
Fnd Lookup
Bne Query - Simple/Complex

Here I am showing you Bne Query type, Go to 'Uploader' section your integrator and 'Add Parameter'












Provide the details as below and note down the Parameter name, Apply












Provide the details as below and note down the Parameter name











Apply and it should look like this













Now, next and move to the 'Importer' section, here I am calling PL/SQL API. Same will be applied to Synchronous/Asynchronous concurrent request call.













Under the Importer Rule section add the PL/SQL API Call rule.

For source, you have four options
Environment Variables
Import  -- Attributes reference of the 'Interface' section, the value you pass from the Spread sheet
Interface Table
Uplaod Parameters 

Here I am showing how to use parameters we created above and the Environment variables
$env$.userid: returns the current user ID
$env$.appid: returns the application ID
$env$.respid: returns the responsibility ID



And these parameters will appear when you upload the data and Importer will be called