After R12 Upgrade PO Number Is Not Shown In WIP Value Summary Screen
Last updated on MARCH 08, 2017
Applies to:Oracle Cost Management - Version 12.1.3 and later
Information in this document applies to any platform.
In 11i for Outside Processing (OSP) jobs, the PO number is displayed in the "Transaction Source" field in Transaction tab in WIP Transaction Distributions form, CSTFQWVS.fmb (WIP > Discrete > WIP Value Summary). But in R12 they are all blank.
The form uses the view CST_DISTRIBUTION_V. In this view, the transaction_source is null in 12.1.
In file cstgwip.odf the view CST_DISTRIBUTION_V is joining on the second select based on po_headers view. if you change this to use po_headers_all table, it is working OK
So the problem seems to be with getting data from po_headers view, possibly due to security.
Noted the following differences between 11i and 12.1:
setting org id context
To get org id, user id and responsibility id:
select user_id from fnd_user where user_name = ;
select responsibility_id from fnd_responsibility_tl where responsibility_name = ;
select organization_id from mtl_parameters where organization_code = ;
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms