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 laterOracle 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 |