Product Proposals
productProposals Based on 26C
Create, change, delete and look up Product Proposals, with cost, next statuses and proposal portfolio relationships.
- Operations
- GET (list)GET (one)POST (create)PATCH (update)DELETE
- Record key
ProductProposalId- Required on create
ConceptMasterIdName- At a glance
- 114 fields1 finders9 children
Try it
Only attributes Oracle marks as searchable are offered.
GET /fscmRestApi/resources/11.13.18.05/productProposals?fields=ActualCost,ActualDevFixedCost,ActualDevLaborCost,ActualDevMaterialCost,ActualDevVariableCost&limit=25&onlyData=true
{
"items": [
{
"ActualCost": 0,
"ActualDevFixedCost": 0,
"ActualDevLaborCost": 0,
"ActualDevMaterialCost": 0,
"ActualDevVariableCost": 0
}
],
"count": 25,
"hasMore": true,
"limit": 25,
"offset": 0
}Shapes and placeholders, not real data. Replace https://<your-pod> and the login with your own: this site never sees them. Based on Oracle's 26C REST specification.
Fields 114
| Attribute | Type | Use |
|---|---|---|
ActualCost | number | Optional on createUpdatableSearchable |
ActualDevFixedCost | number | Optional on createUpdatableSearchable |
ActualDevLaborCost | number | Optional on createUpdatableSearchable |
ActualDevMaterialCost | number | Optional on createUpdatableSearchable |
ActualDevVariableCost | number | Optional on createUpdatableSearchable |
ActualDevelopmentCost | number | Optional on createUpdatableSearchable |
ActualLaunch | date | Optional on createUpdatableSearchable |
ActualMargin | number | Optional on createUpdatableSearchable |
ActualProdFixedCost | number | Optional on createUpdatableSearchable |
ActualProdLaborCost | number | Optional on createUpdatableSearchable |
ActualProdMaterialCost | number | Optional on createUpdatableSearchable |
ActualProdVariableCost | number | Optional on createUpdatableSearchable |
ActualProductionCost | number | Optional on createUpdatableSearchable |
ActualResources | number | Optional on createUpdatableSearchable |
ActualRevenue | number | Optional on createUpdatableSearchable |
Alignment | text · max 30 | Optional on createUpdatableSearchable |
AllocatedBudget | number | Optional on createUpdatableSearchable |
AllowAccesstoEveryone | text | Optional on createUpdatable |
AverageSellingPrice | number | Optional on createUpdatableSearchable |
BaselineDate | date | Optional on createUpdatableSearchable |
BreakEvenTime | number | Optional on createUpdatableSearchable |
BusinessObjectives | text · max 400 | Optional on createUpdatableSearchable |
BusinessUnit | text · max 30 | Optional on createUpdatableSearchable |
BusinessUnitStrength | number | Optional on createUpdatableSearchable |
CPI | number | Optional on createUpdatableSearchable |
CompetitiveAdvantage | text · max 30 | Optional on createUpdatableSearchable |
ConceptCurrencyCode | text · max 15 | Optional on createUpdatableSearchable |
ConceptMasterId | number | Required on createSearchable |
ConceptMasterName | text · max 400 | Read-onlySearchable |
ConceptMasterVersion | text · max 10 | Read-only |
ConceptType | text · max 80 | Optional on createSearchable |
CostValueIndex | number | Optional on createUpdatableSearchable |
CreatedBy | text · max 64 | Read-onlySearchable |
CreationDate | date-time | Read-onlySearchable |
CurrencyConversionRate | number | Optional on createUpdatable |
Description | text · max 1000 | Optional on createUpdatableSearchable |
DevelopmentEnd | date | Optional on createUpdatableSearchable |
DevelopmentStart | date | Optional on createUpdatableSearchable |
DiscountRate | number · default 0 | Optional on createUpdatableSearchable |
EOL | date | Optional on createUpdatableSearchable |
ExpectedCommercialValue | number | Optional on createUpdatableSearchable |
FundingAmount | number | Optional on createUpdatableSearchable |
FundingRequestFor | text · max 30 | Optional on createUpdatableSearchable |
HighLevelDesign | date | Optional on createUpdatableSearchable |
Impact | text · max 30 | Optional on createUpdatableSearchable |
InstanceId | number | Optional on createUpdatable |
InternalRateOfReturn | number | Optional on createUpdatableSearchable |
IsCloned | text · max 1 · default N | Read-only |
IsLatest | text · max 1 | Read-onlySearchable |
LastConceptVersion | text · max 10 | Read-only |
LastProjCostRefreshTime | date-time | Optional on createUpdatable |
LastProjResourceRefreshTime | date-time | Optional on createUpdatable |
LastUpdateDate | date-time | Read-onlySearchable |
LastUpdatedBy | text · max 64 | Read-onlySearchable |
LatestConceptId | number | Read-only |
LatestConceptName | text · max 400 | Read-only |
LatestConceptVersion | text · max 10 | Read-only |
Launch | date | Optional on createUpdatableSearchable |
LifecyclePhase | text · max 80 | Read-only |
MarketAttractiveness | number | Optional on createUpdatableSearchable |
MarketGrowthPercent | number | Optional on createUpdatableSearchable |
MarketSharePercent | number | Optional on createUpdatableSearchable |
MarketStrategy | text · max 30 | Optional on createUpdatableSearchable |
Name | text · max 150 | Required on createUpdatableSearchable |
NetPresentValue | number | Optional on createUpdatableSearchable |
PaybackPeriod | number | Optional on createUpdatableSearchable |
PrimaryJustification | text · max 30 | Optional on createUpdatableSearchable |
ProbOfCommercialSuccess | number | Optional on createUpdatableSearchable |
ProbOfTechnicalSuccess | number | Optional on createUpdatableSearchable |
ProductCategorization | text · max 30 | Optional on createUpdatableSearchable |
ProductLine | text · max 30 | Optional on createUpdatableSearchable |
ProductProposalId | number | Read-onlySearchable |
ProductStrategicFit | text · max 30 | Optional on createUpdatableSearchable |
ProjDevCost | number | Optional on createUpdatableSearchable |
ProjDevFixedCost | number | Optional on createUpdatableSearchable |
ProjDevLaborCost | number | Optional on createUpdatableSearchable |
ProjDevMaterialCost | number | Optional on createUpdatableSearchable |
ProjDevVariableCost | number | Optional on createUpdatableSearchable |
ProjProdCost | number | Optional on createUpdatableSearchable |
ProjProdFixedCost | number | Optional on createUpdatableSearchable |
ProjProdLaborCost | number | Optional on createUpdatableSearchable |
ProjProdMaterialCost | number | Optional on createUpdatableSearchable |
ProjProdVariableCost | number | Optional on createUpdatableSearchable |
ProjectedMargin | number | Optional on createUpdatableSearchable |
ProjectedResources | number | Optional on createUpdatableSearchable |
ProposalNumber | text · max 100 | Read-onlySearchable |
ProposalProjectedCost | number | Optional on createUpdatableSearchable |
ProposalProjectedRevenue | number | Optional on createUpdatableSearchable |
ProposalStatus | text · max 30 · default DRAFT | Read-onlySearchable |
ProposalStatusName | text · max 255 | Read-onlySearchable |
ProposalType | text · max 30 | Optional on createUpdatableSearchable |
ProposalVersionNotes | text · max 400 | Read-onlySearchable |
PublishedFromPortfolio | text · max 30 · default N | Read-onlySearchable |
ReportId | text | Read-only |
ReportTemplate | text | Read-only |
RequirementsDefinition | date | Optional on createUpdatableSearchable |
ResourceValueIndex | number | Optional on createUpdatableSearchable |
ReturnOnInvestment | number | Optional on createUpdatableSearchable |
RiskNumeric | text · max 30 | Optional on createUpdatableSearchable |
RiskSubjective | text · max 30 | Optional on createUpdatableSearchable |
RndKnowHow | text · max 30 | Optional on createUpdatableSearchable |
Rpi | number | Optional on createUpdatableSearchable |
SecondaryJustification | text · max 30 | Optional on createUpdatableSearchable |
SrcProductProposalId | number | Read-only |
SrcProductProposalName | text | Read-only |
SrcProductProposalVersion | number | Read-only |
Summary | text · max 2147483647 | Optional on createUpdatableSearchable |
SupplyChainFit | text · max 30 | Optional on createUpdatableSearchable |
TargetCost | number | Optional on createUpdatableSearchable |
Version | number · default 1 | Read-onlySearchable |
WorkflowObjectType | text | Read-only |
YearFiveRevenue | number | Optional on createUpdatableSearchable |
YearThreeRevenue | number | Optional on createUpdatableSearchable |
YearTwoRevenue | number | Optional on createUpdatableSearchable |
Names, types, labels and flags from Oracle's REST specification (26C). Flexfield and custom attributes vary by pod: check /describe for yours.
Finders 1
Predefined searches: ?finder=Name;variable=value,variable2=value2. Pick one in Try it to build the call.
FindByProductProposalId·ProductProposalId
Check a payload
Checked in your browser only; nothing you paste is sent anywhere. Checks names and flags, not values.
Children 9
Child resources sit under one record: /fscmRestApi/resources/11.13.18.05/productProposals/{ProductProposalId}/child/<name>. Add them to a GET with expand.
AttachmentsGET · POST · DELETE Attachments · 33 fieldsAsyncTrackerIdAttachedDocumentIdCategoryNameContentRepositoryFileSharedCreatedByCreatedByUserNameCreationDateDatatypeCodeDescriptionDmDocumentIdDmFolderPathDmVersionNumberDocumentPreviewURLDownloadInfoErrorStatusCodeErrorStatusMessageExpirationDateFileContentsFileNameFileUrlFileWebImageLastUpdateDateLastUpdatedByLastUpdatedByUserNamePostProcessingActionTitleUploadedFileContentTypeUploadedFileLengthUploadedFileNameUploadedTextUriUrlUserNameCostGET · POST · PATCH · DELETE Costs · 7 fieldsCostAmountCostCategoryCostIdCostStatusCostTrendCostTypeStartDateNextStatusesGET Next Statuses · 4 fields · 2 findersSequenceNumberStatusCodeStatusDescriptionStatusNameProposalPortfolioRelationshipsGET · POST · DELETE Proposal Portfolio Relationships · 7 fieldsEndDatePortfolioCodePortfolioDescriptionPortfolioEnabledPortfolioIdPortfolioNameStartDateProposalVersionsGET Proposal Portfolio Relationships · 8 fields · 1 findersConceptMasterIdConceptMasterNameConceptMasterVersionIsLatestNameProductProposalIdProposalVersionNotesVersionRelationshipsGET · POST · PATCH · DELETE Relationships · 22 fieldsCreatedByCreationDateDescriptionDestObjIdDestObjTypeLastUpdateDateLastUpdatedByLatestFlagLatestFlagNameNameObjectSubTypeObjectTypeValueOrganizationCodeRelatedObjectPk1ValueRelatedObjectPk2ValueRelationshipIdRelationshipTypeRelationshipTypeValueRevisionSrcObjIdSrcObjTypeStatusResourceGET · POST · PATCH · DELETE Resources · 13 fieldsCreatedByCreationDateEndDateLastUpdateDateLastUpdatedByResourceCategoryResourceHeadcountResourceIdResourcePoolResourceStatusResourceTrendSourceStartDateRevenueGET · POST · PATCH · DELETE Revenues · 7 fieldsRevenueAmountRevenueCategoryRevenueIdRevenueStatusRevenueTrendRevenueTypeStartDateTeamGET · POST · DELETE Team Members · 8 fieldsCreatedByCreationDateDisplayNameLastUpdateDateLastUpdatedByTeamIdUserIdUserName
Use in AI Agent Studio
- Point a Business Object or REST tool at
/fscmRestApi/resources/11.13.18.05/productProposalsand ask only for the fields the agent needs withfields=. Big responses cost tokens and slow the agent. - Prefer a finder such as
FindByProductProposalIdfor the agent's main search: its variables become clean tool parameters. - Narrow with
q=on searchable fields and a smalllimit; for a count usetotalResults=true&limit=1. - Call once and pass the result on to later steps rather than calling the same endpoint again.
- This resource can change data. Put a human approval step before any create, update, delete or action call.
More in For Builders.
Pitfalls
- Attribute names are case-sensitive in
q,fieldsand bodies:ActualCost, notactualcost. - 26 fields are read-only: sending them in POST or PATCH fails or is ignored. The builder leaves them out.
- Send dates as
YYYY-MM-DD; date-time fields take ISO 8601 with a time zone. - A list returns 25 rows unless you set
limit; readhasMoreand moveoffsetto page through. - Text fields have maximum lengths (shown in the field table). Longer values are rejected.