My Oracle Support Banner

Is it Possible to Pass the Expendiutre Organization at the Expenditure Item Level Versus the Expenditure Level? (Doc ID 2749897.1)

Last updated on FEBRUARY 05, 2021

Applies to:

Oracle Project Costing - Version 12.2.4 and later
Information in this document applies to any platform.

Goal

Development gave a datafix to update the incurred_by_organization_id value in pa_expenditures_all table but by doing so, the same 'Expnd Org' which is updated by the below statement, gets reflected at the expenditure item level for all the expenditure item lines linked to that expenditure id:

update pa_expenditures_all set incurred_by_organization_id = <ORG_ID value> where expenditure_id = <Expenditure_Id value>

Is it possible to update the 'Expnd Org' only for a particular expenditure item line and not for the whole batch (all the lines linked to an expenditure id)? 

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution


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