Blog Aggregator

Thanks to the gracious folks at Oracle Certification Program, the exam deadline for the EBS R12 exams have been extended to January 31, 2009.
The production exams would be released around first week of April, 2009 or about 8 weeks after the end of the beta exam period. The beta exam results would be informed to candidates around mid-April, 2009.
The picture above shows the Oracle Corporation headquarters at Redwood Shores, California. The glass and steel buildings are shaped like cylinders representing the eponymous Oracle database. The blog editor spent eventful years inside the cylinder before moving to a new address last month. The beta exam dates have been extended for the following exams: 1Z1-206 Oracle E-Business Suite R12: System Administration
1Z1-215 Oracle EBS R12: General Ledger and Payables Fundamentals
1Z1-216 Oracle EBS R12: General Ledger and Receivables Fundamentals
1Z1-225 Oracle EBS R12: Inventory and Purchasing Fundamentals
1Z1-226 Oracle EBS R12: Inventory and Order Management Fundamentals
1Z1-238 Oracle EBS R12: Install, Patch and Maintain Applications
1Z0-244 Oracle EBS R12: Advanced Supply Chain Planning

Many certification candidates who are in the middle of their certification exam preparation had requested for a date extension and once again the Oracle team has been most receptive and accommodating.
Blog readers are encouraged to participate in the EBS R12 Beta Challenge. A new announcement about more prizes as part of the Beta Challenge will be published next week. The OCP Blog Beta Exam Challenge Winners would be announced in May 2009.

Meanwhile, there is more than 100 days now to become one of the first EBS R12 certified professional!

I arrived yesterday afternoon in the Gold Coast and got a bus to my hotel, the Conrad Jupiters Casino. My first impression of the Gold Coast was not too good. It is essentially a big holiday resort. The fact I was staying in a casino gave me a bit of a flashback to Vegas.

On arriving at the hotel I noticed there was a pool, so I went straight out and had a swim. This made me feel a little more positive. Then I noticed there was a gym with a room where they teach fitness classes. The room was empty so I went back to my room, got my Yoga mat and did an Ashtanga practice. It was cool not having to practice in my hotel room. Too many distractions. After this I was feeling up for a wander around.

After leaving the hotel I walked through a shopping center and a restaurant area, then out on to the beach. This is when I realized I was going to like the Gold Coast. The beaches are long and wide with white sand. It is the perfect place to bring kids on holiday, hence the holiday resort developments. I’ve got 2 days before the conference starts so I’m going to spend my time between the beach, the gym and the pool. I’m going to try and blank out the casinos and holiday resort feel as they will only spoil it for me.

I would post photos only the hotel internet charges are extortionate, so I’m using a public terminal. Unless I get internet access at the conference, I probably won’t be online much until I reach New Zealand.

Cheers

Tim…

SEPA in system context have things which is really important. IBAN Code BIC Validation SEPA customer credit transfer, based on the ISO20022 format (XML) So lets see why IBAN and BIC is so important.Take a note, SEPA schemes use BIC and IBAN codes to uniquely identify bank accounts IBAN (International Bank Account Number) The IBAN is provided by the bank [...]

Banks and their corporate customers are about to enter an era of profound global business change. In January 2008, foundations were laid for a Single Euro Payments Area (SEPA) – a process that aims to deliver harmony in all financial transactions across Europe, and create the conditions for much greater standardization in the movement of money [...]

Sometime back ,my client Finance IT manager asked about few queries for documentation details for Oracle, the reason was obvious as they have moved out from SAP to Oracle. Hope this information might be helpful to for Managers, line manager who are planning to go with Oracle EBS or recently started using Oracle. What are the [...]

This is short note for subledger reconciliation reports which helps during period end closure. Reconciliations – Subledger Accounting on-line account reconciliation to streamline the reconciliation process. Subledger Journal Entry Report : This will display detailed Header & Line information for Subledger and General Ledger journal entries by Source & Category Subledger Account Analysis : This report can be [...]

SLA(Sub Ledger Accounting) -Characteristics All SLA data is stored in SLA and is imported to GL from SLA. A protocol exists to ensure all subledgers are transferring data into SLA consistently Creates the final accounting for Subledger Journal Entries (JEs) and transfers the accounting to GL During reconciliation subledgers to GL, all reconciliation reports point to the SLA [...]

I have posted a number of previous notes defining and discussing Oracle diagnostics. This tool is enhanced because of new security model.Let’s take a quick look on revisiting this utility. Six reason why ‘Everyone like Oracle Diagnostic’ Oracle E-Business Suite Diagnostics is a framework and a repository of diagnostic tests. These are six top reason why [...]

UPK Pre-built Content You can take advantage of UPK pre-built content for pre-”go-live” and “post go-live” support training need. Pre Built Content are created by the Applications Development Documentation teams and documenting best practices for system processes within the Oracle applications. You can use this tool to educate your project teams, core user, power user, and [...]

