After R12 Upgrade PO Number Is Not Shown In WIP Value Summary Screen (Doc ID 1568745.1)

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.

Symptoms

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:

11i:
Exec dbms_application_info.set_client_info(&org_id);

setting org id context

For R12:
begin
fnd_global.apps_initialize(&user_id,&responsibility_id,&org_id);
mo_global.init('PO');
end;

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 = ;

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms