27 July 2012

Here are the steps to port your mobile number to another service provider

1. First, you need to generate a UPC (Unique Porting Code).
This can be done by sending an SMS to 1900.
The SMS should be in this format: PORT Eg: PORT <99XXXXXXXX>.
This should be sent to 1900
Operator SMS charge will be applicable.
PM to flag off nationwide roll-out of MNP on Jan 20
2. In reply, you will receive a UPC (Unique Porting Code) as SMS from 1901.
The UPC will be an 8 digit alpha-numeric code. You will also receive the date till when the UPC will remain valid in the MM/DD/YYYY format.
3. Send the UPC to the service number of the mobile operator you wish to switch to, through an SMS, if such a number is available.


You can confirm by visiting the operator's website. Else, visit the nearest outlet/showroom of the operator you want to migrate to with your UPC in hand.
4. Some service providers charge a nominal fee for the process, while others like BSNL have advertised free porting.
5. You will also have to fill and submit the prescribed Mobile Number Portability form to the new operator. They could also ask you to submit documents (like photo ID and address proof). Post-paid subscribers will be asked to submit a copy of their latest bill too.
Also See: India's most trusted brands
6. Your request could be denied if any of these factors apply:
You have an unpaid bill on your existing postpaid mobile number.
Pending request for change of ownership of the concerned Mobile Number
The mobile number is under contractual obligation
90 Days has not lapsed since number activation
90 Days has not lapsed since last Porting Request from the same Mobile Number
You have applied for inter-circle porting
There is a pending legal case against your mobile number
7. The number portability has to be completed within 7 working days as per process mandated by DoT.
You will receive an SMS mentioning the time and date for porting.
Your mobile phone may go 'dead' for 120 minutes, at the time when the porting takes place. At the end of it, your migration to your new operator should be complete.
8. Once the switch is complete, you will receive another SMS from the new operator.
9. One thing you must keep in mind - You can change your operator only once in every 90 days. So, use the service with care

12 May 2012

what are the accounting entries which get affected in order to cash cycle


For Order to Cash Entries.


Step 1:    Sales order creation -  No entries


Step 2:    Pick release :  Inventory Stage A/c Dr
                           To Inventory Finished goods a/c  

Step 3:   Ship confirm :   Cogs A/c Dr
                           Inventory Organization A/c.


Step 4:  In Receviable :  Receviable A/c dr
                          To Revenue A/c
                          To Tax 
                          To Freight
step 5:  When the reciept is not applied to the transaction

Unbilled receivabels a/c dr
to receivables a/c   cr

Step 6:    Cash           :  Cash A/c Dr
                             Receivable A/c cr

Processing Cash Receipts-Oracle Apps



Processing Cash Receipts

There are three steps to processing cash receipts:
1.       Enter a receipt
2.       Apply the receipt
3.       Create journal entries
Order To Cash Cycle - Cash Receipt Processing Steps
Order To Cash Cycle - Cash Receipt Processing Steps
The last process in the Order to Cash Cycle is to collect payment from your customer.  The first step is to enter the receipt.  You can enter a receipt three ways:  manually entering it, using the lockbox program, or by using automatic receipt process.  After the cash receipt has been entered into the Receivables module, you will need to apply the receipt to your invoice.
Apply cash receipt varies based on how you have entered the receipt in step 1.  If you have manually entered your receipt, then you will need to manually apply the receipt to your invoice.  If you are using the lockbox program, you can set rules to automatically apply the receipt.   Sometimes, you will still need to apply the receipt manually if the lockbox program cannot determine the correct invoice.  Lastly if you are creating receipts using the automatic receipt process, the receipt is automatically when the receipt is created.

Oracle Apps Tutorial: Overview of the Order to Cash Cycle in Oracle R12



There are four high-level processes in the Order to Cash cycle.  The first is processing the order, the second is processing the invoice, the third is recognizing the Cost of Goods (COGS), and the last is processing the cash receipt.
Order To Cash Cycle
Order To Cash Cycle

Order Processing