If your business need to drill down the Reporting for your financial report like Balance sheet ,P & L or Cash Flow then you can explore these options in EBS : Financial Analyzer Report Manager Summary Accounts online drill down Third Party tools like GL WAND where you can run the report or multiple report through Excel and drill [...]

Nine months since the launch of SEPA, Oracle has finally released patch for SEPA Credit Transfer (SCT) for much demanded need for European EBS customer. High Points of SEPA Project Lets recap some of high points of SEPA project. Objective: Harmonize electronic payment schemes according ISO 20022 rules. Countries: Euro zone countries Transactions: Only Euro transactions. Period: From January 1, 2008.The [...]

This year in OOW 2008, Oracle CEO Larry Ellison announced a new storage server product, Exadata, a hardware/software solution for offloading I/O processing to proprietary storage nodes. This is first time when Oracle moved in hardware side.Exadata is joint effort by Oracle and HP . Oracle has put up in 22 page paper. The newly Exadata [...]

I have been trawling through our documentation lately. Looking for something else I came across something that I have been asked for lately. The need to keep paragraphs of text together! This functionality was actually delivered back in 10.1.3.3.3, here... Tim Dexter

A “gaucho” by Florencio Molina Campos Here is my self introduction to TalentedApps and 8 things you may or may not know about me.

1. First of all, I am a boy.  I know, my name makes you think of a mermaid, but it is a boy’s name where I come from.  It is supposed to be pronounced differently but I’ve given up on that.  I hope that if we’ve met before this is not something you did not know about me.
2. So where do I come from? One could argue that from the southernmost country on the planet (although I didn’t see snow until I was 17).  A place you definitely want to visit at least once in your life.  The land of San Martin, Gardel, Peron, Borges and Maradona.  Although lately I find more people who can recognize the name of Manu Ginobili more than they can recognize any of these other names.  This place is Argentina.
3. I wrote a short story when I was 8.  It was about chocolate and madness.  It was huge success among family members.  Unfortunately, it followed the same destiny as the Colossus of Rhodes and the Statue of Zeus at Olympia (although of slightly smaller artistic value).  
4. I was passionate about insects and spiders as a child.  I used to say I’d be an entomologist when I grew up until I actually met one and realized the life this person lived.  At about 13 years of age I decided I would be better off focusing my energy on my other passion, which would later become my professional career (software).
5. I migrated to the US in 2002.  This was mostly due to the economic crisis that hit Argentina on December 2001.  I was working then at Peoplesoft Argentina when our VP of development paid us a visit and said our team would be disbanded so we should better start looking for other opportunities.  I received an offer to transfer to Peoplesoft Inc and move to the US.  I had tremendous doubts about moving to another country, especially one on the other side of the planet.  The offer was coming from who would become one of the best managers I’ve had, a frequent blogger on this website who I will always be thankful to.  I finally decided to go with it so I married my lifelong girlfriend, jumped on a plane and started a new life.
6. Moving to the US was challenging in pretty much every aspect.  From the obvious missing family and friends to having to learn how to do a large number of things again.  The hardest aspect was language (despite years of formal education in the English language).  Communication had always been one of my strongest skills (in Spanish of course) and all of a sudden I was crippled.  And consequently I kept quiet for a long time.  Despite positive reinforcement from my manager, it took me several years to partially overcome my self imposed limitation.  360 feedback helped me enormously.
7. My life changed again when my first son was born in 2005.  I had heard  many times that children change your life.  Now I think it is more accurate to say that they actually take it away from you.  And still you can’t figure out how you could possibly have lived this long without them.  My second son arrived 16 months later.  Yes, our hands are quite full and my wife and I constantly remind each other about how very lucky we are.
8. Among other things, I am a carnivore (why can there be vegetarians and vegans but not carnivores?), I use lots of sugar on my coffee (and I probably drink too much of it),  I have a serious spatial orientation disability (which conflicts with the fact that I am a pilot).  I love football (although I had to learn to call it soccer) and I am looking forward to South Africa 2010.  And here it is, a bit more than 8 things about me.

      

Given the number of questions I've fielded about Active Data Guard through other channels, it was inevitable that my recent article about strategies for handling EBS reporting loads would prompt questions about its compatibility with the E-Business Suite.  The answer to this deceptively-simple question is only meaningful if you understand what's happening behind the scenes when users log into the E-Business Suite.  This article compares the operational implications of using Oracle Active Data Guard versus Oracle Data Guard in E-Business Suite environments. Steven Chan http://blogs.oracle.com/stevenChan/about.html

