My favourite.....

Thursday, November 12, 2015

Reporting Tools available in Oracle Fusion

The following reporting options are available for Oracle Fusion Cloud product

1. BI Publisher (High volume transactional reports)
2. OTBI (Oracle Transactional Business Intelligence) (Closely related to OBIEE)
3. Financial Reporting Center (Hyperion like)
4. Smart View (Excel plugin)

Wednesday, November 11, 2015

Solution: Unable to run OAF Page from JDeveloper 505 Error

I was usually able to run the OAF pages from JDeveloper without any issues, but after trying to install a oracle database in the c:\oracle folder some settings were messed up, resulting in 505 Error when OAF pages were run.

Fix: to fix this I have gone through the log (the log section we have in the JDeveloper itself) carefully and found what the issue is..

C:\p9879989_R12_GENERIC\jdevhome\jdev\system\oracle.j2ee.10.1.3.41.57\embedded-oc4j\config\server.xml
[waiting for the server to complete its initialization...]
Nov 11, 2015 7:49:23 PM com.evermind.server.jms.JMSMessages log
INFO: JMSServer[]: OC4J JMS server recovering transactions (commit 0) (rollback 0) (prepared 0).
Nov 11, 2015 7:49:23 PM com.evermind.server.jms.JMSMessages log
INFO: JMSServer[]: OC4J JMS server recovering local transactions Queue[jms/Oc4jJmsExceptionQueue].
WARNING: Code-source C:\p9879989_R12_GENERIC\jdevbin\jdev\appslibrt\xml.jar (from in /C:/p9879989_R12_GENERIC/jdevhome/jdev/system/oracle.j2ee.10.1.3.41.57/embedded-oc4j/config/application.xml) has the same filename but is not identical to /C:/p9879989_R12_GENERIC/jdevbin/lib/xml.jar (from (ignore manifest Class-Path) in META-INF/boot.xml in C:\p9879989_R12_GENERIC\jdevbin\j2ee\home\oc4j.jar). If it contains different versions of the same classes, it will be masked as the latter is already visible in the search path of loader default.root:0.0.0.
WARNING: Code-source C:\p9879989_R12_GENERIC\jdevbin\jdev\appslibrt\jazn.jar (from in /C:/p9879989_R12_GENERIC/jdevhome/jdev/system/oracle.j2ee.10.1.3.41.57/embedded-oc4j/config/application.xml) has the same filename but is not identical to /C:/p9879989_R12_GENERIC/jdevbin/j2ee/home/jazn.jar (from in META-INF/boot.xml in C:\p9879989_R12_GENERIC\jdevbin\j2ee\home\oc4j.jar). If it contains different versions of the same classes, it will be masked as the latter is already visible in the search path of loader default.root:0.0.0.
WARNING: Code-source C:\p9879989_R12_GENERIC\jdevbin\jdev\appslibrt\jazncore.jar (from manifest of /C:/p9879989_R12_GENERIC/jdevbin/jdev/appslibrt/jazn.jar) has the same filename but is not identical to /C:/p9879989_R12_GENERIC/jdevbin/j2ee/home/jazncore.jar (from in META-INF/boot.xml in C:\p9879989_R12_GENERIC\jdevbin\j2ee\home\oc4j.jar). If it contains different versions of the same classes, it will be masked as the latter is already visible in the search path of loader default.root:0.0.0.
WARNING: Code-source C:\oracle\lib\xmlparserv2.jar (from manifest of /C:/p9879989_R12_GENERIC/jdevbin/jdev/appslibrt/jazncore.jar) has the same filename but is not identical to /C:/p9879989_R12_GENERIC/jdevbin/lib/xmlparserv2.jar (from (ignore manifest Class-Path) in META-INF/boot.xml in C:\p9879989_R12_GENERIC\jdevbin\j2ee\home\oc4j.jar). If it contains different versions of the same classes, it will be masked as the latter is already visible in the search path of loader default.root:0.0.0.
WARNING: Code-source C:\oracle\jlib\ldapjclnt10.jar (from manifest of /C:/p9879989_R12_GENERIC/jdevbin/jdev/appslibrt/jazncore.jar) has the same filename but is not identical to /C:/p9879989_R12_GENERIC/jdevbin/jlib/ldapjclnt10.jar (from in META-INF/boot.xml in C:\p9879989_R12_GENERIC\jdevbin\j2ee\home\oc4j.jar). If it contains different versions of the same classes, it will be masked as the latter is already visible in the search path of loader default.root:0.0.0.
15/11/11 19:49:26 WARNING: Application.setConfig Application: datatags is in failed state as initialization failed.
java.lang.IllegalAccessError: tried to access method oracle.xml.jaxp.JXDocumentBuilder.()V from class oracle.xml.jaxp.JXDocumentBuilderFactory
Nov 11, 2015 7:49:26 PM com.evermind.server.ServerMessages warningApplicationInitializationFailed
WARNING: Exception initializing deployed application: datatags. Application: datatags is in failed state as initialization failed
Nov 11, 2015 7:49:26 PM com.evermind.server.ServerMessages warningApplicationInitializationFailed
WARNING: Exception initializing deployed application: APPS_OA. Application: APPS_OA is in failed state as initialization failed
15/11/11 19:49:26 WARNING: Application.setConfig Application: APPS_OA is in failed state as initialization failed.
java.lang.IllegalAccessError: tried to access method oracle.xml.jaxp.JXDocumentBuilder.()V from class oracle.xml.jaxp.JXDocumentBuilderFactory
15/11/11 19:49:26 WARNING: Application.setConfig Application: current-workspace-app is in failed state as initialization failed.
java.lang.IllegalAccessError: tried to access method oracle.xml.jaxp.JXDocumentBuilder.()V from class oracle.xml.jaxp.JXDocumentBuilderFactory
Nov 11, 2015 7:49:26 PM com.evermind.server.ServerMessages warningApplicationInitializationFailed
WARNING: Exception initializing deployed application: current-workspace-app. Application: current-workspace-app is in failed state as initialization failed
Nov 11, 2015 7:49:27 PM com.evermind.server.http.HttpMessages internalErrorWhileTryingToInstantiate
SEVERE: Internal error raised tyring to instantiate web-application: webapp defined in web site OC4J 10g (10.1.3) Default Web Site. Application: webapp has been stopped
Upon looking it carefully, I found in those warning that the file version were not the same and copied the ones from jdev to c:\oracle and everything is back!!