There are five steps to processing an order:
1.       Enter an order
2.       Book the order
3.       Pick release the order
4.       Ship confirm the order
5.       Close the order
Order To Cash Cycle - Order Processing Steps
Order To Cash Cycle - Order Processing Steps
A sales order is an agreement between you and your customer to sell them a product (i.e. inventory item) at a specific price.  When you enter the order into the Order Management module, you will specify the customer, the ship-to location, the item, and the item’s selling price.  When you have completed the order (and the customer agrees to the order), then you perform step 2 and book the order.
Booking the order notifies the planning and shipping modules that the order has been finalized and can be included in the supply chain planning process.  The planning modules will determine if you need to buy or make the item.  Once the item has been purchased or manufactured, you will perform step 3 and pick release the order
Pick releasing the order will allocate on-hand inventory to your order and tell the warehouse to move the item from inventory to the shipping staging area.  Once your item is in the shipping staging area, it is ready to be shipped.  At this point you are ready to perform step 4 and ship confirm the order.
Ship confirming the order tells Oracle that the shipment is complete and to decrement the on-hand inventory.  During this process, Oracle will also print out any shipping documents that you need.  Invoice lines will also be generated this process for the shipments on your order.  If you wish, you can configure the order to only generate invoice lines when all order lines have been shipped.  After the shipment process is complete, you are ready for step 5 – closing the order.
Closing the order will prevent you from adding additional lines to the order.  If you do not manually close the order, Oracle’s workflow will close all orders that do not have open lines at the end of the month.  The process of closing orders helps Order Management and Shipping programs run more efficiently because they only look for open orders.
Invoice Processing
There are four steps to processing an invoice:
1.       Import
2.       Print
3.       Revenue Recognition
4.       Create journal entries
Order To Cash Cycle - Invoice Processing Steps
Order To Cash Cycle - Invoice Processing Steps
As we discuss in order processing, the invoice lines are generated during the shipping process.  Order Management uses the “Order Line” workflow to load records into the AR invoice open interface tables.  You can perform step 1, Import the invoices, by using the AutoInvoice program.   After you successfully import your invoices, you are to perform step 2 and print your invoices.
Printing your invoices is pretty straight-forward, you can use the Print invoice program to print all new the invoices.  Once the invoice is printed, Oracle will record the date it was printed on the invoice header.  If you need to re-print the invoice, you can use another program to print only select invoices.
At the same time you are printing your invoice, you can run the revenue recognition program.  This program will determine if there any revenue rules attached to your invoice and if those rules require revenue to be deferred.  Once you have run the revenue recognition program, you can perform step 4 and create the journal entries.
In R12, all journal entries are created by using Subledger Accounting programs.  In Receivables, you can create journal entries by using the “Submit Accounting” program or you can create the journal entry by going into the Invoice and clicking on the Create Accounting on the Tools menu.

Recognizing Cost of Goods Sold (COGS)- Oracle R12



Recognizing Cost of Goods Sold (COGS)

There are three steps to processing Cost of Goods Sold:
1.       Defer cost of goods
2.       Recognize cost of goods
3.       Create journal entries
Order To Cash Cycle - Cost Of Goods Sold Processing Steps
Order To Cash Cycle - Cost Of Goods Sold Processing Steps
In R12, the Cost of Goods Sold is automatically deferred when the item is shipped.  This deferral happens when the Shipping module interfaces a Sales Order Issue transaction to the Inventory module.  After you have recognized revenue in the Receivables module, you can perform step 2 and recognize Cost of Goods Sold.
You will need to run three programs:  Record Order Management Transactions, Collect Revenue Recognition Information, and Generate COGS Recognition Events.  These programs will calculate the percent of COGS to recognize based on the percent of revenue that was recognized.  The Generate COGS Recognition Events program will create a new transaction record in the Inventory module for accounting.  Once you have these three programs you are ready to perform the last step and create accounting.
In R12, all journal entries are created by using Subledger Accounting programs.  The transactions in the Inventory module are accounted for in the Cost Management module, you can create journal entries by using the “Create Accounting – Cost Management” program.

10 May 2012

How to post HTML or XML in blogs

