My Oracle Support Banner

Tax Change In Shopping Cart Is Not Retained When Requisition is Autocreated into Purchase Order (Doc ID 2555899.1)

Last updated on SEPTEMBER 20, 2021

Applies to:

Oracle iProcurement - Version 12.2.4 and later
Oracle Purchasing - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

Use How To Make Tax Code Selection Visible In iProcurement? <Note 1341765.1> to enable tax in Shopping Cart.

Tax change in Shopping cart is not retained.

Case 1

- Enter iProcurement, 
- Enter a good line. Add to cart
- VIew Cart and Check out
- Tax fields are showing in Shopping cart popup.
- See Tax Classification default value =
- Cursor in value, remove STD, type Zero --> LOV came back with
- Click link for , tab. Cursor is now at the flash light.
- Click Save.
- Click Home
- Click View Cart and CHeckout
- See tax =
- Following query returns 'N':
SELECT user_upd_det_factors_flag
FROM zx_lines_det_factors zld
WHERE trx_id IN (
  SELECT requisition_header_id
  FROM po_requisition_headers_all
  WHERE segment1 = '&req_number' );

Case 2

- Enter iProcurement, 
- Enter a good line. Add to cart
- VIew Cart and Check out
- Tax fields are showing in Shopping cart popup.
- See Tax Classification default value =
- Cursor in value, remove STD, type Zero --> LOV came back with
- Click link for , tab then tab again. Cursor is now at the next tax
field "Vat Business Category"
- Click Save.
- Click Home
- Click View Cart and CHeckout
- See tax =
- Following query returns 'N':
SELECT user_upd_det_factors_flag
FROM zx_lines_det_factors zld
WHERE trx_id IN (
  SELECT requisition_header_id
  FROM po_requisition_headers_all
  WHERE segment1 = '&req_number' );
- Approve req
- Create PO. Tax on PO is

Case 3

- Enter iProcurement, 
- Enter a good line. Add to cart
- VIew Cart and Check out
- Tax fields are showing in Shopping cart popup.
- See Tax Classification default value =
- Cursor in value, remove STD, type Zero --> LOV came back with
- Click link for , tab. Cursor is now at the flash light.
- Click Save.
- Click Home
- Click View Cart and CHeckout
- See tax =
- Following query returns 'N':
SELECT user_upd_det_factors_flag
FROM zx_lines_det_factors zld
WHERE trx_id IN (
  SELECT requisition_header_id
  FROM po_requisition_headers_all
  WHERE segment1 = '&req_number' );
- Click Requisition, Complete
- Choose to Update line
- Delete current tax value. Change to a different value. Apply
- Following query returns 'Y'
SELECT user_upd_det_factors_flag
FROM zx_lines_det_factors zld
WHERE trx_id IN (
  SELECT requisition_header_id
  FROM po_requisition_headers_all
  WHERE segment1 = '&req_number' );


For iProc tax to be retained into PO, USER_UPD_DET_FACTORS_FLAG must be Y to work with PO: Retain manually updated PR Tax on PO.

This problem results in PO with incorrect tax for the PO.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.