SSIS Components for Oracle Fusion Cloud Financials

Build 26.0.9770

ProjectsProjectOpportunities

An object that includes attributes that are used to store values while creating or updating the opportunity details for a project. An opportunity is defined as a potential revenue-generating event.

Columns

Name Type SupportedFinders Description
ProjectsProjectId [KEY] Long Unique identifier of the project.
OpportunityAltNumber String Unique identifier of the opportunity that is created in third-party application.
OpportunityAmount Decimal Total amount of a customer deal in the opportunity management application.
OpportunityCurrencyCode String Currency code of the deal amount for the opportunity.
OpportunityCustomerId Long Unique identifier of the customer with whom the deal is made for the project.
OpportunityCustomerName String Name of the customer with whom the deal is made for the project.
OpportunityCustomerNumber String Customer number in the opportunity management application.
OpportunityDescription String Description of the opportunity that the project is associated with.
OpportunityName String Name of the opportunity that the project is associated with.
OpportunityNumber String The public unique identifier for an opportunity in the opportunity management application.
OpportunityStatus String Status of an opportunity in the opportunity management application.
OpportunityWinConfPercent Decimal Percentage probability of winning an opportunity in the opportunity management application.
OpportunityId [KEY] Long Identifier of the opportunity associated with the project
ProjectId Long FindByProjectId, PrimaryKey Unique identifier of the project unit assigned to the project.
ActiveDate Date FindByProjectTeamMember, findByProjectRoleAndProjectTeamMember activedate
ClassCategory String FindProjectsByClassCategory classcategory
Finder String finder
FinishDate Date FindChargeableProjectsByPersonIdAndDateRange, findChargeableProjectsByTeamMemberAndDateRange finishdate
OwningOrganizationName String FindByOrg owningorganizationname
PartyName String FindByPartyName partyname
PersonId Long FindChargeableProjectsByTeamMemberAndDateRange, findChargeableProjectsByPersonIdAndDateRange personid
PersonName String FindByProjectTeamMember, findByProjectRoleAndProjectTeamMember personname
ProjectName String FindByProjectName projectname
ProjectRole String FindByProjectRoleAndProjectTeamMember projectrole
ProjectStatus String FindByProjectStatus projectstatus
SearchAttribute String FindChargeableProjectsByPersonIdAndDateRange searchattribute
SourceApplicationCode String FindBySourceApplication sourceapplicationcode
SourceProjectReference String FindBySourceApplication sourceprojectreference
StartDate Date FindChargeableProjectsByPersonIdAndDateRange, findChargeableProjectsByTeamMemberAndDateRange startdate

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770