JDBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9062

Ideas

The Ideas resource gets the details about an idea. An idea represents a suggestion to improve a product or a process, or it could represent a suggestion to launch a new product or a new process.

Columns

Name Type Description
IdeaId [KEY] Long Value that uniquely identifies an idea.
Type String Value that indicates the type of idea. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Product Idea Classes task.
TypeDisplayValue String TypeDisplayValue of Ideas
Name String Name of the idea.
IdeaNumber String IdeaNumber of Ideas
CreatedBy String CreatedBy of Ideas
ObjectVersionNumber Int Number that identifies the version of the record in the database.
CreationDate Datetime CreationDate of Ideas
LastUpdateDate Datetime LastUpdateDate of Ideas
LastUpdatedBy String LastUpdatedBy of Ideas
Status String Status of the idea. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Product Idea Statuses task.
StatusDisplayValue String StatusDisplayValue of Ideas
LastUpdateLogin String LastUpdateLogin of Ideas
VoteSummaryAsText String VoteSummaryAsText of Ideas
AllowAccesstoEveryone String Contains one of the following values: true or false. If true, then access is allowed for all users. If false, then access is not allowed for all users. The default value is false.
Description String Description of the idea.
Content String Detailed description of the idea along with pictures and images.
Tags String Tags of Ideas
YesVoteCnt Int Total number of users that have voted Yes.
NoVoteCnt Int Total number of users that have voted No.
LikeIt Int Value that indicates the number of users who have liked the idea.
ReferencesCnt Int Value that indicates the count of references for an idea. The references to an idea are typically other objects that are linked to this idea.
Popularity Int Value that indicates the popularity of the idea.
HasMyVote Bool Contains one of the following values: true or false. If true, then the user has voted in favor of the idea. If false, then the user has not voted in favor of the idea. The default value is false.
CommentsCnt Int Total number of comments on the idea.
Customers String Customers of Ideas
CommentsCount Int CommentsCount of Ideas
LikeCount Int LikeCount of Ideas
DisLikeCount Int DisLikeCount of Ideas
ProjectedMarketDemand_c String ProjectedMarketDemand_c of Ideas
CompetitiveThreat_c String CompetitiveThreat_c of Ideas
ProjectedDevelopmentLOE_c String ProjectedDevelopmentLOE_c of Ideas
ProjectedMarketSize_c String ProjectedMarketSize_c of Ideas
StrategicFitWithBrandPortfolio_c String StrategicFitWithBrandPortfolio_c of Ideas
ProjectedRevenue_c String ProjectedRevenue_c of Ideas
IdeaPreliminaryRanking_c String IdeaPreliminaryRanking_c of Ideas
BusinessNeed_c String BusinessNeed_c of Ideas
PotentialCustomers_c String PotentialCustomers_c of Ideas
CreatorIdeaDescription_c String CreatorIdeaDescription_c of Ideas
Finder String Finder of Ideas

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062