R12: Data Fix Needed For pa_expenditure_comments (Doc ID 2511083.1)

Last updated on JULY 08, 2020

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------

- Data fix was provided via another bug in (labor distribution). It processed and generated data almost as expected, it generated all except "pa_expenditure_comments".
- Data is correctly reprocessed.

EXPECTED BEHAVIOR
-----------------------
Expect to see data in pa_expenditure_comments

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

Ran the following query:
=================
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 (
  xxxxxxx,
  yyyyyy
  )
/

Cause

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