Wednesday, December 24, 2014

GST and its Impact on India's Consumer, Manufacturing, Service Sector, State and Central Government

Introduction of GST in India is going to be big boom for domestic IT industry. Tax software will need changes to handle tax credit feature introduced by GST. For export of goods or services there will be GST at the rate of 0%. This is going to impact on Inter-Company transactions setup done in existing Oracle EBS and Hyperion and all tax related setup.

Companies will have to create new account to keep track of GST related transaction. Lot of existing central and state taxes need to be end dated and changes need to be done in tax rules for items which are tax exempt. Petrol, alcoholic liquor for human consumption will still have all the taxes but no GST. Tobacco and tobacco products would be subject to GST. In addition, the Center could continue to levy Central Excise duty and the States to levy sales tax / VAT.

Abolition of Octroi will reduce lead time for procurement. That will trigger some changes into Oracle EBS such as updating lead time and replenishment of stock level.  Companies might reduce there number of warehouses because of tax saving and increased supply chain efficiency.

Government has created a Goods and Service Tax Network (GSTN), the quasi-government company ( http://gstn.org/) and is in the process of finalising the tender for selecting a managed service provider an IT firm to which a majority of the mandate will be outsourced.

Read More: http://www.business-standard.com/article/economy-policy/gst-to-snap-up-it-talent-from-the-pvt-sector-114121900421_1.html

This generated my interest into learning more about GST and result of that is this blog post. 

Goods and Service Tax (GST) is India’s biggest indirect tax reform since 1947. 

Finance Minister Arun Jaitely of Modi government tabled the Constitution Amendment Bill 2011, or GST Bill in parliament on 19-Dec-2014. GST Bill seeks to amend the Constitution to allow for the introduction of a uniform, national goods-and-services tax. The implementation of GST has been opposed by some states because they are reluctant to surrender their right to impose such taxes. In particular, some have objected to the inclusion of petroleum products and liquor–major sources of revenue–in the proposed GST. The government aims to bring the tax into effect from April 1, 2016. 

Change in Mindset because of Tax Credit
Under the GST structure, every company gets a deduction on the taxes already paid by its suppliers. That results in every buyer ensuring that his supplier has paid his part to claim his deductions. This will be big mind set change in doing business in India to reduce leakage in tax collection. This will be big relief for tax payer and tax collector. The key is setting right GST rate. 

Best source to get latest information on GST is
1. http://gstindia.com/news.php
2. http://qz.com/317108/the-complete-guide-to-understanding-indias-biggest-tax-reform-the-gst/
3. http://blogs.wsj.com/indiarealtime/2014/06/18/is-india-ready-for-uniform-goods-and-services-tax/
4. http://www.cbec.gov.in/deptt_offcr/gst-status-18032014.pdf
5. http://profit.ndtv.com/videos/news/video-standard-rate-in-gst-could-be-27-ey-349492
6. http://www.moneycontrol.com/news/business/gst-will-lead-to-lower-costs-benefit-supply-chain-biz-tci_1258319.html

There is lot of material available to read but still lot of things are not clear.

Positive Impact on Big Manufacturing Sector
Abolition of Octroi will help to keep factories in the state Reduction is overall tax rate if GST is less than 26%. GST will make products competitive in domestic and international market.

Abolition of Octroi will help improve supply chain efficiency.

Negative impact on Small companies and unorganized sector
Companies with a turnover of Rs 10 lakh (currently Rs 1.5 crore) will have to pay GST.

Negative Impact on Service Sector
At present Manufacturing sector pays lot higher in taxes to government because of cascading effect of Indirect taxes. Manufacturing Sector burden will go down if GST is introduced at the rate between 19% to 22%. But at present Service sector pays close to 12% tax and there burden will increase drastically. How it will impact on Service is still not clear.

Banks and Hotel Industry, Warehouse companies will have to change their accounting rules to treat GST's credit facility. They will have to take GST credit from states.

Accounting Rules for Bill_To and Ship_To in different states 
There are 3 component in GST. Central GST ( CGST), State GST (SGST) and Interstate GST (IGST). CA.P.J.Johney has explained all these taxes very nicely in his YouTube video. 
https://www.youtube.com/watch?v=VXGc-wY2WqM

Some of the unanswered questions he has raised that if Bill To Party is in one state and Ship To Party is in different state then who will pay the GST? If SGST is different in both state then it will add more complexities. Accounting rules for such transactions are still not clear.

Impact on decision maker to setup new factory location
GST would be a destination based tax as against the present concept of origin based tax. In new system if it is B2B transaction then credit will be available to retailer or manufacturer and SGST will go to destination state.
In new environment states will not be able to offer tax incentives or exemption to setup new factory. If new factory needs to be setup decision maker need to see cost factor and supply chain cycle.

As per Vineet Agarwal, MD of Transport Corporation of India, GST being a consumption tax, it would mean that today let’s assume that there is a company which has five production units and maybe 25 warehouses across India because of saving tax, saving the central sales tax they will start reducing these numbers of warehouses, so instead of 25 warehouses they might have 15 warehouses. Therefore, the distribution matrix will change from five factories to 15 warehouses which would essentially mean that the size of these warehouses will increase essentially reducing the overall inventory but concentrating that inventory at several locations. So a lot of changes will come from supply chain perspective for manufactured products with GST coming in.

  
Impact on State Governments
The Center will compensate the states for loss of revenue arising on account of implementation of the GST for a period up to five years. However, the compensation will be on a tapering basis, i.e. 100% for the first three years, 75% in the fourth year and 50% in the fifth year. Once 5 year loss of revenue compensation period is over then rating agencies will rate the states based on their revenue collection at that time. If rating goes down it will be difficult for state government to raise money at cheaper rate. 

Good news is state's tax collection from service sector will improve drastically.

GST would be a destination based tax as against the present concept of origin based tax. At present states which has lot of manufacturing facility collects larger tax. In new system state with larger consumption will collect more tax. e.g if Maharashtra is biggest consumer of goods and services will collect larger tax. States which of tax incentives to setup new manufacturing facility will go away in new system. To attract new manufacturing they will have to provide good infrastructure, cheaper land and electricity.

Abolition of Octroi will help to keep factories in the state.

There will be levy of an extra 1% origin-based levy on interstate transaction for 2 years. Set-offs will not be available against this extra levy, the proceeds of which will be collected by the Center and assigned to states from where the supply originates.

Impact on Central Government 
Till now there no news which will impact Central Government negatively.  GST would apply to all goods and services barring a few to be specified. Because of wider tax collection base revenue is going to increase for central government. Higher rate will kill the economy but that chance is very low because we have very smart prime minister at the center.

Import of goods or services would be treated as inter-State supplies and therefore, would be subject to IGST in addition to the applicable customs duties

Central Board of Excise and Customs will have to change their software to handle collection and credit system and get ready to handle for increased number of tax payers.  

Impact on Citizens
Prices of manufactured goods will go down and that benefit will get pass to consumer. Prices of some service sector will go up. 

GST more or less equalises taxation across products, and hence may be iniquitous. For example, currently center and states can levy higher taxes on luxury goods and services (five-star dinners, cars above a certain size) and this is fair. Once GST kicks in, all goods and services may end up paying the same tax. This means the rich who buy luxury goods may pay less tax and the poor more than they should. This goes against the basic tenets of taxing the rich more and the poor less.

Read more at: http://www.firstpost.com/india/5-reasons-gst-may-cracked-1857539.html

The Goods and Service Tax Network (GSTN), the quasi-government company tasked with building the technology backbone for the long-pending indirect tax reform, is looking to hire technology professionals from companies such as Infosys, Wipro, Accenture and others.

Truck drivers will be able to deliver goods faster and resulting more revenue to them.


To summarize this if GST rolls-out at attractive rate, it will be a big boost to India's domestic market.

Thursday, August 21, 2014

Dunning Letter XML File for Template Creation

Below URL shows all the steps we need to do generate custom dunning letter.
Dunning letter setup and usage in Oracle r12
http://oraclemaniac.com/2014/03/11/dunning-letter-setup-and-usage-in-oracle-r12/

Only missing piece is where we can get the XML file to create custom RTF template.
Once you run concurrent program IEX: Send Dunnings for Delinquent Customers  iex_xml_request_histories table gets populated.

Step 1: Goto Collections Administrator --> Concurrent Requests --> View Requests
Step 2: Click on Details icon next to Oracle Collections Delivery XML Process (IEX: Bulk XML Delivery Manager)
Step 3: Click on View Log button at right hand corner. You can see below query in the log.

XMLDATA column stores XML file used by BI Publisher to generate dunning letter.

SELECT *
  FROM iex_xml_request_histories
 WHERE 1 = 1 
   AND status IN ('XMLDATA', 'XMLDOC','SUCCESSFUL', 'OTHER PROCESSING FAILURE'
   AND conc_request_id = :1

Pass Conc Req ID of "IEX: Send Dunnings for Delinquent Customers"
Same Conc Req id is also parameter of "Oracle Collections Delivery XML Process (IEX: Bulk XML Delivery Manager)"



Friday, January 24, 2014

ORA-01403: no data found in Package AP_VENDOR_PUB_PKG Procedure Validate_Vendor_Site

We use below script to create new supplier site.

-- Create Supplier
ap_vendor_pub_pkg.create_vendor_site
(p_api_version        => 1.0,
 p_init_msg_list      => fnd_api.g_true,
 p_commit             => fnd_api.g_false,
 p_validation_level   => fnd_api.g_valid_level_full,
 p_vendor_site_rec    => l_v_site_rec_type,
 x_vendor_site_id     => l_vendor_site_id,
 x_party_site_id      => l_party_site_id,
 x_location_id        => l_location_id,
 x_return_status      => l_return_status,--OUT 
 x_msg_count          => l_msg_count,    --OUT
 x_msg_data           => l_msg_data      --OUT);

We got below error.
ORA-01403: no data found in Package AP_VENDOR_PUB_PKG Procedure Validate_Vendor_Site

Developer dropped and recreated SYNONYM AP_SYSTEM_PARAMETERS as suggested by some of the Oracle forums.

After this we were able to create the supplier sites but AP forms stopped working because AP_SYSTEM_PARAMETERS started working as a normal synonym instead of Global Temporary Table. 

DO NOT drop AP_SYSTEM_PARAMETERS because it will drop MOAC security record from v$sqlarea ,v$vpd_policy tables.

Use below query to check security details which helps to work this synonym as a Global Temporary Table. 

 select substr(sql_text,1,200) sql_text,
 predicate,
 policy,
 object_name
 from v$sqlarea ,v$vpd_policy
 where hash_value = sql_hash
 and object_name = 'AP_SYSTEM_PARAMETERS';

Query Output
------------
SQL_TEXT= Select /*bug10155938 sql*/ org_id from ap_system_parameters
PREDICATE   = org_id = sys_context('multi_org2','current_org_id')
POLICY      = ORG_SEC
OBJECT_NAME = AP_SYSTEM_PARAMETERS


There must be some bug in the Oracle program because of which we get below error.
ORA-01403: no data found in Package AP_VENDOR_PUB_PKG Procedure Validate_Vendor_Site


If you drop AP_SYSTEM_PARAMETERS by mistake then you need to run below scripts to get it back.

Get below script from Oracle and Run the below scripts as apps user

SQL>@apmoconv.sql MOSYN AP APPS
SQL>@apmoconv.sql MOVPD AP APPS


NOTE: The first statement will recreate the synonym and the second statement will apply the policy. The binds of the script are in the same order in which it is fed to the script.
bind#1 -> MOSYN/MOVPDbind#2 -> APbind#3 -> APPS



D
O NOT Drop AP_SYSTEM_PARAMETERS.