Get a MDF request associated to the budget
get
/crmRestApi/resources/11.13.18.05/mdfBudgets/{BudgetCode}/child/FundRequest/{FundRequestCode}
Request
Path Parameters
-
BudgetCode(required): string
The unique alternate identifier of the MDF budget.
-
FundRequestCode(required): string
The unique alternate identifier of the marketing MDF request.
Query Parameters
-
dependency: string
This parameter specifies dependencies which are fields that are set before and rolled back after generating the response. Generally they are used to preview the effects of an attribute change. The fields specified in this parameter are always set in the resource instance in question. When a child resource collection is requested and the parameter is set, the fields will be set in the parent resource instance before generating the resource collection payload. The value of this query parameter is a set of dependency fields. Example: dependency=ProductId=2
Format: <attr1>=<val1>,<attr2>=<value2> -
expand: string
When this parameter is provided, the specified children are included in the resource payload (instead of just a link). The value of this query parameter is "all" or "". More than one child can be specified using comma as a separator. Example: ?expand=Employees,Localizations. Nested children can also be provided following the format "Child.NestedChild" (Example: ?expand=Employees.Managers). If a nested child is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?expand=Employees.Managers" is the same as "?expand=Employees,Employees.Managers" (which will expand Employees and Managers).
-
fields: string
This parameter filters the resource fields. Only the specified fields are returned, which means that if no fields are specified, no fields are returned (useful to get only the links). If an indirect child resource is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?fields=Employees.Managers:Empname" is the same as "?fields=;Employees:;Employees.Managers:Empname" (which will only return the "Empname" field for Managers). the value of this query parameter is a list of resource fields. The attribute can be a direct (Example: Employees) or indirect (Example: Employees.Managers) child. It cannot be combined with expand query parameter. If both are provided, only fields will be considered.
Format: ?fields=Attribute1,Attribute2
Format for fields in child resource: ?fields=Accessor1:Attribute1,Attribute2 -
links: string
This parameter can be used to show only certain links while accessing a singular resource or a resource collection. The parameter value format is a comma-separated list of : <link_relation>
Example:
self,canonical -
onlyData: boolean
The resource item payload will be filtered in order to contain only data (no links section, for example).
Header Parameters
-
Metadata-Context: string
If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
-
REST-Framework-Version: string
The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
There's no request body for this operation.
Back to TopResponse
Supported Media Types
- application/json
Default Response
The following table describes the default response for this task.
Headers
-
Metadata-Context:
If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
-
REST-Framework-Version:
The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
Root Schema : mdfBudgets-FundRequest-item-response
Type:
Show Source
object-
ActivityEndDate: string
(date)
Title:
End DateThe date when the fund request activity was completed. -
ActivityStartDate: string
(date)
Title:
Start DateThe date when the fund request activity was started. -
Age: number
Title:
Request AgeRead Only:trueThe number of days since the creation of the MDF request. -
ApprovalActionComments: string
Title:
Approver CommentsThe comments entered during approval action on the fund request. -
ApprovalTaskStatusCode: string
Title:
StatusThe code indicating the approval action that can be taken in the MDF Claim. The accepted values are Approve, Reject, Return, Withdraw, Terminate, and HtOutcmeReturnReturnAction. -
ApprovedAmount: number
Title:
Approved AmountDefault Value:0The amount approved for the MDF request. -
ApprovedAmountPercent: number
Title:
Approved PercentDefault Value:100The percentage of amount approved of the total fund request. -
ApprovedBy: string
Title:
Approved ByMaximum Length:64The user who approved the MDF request. -
ApprovedById: integer
(int64)
Title:
Approved by IDThe unique identifier of the user who approved the marketing MDF request. -
ApprovedDate: string
(date)
Title:
Approved DateThe date on which the MDF request was approved. -
AvailableFundRequestAmount: number
Title:
Available AmountRead Only:trueDefault Value:0The difference between total approved marketing MDF request and total approved claim amounts, which is available to new claims. -
BgtExchangeRate: number
Title:
Budget Exchange RateDefault Value:0The exchange rate of the MDF budget which is associated with the fund request. -
BudgetCode: string
Title:
Budget CodeRead Only:trueMaximum Length:100Public Unique Identifier for the marketing Budget. -
BudgetCurrency: string
Title:
Budget CurrencyRead Only:trueMaximum Length:30The currency used for the MDF budget associated with the fund request. -
BudgetEndDate: string
(date)
Title:
Budget End DateRead Only:trueThe end date for the MDF budget associated with the fund request. -
BudgetId: integer
(int64)
Title:
Budget IDThe parent budget associated with the marketing MDF request. -
BudgetName: string
Title:
BudgetThe name of the MDF budget associated with the fund request. -
BudgetStartDate: string
(date)
Title:
Budget Start DateRead Only:trueThe start date for the MDF budget associated with the fund request. -
CanApprove: boolean
Title:
Can ApproveRead Only:trueIndicates whether a request can be approved by the user. -
CanReject: boolean
Title:
Can RejectRead Only:trueIndicates whether a request can be rejected by the user. -
CanReturn: boolean
Title:
Can ReturnRead Only:trueIndicates whether a request can be returned by the user. -
CanSubmit: boolean
Title:
Can SubmitRead Only:trueIndicates whether a request can be submitted by the user. -
CanTerminate: boolean
Title:
Can TerminateRead Only:trueIndicates whether a request can be terminated by the user. -
CanWithdraw: boolean
Title:
Can WithdrawRead Only:trueIndicates whether a request can be withdrawn by the user. -
ChannelManager: string
Title:
Channel ManagerRead Only:trueMaximum Length:450The user who is the channel manager for the fund request. -
ChannelManagerId: integer
(int64)
Title:
Channel Manager IDRead Only:trueThe unique identifier of the resource who is the channel manager for the fund request. -
Comments: string
Title:
CommentsMaximum Length:1000The additional comments for the marketing MDF request. -
ConversionCurrencyCode: string
Title:
Conversion Currency CodeRead Only:trueMaximum Length:30The currency code used for conversion in the request. -
ConversionRateType: string
Title:
Conversion Rate TypeRead Only:trueMaximum Length:30The currency conversion rate type for the MDF fund request. A list of valid values are defined in the lookup ZCA_COMMON_RATE_TYPE. Review and update the profile option using the Setup and Maintenance work area, Manage Currency Profile Options task. -
ConvExchangeRate: number
Title:
Conversion Exchange RateRead Only:trueThe currency exchange rate for the request against the corporate currency. -
CreatedBy: string
Title:
Created ByRead Only:trueMaximum Length:64The user who created the marketing MDF request. -
CreatedBy_FN: string
Title:
Created ByRead Only:trueThe name of the creator of the fund request. -
CreationDate: string
(date-time)
Title:
Creation DateRead Only:trueThe date when the MDF request was created. -
CurrencyCode: string
Title:
CurrencyMaximum Length:30The currency code for the MDF request. A list of valid values are defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the profile option using the Setup and Maintenance work area, Manage Currency Profile Options task. -
CurrencyConversionDate: string
(date)
Title:
Currency Conversion DateRead Only:trueThe date of currency exchange rate for the request against the corporate currency. -
DeleteFlag: boolean
Title:
Delete IndicatorRead Only:trueIndicates whether the request can be deleted. If the user has access to delete the request then the default value is true, else false. -
Description: string
Title:
DescriptionMaximum Length:4000The description for the marketing MDF request. -
FundRequestCode: string
Title:
CodeMaximum Length:100The unique alternate identifier of the marketing MDF request. -
FundRequestId: integer
(int64)
Title:
Fund Request IDThe unique identifier of the MDF request. -
FundRequestName: string
Title:
NameMaximum Length:250The display name for the MDF request. -
FundRequestStatusCode: string
Title:
StatusMaximum Length:30Default Value:DRAFTThe status code of the marketing MDF request. -
FundRequestType: string
Title:
TypeMaximum Length:30The type of the fund request. -
Justification: string
Title:
JustificationMaximum Length:1000The justification for the fund request. -
LastUpdateDate: string
(date-time)
Title:
Last Update DateRead Only:trueThe date when the fund request was last updated. -
LastUpdatedBy: string
Title:
Last Updated ByRead Only:trueMaximum Length:64The user who last updated the marketing MDF request. -
LastUpdateLogin: string
Title:
Last Update LoginRead Only:trueMaximum Length:32The login of the user who last updated the fund request. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
ManageApprovalDataFlag: boolean
Read Only:
trueIndicates whether user can modify fund request attributes while the fund request is awaiting approval. -
ManageGeneralDataFlag: boolean
Read Only:
trueIndicates whether user can modify fund request attributes when the fund request is either in draft or returned or withdrawn status. -
ManagePartnerDataFlag: boolean
Read Only:
trueIndicates that partner users are restricted from modifying the partner field. It indicates whether channel users can update the partner field when the fund request is in draft, return, or withdrawn status. -
ManageTeamDataFlag: boolean
Read Only:
trueIndicates whether the logged in user has full access on the fund request record. -
OwnerEmailAddress: string
Title:
EmailRead Only:trueMaximum Length:320The e-mail address of the owner of the fund request. -
OwnerFormattedPhoneNumber: string
Title:
PhoneRead Only:trueThe formatted phone number of the owner of the fund request. -
OwnerId: integer
(int64)
Title:
Owner IDThe internal resource who manages the marketing budget. -
OwnerName: string
Title:
OwnerMaximum Length:360The owner of the fund request. -
OwnerPartyNumber: string
Title:
Owner Party NumberRead Only:trueMaximum Length:30Public Unique Identifier for the Resource. -
PartnerCompanyNumber: string
Title:
Partner Company NumberMaximum Length:30Public Unique Identifier for the Partner. -
PartnerCountry: string
Title:
Partner CountryRead Only:trueMaximum Length:2The country of the partner associated with the fund request. -
PartnerId: integer
(int64)
Title:
Partner IDThe unique identifier of the partner account associated to the marketing MDF request. -
PartnerName: string
Title:
PartnerMaximum Length:360The partner account identifier name associated to the marketing MDF request. -
PartnerPartyUniqueName: string
Title:
PartnerRead Only:trueMaximum Length:360The name of the partner associated with the fund request. -
RecordSet: string
Title:
Record SetRead Only:trueFinds MDF request based on the filter criteria. -
RejectedBy: string
Title:
Rejected ByMaximum Length:64The user who rejected the marketing MDF request. -
RejectedById: integer
(int64)
Title:
Rejected by IDThe unique identifier of the user who rejected the MDF request. -
RejectedDate: string
(date)
Title:
Rejected DateThe date when the marketing MDF request was rejected. -
RejectReasonCode: string
Title:
Reject ReasonThe reason code for rejecting the fund request. -
RequestedAmount: number
Title:
Requested AmountThe amount submitted for the MDF request. The amount is displayed in the currency code associated with the MDF claim. -
RequestStatusMeaning: string
Title:
StatusThe status of the MDF request. -
ReturnReasonCode: string
Title:
Return ReasonThe reason code for returning the fund request back to the submitter. -
SubmitClaimsBy: string
(date)
Title:
Claim DeadlineRead Only:trueThe date by which associated claim needs to be submitted. -
SubmitFundReqBy: string
(date)
Title:
Request DeadlineThe date by which fund request needs to be submitted. -
SubmittedBy: string
Title:
Submitted ByMaximum Length:64The user who submitted the marketing MDF request. -
SubmittedById: integer
(int64)
Title:
Submitted by IDThe unique identifier of the user who submitted the request. -
SubmittedDate: string
(date)
Title:
Submitted DateThe date when the marketing MDF request was submitted. -
TotalApprovedClaimAmount: number
Title:
Approved Claim AmountRead Only:trueDefault Value:0The total amount of all approved claims for the marketing MDF request. -
UpdateFlag: boolean
Title:
Update IndicatorRead Only:trueIndicates whether the request can be updated. If the user has access to update the request then the default value is true, else false.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : link
Type:
Show Source
object-
href: string
Title:
hyperlink referenceThe URI to the related resource. -
kind: string
Title:
kindAllowed Values:[ "collection", "item", "describe", "other" ]The kind of the related resource. -
name: string
Title:
nameThe name of the link to the related resource. -
properties: object
properties
-
rel: string
Title:
relationAllowed Values:[ "self", "lov", "parent", "canonical", "child", "enclosure", "action", "custom" ]The name of the relation to the resource instance. Example: self.
Nested Schema : properties
Type:
Show Source
object-
changeIndicator: string
Change indicator or the ETag value of the resource instance.
Links
- BudgetLOVVA
-
Operation: /crmRestApi/resources/11.13.18.05/mdfBudgetsParameters:
- finder:
MdfRestActiveBudgetFinder%3BbindStatus%3DACTIVE
The list of values to indicate the budget name associated to fund request.
The following properties are defined on the LOV link relation:- Source Attribute: BudgetName; Target Attribute: BudgetName
- Display Attribute: BudgetName, PartnerNameTrans
- finder:
- CurrencyPVA
-
The list of values to indicate the currency code for the MDF Request such as USD, CAD, or Euro.
The following properties are defined on the LOV link relation:- Source Attribute: CurrencyCode; Target Attribute: CurrencyCode
- Display Attribute: CurrencyCode
- FundRequestPartnerPartySearchVA
-
The list of values to indicate the partners associated with the MDF request.
The following properties are defined on the LOV link relation:- Source Attribute: PartnerId; Target Attribute: PartyId
- Display Attribute: PartyId
- FundRequestTypeLOVVA
-
Parameters:
- finder:
LookupTypeActiveEnabledOrBindCodeFinder%3BBindLookupType%3DORA_MKT_MDFREQUEST_TYPE%2CBindLookupCode%3D{FundRequestType}
The list of values to indicate the types of the MDF requests.
The following properties are defined on the LOV link relation:- Source Attribute: FundRequestType; Target Attribute: LookupCode
- Display Attribute: Meaning
- finder:
- RecordSetVA
-
Parameters:
- finder:
LookupTypeActiveEnabledOrBindCodeFinder%3BBindLookupType%3DORA_MKT_MDF_RECORD_SET%2CBindLookupCode%3D{RecordSet}
The list of values that lets you to select the record set.
The following properties are defined on the LOV link relation:- Source Attribute: RecordSet; Target Attribute: LookupCode
- Display Attribute: Meaning
- finder:
- RejectReasonCodeVA
-
Parameters:
- finder:
LookupTypeActiveEnabledOrBindCodeFinder%3BBindLookupCode%3D{RejectReasonCode}%2CBindLookupType%3DORA_MKT_MDFREQUEST_REJECT
The list of values to indicate the reject reason of the fund request.
The following properties are defined on the LOV link relation:- Source Attribute: RejectReasonCode; Target Attribute: LookupCode
- Display Attribute: Meaning
- finder:
- RequestStatusLOVVA
-
Parameters:
- finder:
LookupTypeActiveEnabledOrBindCodeFinder%3BBindLookupType%3DMKT_MDF_FUNDREQ_STATUS%2CBindLookupCode%3D{FundRequestStatusCode}
The list of values to indicate the status of the MDF request.
The following properties are defined on the LOV link relation:- Source Attribute: FundRequestStatusCode; Target Attribute: LookupCode
- Display Attribute: Meaning
- finder:
- ResourceVOVA
-
Operation: /crmRestApi/resources/11.13.18.05/resourcesThe list of values to indicate the name of the owner associated with the MDF request.
The following properties are defined on the LOV link relation:- Source Attribute: OwnerName; Target Attribute: PartyName
- Display Attribute: PartyName
- ReturnReasonCodeVA
-
Parameters:
- finder:
LookupTypeActiveEnabledOrBindCodeFinder%3BBindLookupCode%3D{ReturnReasonCode}%2CBindLookupType%3DORA_MKT_MDFREQUEST_RETURN
The list of values to indicate the return reason of the fund request.
The following properties are defined on the LOV link relation:- Source Attribute: ReturnReasonCode; Target Attribute: LookupCode
- Display Attribute: Meaning
- finder:
Examples
The following example shows how to get a mdf request associated to the budget by submitting a get request on the REST resource using cURL.
cURL Command
curl -u <username:password> \ -X
https://servername.fa.us2.oraclecloud.com/fscmRestApi/resources/11.13.18.05/mdfBudgets/{BudgetCode}/child/FundRequest/{FundRequestCode}
Example of Response Body
The following shows an example of the response body in JSON format.
{
"RecordSet": null,
"FundRequestId": 300100543257820,
"FundRequestName": "RequestApp_0b602762412",
"CurrencyCode": "USD",
"RequestedAmount": 100000,
"ApprovedAmount": 100000,
"CreationDate": "2021-06-17T04:06:25+00:00",
"RequestStatusMeaning": "Approved",
"Age": 123,
"ApprovedBy": "Account_MgrENT1 CAM",
"ApprovedDate": "2021-06-17",
"BudgetName": "BudgetActive_64d02762383",
"Description": null,
"FundRequestCode": "RequestApp_0b602762412",
"LastUpdatedBy": "Channel_OPS_Mgr_ENT1 COM",
"LastUpdateDate": "2021-06-17T04:06:51.202+00:00",
"PartnerName": "Stryker Corp.",
"RejectedBy": null,
"RejectedDate": null,
"SubmittedDate": null,
"CreatedBy": "CHANNEL_OPERATIONS_MANAGER",
"LastUpdateLogin": "C4774F721408A0D0E0533DFDF40A851E",
"BudgetId": 300100543257793,
"FundRequestStatusCode": "APPROVED",
"PartnerId": 100000016934002,
"SubmittedBy": null,
"TotalApprovedClaimAmount": 100,
"AvailableFundRequestAmount": 99900,
"SubmitFundReqBy": "2021-06-24",
"Comments": null,
"CreatedBy_FN": "Channel_OPS_Mgr_ENT1 COM",
"ConversionRateType": "Corporate",
"ConversionCurrencyCode": "USD",
"BgtExchangeRate": 1,
"ApprovedAmountPercent": 100,
"FundRequestType": null,
"Justification": null,
"OwnerId": 100010038017885,
"ActivityEndDate": null,
"ChannelManager": "Account_MgrENT1 CAM",
"ActivityStartDate": null,
"OwnerName": "Channel_OPS_Mgr_ENT1 COM",
"ChannelManagerId": 100010038017873,
"PartnerPartyUniqueName": "Stryker Corp.",
"PartnerCountry": "US",
"OwnerEmailAddress": "sendmail-test-discard@oracle.com",
"ApprovedById": 100010038017873,
"CurrencyConversionDate": "2021-06-17",
"RejectedById": null,
"SubmittedById": null,
"CanSubmit": "false",
"CanTerminate": "true",
"OwnerFormattedPhoneNumber": "+1 (650) 633-8437",
"CanApprove": "false",
"CanReject": "false",
"CanReturn": "false",
"CanWithdraw": "false",
"ReturnReasonCode": null,
"RejectReasonCode": null,
"ApprovalActionComments": null,
"ConvExchangeRate": 1,
"UpdateFlag": false,
"DeleteFlag": false,
"ApprovalTaskStatusCode": null,
"OwnerPartyNumber": "100010038017885",
"PartnerCompanyNumber": "100001",
"SubmitClaimsBy": "2021-06-24",
"BudgetCurrency": "USD",
"BudgetStartDate": "2021-06-17",
"BudgetEndDate": null,
"BudgetCode": "BudgetActive_64d02762383",
"links": [
{
"rel": "self",
"href": "https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/mdfBudgets/BudgetActive_64d02762383/child/FundRequest/RequestApp_0b602762412",
"name": "FundRequest",
"kind": "item",
"properties": {
"changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000278"
}
},
{
"rel": "canonical",
"href": "https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/mdfBudgets/BudgetActive_64d02762383/child/FundRequest/RequestApp_0b602762412",
"name": "FundRequest",
"kind": "item"
},
{
"rel": "parent",
"href": "https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/mdfBudgets/BudgetActive_64d02762383",
"name": "mdfBudgets",
"kind": "item"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/mdfBudgets/BudgetActive_64d02762383/child/FundRequest/RequestApp_0b602762412/lov/FundRequestTypeLOVVA",
"name": "FundRequestTypeLOVVA",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/mdfBudgets/BudgetActive_64d02762383/child/FundRequest/RequestApp_0b602762412/lov/ReturnReasonCodeVA",
"name": "ReturnReasonCodeVA",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/mdfBudgets/BudgetActive_64d02762383/child/FundRequest/RequestApp_0b602762412/lov/RequestStatusLOVVA",
"name": "RequestStatusLOVVA",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/mdfBudgets/BudgetActive_64d02762383/child/FundRequest/RequestApp_0b602762412/lov/FundRequestPartnerPartySearchVA",
"name": "FundRequestPartnerPartySearchVA",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/mdfBudgets/BudgetActive_64d02762383/child/FundRequest/RequestApp_0b602762412/lov/ResourceVOVA",
"name": "ResourceVOVA",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/mdfBudgets/BudgetActive_64d02762383/child/FundRequest/RequestApp_0b602762412/lov/CurrencyPVA",
"name": "CurrencyPVA",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/mdfBudgets/BudgetActive_64d02762383/child/FundRequest/RequestApp_0b602762412/lov/RejectReasonCodeVA",
"name": "RejectReasonCodeVA",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/mdfBudgets/BudgetActive_64d02762383/child/FundRequest/RequestApp_0b602762412/lov/BudgetLOVVA",
"name": "BudgetLOVVA",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername.fa.us2.oraclecloud.com/crmRestApi/resources/11.13.18.05/mdfBudgets/BudgetActive_64d02762383/child/FundRequest/RequestApp_0b602762412/lov/RecordSetVA",
"name": "RecordSetVA",
"kind": "collection"
}
]
}