EGL9.2: Budget Checking Transaction not Using Project Fields Running in 'Translation Tree Error'. (Doc ID 2090014.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.2 version, KK-Budget Checking

When attempting to budget check a journal (or Purchase Order. Requisition) that does not use project chartfields the following error occurs.

ERROR
-----------------------
Budget error: Translation Tree error
Message: No translate value for Account: "620000" in Tree "TREE_CC_PRJ", SetID "SHARE". Budget Processor was not able to find a translated budgetary chartfield value, in the specified tree, for the specified detail level chartfield.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Setup Budget Definition CC_PRJ where Budget Type = Expense, Ruleset CF = Project, Control CF = Project and Control Option = Control.
  2. Define the following chartfields in Keys and Translations:
    • Account is linked to tree TREE_CC_PRJ (Tree is linked to account 610000) and value is Required
    • Activity is Not Required
    • Business Unit is Not Required
    • Fund Code is Optional
    • Operating Unit is Optional
    • Department is Optional
    • Product is Optional
    • Project is Not Required
  3. Setup Budget Definition CC_ORG where Budget Type = Expense, Ruleset CF = Department, Control CF = Product and Control Option = Control.
  4. Define the following chartfields in Keys and Translations:
    • Account is linked to tree TREE_CC_ORG (Tree is linked to account 620000) and value is Required.
    • Fund Code is Optional
    • Class Field is Optional
    • Program Code is Optional
    • Operating Unit is Optional
    • Department is Required
    • Product is Required
  5. Create and post a budget journal for CC_PRJ. PC Business Unit US001, Project ALLPROJECTS, Activity G&A, Account 610000, Operating Unit FLORIDA, Fund Code F100 and Department 42000.
  6. Create and post a budget journal for CC_ORG. PC Business Unit, Project and Activity are blank. Account 620000, Operating Unit FLORIDA, Fund Code F100, Product ALLPRD and Department 42000.
  7. Create a journal. Line 1 is for account 100000 and amount is -250. Line 2 is for Account 620000, Operating Unit FLORIDA, Fund Code F100, Product ALLPRD and Department 42000.
  8. Edit journal and budget status is in Error.
  9. Budget error: Translation Tree error
  10. Message: No translate value for Account: "620000" in Tree "TREE_CC_PRJ", SetID "SHARE". Budget Processor was not able to find a translated budgetary chartfield value, in the specified tree, for the specified detail level chartfield.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot budget check any transaction where PC Business Unit, Project and Activity are blank.

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