My Oracle Support Banner

PO_REQLOAD is not Creating REQ_HDR_VAT When Run Replenishment (Doc ID 2968372.1)

Last updated on SEPTEMBER 27, 2023

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

PO_REQLOAD is not creating REQ_HDR_VAT when Run Replenishment.


When run replenishment requests for multiple inventory Business Units, and load these with one run of the requisition Loader process then not all VAT calculations are done.
REQ_HDR_VAT is not populated

Note: In the Replication Steps, User Details / Company Names / Addresses / Emails / Telephone Numbers / Etc. are fictitious (based upon made-up data used in the Oracle DEMO Environments), any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.


The issue can be reproduced at will with the following steps:

1. Requisition Loader default. Business Unit ‘CAN01’. Check the Requester on this page.
  Go to Setup Financials/Supply Chain > Product Related > Procurement Options > Purchasing > Requisition Loader Default
2. Requester setup. Search for the Requester above.
  Go to Setup Financials/Supply Chain > Product Related > Procurement Options > Purchasing > Requester Setup
3. Requisition Loader default. Business Unit ‘FRA01’. Check the Requester on this page.
  Go to Setup Financials/Supply Chain > Product Related > Procurement Options > Purchasing > Requisition Loader Default
4. Requester setup. Search for the Requester above.
  Go to Setup Financials/Supply Chain > Product Related > Procurement Options > Purchasing > Requester Setup
5. Define Business Unit Item for Business Unit = ‘CAN01’ and ‘FRA01’ and setup Replenishment
  Go to Menu > Items > Define Items and Attributes > Define Business Unit Item
6. Setup Replenishment for Business Unit = 'CAN01' and 'FRA01'
  Go to Menu > Inventory > Replenish Inventory > Setup Replenishment
7. Create Replenishment Request for Business Unit = 'CAN01' and 'FRA01'
  Go to Menu > Inventory > Replenish Inventory > Create Replenishment Requests
8. Replenishment created. Review at Manage Replenishment Request.
  Go to Menu > Inventory > Replenish Inventory > Manage Replenishment Requests
9. Run Load Requisition for All Business Unit.
  Go to Menu > Purchasing > Requisitions > Load Requisitions.
Issue 1: Only one requisition created. (Customer is able to run process for all BUs)

10. Go back Manage Replenishment Request. Business Unit = ‘FRA01’. Status = Processed
11. Requisition created.
  Go to Menu > Purchasing > Requisitions > Add/Update Requisitions
12. Query: SELECT * FROM PS_REQ_HDR_VAT where BUSINESS_UNIT = 'FRA01' AND REQ_ID = '0000000007'.
  REQ_HDR_VAT not created
13. Run again Load Requisition for BU = ‘CAN01’ only (because it was not created in previous process)
14. Go to Manage Replenishment Request. Business Unit = ‘CAN01’. Status = Processed
15. Requisition created.
  Go to Menu > Purchasing > Requisitions > Add/Update Requisitions
16. SELECT * FROM PS_REQ_HDR_VAT where business_unit = 'CAN01' AND REQ_ID = '0000000007'
  REQ_HDR_VAT not created
Issue 2: REQ_HDR_VAT is not creating when REQLOAD process from replenishment. (Customer reported this issue but only for 1 requisition)
17. Additional test. Create requisition online.
  Go to Menu > Purchasing > Requisitions > Add/Update Requisitions
18. SELECT * FROM PS_REQ_HDR_VAT where BUSINESS_UNIT = 'FRA01' AND REQ_ID = '0000000005'. REQ_HDR_VAT created

Changes

 

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
Changes
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.