Thanks,
Sridhar

Thursday, January 01, 2015

Installing Samba on Ubuntu

First I have to remove the previous installation that was not working..

sudo apt-get autoremove samba samba-common
sudo apt-get autoremove system-config-samba

after that tried to install using..

sudo apt-get install samba samba-common
sudo apt-get install system-config-samba cifs-utils

but when i ran the first command it gives errors saying some dependencies are not met..

tried "aptdcon --fix-install  " to fix if something is damaged..

Installed Samba successfully and Plex Media Server..

this way we can access content via network shared drives across all the other network connected devices

and with PLEX Media server the content is available for DLNA enabled TV.

My smb.conf file..

 #============= Global Settings =================
 
[global]

   workgroup = VIJJUSIDHU1
   server string = sridhar-laptop (Samba, Ubuntu)
   security = share 
   wins support = yes
   usershare allow guests = Yes
[Movies]

   path=/home/sridhar/Videos
   public = yes
   writable = yes
   read only = No

[Pictures]

 path=/home/sridhar/Pictures
        public = yes
        writable = yes
 read only = no

[Music]
 path=/home/sridhar/Music
 public = yes
        writable = yes
 read only = no

[Musicwd]
 path=/media/SRIDHAR/MEDIA/Songs
 public = yes
        writable = yes
 read only = no

in the last section you can observe that the path is  a Portable Harddrive..

For authorizing a Portable HDD to be accessed over network you need to add the device to the

FSTAB.. usually this is located in the /etc/fstab (note that this is the file itself not a Directory)

you will need the UUID of the HDD which you can access from gparted (another application)

Thanks,

Sridhar Gajjala

Monday, August 04, 2014

Supplier Labels Using XML Publisher Horizontally

There is a requirement to print the Supplier Labels Horizontally using BI Publisher.

Usually we can employ the Multiple Columns Property in the word document functionality..

but, this would not work some time as using this would achieve...

1 4 7
2 5 8
3 6 9