JMS is a bit different in JDeveloper 11G and WebLogic 10.3 then when you use OC4J 10.1.3. This blog will show you how you can create a Queue and Connection Factory in WebLogic and use this in one of your JDeveloper 11g projects.
First you have to add two libraries to the project, The first is the AQJMS library ( even when we don't use AQ ) and the second library is the WebLogic 10.3 thin Client

Start the weblogic server. Menu Run , Start Server Instance


The url is http://localhost:7101/console. Username weblogic password weblogic.


Default the weblogic server has an empty configuration. We need to create a new jms server with a database of file persistance. We need this for the queue or topic persistence

create a new jms system module. In this module we will create a new connection factory and queue
Select the just created jms module and create a new connection factory first.



Create a new queue

Make sure that the queue uses the jms server. See the targets this can't be empty

And here is the java code to test the connection factory and the queue

The difference with oc4j is that you use other jndi properties. This are the right properties for WebLogic 10.3 in JDeveloper 11g

java.naming.factory.initial weblogic.jndi.WLInitialContextFactory
java.naming.provider.url t3://localhost:7101
java.naming.security.principal weblogic
java.naming.security.credentials weblogic

package nl.ordina.jms;

import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.sql.Timestamp;
import java.util.Properties;
import javax.jms.JMSException;
import javax.jms.Queue;
import javax.jms.QueueConnection;
import javax.jms.QueueConnectionFactory;
import javax.jms.QueueReceiver;
import javax.jms.QueueSender;
import javax.jms.QueueSession;
import javax.jms.Session;
import javax.jms.TextMessage;
import javax.naming.Context;
import javax.naming.InitialContext;

public class WeblogicClient {

    private QueueConnection         connection  = null;
    private QueueSession            session     = null;
    private QueueSender             sender      = null;
    private QueueReceiver           receiver    = null;
    private Queue                   queue       = null;
    private long                    waitTime    = 0;


    public WeblogicClient() {
        setUp();
        put();
        get();
        tearDown();
    }

    public static void main(String[] args) {
        WeblogicClient weblogicClient = new WeblogicClient();
    }

    public void tearDown() {
        try {
            sender.close(); 
            receiver.close(); 
            session.close(); 
            connection.close();

        } catch (JMSException je) {
            je.printStackTrace();
        } finally {
        }
    }

    public void get(){
        try {
            javax.jms.TextMessage textMessage = (javax.jms.TextMessage)receiver.receive();
            System.out.println("Receiving message [" + textMessage.getJMSMessageID() + "] enqueued at " + new Timestamp(textMessage.getJMSTimestamp()).toString());
            String xmlText = textMessage.getText();
            System.out.println(xmlText);
        } catch (JMSException jmse) {
            jmse.printStackTrace();
        }
    }

    public void put(){
        String messageId = null;
        String xmlData = "";
        FileInputStream fis;
        try {
            fis = new FileInputStream("D:\\projecten\\mhs_esb\\delfor.xml");
            int x= fis.available();
            byte b[]= new byte[x];
            fis.read(b);
            xmlData = new String(b);
        } catch (FileNotFoundException e) {
            // TODO
        } catch (IOException e) {
            // TODO
        }
        try {
              TextMessage message = session.createTextMessage(xmlData);
              sender.send(message);
        } catch (JMSException jmse) {
                 jmse.printStackTrace();
        }
    }

    protected void setUp() {

        String queueName = "jms/QTest";
        String queueConnectionFactoryName = "jms/CFTest";
        Context ctx;

        try {
            Properties parm = new Properties();
            parm.setProperty("java.naming.factory.initial","weblogic.jndi.WLInitialContextFactory");
            parm.setProperty("java.naming.provider.url","t3://localhost:7101");
            parm.setProperty("java.naming.security.principal","weblogic");
            parm.setProperty("java.naming.security.credentials","weblogic");

            ctx = new InitialContext(parm);

            QueueConnectionFactory connectionFactory = 
            (QueueConnectionFactory)ctx.lookup(queueConnectionFactoryName);

            connection = connectionFactory.createQueueConnection();        
            connection.start();        
            session = connection.createQueueSession(false, Session.CLIENT_ACKNOWLEDGE);          
            queue = (Queue)ctx.lookup(queueName); 
            sender   = session.createSender(queue); 
            receiver = session.createReceiver(queue); 


        } catch (JMSException je) {
            throw new RuntimeException("Fout opgetreden bij het starten ",je);
        } catch (Throwable t) {
            throw new RuntimeException("Fout opgetreden bij het starten ",t);
                                       
        }
    }

}

Store expressions as virtual columns in Oracle 11g. October 2008

It seems I’m not the only one who has thought to use cartoons to explain databases to others. On Amazon, you can now pre-order The Manga Guide to Databases, a graphic novel about database technology.

Follow Tico the Fairy as she teaches Princess Ruruna how to simply management of her nation with a well made database.

Why not? Google used a comic to sell their new Chrome browser, after all!

This came in my inbox today. Looks like AIOUG (All India Oracle User’s Group) is organizing a tech event in Bangalore. Since i am in Bangalore now, i thought i would attend this event as well. So, if you are in Bangalore and if you want to be part of a user group, just come along as the registration is free. You can register yourself here. If you are coming in and want to meet up, just drop me an email (my email is in the contact me page). Lets see how the event goes.

From AIOUG       

An Oracle DB user which has been granted CREATE ANY DIRECTORY can use that system privilege to grant themselves the SYSDBA system privilege by creating a DIRECTORY pointing to the password file location on the OS and then overwriting it with a previously prepared known binary password file using UTL_FILE.PUT_RAW from within the DB. This paper [...]