You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Defaulting Expenditure organization at AP invoice line level same as Project owning organization.

in Project Management 1 comment

Summary:

Hi,

We have a requirement to default the expenditure organization same as project owning organization for the we have used the custom SQL in Org ID Value Set as below suggested by Oracle:

org_id = :{PARAMETER.BusinessUnit} and nvl(:{SEGMENT.EXPENDITURE_ITEM_DATE}, trunc(sysdate)) between nvl(EFFECTIVE_START_DATE, nvl(:{SEGMENT.EXPENDITURE_ITEM_DATE}, trunc(sysdate))) and nvl(EFFECTIVE_END_DATE, nvl(:{SEGMENT.EXPENDITURE_ITEM_DATE}, trunc(sysdate))) and organization_id = (select carrying_out_organization_id from pjf_projects_all_b where project_id = :{SEGMENT.PROJECT_ID})

It is defaulting the Project owing organization as Expenditure organization but not letting the user to select another organization when required because there is only one record showing in the LOV. To overcome this issue, I changed the Value Set back to standard and used initial value section to default the value.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!