PAXTRAPE: Data Fix Needed for PA_EXPENDITURE_COMMENTS as Comments Are Not Viewable in the Expenditure Inquiry (Doc ID 2511083.1)

Last updated on OCTOBER 23, 2024

Applies to:

Symptoms

Data stored in pa_expenditure_comments is not viewable in the Expenditure Inquiry after a datafix given in a different application. 

Steps to Reproduce
-----------------------

1.  Project Costing Super User
2.  Expenditure | Expenditure Inquiry | Project
3.  Query up an expenditure item and notice the comments are blank
4.  The following query also shows the issue:

SELECT
  x.expenditure_group,
  x.expenditure_id,
  ei.expenditure_item_id,
  pec.expenditure_comment,
  ei.*,
  x.*,
  pec.*
FROM
  apps.pa_expenditure_items_all ei,
  apps.pa_expenditures_all x,
  apps.pa_expenditure_comments pec
WHERE
  1 = 1
  AND ei.expenditure_id = x.expenditure_id
  AND ei.expenditure_item_id = pec.expenditure_item_id (+)
  AND ei.expenditure_id IN (  'your expenditure_id',   'your expenditure_id')/

Cause

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