where as what we want to achieve is..

1 2 3
4 5 6
7 8 9

for this I would resort back to using table for the purpose..

the F loop would be for the data group and the IF would have this....

since I want to have labels printed on three columns, my logic would be

This along with some cosmetic changes would give the desired result.

Thanks,
Sridhar

Wednesday, July 30, 2014

Making a home NAS Server

I started this project thinking it would be pretty easy but it was not.. well it did add significantly to my learning curve. I have learnt few things about SAMBA, DLNA server, mapping network drives.

The tools/softwares I used for the implementation are..

1. Unused old laptop (Vostr-1400, Intel Dual Core 1.4GHz, 4GB Ram, 160GB HDD)
2. O.S Ubuntu 10.
3. Samba
4. PLEX Media server
5. GParted
6. webmin

The most trying part was to make the shared drives created by GParted available to the other computers on network.

gparted is used to create drives which I also used for extracting information about the portable HDD (UID).

For installing samba and playing around with drives the key file is smb.conf which is available after installing samba on Linux, it is available at /etc/samba/smb.conf

A point to be noted is backing up the original smb.conf.

It is the WorkGroup that gets the samba associated with the other computers running windows 7 with it.

Also I used the webmin which is a more appealing to eye GUI for dealing with the paritions or shared drives.

I will try to add more detail to this going forward, for now I am able to access all the media files through PLEX Media server (on my TV/Phone/Windows media player on windows 7 laptop), and able to upload new content through the same.

AndSMB is another app available on google Play Store which lets my Android phone connect to the samba server and download the media files (songs) to the phone.

Thanks,
Sridhar

Monday, April 09, 2012

Oracle Applications: Creating AP Checks in Oracle R12

Oracle Applications: Creating AP Checks in Oracle R12: Check Printing has changed considerably in Oracle R12. Initially it looked to me to be very complex, but after spending considerable time un...

Sunday, July 27, 2008

My experience in NY

I have came to Newjersey on April 15th, since then I had met a number of people.
I never really have enjoyed the company of new people, so I was not at all ready to come to this place. But things have forced me to come here.

I came here to a friend of mine, Shiva, who was my classmate in my undergraduation. He is a different person. I never thought I would see him again, but he was the only person whom I would rely on, that's because he always cares about others, enquires about the situation and gives advices whether needed or not.

So, the reason I came here was to earn some money for the fee of next semister. It was really hard time for me. It took a week for me to get a job. First I had gone to a Deli store of a pakistani, his name was Kenny, he asked me how long did I intend to stay here, I very innocently told him that am to stay for four months.

He wanted me to come the next day, when I have seen him the next day he told me to come after a week, I thought it was very easy to get a job without lying but it wasn't. He said he will call me back and never did.

I lost all the hope in a couple of days and have started the hunt again. Now it was the turn of some Indian restaurants, even they told the same. I never realized my mistake of mentioning the stay period of foour months that scared them.

After a few days Shiva had told me about a Liquor store. It's name was NYWE. I have gone there the next morning and meet the owner. I told him that I was being referred even though I never seen the person that referred me till now. He said he would call me back but he called me as soon I have left the place.

So everything was going just right. because the pay was good and I was supposed to deliver the order's to door. So I made extra money in the evenings.

So I knew a lot of streets up there at broadway. Mr. Paul said that he cannot give me more hours as he had lot of people, and that had turned me down.

The people I met there were Mr. Tsedo a tibetan settled in darjeeling INDIA, and sereen a nepali woman who settled in assam, and Sagar a nepali kid. There was a mexican guy who was very fast and had good brains named George. He told me a lot of his life here and in Mexico. Then there were two american girls and a american guy. I never used to talk to them.

So, after he made it clear that I won't be getting many hours I thought to myself that this way I wont be able to get much money which was the main purpose I came here, I started looking for more jobs.

Then one day Shiva told me that there was a need in his restaurant. So without any second thought I had left for that. I liked the first one because everyone were good to me.

The job in the restaurant was really not good. I had to work in the kitchen as a food runner.
I started thinking about shifting from that very soon. the people also were not good there.

I have done that job for one and a half month and then left the job for a grossary store which I am currently doing.

more when I go back to CA or change the job.