Oracle – Jitendra Zaa's Blog

Create BPA Script in Oracle Utilities to invoke UI Map

posted by Jitendra on June 15, 2011 under category JAVA, Oracle and tagged as CC&B /ORMB / SPL with 3 Comments

This is the fourth article in series And we will see how to Create BPA Script in Oracle Utilities to invoke UI Map.

In this post, i will discuss on creating the BPA Script to invoke the UI Map.

Navigate to “Admin Menu | S | Script +” and the details as per below image:

Creating BPA Script in Oracle Utilities / ORMB / CC&B — Creating BPA Script in Oracle Utilities

Continue reading “Create BPA Script in Oracle Utilities to invoke UI Map”

Creating UI Map in Oracle Utilities

posted by Jitendra on June 15, 2011 under category JAVA, Oracle and tagged as CC&B /ORMB / SPL with Leave a comment

This is the third article in series for creating the UI Map in Oracle Utlities / CC&B / ORMB

This is the third article in series to create the UI Map in Oracle Utilities. In Previous two article we have seen that how to create the Business Service, Data Area and Service Program.

Navigate to “Admin Menu | U | UI Map +“. Give the UI Map Name as “CM_PERINPUT” and select “UI Map Type” = Complete HTML Document.

Creating UI Map in Oracle Utilities / CC&B / ORMB — Creating UI Map in Oracle Utilities

Continue reading “Creating UI Map in Oracle Utilities”

Creating Business Service and Service Program in ORMB / CC&B / Oracle Utilities

posted by Jitendra on June 15, 2011 under category JAVA, Oracle and tagged as CC&B /ORMB / SPL, Eclipse with 2 Comments

Creating Business Service and Service Programin ORMB / CC&B / Oracle Utilities

In Previous article, we have seen that how to create the Data Area and benefits of using Data Area. This article will focus on creating the Business Service and Service Program in CC&B.

First we have to create the Business Service in application then we have to code it in JAVA and deploy the updated “cm.jar“ file on server.

Go to “Admin | S | Service Program +“ and enter the Service name, Description and select the “Java Based Service” as Service Type. In this example my service name is “PERSER“.

Now go to “Admin | B | Business Service +“ and enter the Business Service name and select the previously create service “PERSER“ for Service Name using look up. In this case the Business Service Name is “CM_PERSER“.
Now go to the “Schema” and add following code and click on Save. Continue reading “Creating Business Service and Service Program in ORMB / CC&B / Oracle Utilities”

Step by Step tutorial for creation of Business Service, Data Area, UI Map and BPA Script in ORMB / CC&B / Oracle Utilities for beginners

posted by Jitendra on June 14, 2011 under category JAVA, Oracle and tagged as CC&B /ORMB / SPL with 5 Comments

Step by Step tutorial for creation guide of Business Service, Data Area, UI Map and BPA Script in ORMB / CC&B / Oracle Utilities for beginners

Before starting this demo application, I am assuming that you already have done CC&B set up on your local and Eclipse is configured.
What I am going to do so that I can use Business Script, Data Area, UI Map and BPA Script?
In this tutorial, I will create one UI Map which will take the person name as input and display list of all the person names as per input.
Final output screen would look like:

UI Map in ORMB/CC&B/Oracle Utility with BPA Script

Continue reading “Step by Step tutorial for creation of Business Service, Data Area, UI Map and BPA Script in ORMB / CC&B / Oracle Utilities for beginners”

Resolve Missing Builder error for eclipse in CC&B (ORMB)

posted by Jitendra on May 11, 2011 under category JAVA, Oracle and tagged as CC&B /ORMB / SPL, Eclipse with 2 Comments

How to Resolve Missing Builder error for eclipse in CC&B (ORMB)

CC&B (Customer Care And Billing System) or ORMB (Oracle Revenue Management And Billing System) (Previously named as “SPL” before Oracle acquires it) are the same application with use in different domain. This application is used to maintain all the billing, collection and payment related operations of the underlying company. I am going to write few articles on this product from today which i feel can be helpful to others.

One problem faced by most of the starters of CC&B (ORMB) in eclipse is “Missing Builder (com.splwg.tools.dbConnection)” error as shown in below image.

Because of this error, eclipse does not compile any java files and therefore “cm.jar deployment” doesn’t work. Continue reading “Resolve Missing Builder error for eclipse in CC&B (ORMB)”

Resolve error – ORA-28000: the account is locked

posted by Jitendra on May 10, 2011 under category Oracle, SQL and tagged as Oracle, SQL with 8 Comments

How to Resolve error – ORA-28000: the account is locked

It is the chance that you might come across the error “ORA-28000: the account is locked“. To unlock the account, run below sql query in Oracle using admin user.

Lets say that you want to unlock account “om” in oracle

alter user om account unlock;
grant connect, resource to om;

I hope it would be helpful for the readers.