EGL9.2: CATEGORY,SUB-CATEGORY Prompt Table Edit Error While Include PC Business Unit in Speed Type (Doc ID 2119653.1)

Last updated on JANUARY 05, 2017

Applies to:

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

Symptoms

Issue:
-----

On Journal entry page, if PC Business unit field value is populated using speed type then Upon selecting Category & Sub-category prompts throws below error :

There are no prompt values currently available for this field. (4,4)
The prompt table for this field is currently not specified. Use any value you wish.

Now if we populate the category & sub-category fields manually or using speed-type, it throws below error & Journal entry could not be saved.

Prompt table's record definition not found for . (2,650)
The prompt table's record definition could not be opened. The prompt table's record definition may not exist.

Steps to Replicate:
-------------------
1. Set up a Speed type including PC Business Unit but not including Category & Sub-category.
2. Set up another Speed type including PC Business Unit, Category & Sub-category.
3. Make sure that Category & sub-category edit tables are set in Project Costing Definition for the PC Business unit that is used in speed types defined in previous steps.
4. Create a journal & enter a journal line using speed type that includes PC Business Unit but not Category & Sub-category.Click on the prompts against Category/ sub-category.
5. Now Either enter the value of category & sub-category manually(with-out using prompt) or enter using another speed type that includes PC Business Unit, Category & Sub-category. Click on Save.

Please see Replication screenshots for more details.


Error:
--------

Prompt table's record definition not found for . (2,650)
The prompt table's record definition could not be opened. The prompt table's record definition may not exist.

An error has occurred while executing ExecuteEdits. (2,651) PC_CF1_N_SBR.BUSINESS_UNIT_PC.SaveEdit Name:edit_project_chartfields PCPC:1499 Statement:18
Called from:PC_CF1_N_SBR.BUSINESS_UNIT_PC.SaveEdit Name:PC_Edits_SE Statement:250
Called from:PC_CF1_N_SBR.BUSINESS_UNIT_PC.SaveEdit Statement:300

What is Working:

-------------------

Issue only appears when the PC Business unit value is entered using speed types. Does not appear if PC business unit is entered manually on the journal
lines.

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