Solved: oracle.adfmf.application does not exist

Post installation of JDeveloper (12.1.3) and after adding the MAF Extension, I created a sample MAF Application by following this tutorial (Oracle JDeveloper 12c (12.1.3) Tutorials - Setting Up Mobile Application Framework ).

I received an error in the console stating that "oracle.adfmf.application does not exist" in "LifeCycleListenerImpl.java" (This is created automatically when you select an MAF Application).

I did some research and stumbled upon the fact that adf-mobile-javadoc.jar contains what I need. Hence the jar was added and the issue disappeared.

Steps to follow:
1. Right-Clicking the ApplicationController project
2. Select "Project Properties..."
3. Select "Libraries and Classpath"
4. Add "JAR/Directory..."
5. Browse to the installation directory of JDeveloper (<InstallatonDirectiry>\jdeveloper\jdev\doc\studio_doc\ohj)
6. Select "adf-mobile-javadoc.jar"
7. Click "Open"
8. Click "OK"
9. Select "Save All"

The error should disappear.

Regards,
Brendon

Oracle Fusion (Business Intelligence) - Creating an Analysis using "Create Direct Database Query"

If  you ever have a requirement in which you need to create an Analysis but do not find the right Subject Area for it, then you can use the "Create Direct Database Query" that OBIEE offers.

Or if you want to place the results of a BIP sql query on a Dashboard (by creating an Analysis). 

Depending on your requirement, you may choose to use this option.

Lets look at the steps to do this:

1. Login to OBIEE (BI Tool)

2. Select New > Analysis > Create Direct Database Query

3. On the Criteria tab
 a. Connection Pool = "HCM_OLTP"."Connection Pool" (add the quotes as well)
 b. SQL Statement = SELECT Last_Name from PER_PERSON_NAMES_F

Note: For FSCM use "FSCM_OLTP"."Connection Pool"

4. Click the "Validate SQL and Retrieve Columns"
 
5. Select the Results tab
 You should see the results that your query returned

6. Save the Analysis

Regards,
Brendon Charles

Inserting values into columns of a Table using '&' with Oracle SQL

So what does one do after say, creating a table?
Insert data into that table of course.

How are we going to do this?
The conventional way is to go with a:

1. INSERT INTO table_name VALUES ( value1, value2, ..., valueN);
2. Else, you can use say a "short cut" of sorts by using '&', like below:

• INSERT INTO table_name VALUES ( &column1, &column2, ..., &columnN);

Basically each time you run the above statement you will be get a prompt to enter the column values, which makes data entry a bit easy.

Note: An error that I faced while using this was:

ORA-00984: column not allowed here

You may come across this, so please find the solution below:

If you are trying to enter a character value, say for example the column column2 is VARCHAR2(20) as per the table structure. 

Then you will have to explicitly enclose the data in single quotes, say 'data for value2 column' is the right way to entering data into column2.

Happy Programming!

Brendon