New Item Is Not Visible In Drop-down Attribute of Methods in Worksheets

(Doc ID 2332847.1)

Last updated on NOVEMBER 28, 2017

Applies to:

Oracle Demantra Demand Management - Version 12.2.4.1 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4.1 version, Worksheet

ACTUAL BEHAVIOR
---------------
New item is not visible in worksheet

When a new item is coming to Demantra, in worksheet  Dest Item dropdown the new item is not getting listed.

EXPECTED BEHAVIOR
-----------------------
The new items to be listed in the Dest Item .

WHAT IS WORKING
-----------------------
The item is available after restarting the application server.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Compare the items in t_ep_item and EBS
2. If any new item is found with all mandatory attributes like item number, desc, abc class code, category and subcategory we create record in t_src_item_tmpl.
3. Then load to Demantra using EP_LOAD_MAIN
4. Log into Collaborator Workbench.
5. Open an worksheet
6. Call the NPI method.
The new item is not available in the Dest Item dropdown.



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