When Editing a Fluid Requisition and Updating the Header Comments, the Comments Tables, REQ_COMMENTS and COMMENTS_TBL are Not Being Updated (Doc ID 2966685.1)

Last updated on SEPTEMBER 07, 2023

Applies to:

Symptoms

When Editing a Fluid Requisition and Updating the Header Comments, the Comments Tables, REQ_COMMENTS and COMMENTS_TBL are Not Being Updated

The issue can be reproduced at will with the following steps:
1. Click on the eProcurement Tile
2. Click on the Create Requisition Tile
3. Click on Special Requests on Left Menu
4. Enter the required information then click Add to Cart
5. Click on Checkout
6. Click on the Header Comments button
7. Enter comment text HDR COMM then click Done
8. Click Submit to create the requisition
9. Run SQL below to check the data in the Comments tables
      select a.req_id, a.oprid, a.comment_id, a.random_cmmt_nbr, a.comment_type, b.comments_2000
      from ps_req_comments a, ps_comments_tbl b
      where a.req_id = ''
      and a.oprid = b.oprid
      and a.comment_id = b.comment_id
      and a.random_cmmt_nbr = b.random_cmmt_nbr
      order by a.comment_id;

10. Header Comment is saved on the tables correctly.
11. Now- Click Edit this Requisition
12. Click on the Header Comments button
13. Update the Header Comment from HDR COMM to HDR COMM UPDT then click Done
14. Click Submit
15. Run the SQL above again to check and see if the update to our Header Comments were saved
16. The header comments were not updated correctly.

Cause

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