ERP Implementation Expert

Tuesday 21 November 2017

Any change even small change in PO must go for Approval in R12 -- Query for this

Any change in PO must go for Approval - R12

To update the Table à to set it to -100%

UPDATE po_change_order_tolerances_all
set maximum_increment = -100
where change_order_type ='CO_ORDERS' AND tolerance_name='PO_AMOUNT' AND org_id =104;

Thursday 29 October 2015

Any Customer is having Windows 7/8/8.1 Pro. legal license is eligible for Free Upgrade to Windows 10 till one year from July 2015, irrespective of SA is there with license or not or active or expired.

Yes, we can Upgrade to Windows 10 even you have volume Licensing.

Any Customer is having Windows 7/8/8.1 Pro. legal license is eligible for Free Upgrade to Windows 10 till one year from July 2015, irrespective of SA is there with license or not or active or expired.

---------- Forwarded message ----------
From: Volume License Service Center APGC Support <CNTUS.MVLS.AU.00.EN.DCA.KLM.CS.T01.CUS.00.EM@css.one.microsoft.com>
Date: Tue, Oct 27, 2015 at 3:24 PM
Subject: RE: SRX1308888303ID - Windows 7, Windows 8 and Windows 8.1. Volume licenses for that we are not able to find the key on the Volume Licensing Service Center.
To: raj kumar sharma <raj260843@gmail.com>

Dear Raj,

Thank you for your reply and I'm glad to be of assistance.

