Projects - EBS (MOSC)

MOSC Banner

Update to existing AutoAccounting Rule

in Projects - EBS (MOSC) 5 commentsAnswered ✓

Hi, path is:

Project Ledger Sys Admin > Projects CORE > Setup > AutoAccounting > Rules > Query on Rule Name

Value is:

SELECT CASE ppa.project_type
WHEN 'Planned Maintenance' THEN
(SELECT pt.attribute2
FROM pa_projects_all ppa
,pa_expenditure_items_all peia
,pa_tasks pt
WHERE peia.task_id = pt.task_id AND
pt.project_id = ppa.project_id AND
peia.expenditure_item_id =:1)
ELSE
ppa.attribute1
END attribute_value
FROM pa_projects_all ppa
WHERE ppa.project_id =:2

The above statement has existed in our Oracle install since we went live in 2017
It comes to me to try and update to include a 2nd Project Type

Tagged:

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