Projects - EBS (MOSC)

MOSC Banner

Autoaccounting rule being cut off

edited Dec 11, 2014 10:04AM in Projects - EBS (MOSC) 2 commentsAnswered

Trying to change the auto accounting rule in Projects from:

select decode(pt.project_type, 'OH INDIRECT GOVT', :1||'.OH','CONTRA R&D',:2,:3)

from pa_expenditures_all pae,

pa_expenditure_items_all paei,

pa_expenditure_types et,

pa_projects_all p,

pa_tasks t,

pa_project_types_all pt

where

paei.expenditure_item_id = :4

and pae.expenditure_id = paei.expenditure_id

and paei.task_id = t.task_id

and t.project_id = p.project_id

and p.project_type = pt. project_type

and paei.expenditure_type = et.expenditure_type

and p.org_id = pt.org_id

to below:

select decode(pt.project_type, 'OH INDIRECT GOVT', :1||'.OH','CONTRA R&D',:2,'SBR UNFUNDED PROJECT','13650',:3)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center