While writing tutorials or asking a question, sometimes it becomes very necessary to post html and javascript codes in your blog comment forms powered by Blogger. You have seen many authors posting HTML effectively but when some of you try to do it, you get an error. This is because Blogger Comment form doesn't support direct posting of HTML and JavaScript. In order to help you to do that we will need to change/encode the same code into a text and then post it effectively without any error. The Tool below will help you to change HTML characters to simple text, which could be easily inserted in your blogger template and comment form. You can also use it to convert your adsense code into an embeddable form. It converts special characters in this way,
'<' becomes '& l t ;' '>' becomes '& g t ;'
'"' (double quote) becomes '& q u o t;'
''' (single quote) becomes ' & # 0 3 9 ;'
'&' becomes '& a m p;'

Use URL : http://centricle.com/tools/html-entities/

To convert the HTML/XML codes

Invoking web services in Oracle using SOAP

Introduction:-
This document gives fair knowledge of invoking web services using Oracle 9i. Oracle9i allows direct access to web services from PL/SQL using the UTL_HTTP package. This document explains step by step process to invoke web services using UTL_HTTP. Communication between client and server is implemented by SOAP protocol.
What is WSDL?
WSDL stands for Web Services Description Language. It is written in XML and treated as an XML document. The document describes a Web service. It specifies the location of the service and the operations (or methods) the service exposes. WSDL is not yet a W3C standard. It is a language proposed by IBM and Microsoft for describing the capabilities of web services. WSDL is a specification defining how to describe web services in a common XML grammar. WSDL describes four critical pieces of data:
1) Public functions available with the web service
2) Data type information for all message requests and message responses
3) Binding information about the transport protocol to be used (GET or POST method to be used)
4) Address information for locating the specified service (URL to be used to access web service)
In a nutshell, WSDL represents a contract between the service requestor and the service provider, The crucial difference is that WSDL is platform- and language-independent and is used primarily (although not exclusively) to describe SOAP services. Using WSDL, a client can locate a web service and invoke any of its publicly available functions. WSDL therefore represents a cornerstone of the web service architecture, because it provides a common language for describing services and a platform for automatically integrating those services.
The WSDL Specification
WSDL is an XML grammar for describing web services. Some of the major elements are mentioned below. Examples mentioned in each specification are taken from the WSDL example which is attached as a screen shot.

• Definitions
The definitions element must be the root element of all WSDL documents. It defines the name of the web service, declares multiple namespaces used throughout the remainder of the document, and contains all the service elements described.
<?xml version="1.0" encoding="utf-8" ?>
<wsdl:definitions xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/" xmlns:tm="http://microsoft.com/wsdl/mime/textMatching/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:mime="http://schemas.xmlsoap.org/wsdl/mime/" xmlns:tns="http://fxpress.com/webservices" xmlns:s="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://schemas.xmlsoap.org/wsdl/soap12/" xmlns:http="http://schemas.xmlsoap.org/wsdl/http/" targetNamespace="http://fxpress.com/webservices" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">

• Types
The types element describes all the data types used between the client and server. WSDL is not tied exclusively to a specific typing system, but it uses the W3C XML Schema specification as its default choice. If the service uses only XML Schema built-in simple types, such as strings and integers, the types element is not required.
<s:element name="GetForeignCurrencyCalendarMonthEndRates"><s:complexType><s:sequence>
<s:element minOccurs="1" maxOccurs="1" name="month" type="s:int" />
<s:element minOccurs="1" maxOccurs="1" name="year" type="s:int" />
</s:sequence></s:complexType></s:element>
<s:element name="GetForeignCurrencyCalendarMonthEndRatesResponse">
<s:complexType><s:sequence>
<s:element minOccurs="0" maxOccurs="1"name="GetForeignCurrencyCalendarMonthEndRatesResult">
<s:complexType><s:sequence><s:element ref="s:schema" />
• Message
The message element describes a one-way message, whether it is a single message request or a single message response. Message parameters or message return values are defined in tag.
<wsdl:message name="GetForeignCurrencyCalendarMonthEndRatesSoapIn">
<wsdl:part name="parameters" element="tns:GetForeignCurrencyCalendarMonthEndRates" />
</wsdl:message>
<wsdl:message name="GetForeignCurrencyCalendarMonthEndRatesSoapOut">
<wsdl:part name="parameters" element="tns:GetForeignCurrencyCalendarMonthEndRatesResponse"/>
</wsdl:message>
• PortType
The portType element defines the operation adopted for client server communication.
For example, a portType can combine one request and one response message into a single request/response operation, most commonly used in SOAP services.
<wsdl:port name="BoeingRetrievalSoap" binding="tns:BoeingRetrievalSoap">
<soap:addresslocation="https://treasury2.fxpress.com/Secure/WebServices/BoeingRetrievalTest
/BoeingRetrieval.asmx" />
</wsdl:port>
• Binding
The binding element provides specific details on how a portType operation will actually be transmitted over the wire. HTTP GET and POST bindings are generally used in the operation. The HTTP GET binding adds any input parameters to the operation to the uniform resource locator (URL). But, the HTTP POST binding sends the parameters in the request body.
GET
The GET binding request does not send a request document. Instead, you attach all of the necessary parameters in the query string to the URL You can attach a query string to the URL with a question mark (?). The delimiter between any parameter=value pair is the ampersand (&). The following example is a GET binding request that uses a query string with the question mark, and a delimiter. In this way whatever you will send will be seen by other user so can say that it is not even secure.
http://server:port/contextRoot/group/dadx/operationName?param1=abc¶m2=1234¶m3=thi&20is&20a&20parameter

POST
The Post method is more powerful request. By using Post we can request as well as send some data to the server. We use post method when we have to send a big chunk of data to the server, like when we have to send a long enquiry form then we can send it by using the post method.
A POST binding issues an HTTP POST request. A POST bind request sends a request document. The document contains the request parameter, but the parameter is not in XML format. An HTTP client application, such as a Web browser, creates the request document. A Web browser usually creates a request document from input forms that are sent to the server.