As mentioned in my previous email, we are not saying you cannot upgrade to Windows 10. You will be able to upgrade but it is not from VLSC portal. The upgrade platform is Windows update (http://www.microsoft.com/en-us/windows/windows-10-upgrade).

This is the free upgrade which is offered to all Microsoft customers who are currently using Qualified Windows 7/8/8.1 users.

I hope I was able to address your enquiry to your satisfaction. Please feel free to contact us should you require further assistance.

Thank you for your continued support towards Microsoft products and services.

Regards,
Ameer Shahzman
Microsoft Volume Licensing Services Support Center
Email: vlservp@microsoft.com

India: 000800 440 1555 (Toll-Free Number) / 1 (212) 444 0497 (Toll Number)
For more information on Volume Licensing/Software Assurance:
http://www.microsoft.com/licensing/sa/default.mspx

--- Original Message ---
From : "Raj Kumar Sharma" Sent : Tuesday, October 27, 2015 5:46:34 AM UTC

To : "Volume License Service Center APGC Support"
Subject : Re: SRX1308888303ID - Windows 7, Windows 8 and Windows 8.1. Volume licenses for that we are not able to find the key on the Volume Licensing Service Center.

Dear Mr. Ameer Shahzman,

Thanks for your reply and the attached document, This document clearly says that what ever we are understanding is correct.

This is our understanding it is clearly stated on Microsoft policies on website that any customer having Legal License of Windows 7/8 or 8.1 (Except Enterprise Edition) is eligible for Free Upgrade to Windows 10 (Volume Licenses , Active or Expire etc. are not eligible is not mentioned any where. ) Means if any Customer is having Windows 7/8/8.1 Pro. legal license is eligible for Free Upgrade to Windows 10 till one year from July 2015, irrespective of SA is there with license or not or active or expired.

Kindly provide the link of the document where this exclusion is mentioned that Volume License holder without SA are not eligible for Free upgrade.

With Best Regards

Raj Kumar Sharma

On Mon, Oct 26, 2015 at 9:42 AM, Volume License Service Center APGC Support <CNTUS.MVLS.AU.00.EN.DCA.KLM.CS.T01.CUS.00.EM@css.one.microsoft.com> wrote:

Dear Raj,

Thank you for your reply and I am glad to be of assistance.

Raj, please refer below trail email which I have replied on the 21/10/2015.

Please feel free to contact us if you may need further assistance in relations to Volume Licensing and I will be glad to help.

Thank you for your continued support towards Microsoft products and services.

Regards,

Ameer Shahzman
Microsoft Volume Licensing Services Support Center
Email: vlservp@microsoft.com

India: 000800 440 1555 (Toll-Free Number) / 1 (212) 444 0497 (Toll Number)
For more information on Volume Licensing/Software Assurance:
http://www.microsoft.com/licensing/sa/default.mspx

--- Original Message ---
From : CNTUS.MVLS.AU.00.EN.DCA.KLM.CS.T01.CUS.00.EM
Sent : Wednesday, October 21, 2015 11:53:31 AM UTC
To : "Raj Kumar Sharma"
Subject : RE: SRX1308888303ID - Windows 7, Windows 8 and Windows 8.1. Volume licenses for that we are not able to find the key on the Volume Licensing Service Center.

Hi Raj,

Thank you for your reply and I'm glad to be of assistance.

Based on your recent email, I believe there has been a misinterpretation. Please be informed that upgrade via VLSC is only available for active Software Assurance customer. However that does not mean you will not be able to upgrade to Windows 10 using a different platform.

As for customers without active Software Assurance they would either need to purchase Windows 10 Pro upgrade licenses within VL or use Windows Update portal to upgrade to Windows 10 (retail version).

I have attached the PDF documentation with those information for your perusal.

Please feel free to revert back to me for further enquiries.

Regards,

Ameer Shahzman
Microsoft Volume Licensing Services Support Center
Email: vlservp@microsoft.com

India: 000800 440 1555 (Toll-Free Number) / 1 (212) 444 0497 (Toll Number)
For more information on Volume Licensing/Software Assurance:
http://www.microsoft.com/licensing/sa/default.mspx

--- Original Message ---
From : "Raj Kumar Sharma" Sent : Friday, October 23, 2015 11:16:30 AM UTC

To : "Volume License Service Center APGC Support"
Subject : Re: SRX1308888303ID - Windows 7, Windows 8 and Windows 8.1. Volume licenses for that we are not able to find the key on the Volume Licensing Service Center.

Dear Mr. Ameer Shahzman,

We are waiting for your reply.

With Regards

Raj Kumar Sharma

On Tue, Oct 20, 2015 at 10:04 AM, Raj Kumar Sharma <raj260843@gmail.com> wrote:

Dear Mr. Ameer Shahzman,

If you have any such policy please share it. We are not able to understand why you are not able to share it . If its a legal Policy of any Company on a Particular Product and that is concern to the Customer company should share it.

To the best of our understanding it is clearly stated on Microsoft policies on website that any customer having Legal License of Windows 7/8 or 8.1 (Except Enterprise Edition) is eligible for Free Upgrade to Windows 10 (Volume Licenses , Active or Expire etc. are not eligible is not mentioned any where. ) Means if any Customer is having Windows 7/8/8.1 Pro. legal license is eligible for Free Upgrade to Windows 10 till one year from July 2015, irrespective of SA is there with license or not or active or expired.

Kindly provide the link of the document where this exclusion is mentioned that Volume License holder without SA are not eligible for Free upgrade.

With Best Regards

Raj Kumar Sharma

On Mon, Oct 19, 2015 at 6:03 PM, Volume License Service Center APGC Support <CNTUS.MVLS.AU.00.EN.DCA.KLM.CS.T01.CUS.00.EM@css.one.microsoft.com> wrote:

Dear Raj,

Thank you for your reply and I am glad to be of assistance.

Raj, unfortunately we are unable to share the link. However, you may consider this email as a written confirmation from Microsoft Volume Licensing.

Please feel free to contact us again if you have further enquiry or require additional information.

Thank you for your continued support towards Microsoft products and services.

Regards,

Ameer Shahzman

Microsoft Volume Licensing Services Support Center
Email: vlservp@microsoft.com

India: 000800 440 1555 (Toll-Free Number) / 1 (212) 444 0497 (Toll Number)
For more information on Volume Licensing/Software Assurance:
http://www.microsoft.com/licensing/sa/default.mspx

--- Original Message ---
From : "Raj Kumar Sharma" Sent : Monday, October 19, 2015 10:09:41 AM UTC

To : "Volume License Service Center APGC Support"
Subject : Re: SRX1308888303ID - Windows 7, Windows 8 and Windows 8.1. Volume licenses for that we are not able to find the key on the Volume Licensing Service Center.

Dear Mr. Ameer Shahzman,

Thanks for updating, You are requested to kindly share the link of the Microsoft Document where this policy is written.

It will be a great help to us.

With Regards

Raj Kumar Sharma

On Mon, Oct 19, 2015 at 1:17 PM, Volume License Service Center APGC Support <CNTUS.MVLS.AU.00.EN.DCA.KLM.CS.T01.CUS.00.EM@css.one.microsoft.com> wrote:

Dear Raj,

Thank you for your reply and I am glad to be of assistance.

Raj, please be informed that for Volume Licensing, only Agreement with active Software Assurance will be able to upgrade to Windows 10 and get the product key via VLSC portal.

Therefore, if you did not purchase Software Assurance along with the licenses then you are not able to upgrade to Windows 10. You will not be able to download Windows 10 in VLSC portal and even get the product key for activation.

Please feel free to contact us if you may need further assistance in relations to Volume Licensing and I will be glad to help.

Thank you for your continued support towards Microsoft products and services.

Regards,
Ameer Shahzman

Microsoft Volume Licensing Services Support Center
Email: vlservp@microsoft.com
India: 000800 440 1555 (Toll-Free Number) / 1 (212) 444 0497 (Toll Number)
For more information on Volume Licensing/Software Assurance:
http://www.microsoft.com/licensing/sa/default.mspx

--- Original Message ---
From : "Raj Kumar Sharma" Sent : Monday, October 19, 2015 6:10:31 AM UTC
To : "Volume License Service Center APGC Support"
Subject : Re: SRX1308888303ID - Windows 7, Windows 8 and Windows 8.1. Volume licenses for that we are not able to find the key on the Volume Licensing Service Center.

Dear Mr. Ameer Shahzman,

Thanks a lot for replying. We wants to know what is the upgrade policy of the Microsoft on Volume Licenses. As this is very clear that Win-XP, Win-2K, Vista, Windows 7/8/8.1 (Enterprise Edition) will not get Free upgrade.

Kindly confirm in general not only for our specific license, what the Policy of the Microsoft on the Windows 10 free upgrade from Windows 7/8/8.1 Pro. Volume License purchased with SA (Expired / Active)

Thanks a lot once gain and waiting for your reply.

With Regards

Raj Kumar Sharma

On Mon, Oct 19, 2015 at 10:26 AM, Volume License Service Center APGC Support <CNTUS.MVLS.AU.00.EN.DCA.KLM.CS.T01.CUS.00.EM@css.one.microsoft.com> wrote:

Dear Raj,

Thank you for writing to Microsoft Volume Licensing Customer Service team and I am glad to be of assistance.

Based on your email communication, I understand that you are enquiring on your license status and Windows 10 product key. Please correct me if I have misunderstood your enquiry.

Please be informed that I may need few details to assist you further. Kindly provide:

· Microsoft account ID (VLSC portal login ID)

· Agreement Number / Enrollment Number / Public Customer Number

I look forward for your reply.

Please feel free to contact us if you may need further assistance in relations to Volume Licensing and I will be glad to help.

Thank you for your continued support towards Microsoft products and services.

Regards,

Ameer Shahzman

Microsoft Volume Licensing Services Support Center
Email: vlservp@microsoft.com

India: 000800 440 1555 (Toll-Free Number) / 1 (212) 444 0497 (Toll Number)
For more information on Volume Licensing/Software Assurance:
http://www.microsoft.com/licensing/sa/default.mspx

--- Original Message ---
From : "Raj Kumar Sharma"
Sent : Friday, October 16, 2015 7:31:02 AM UTC
To : "vlservp@microsoft.com"
Subject : Windows 7, Windows 8 and Windows 8.1. Volume licenses for that we are not able to find the key on the Volume Licensing Service Center.

Dear Sir/Madam,

We are thankful to the Microsoft who recently launches a very good, user friendly and stable O/S Windows 10. Everyone is very happy as Microsoft announced to provide FREE upgrade till one year for all legal users of Windows 7, Windows 8 and Windows 8.1.

We are having some Windows 7, Windows 8 and Windows 8.1. Volume licenses for that we are not able to find the key on the Volume Licensing Service Center. On some of our licenses have "Software Assurance Pack" in "Active" stage and on some it's expire.

Kindly look into the matter and suggest us how we can get new key for Windows 10 upgrade.

With Best Regards

Raj Kumar Sharma

Monday 12 January 2015

11 things to do when you gets an email or a letter for software compliance.

11 things to do when you gets an email or a letter for software compliance.

First of all don’t reply the e-mail. Normally, Software vendors are sending bulk e-mails. Who so ever reply their e-mail, they catch that company. So, wait for the reminder and e-mail addressed to only your company mail id.

1. READ CAREFULLY

Read the contents of the email or letter carefully and verify whether it is written by an authorised person of the software vendor. Consult your preferred software dealer and your legal team.

2. INTERNAL SOFTWARE AUDIT

Do an internal software audit for the exact usage of the software vendors product (and other software products as well) in the computers and systems within your organisation.

3. REMOVE EXTRA OR UNUSED SOFTWARE

If there are multiple installations of different versions of the same software in any computer or if there is any inadvertent installation of the software product which has never been used, you should uninstall these software products under the licence terms.

4. MAKE LIST OF EXISTING LICENCES AND CHECK FOR SHORTFALL

Make a list of all the software licences in your organisation and check if all the installed software from the internal software audit can be covered the existing licences. If there is any shortfall, make a proper bill of materials.

5. PLACE ORDERS TO YOUR PREFERRED SOFTWARE PARTNER FOR ANY SHORTFALL

If there is any shortfall in software licensing, place orders to your preferred software partner.

As per the ethics standards that all major international companies follow, the employees of the software vendor or the employees of the software auditor cannot recommend any particular name or names of software partners to purchase the software. These employee/s would lose their jobs in case they try to favour any particular software partner/s.

6. REPLY TO SOFTWARE AUDIT LETTER OR EMAIL.

Send the reply to the software vendor with your software compliance report. If they agree with your software compliance report, the matter is closed.

If the software vendor are not convinced of your software compliance, they may insist on a software audit by an reputed independent auditor under the license terms.

The Software license terms normally only specifies for an internal audit and self-declaration of software usage and does not allow for an external audit unless ordered by court (after due legal process).

7. PREPARE FOR THE SOFTWARE AUDIT

Check the software license terms of the software vendor for the terms of the software audit under the license agreement.

Ask for the software vendor's authorization letter to the Audit firm to conduct software audits for the software vendor.

Request for the names, photographs and profiles of the person/s authorized by the software vendor to conduct the software audit. Also instruct the software vendor and auditor to ensure that the software auditor should not have any active interest, direct or indirect investment in your business profile.

8. NON DISCLOSURE AGREEMENT FOR THE AUDITORS

Send the Non-Disclosure Agreement (NDA) to the authorized auditors to agree and sign. The NDA should specify that the information gathered during the software audit will be used specifically for purpose of the software audit report to be sent to the software vendor. No information gathered during the software audit can be passed to any competitor/s or be used for any commercial or non-commercial purpose.

9. THE SOFTWARE AUDIT

After the NDA has been signed by the auditors, you should allow the auditors to physically check for the software vendor's products installed in the computers in your organization. You should disallow the use of any software audit tool unless the source code of the software tool has been provided to you in advance. You should insist on an independent software test report for the software audit tool and an indemnity bond from the software auditor for any damages that may be caused by the use of the software audit tool.

10. PLACE ORDERS TO YOUR PREFERRED SOFTWARE PARTNER FOR ANY SHORTFALL

If there is any shortfall found during the software audit, place orders to your preferred software partner.

11. DO INTERNAL SOFTWARE AUDITS EVERY MONTH

Do monthly internal software audits for the exact usage of the all the software products in the computers and systems within your organization. If there is any shortfall found during these monthly software audits, place orders to your preferred software partner.

Thursday 18 December 2014

Some More Information regarding Oracle EBS Licenseing

If licensing by Named User Plus, the minimum is 10 Named User Plus licenses per Processor for IAS EE. In case of numerous users on web applications, NUPS metric is not advisable/ practical to implement.

We recommend the NUPS metric in the Test and Development environment and the Processor metric in the Production and Data Recovery environment.

Oracle Licensing policiy is published at http://www.oracle.com/us/corporate/pricing/index.html

Policy for modifications and customizations made to the Ebusiness Suite can be found in the application licensing table here - http://www.oracle.com/us/corporate/pricing/application-licensing-table-070571.pdf

Oracle Licenses some facts

Oracle Licenses is based on the Processor or Named Users.

Normally, if you purchased Oracle Apps EBS after 1 year Oracle Sales team will visit you and ask for you to purchase the Licenses of the Oracle Database Enterprises Edition and the Web Logic Suite (Oracle Internet Application Server). As you all aware that EBS implementation without 1 single customization in India just near to impossible. If you made a single report that is customization, if you put your Logo on Sales Invoice that is Customization (In Oracle words Modification).

If you have made any modification you need to take licenses of Oracle Database Enterprises Edition and the Web Logic Suite (Oracle Internet Application Server).

If you procure Processor based licenses then the below is the factor :-

Processors/ Sockets or MCM Chips	Cores per processor	Total Cores to be considered	Processor Factor (Based on your Hardware)	Number of Processor licenses required
1	4	4	0.5	2
2	4	4	0.75	3

Or you can adopt the Named User Licenses based on your requirement.

So, you are requested to kindly inform your management that if are planning the Buy Oracle EBS R12 or any Oracle Application and doing any customization we should be ready to invest around 1-2 Crores based on your users and hardware infrastructure .

Yes you need to procure the licensed for your test instance also.

Maybe you know the rule: When using Oracle Enterprise Edition database, and want to license by NUP’s – Named User Plus Licenses – you are bound to a minimum of 25 users per Oracle-defined processor. So using a server with one Intel-based quad-core processor (with a factor of 0,5), you have to pay for (4 * 0,5 =) 2 Oracle processors, which is equal to a minimum of 50 users.

This has been defined in the Software Investment Guide (page 14):

Minimums for this metric may be discrete quantities, or they may be based on the number of processors in the machine on which the software will be installed and/or run. For example, the minimum for the Database Enterprise Edition, the iAS Standard Edition and the iAS Enterprise Edition is 25, 10 and 10 Named Users Plus per Processor, respectively

Let’s stick for a moment on the Enterprise Edition of the database, and the example above. When a second server (1 quad core) is added, also with an Enterprise Edition database on it you’ll have to pay for a total of 100 NUP’s.

But what if I only have got 60 users (non human operating device included) who are directly or indirectly authorized to use those two databases / nodes. Will I pay for 60 users or 100 ? To be sure I asked this question to my contact at LMS (License Management Service at Oracle).

The answer (translated):

100 NUP’s. Like you do with a single node, you have to count the minimum number of NUP’s (in this case 100) or the number of authorized users, whichever is higher….

Monday 15 September 2014

Allow Uppercase in Customer Name

Application Name : AR
Form Name – ARXCUDCI User Form Name – Customers
Function Name - AR_ARXCUDCI_STD
Description - Allow Uppercase in Customer Name
Level - Function
Form Personalization Conditions

Define Trigger event “WHEN-VALIDATE-RECORD”

Trigger Object “CUST”
Processing Mode “Only in Enter-Query Mode”

Wednesday 23 October 2013

Alert Query for Receipt Intimation - Material received at Warehouse in 11i

SELECT hre.full_name

, SUBSTR(poh.segment1,1,10) || '/' ||

SUBSTR(pol.line_num,1,4) || '/' ||

SUBSTR(por.release_num,1,4) || '/' ||

SUBSTR(pll.shipment_num,1,4)

, pov.vendor_name

, pol.item_description

INTO &AGENT

, &PO

, &VENDOR

, &LINE

FROM hr_employees_current_v hre

, po_vendors pov

, po_headers poh

, po_lines pol

, po_line_locations pll

, po_releases por

WHERE poh.type_lookup_code IN ('STANDARD','BLANKET','PLANNED')

AND NVL(pll.receipt_required_flag, 'N') = 'N'

AND NVL(pll.closed_code, 'OPEN') = 'OPEN'

AND NVL(pll.cancel_flag, 'N') = 'N'

AND NVL(poh.closed_code, 'OPEN') = 'OPEN'

AND NVL(poh.cancel_flag, 'N') = 'N'

AND NVL(por.closed_code, 'OPEN') = 'OPEN'

AND NVL(por.cancel_flag, 'N') = 'N'

AND poh.po_header_id = pol.po_header_id

AND pov.vendor_id = poh.vendor_id

AND pll.po_line_id = pol.po_line_id

AND por.po_release_id(+) = pll.po_release_id

AND hre.employee_id = poh.agent_id

AND pol.creation_date BETWEEN (sysdate - :CHECKDAYS)

AND sysdate

ORDER BY hre.full_name

, poh.segment1

, pov.vendor_name

, pol.creation_date

select rowidtochar(cust.rowid),

substr(hr.name,1,3) "ORGN_CODE",

a.receipt_num,

sysdate,

b.quantity_received,

b.line_num,

e.segment1,

c.segment1,

c.Description,

substr(k.email_address,1,55),

substr(l.email_address,1,55),

substr(m.email_address,1,55),

decode(e.org_id,'46','abc@rrr.com','42','hod@rrr.com',NULL),

nvl(j.segment1,'NULL'),

l.user_name

into &rowid,&orgn,&recvno,&recv_date,&recv_qty,

&lineno,&pono,&itemno,&item_desc1,&email1,&email2,&email3,&email4,&reqno,&username

from PO_RECEIPT_ALERT_CUSTOM cust,

rcv_shipment_headers a,

rcv_shipment_lines b,

mtl_system_items c,

ic_item_mst d,

po_headers_all e,

po_requisition_headers_all j,

po_requisition_lines_all porl,

po_line_locations_all poll,

fnd_user k,fnd_user l,fnd_user m,

hr_organization_units hr

where cust.shipment_header_id = a.shipment_header_id

and a.shipment_header_id = b.shipment_header_id

and d.item_no = c.segment1

and d.gl_class in ('GS','RM','FA','PY')

and b.po_header_id = e.po_header_id

and a.ship_to_org_id = hr.organization_id

and b.item_id = c.inventory_item_id

and a.ship_to_org_id = c.organization_id

and b.po_line_location_id = poll.line_location_id

and poll.line_location_id = porl.line_location_id(+)

and j.requisition_header_id(+) = porl.requisition_header_id

and e.created_by = k.user_id

and decode(j.created_by,null,e.created_by,j.created_by) = l.user_id

and a.created_by = m.user_id

and cust.rowid =:rowid

order by b.line_num