Get all headers
get
/fscmRestApi/resources/11.13.18.05/purchaseRequisitions
Request
Query Parameters
-
effectiveDate: string
This query parameter is used to fetch resources which are effective dated as of the specified start date. The value of this query parameter is a string having a date in yyyy-MM-dd format
-
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 -
finder: string
Used as a predefined finder to search the collection.
Format: ?finder=<finderName>;<variableName>=<variableValue>,<variableName2>=<variableValue2>
The following are the available finder names and corresponding finder variables:- ActiveRequisitionInPreferredBUFinder: Finds an active requisition from the shopping cart based on the requisitioning business unit selected by the logged in user in their requisition preferences.
Finder Variables:- bindPreparerId; integer; Value that uniquely identifies the user who created the requisition.
- InternallyManagedRequisitionsFinder: Finds internally managed requisitions for the logged in user.
Finder Variables:- bindPreparerId; integer; Value that uniquely identifies the user who created the requisition.
- PrimaryKey: Finds purchase requisition headers according to the primary key.
Finder Variables:- RequisitionHeaderId; integer; Value that uniquely identifies the purchase requisition header.
- ActiveRequisitionInPreferredBUFinder: Finds an active requisition from the shopping cart based on the requisitioning business unit selected by the logged in user in their requisition preferences.
-
limit: integer
This parameter restricts the number of resources returned inside the resource collection. If the limit exceeds the resource count then the framework will only return the available resources.
-
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 -
offset: integer
Used to define the starting position of the resource collection. If offset exceeds the resource count then no resources are returned. Default value is 0.
-
onlyData: boolean
The resource item payload will be filtered in order to contain only data (no links section, for example).
-
orderBy: string
This parameter orders a resource collection based on the specified fields. The parameter value is a comma-separated string of attribute names, each optionally followed by a colon and "asc" or "desc". Specify "asc" for ascending and "desc" for descending. The default value is "asc". For example, ?orderBy=field1:asc,field2:desc
-
q: string
This query parameter defines the where clause. The resource collection will be queried using the provided expressions. The value of this query parameter is one or more expressions. Example: ?q=Deptno>=10 and <= 30;Loc!=NY
Format: ?q=expression1;expression2
You can use these queryable attributes to filter this collection resource using the q query parameter:- ActiveRequisitionFlag; boolean; Contains one of the following values: Y or N. If Y, then the requisition is active for a preparer-business unit combination. If N, then the requisition isn???t active for a preparer-business unit combination. The default value is N.
- CreatedBy; string; User who created the requisition.
- CreationDate; string; Date and time when the requisition was created.
- Description; string; Description of the requisition.
- DocumentStatus; string; Status of the requisition.
- DocumentStatusCode; string; Abbreviation that identifies the requisition status.
- LastUpdateDate; string; Date and time when the requisition was last updated.
- LastUpdatedBy; string; Name of the user who last updated the requisition.
- OverridingApproverPersonNumber; string; Person number of the user specified on the requisition as the overriding approver for approval routing.
- Preparer; string; Name of the user who owns the requisition. This user creates the requisition but can transfer ownership to another user.
- PreparerId; integer; Value that uniquely identifies the user who created the requisition.
- Requisition; string; Number that identifies the requisition. It's used to identify the requisition by end users.
- RequisitionHeaderId; integer; Value that uniquely identifies the requisition.
- RequisitioningBU; string; Name of the business unit that raised the requisition for goods and services.
- RequisitioningBUId; integer; Value that uniquely identifies the business unit that raised the requisition for goods and services.
- SpecialHandlingType; string; Type of special handling required for the requisition. Examples of special handling cases are Bill only, Bill and replace, and so on.
- SpecialHandlingTypeCode; string; Abbreviation that identifies the special handling type of the requisition.
-
totalResults: boolean
The resource collection representation will include the "estimated row count" when "?totalResults=true", otherwise the count is not included. The default value is "false".
Header Parameters
-
Effective-Of:
This header accepts a string value. The string is a semi-colon separated list of
= . It is used to perform effective date range operations. The accepted parameters are RangeMode, RangeSpan, RangeStartDate, RangeEndDate, RangeStartSequence and RangeEndSequence. The parameter values are always strings. The possible values for RangeMode are SET_LOGICAL_START, SET_LOGICAL_END, END_DATE, SET_EFFECTIVE_START, SET_EFFECTIVE_END, REPLACE_CORRECTION, REPLACE_UPDATE, RECONCILE_CORRECTION, CORRECTION, RECONCILE_UPDATE, UPDATE, ZAP and DELETE_CHANGES. The possible values for RangeSpan are PHYSICAL_ROW_END_DATE and LOGICAL_ROW_END_DATE. The values for RangeStartDate and RangeEndDate have to be a string representation of a date in yyyy-MM-dd format. The value for RangeStartSequence and RangeEndSequence must be strings such that when parsed they yield positive integers. -
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.
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 : purchaseRequisitions
Type:
Show Source
object
-
count(required): integer
The number of resource instances returned in the current range.
-
hasMore(required): boolean
Indicates whether more resources are available on the server than the subset returned in the response. If the value is true, then there are more resources to retrieve from the server. The default value is false.
-
items: array
Items
Title:
Items
The items in the collection. -
limit(required): integer
The actual paging size used by the server.
-
links(required): array
Links
Title:
Links
The link relations associated with the resource instance. -
offset(required): integer
The offset value used in the current page.
-
totalResults: integer
The estimated row count when "?totalResults=true", otherwise the count is not included.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : purchaseRequisitions-item-response
Type:
Show Source
object
-
ActiveRequisitionFlag: boolean
Maximum Length:
1
Default Value:false
Contains one of the following values: Y or N. If Y, then the requisition is active for a preparer-business unit combination. If N, then the requisition isn???t active for a preparer-business unit combination. The default value is N. -
ApprovedByEmail: string
Title:
Approved by Email
Maximum Length:240
Email address of the approver of the requisition. -
ApprovedById: integer
(int64)
Value that uniquely identifies the approver of the requisition.
-
ApprovedDate: string
(date-time)
Read Only:
true
Date and time when the requisition was most recently approved. -
attachments: array
Attachments for Purchase Requisitions
Title:
Attachments for Purchase Requisitions
The Attachments for Purchase Requisitions resource manages attachments for a purchase requisition. -
BudgetaryControlEnabledFlag: boolean
Read Only:
true
Maximum Length:1
Contains one of the following values: true, or false, or Null. If true, then the underlying requisitioning business unit has been enabled for budgetary control. If false, then the underlying requisitioning business unit hasn't been enabled for budgetary control. If Null, then the value hasn't been set. The default value is Null. -
CreatedBy: string
Read Only:
true
Maximum Length:64
User who created the requisition. -
CreationDate: string
(date-time)
Read Only:
true
Date and time when the requisition was created. -
Description: string
Maximum Length:
240
Description of the requisition. -
DFF: array
Flexfields for Purchase Requisitions
Title:
Flexfields for Purchase Requisitions
The Flexfields for Purchase Requisitions resource manages details about purchase requisitions. -
DocumentStatus: string
Title:
Status
Read Only:true
Maximum Length:80
Status of the requisition. -
DocumentStatusCode: string
Read Only:
true
Maximum Length:25
Default Value:INCOMPLETE
Abbreviation that identifies the requisition status. -
EmergencyPONumber: string
Read Only:
true
Maximum Length:30
Number that identifies the purchase order reserved in advance for an emergency requisition. -
EmergencyRequisitionFlag: boolean
Read Only:
true
Maximum Length:1
Contains one of the following values: true, or false, or Null. If true, then requisition is an emergency requisition. If false, then requisition isn't an emergency requisition. If Null, then the value hasn't been set. The default value is Null. -
ExternallyManagedFlag: boolean
Maximum Length:
1
Contains one of the following values: true, or false. If true, then requisition is externally managed. If false, then requisition isn't externally managed. This attribute doesn't have a default value. -
FunctionalCurrencyCode: string
Read Only:
true
Maximum Length:15
Abbreviation that identifies the currency of the current requisitioning business unit. -
FundsChkFailWarnFlag: boolean
Maximum Length:
1
Default Value:false
Contains one of the following values: true, or false, or Null. If true, then funds check failed. If false, then funds check didn't fail. If Null, then the value hasn't been set. The default value is Null. -
FundsOverrideApprover: string
Title:
Funds Override Approver
Read Only:true
Maximum Length:240
User who has the authority to override insufficient funds for a requisition. -
FundsOverrideApproverEmail: string
Title:
Funds Override Approver Email
Read Only:true
Maximum Length:240
Email address of the specific user who has the authority to override insufficient funds for a requisition. -
FundsOverrideApproverId: integer
(int64)
Read Only:
true
Value that uniquely identifies the user who has the authority to override insufficient funds for a requisition. -
FundsStatus: string
Title:
Funds Status
Read Only:true
Maximum Length:80
Status of the funds reservation request. -
FundsStatusCode: string
Read Only:
true
Maximum Length:30
Abbreviation that identifies the status of funds check or funds reservation validation result. -
HasActionRequiredLinesFlag: boolean
Read Only:
true
Maximum Length:1
Contains one of the following values: Y or N. If Y, then the requisition contains lines that require an action. If N, then the requisition doesn't contain lines that require an action. The default value is N. -
HasPendingApprovalLinesFlag: boolean
Read Only:
true
Maximum Length:1
Contains one of the following values: true, false, or Null. If true, then the requisition contains lines that are pending approval. If false, then the requisition doesn't contain lines that are pending approval. If Null, then the value hasn't been set. The default value is Null. -
HasRejectedLinesFlag: boolean
Read Only:
true
Maximum Length:1
Contains one of the following values: true, false, or Null. If true, then the requisition contains rejected lines. If false, then the requisition doesn't contain rejected lines. If Null, then the value hasn't been set. The default value is Null. -
HasReturnedLinesFlag: boolean
Read Only:
true
Maximum Length:1
Contains one of the following values: true, false, or Null. If true, then the requisition contains returned lines. If false, then the requisition doesn't contain returned lines. If Null, then the value hasn't been set. The default value is Null. -
HasWithdrawnLinesFlag: boolean
Read Only:
true
Maximum Length:1
Contains one of the following values: true, false, or Null. If true, then the requisition contains withdrawn lines. If false, then the requisition doesn't contain withdrawn lines. If Null, then the value hasn't been set. The default value is Null. -
IdentificationKey: string
Read Only:
true
Maximum Length:255
Value that's used to get the approval task ID that uniquely identifies the approval task for a requisition. -
InsufficientFundsFlag: boolean
Maximum Length:
1
Default Value:false
Contains one of the following values: true, false, or Null. If true, then the requisition was submitted for approval with a funds override request due to insufficient funds. If false, then the requisition was submitted for approval without a funds override request. If Null, then the value hasn't been set. The default value is Null. -
InterfaceSourceCode: string
Maximum Length:
25
Abbreviation that identifies the source of the requisition from a requisition import process. -
InterfaceSourceLineId: integer
(int64)
Read Only:
true
Value that uniquely identifies the source requisition line from a requisition import process. -
InternalTransferFlag: boolean
Read Only:
true
Maximum Length:1
Default Value:false
Contains one of the following values: true, or false, or Null. If true, then all the lines on the requisition are for internal material transfer. If false, then not all the lines on the requisition are for internal material transfer. If Null, then the value hasn't been set. The default value is Null. -
Justification: string
Title:
Justification
Maximum Length:1000
Reason for creating the requisition. -
LastUpdateDate: string
(date-time)
Read Only:
true
Date and time when the requisition was last updated. -
LastUpdatedBy: string
Read Only:
true
Maximum Length:64
Name of the user who last updated the requisition. -
LifecycleStatus: string
Title:
Lifecycle Status
Read Only:true
Maximum Length:80
Aggregated value of the lifecycle status across requisition lines. This attribute isn't currently used. -
LifecycleStatusCode: string
Read Only:
true
Maximum Length:30
Abbreviation that identifies the requisition lifecycle status. This attribute isn't currently used. -
lines: array
Lines
Title:
Lines
The Lines resource manages items to be requisitioned, their quantity, unit of measure, price, and deliver-to-location information. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
LockedByBuyerFlag: boolean
Read Only:
true
Maximum Length:1
Contains one of the following values: true, false, or Null. If true, then the requisition contains lines that the buyer is currently modifying. If false, then the requisition doesn't contain lines that the buyer is currently modifying. If Null, then the value hasn't been set. The default value is Null. -
ModifyingApprover: string
Title:
Modifying Approver
Read Only:true
Maximum Length:240
Name of the user who is currently modifying the requisition during the approval process. -
ModifyingApproverEmail: string
Title:
Modifying Approver Email
Read Only:true
Maximum Length:240
Email address of the user who is currently modifying the requisition during the approval process. -
ModifyingApproverId: integer
(int64)
Read Only:
true
Value that uniquely identifies the user who is currently modifying the requisition during the approval process. -
OverridingApprover: string
Title:
Overriding Approver
Read Only:true
Maximum Length:240
Name of the user specified on the requisition as the overriding approver for approval routing. -
OverridingApproverEmail: string
Title:
Overriding Approver Email
Read Only:true
Maximum Length:240
Email address of the user specified on the requisition as the overriding approver for approval routing. -
OverridingApproverId: integer
(int64)
Value that uniquely identifies the user specified on the requisition as the overriding approver for approval routing.
-
OverridingApproverPersonNumber: string
Title:
Overriding Approver Person Number
Maximum Length:30
Person number of the user specified on the requisition as the overriding approver for approval routing. -
Preparer: string
Title:
Entered By
Read Only:true
Maximum Length:240
Name of the user who owns the requisition. This user creates the requisition but can transfer ownership to another user. -
PreparerEmail: string
Title:
Entered by Email
Maximum Length:240
Email address of the user who owns the requisition. This user is the person who created the requisition unless ownership was transferred from the user who created the requisition. -
PreparerId: integer
(int64)
Value that uniquely identifies the user who created the requisition.
-
RejectedByDisplayName: string
Title:
Name
Read Only:true
Maximum Length:240
Display name of the person who rejected the requisition lines. -
RejectedById: integer
(int64)
Read Only:
true
Value that uniquely identifies the person who rejected the requisition lines. -
RejectedReason: string
Read Only:
true
Maximum Length:4000
Reason for rejecting the requisition lines. -
Requisition: string
Read Only:
true
Maximum Length:64
Number that identifies the requisition. It's used to identify the requisition by end users. -
RequisitionHeaderId: integer
(int64)
Read Only:
true
Value that uniquely identifies the requisition. -
RequisitioningBU: string
Title:
Requisitioning BU
Maximum Length:240
Name of the business unit that raised the requisition for goods and services. -
RequisitioningBUId: integer
(int64)
Value that uniquely identifies the business unit that raised the requisition for goods and services.
-
RequisitionLineGroup: string
Read Only:
true
Maximum Length:30
Default Value:LINES_REQUIRING_ATTENTION
Value that indicates the group of the requisition lines in the requisition. -
SoldToLegalEntity: string
Title:
Legal Entity
Read Only:true
Maximum Length:240
Legal entity that's liable for the corresponding purchase order amount. -
SoldToLegalEntityId: integer
(int64)
Read Only:
true
Value that uniquely identifies the legal entity that's liable for the corresponding purchase order amount. -
SourceApplicationCode: string
Maximum Length:
25
Abbreviation that uniquely identifies the application used to create the requisition. This attribute isn't currently used. -
specialHandlingDFF: array
Special Handling Flexfields for Purchase Requisition
Title:
Special Handling Flexfields for Purchase Requisition
The Special Handling Flexfields for Purchase Requisitions resource manages details about purchase requisitions. -
SpecialHandlingType: string
Maximum Length:
30
Type of special handling required for the requisition. Examples of special handling cases are Bill only, Bill and replace, and so on. -
SpecialHandlingTypeCode: string
Maximum Length:
30
Abbreviation that identifies the special handling type of the requisition. -
SubmissionDate: string
(date-time)
Read Only:
true
Date and time when the requisition was submitted for approval. -
summaryAttributes: array
Summary Attributes for Purchase Requisitions
Title:
Summary Attributes for Purchase Requisitions
The Summary Attributes for Purchase Requisitions resource manages the aggregated summary attributes of purchase requisitions. The summary attributes comprise aggregated information from across the lines for a requisition. This resource returns the corresponding data only when called in conjunction with an appropriate finder.
Nested Schema : Attachments for Purchase Requisitions
Type:
array
Title:
Attachments for Purchase Requisitions
The Attachments for Purchase Requisitions resource manages attachments for a purchase requisition.
Show Source
Nested Schema : Flexfields for Purchase Requisitions
Type:
array
Title:
Flexfields for Purchase Requisitions
The Flexfields for Purchase Requisitions resource manages details about purchase requisitions.
Show Source
Nested Schema : Lines
Type:
array
Title:
Lines
The Lines resource manages items to be requisitioned, their quantity, unit of measure, price, and deliver-to-location information.
Show Source
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Special Handling Flexfields for Purchase Requisition
Type:
array
Title:
Special Handling Flexfields for Purchase Requisition
The Special Handling Flexfields for Purchase Requisitions resource manages details about purchase requisitions.
Show Source
-
Array of:
object Discriminator: __FLEX_Context
Discriminator:
{ "propertyName":"__FLEX_Context", "mapping":{ "ORA_PO_BILL_ONLY_HEADERS":"#/components/schemas/oracle_apps_flex_prc_por_manageReq_restModel_specialHandlingHeaders_view_RequisitionHeaderSHDFFORA__5FPO__5FBILL__5FONLY__5FHEADERSVO-item-response" } }
Nested Schema : Summary Attributes for Purchase Requisitions
Type:
array
Title:
Summary Attributes for Purchase Requisitions
The Summary Attributes for Purchase Requisitions resource manages the aggregated summary attributes of purchase requisitions. The summary attributes comprise aggregated information from across the lines for a requisition. This resource returns the corresponding data only when called in conjunction with an appropriate finder.
Show Source
Nested Schema : purchaseRequisitions-attachments-item-response
Type:
Show Source
object
-
AsyncTrackerId: string
Title:
Asynchronous Upload Tracker Id
An identifier used for tracking the uploaded files. -
AttachedDocumentId: integer
(int64)
Title:
Attached Document Id
Value that uniquely identifies the attached document. -
CategoryName: string
Title:
Category
Maximum Length:30
Name of the attachment category. - ContentRepositoryFileShared: boolean
-
CreatedBy: string
Title:
Created By
Read Only:true
Maximum Length:255
User who created the record. -
CreatedByUserName: string
Title:
Created By User Name
Read Only:true
Login that the user used when creating the document. -
CreationDate: string
(date-time)
Title:
Creation Date
Read Only:true
Date and time when the user created the record. -
DatatypeCode: string
Title:
Type
Maximum Length:30
Default Value:FILE
Abbreviation that identifies the data type. -
Description: string
Title:
Description
Maximum Length:255
Description of the attachment. -
DmDocumentId: string
Maximum Length:
255
Value that uniquely identifies the document from which the attachment is created. -
DmFolderPath: string
Title:
Dm Folder Path
Maximum Length:1000
Path of the folder from which the attachment is created. -
DmVersionNumber: string
Maximum Length:
255
Number that identifies the document version from which the attachment is created. -
DownloadInfo: string
Title:
DownloadInfo
JSON object represented as a string containing information used to programmatically retrieve a file attachment. -
ErrorStatusCode: string
Title:
Error Status Code
Abbreviation that identifies the error code, if any, for the attachment. -
ErrorStatusMessage: string
Title:
Error Status Message
Text of the error message, if any, for the attachment. -
ExpirationDate: string
(date-time)
Title:
Expiration Date
Date when the contents of the attachment are no longer valid. -
FileContents: string
(byte)
Title:
File Contents
Contents of the attached file. -
FileName: string
Title:
File Name
Maximum Length:2048
Name of the attached file. -
FileUrl: string
Title:
File Url
Uniform resource locator of the file. -
FileWebImage: string
(byte)
Title:
File Web Image
Read Only:true
Base64-encoded image of the file displayed in .png format if the source is a convertible image. -
LastUpdateDate: string
(date-time)
Title:
Last Update Date
Read Only:true
Date and time when the user most recently updated the record. -
LastUpdatedBy: string
Title:
Last Updated By
Read Only:true
Maximum Length:255
User who most recently updated the record. -
LastUpdatedByUserName: string
Title:
Last Updated By User
Read Only:true
Login that the user used when updating the document. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
PostProcessingAction: string
Title:
PostProcessingAction
The name of the action that can be performed after an attachment is uploaded. -
Title: string
Title:
Title
Title of the attachment. -
UploadedFileContentType: string
Title:
Uploaded File Content Type
Content type of the attached file. -
UploadedFileLength: integer
Title:
File Size
Size of the attached file. -
UploadedFileName: string
Title:
Uploaded File Name
Name of the attached file. -
UploadedText: string
Title:
Uploaded Text
Contents of text file that is attached. -
Uri: string
Title:
Uri
Maximum Length:4000
URI (Uniform Resource Identifier) of the topology manager type attachment. -
Url: string
Title:
Url
Maximum Length:4000
Uniform resource locator of the web page type attachment. -
UserName: string
Title:
User Name
Read Only:true
Maximum Length:255
Login that the user used when creating the attachment.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : link
Type:
Show Source
object
-
href: string
Title:
hyperlink reference
The URI to the related resource. -
kind: string
Title:
kind
Allowed Values:[ "collection", "item", "describe", "other" ]
The kind of the related resource. -
name: string
Title:
name
The name of the link to the related resource. -
properties: object
properties
-
rel: string
Title:
relation
Allowed 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.
Nested Schema : purchaseRequisitions-DFF-item-response
Type:
Show Source
object
-
__FLEX_Context: string
Title:
Attribute Value
Maximum Length:30
Descriptive flexfield context name for purchase requisition distributions -
__FLEX_Context_DisplayValue: string
Title:
Attribute Value
Descriptive flexfield context display value for purchase requisition distributions. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
RequisitionHeaderId: integer
(int64)
Value that uniquely identifies the requisition.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : purchaseRequisitions-lines-item-response
Type:
Show Source
object
-
ActionRequired: string
Title:
Meaning
Read Only:true
Maximum Length:80
Action required of the requisition preparer or a requester on a requisition line. -
ActionRequiredCode: string
Read Only:
true
Maximum Length:30
Abbreviation that identifies the action required of the requisition preparer or a requester on a requisition line. -
AdditionalContactEmail: string
Title:
Additional Contact Email
Maximum Length:1500
Email addresses of additional supplier contacts. These email addresses are used to send purchase orders to supplier contacts involved in the procurement process. -
Amount: number
Read Only:
true
Total amount of the requested items in the currency of the buying company. -
AssignedBuyer: string
Title:
Assigned Buyer
Read Only:true
Maximum Length:240
Name of the person responsible for managing the purchase requisition through its life cycle. -
AssignedBuyerDisplayName: string
Title:
Name
Read Only:true
Maximum Length:240
Display name of the person responsible for managing the purchase requisition through its life cycle. -
AssignedBuyerEmail: string
Title:
Assigned Buyer Email
Read Only:true
Maximum Length:240
Email address of the person responsible for managing the purchase requisition through its life cycle. -
AssignedBuyerId: integer
(int64)
Read Only:
true
Value that uniquely identifies the person responsible for managing the purchase requisition through its life cycle. -
attachments: array
Attachments for Lines
Title:
Attachments for Lines
The Attachments for Lines resource manages attachments for a purchase requisition line. -
BackToBackFlag: boolean
Read Only:
true
Maximum Length:1
Contains one of the following values: true or false. If true, then the purchase requisition line is intended to fulfill a specific customer sales order upon receipt. If false, then the purchase requisition line doesn't have a backing sales order. This attribute doesn't have a default value. -
BPADescriptionUserOverrideFlag: boolean
Read Only:
true
Maximum Length:1
Contains one of the following values: true or false. If true, then the blanket purchase agreement description attribute has been updated by the user. If false, then the blanket purchase agreement description attribute hasn't been updated by the user. The default value is false. -
BPAPriceUserOverrideFlag: boolean
Read Only:
true
Maximum Length:1
Contains one of the following values: true or false. If true, then the blanket purchase agreement price attribute has been updated by the user. If false, then the blanket purchase agreement price attribute hasn't been updated by the user. The default value is false. -
BuyerOnPurchaseOrder: string
Title:
Name
Read Only:true
Maximum Length:240
Display name of the person who is responsible for managing the purchase order. -
BuyerProcessingFlag: boolean
Read Only:
true
Maximum Length:1
Contains one of the following values: true or false. If true, then the requisition line is being processed by the buyer. If false, then the requisition line isn't being processed by the buyer. The default value is false. -
CancelDate: string
(date)
Read Only:
true
Date when the requested items were canceled. -
CancelReason: string
Read Only:
true
Maximum Length:240
Reason for canceling the requested items. -
Carrier: string
Title:
Carrier
Read Only:true
Maximum Length:360
Company that transports goods from one point to another by land, sea, or air. -
CarrierId: integer
(int64)
Read Only:
true
Value that uniquely identifies the company that transports goods from one point to another by land, sea, or air. -
CategoryId: integer
(int64)
Value that uniquely identifies the purchasing category.
-
CategoryName: string
Maximum Length:
2400
Name of the purchasing category that is used for classifying the purchase being made by using this order line. -
ConfiguredItemFlag: boolean
Read Only:
true
Maximum Length:1
Default Value:false
Contains one of the following values: true or false. If true, then the requisition line is for a configured item and configuration details might exist. If false, then the requisition line isn't for a configured item. This attribute doesn't have a default value. -
ConversionRate: number
Conversion rate to use when converting the currency.
-
ConversionRateDate: string
(date)
Date from when the conversion rate is used to convert an amount into another currency.
-
ConversionRateType: string
Maximum Length:
30
Type of rate used to determine the currency conversion rate for the purchase requisition. -
CreatedBy: string
Read Only:
true
Maximum Length:64
User who created the requisition. -
CreationDate: string
(date-time)
Read Only:
true
Date and time when the purchase requisition was initiated. -
Currency: string
Title:
Currency Name
Maximum Length:80
Purchase requisition currency. -
CurrencyAmount: number
Total amount of the requested item in the currency of the supplier.
-
CurrencyCode: string
Maximum Length:
15
Abbreviation that identifies the purchase requisition currency. -
DeliverToAddress: string
Title:
Deliver-to Address
Read Only:true
Physical address of the final location where the buying company should deliver the goods previously received from a supplier. -
DeliverToCustomer: string
Title:
Deliver-to Customer
Read Only:true
Maximum Length:360
Name of the third party to whom the materials need to be delivered. -
DeliverToCustomerId: integer
(int64)
Read Only:
true
Value that uniquely identifies the third party to whom the materials need to be delivered. -
DeliverToCustomerLocationId: integer
(int64)
Value that uniquely identifies the third-party location to which materials need to be delivered.
-
DeliverToLocationCode: string
Title:
Deliver-to Location
Maximum Length:60
Name of the location to which the buying company should deliver goods received from a supplier. -
DeliverToLocationId: integer
(int64)
Value that uniquely identifies the final location where the buying company should deliver the goods previously received from a supplier.
-
DeliverToOneTimeAddress: string
Title:
One-Time Address
Read Only:true
Physical address of the one-time location where the buying company should deliver the goods that were previously received from a supplier. This location not internal to the organization. -
DestinationOrganization: string
Title:
Organization
Read Only:true
Maximum Length:240
Name of the inventory organization that receives the item. -
DestinationOrganizationCode: string
Title:
Deliver-to Organization
Maximum Length:18
Abbreviation that identifies the inventory organization where the supplier should deliver the goods. -
DestinationOrganizationId: integer
(int64)
Value that uniquely identifies the inventory organization where the supplier should deliver the goods.
-
DestinationSubinventory: string
Maximum Length:
10
Name of the subinventory that identifies where to deliver the requested item. -
DestinationType: string
Title:
Destination Type
Maximum Length:80
Type of destination to determine how the purchased goods or services should be charged. Valid values include Inventory, Expense, Drop Ship, and Work Order. -
DestinationTypeCode: string
Maximum Length:
25
Abbreviation that identifies whether the item is for inventory, expense, drop ship, or manufacturing. Valid values include INVENTORY, EXPENSE, DROP SHIP, and MANUFACTURING. -
DFF: array
Flexfields for Purchase Requisition Lines
Title:
Flexfields for Purchase Requisition Lines
The Flexfields for Purchase Requisition Lines resource manages details about purchase requisition lines. -
DisableAutosourceFlag: boolean
Maximum Length:
1
Default Value:false
Contains one of the following values: Y or N. If Y, then the requisition line isn't automatically sourced. If N, then the requisition is automatically sourced. The default value is N. -
distributions: array
Distributions
Title:
Distributions
The Distributions resource manages purchasing details such as details about accounting or the project. -
FormattedDeliverToAddress: string
Title:
Address
Read Only:true
Formatted physical address of the final location where the buying company should deliver the goods previously received from a supplier. -
FundsStatus: string
Title:
Funds Status
Read Only:true
Maximum Length:80
Status of the funds reservation request at the line level. -
FundsStatusCode: string
Read Only:
true
Maximum Length:30
Abbreviation that identifies the status of funds check or the validation result of funds reservation at the line level. -
HazardClass: string
Title:
Hazard Class
Read Only:true
Maximum Length:40
Value that uniquely identifies the hazard class. -
HazardClassCode: string
Title:
Code
Read Only:true
Maximum Length:30
Abbreviation that identifies the hazard class specified on the line. -
HazardClassId: integer
(int64)
Value that uniquely identifies the hazard class captured on the line to comply with Section 19 of the International Safety Rating System.
-
informationTemplates: array
Information Templates for Purchase Requisition Lines
Title:
Information Templates for Purchase Requisition Lines
The Information Templates for Purchase Requisitions Lines resource manages the information templates associated with a smart form used to create a requisition line. This resource is not currently used. -
InformationTemplateTouchedFlag: boolean
Maximum Length:
1
Contains one of the following values: Y or N. If Y, then the requisition line information templates were reviewed by the user. If N, then the requisition line information templates weren't reviewed by the user. -
Item: string
Maximum Length:
300
Abbreviation that uniquely identifies the item being purchased. -
ItemDescription: string
Maximum Length:
240
Description of the goods or services being purchased. -
ItemId: integer
(int64)
Value that uniquely identifies the item being purchased.
-
ItemRevision: string
Maximum Length:
18
Number that identifies the revision of the item. -
ItemUserOverrideFlag: boolean
Maximum Length:
1
This attribute isn't currently used. -
LastApprovalDate: string
(date-time)
Read Only:
true
Date when the requisition lines was last approved. -
LastSubmittedDate: string
(date-time)
Read Only:
true
Date when the requisition line was last submitted for approval. -
LastUpdateDate: string
(date-time)
Read Only:
true
Date when the record was last updated. -
LastUpdatedBy: string
Read Only:
true
Maximum Length:64
User who most recently updated the record. -
LifecycleSecondaryStatus: string
Read Only:
true
Maximum Length:100
Code that indicates additional information about a line lifecycle. This information is used to indicate the secondary status of a requisition line. -
LifecycleStatus: string
Title:
Lifecycle Status
Read Only:true
Maximum Length:80
Status indicating the post approval progress of the requisition line. -
LifecycleStatusCode: string
Read Only:
true
Maximum Length:30
Abbreviation that identifies the requisition line lifecycle status. -
LineImageURL: string
Title:
Image URL
Read Only:true
URL (Uniform Resource Locator) that locates the image representing the requisition line item, if any. -
LineNumber: number
Number that uniquely identifies the line associated with a purchase requisition.
-
LineStatus: string
Read Only:
true
Maximum Length:25
Abbreviation that identifies the purchase requisition line status in the line life cycle. -
LineStatusDisplayValue: string
Title:
Status
Read Only:true
Maximum Length:80
Status of the requisition line. -
LineTypeCode: string
Title:
Line Type Code
Maximum Length:30
Abbreviation that uniquely identifies the line type. Values include Goods, Fixed Price Services, and so on. -
LineTypeId: integer
(int64)
Value that uniquely identifies type that indicates whether a purchase requisition line is for goods or services.
-
LineTypeOrderTypeLookupCode: string
Read Only:
true
Maximum Length:25
Abbreviation that identifies the type of agreement line. Valid values are QUANTITY or FIXED PRICE. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
ManufacturerName: string
Maximum Length:
240
Name of the company that manufactures the item being purchased. -
ManufacturerPartNumber: string
Maximum Length:
700
Number that uniquely identifies the item as provided by the manufacturer. -
ModeOfTransport: string
Title:
Mode of Transport
Read Only:true
Maximum Length:80
Mode of transportation used to ship the product, such as truck, air, or boat. -
ModeOfTransportCode: string
Read Only:
true
Maximum Length:30
Abbreviation that identifies the mode of transport. -
ModifiedByBuyer: string
Title:
Modified by Buyer
Read Only:true
Maximum Length:240
Buyer who modified the requisition line by splitting the requisition line or by replacing the requested item with a catalog item. -
ModifiedByBuyerId: integer
(int64)
Read Only:
true
Value that uniquely identifies the buyer who modified the requisition line by splitting the requisition line or by replacing the requested item with a catalog item. -
NegotiatedByPreparerFlag: boolean
Maximum Length:
1
Contains one of the following values: true or false. If true, then the price on the purchase requisition line is agreed on in advance between the buying company and the supplier. If false, then the price isn't agreed on in advance. This attribute doesn't have a default value. -
Negotiation: string
Read Only:
true
Maximum Length:40
Value that identifies the negotiation document associated with the requisition line. -
NegotiationHeaderId: integer
(int64)
Read Only:
true
Value that uniquely identifies the negotiation document associated with the requisition line. -
NegotiationLineNumber: number
Read Only:
true
Number that identifies the negotiation line associated with the requisition line. -
NegotiationRequiredFlag: boolean
Maximum Length:
1
Contains one of the following values: true or false. If true, then a request for a quotation is required prior to placing the requisition line on a purchase order. If false, then a request for a quotation isn't required. This attribute doesn't have a default value. -
NewSupplierFlag: boolean
Maximum Length:
1
Contains one of the following values: true or false. If true, then the supplier entered on the line is a new supplier. If false, then the supplier entered on the line is an existing supplier. This attribute doesn't have a default value. -
NoteToBuyer: string
Title:
Note to Buyer
Maximum Length:1000
Note to the buyer on the purchase requisition. -
NoteToReceiver: string
Title:
Note to Receiver
Maximum Length:1000
Note to the receiver on the purchase requisition. -
NoteToSupplier: string
Title:
Note to Supplier
Maximum Length:1000
Note to the supplier on the purchase requisition. -
OneTimeLocationFlag: boolean
Read Only:
true
Maximum Length:1
Default Value:false
Contains one of the following values: true or false. If true, then the location on final delivery of goods is a one-time delivery address. If false, then the location of delivery is an existing address in Oracle Fusion Cloud Global Human Resources. The default value is false. -
OnNegotiationFlag: boolean
Read Only:
true
Maximum Length:1
Contains one of the following values: true or false. If true, then the requisition line is part of an active sourcing negotiation in Oracle Sourcing. If false, then the requisition line isn't part of an active negotiation. This attribute doesn't have a default value. -
OriginalApprovalDate: string
(date-time)
Read Only:
true
Date when the requisition line was first approved. -
OriginalSubmittedDate: string
(date-time)
Read Only:
true
Date when the requisition line was first submitted for approval. -
POAutomationFailedReason: string
Read Only:
true
Maximum Length:240
Functional reason for the failure of automatic processing of requisition line to purchase order. -
POAutomationFailedReasonCode: string
Read Only:
true
Maximum Length:30
Abbreviation that indicates the reason for the failure of automatic processing of requisition line to purchase order. -
POBuyerId: integer
(int64)
Read Only:
true
Value that uniquely identifies the buyer who is responsible for managing the purchase order. -
POCancelReason: string
Title:
Cancellation Reason
Read Only:true
Maximum Length:240
Reason provided by the employee for cancelling the purchase order. -
POHeaderId: integer
(int64)
Read Only:
true
Value that uniquely identifies the purchase order. -
POHoldReason: string
Read Only:
true
The reason provided by the buyer while placing the purchase order on hold. -
POLineId: integer
(int64)
Read Only:
true
Value that uniquely identifies the parent purchase order line. -
Price: number
Price of the requested item in the currency of the supplier.
-
ProcurementBU: string
Title:
Procurement BU
Read Only:true
Maximum Length:240
Business unit responsible for managing the procurement function. -
ProcurementBUId: integer
(int64)
Read Only:
true
Value that uniquely identifies the business unit responsible for managing the procurement function. -
PublicShoppingListHeaderId: integer
(int64)
Value that uniquely identifies the public shopping list.
-
PurchaseOrder: string
Title:
Order
Read Only:true
Maximum Length:30
Number that identifies the purchase order created to fulfill the requisition line. -
Quantity: number
Quantity of the goods being purchased.
-
RequestedDeliveryDate: string
(date)
Date when the buying company requested the ordered item or service to be delivered.
-
RequestedShipDate: string
(date)
Read Only:
true
Date when the buying company requested the ordered item to be shipped. -
Requester: string
Title:
Requester
Read Only:true
Maximum Length:240
Person for whom goods or services are being ordered. -
RequesterDisplayName: string
Title:
Name
Read Only:true
Maximum Length:240
Display name of the person for whom goods or services are being ordered. -
RequesterEmail: string
Title:
Requester Email
Maximum Length:240
Email address of the person for whom goods or services are being ordered. -
RequesterId: integer
(int64)
Value that uniquely identifies the person for whom goods or services are being ordered.
-
RequisitionHeaderId: integer
(int64)
Read Only:
true
Value that uniquely identifies the requisition header. -
RequisitionLineGroup: string
Read Only:
true
Maximum Length:30
Value that indicates the group of the requisition line. -
RequisitionLineId: integer
(int64)
Read Only:
true
Value that uniquely identifies the requisition line. -
RequisitionLineInPool: string
Read Only:
true
Maximum Length:1
Value that indicates if a requisition line is available for processing by the buyer. Valid values include Y, N, and P, where P indicates already processed. -
RequisitionLinePOInstanceId: integer
(int64)
Read Only:
true
Uniquely identifies the request ID of the Generate Orders process that processed the requisition line. -
RequisitionLineSource: string
Maximum Length:
25
Default Value:REST_INTEGRATION
Value that indicates the source of the line. This attribute isn't currently used. -
ResponseLineNumber: number
Read Only:
true
Number that identifies the line in a response submitted by supplier for a negotiation. -
ResponseNumber: number
Read Only:
true
Number that identifies the response submitted by supplier for a negotiation document. -
ReturnedByBuyerDisplayName: string
Title:
Returned by Buyer
Read Only:true
Maximum Length:240
Name of the buyer who returned the requisition line. -
ReturnedByBuyerId: integer
(int64)
Read Only:
true
Value that uniquely identifies the buyer who returned the requisition line. -
ReturnReason: string
Read Only:
true
Maximum Length:4000
Reason provided by the buyer while returning the requisition line. -
SalesOrder: string
Read Only:
true
Maximum Length:50
Number that uniquely identifies a backing customer sales order number. -
SalesOrderLineNumber: string
Read Only:
true
Maximum Length:50
Number that uniquely identifies the sales order line for a given customer sales order. -
SalesOrderScheduleNumber: string
Read Only:
true
Maximum Length:50
Number that uniquely identifies the sales order schedule for a given customer sales order line. -
SecondaryQuantity: number
Scheduled quantity in terms of the secondary unit of measure for a dual unit of measure controlled item.
-
SecondaryUOM: string
Title:
UOM Name
Read Only:true
Maximum Length:25
Secondary unit of measure to use for the quantity of a dual unit of measure controlled item. -
SecondaryUOMCode: string
Read Only:
true
Maximum Length:3
Abbreviation that identifies the alternative unit of measure that is allowed to quantify a dual unit of measure controlled item. -
ServiceLevel: string
Title:
Service Level
Read Only:true
Maximum Length:80
Transportation priority that determines how quickly to transport goods. -
ServiceLevelCode: string
Read Only:
true
Maximum Length:30
Abbreviation that identifies the service level for the shipping method. -
ShipToCustomer: string
Title:
Ship-to Customer
Read Only:true
Maximum Length:360
Name of the party who will receive the materials that are shipped. -
ShipToCustomerId: integer
(int64)
Read Only:
true
Value that uniquely identifies the third party to which materials need to be shipped. -
SmartFormId: integer
(int64)
Value that uniquely identifies the smart form. This attribute isn't currently used.
-
SmartFormName: string
Maximum Length:
250
Name of the smart form on the requisition line. This attribute isn't currently used. -
SourceAgreement: string
Title:
Agreement
Maximum Length:30
Number that uniquely identifies the source agreement referenced by the purchase requisition line. -
SourceAgreementHeaderId: integer
(int64)
Value that uniquely identifies the source agreement referenced by the purchase requisition line.
-
SourceAgreementLineId: integer
(int64)
Value that uniquely identifies the source agreement line for a given source agreement.
-
SourceAgreementLineNumber: number
Title:
Agreement Line
Number that identifies the line of the source agreement referenced by the purchase requisition line. -
SourceAgreementType: string
Title:
Agreement Type
Read Only:true
Maximum Length:80
Value that indicates whether the referenced agreement is a blanket purchase agreement or a contract purchase agreement. -
SourceAgreementTypeCode: string
Maximum Length:
25
Abbreviation that identifies the source agreement type. Values include CONTRACT and BLANKET. -
SourceOrganization: string
Title:
Source Organization
Read Only:true
Maximum Length:240
Name of the inventory organization that will supply the item to the destination inventory organization in an internal material transfer operation. -
SourceOrganizationCode: string
Maximum Length:
18
Abbreviation that identifies the inventory organization that supplies the item to the destination inventory organization in an internal material transfer operation. -
SourceOrganizationId: integer
(int64)
Value that uniquely identifies the inventory organization that will supply the item to the destination inventory organization in an internal material transfer operation.
-
SourceSubinventory: string
Maximum Length:
10
Subinventory within a source inventory organization that will supply the item to the destination inventory organization in an internal material transfer operation. -
SourceType: string
Title:
Source Type
Maximum Length:80
Value that indicates the type of source the requisition line is sourced from. For example: Inventory, Supplier. -
SourceTypeCode: string
Maximum Length:
10
Default Value:EXTERNAL
Abbreviation that identifies the type of supply source for the requisition line. Values include the following values. Internal: the line is sourced from an inventory organization. External: the line is sourced for supplier. -
specialHandlingDFF: array
Special Handling Flexfields for Purchase Requisition Lines
Title:
Special Handling Flexfields for Purchase Requisition Lines
The Special Handling Flexfields for Purchase Requisitions Lines resource manages details about purchase requisition lines. -
SuggestedBuyer: string
Title:
Suggested Buyer
Read Only:true
Maximum Length:240
Name of the buyer suggested for managing the purchase requisition line through its life cycle. -
SuggestedBuyerEmail: string
Title:
Suggested Buyer Email
Maximum Length:240
Email address of the suggested buyer. -
SuggestedBuyerId: integer
(int64)
Value that uniquely identifies the suggested buyer.
-
SuggestedSupplier: string
Maximum Length:
360
Name of the new supplier suggested on the requisition line for fulfillment of the ordered goods and services. -
SuggestedSupplierContact: string
Maximum Length:
80
Name of the person representing the new supplier involved in supporting the customer relationship. -
SuggestedSupplierContactEmail: string
Maximum Length:
1000
Email address of the person representing the new supplier. -
SuggestedSupplierContactFax: string
Maximum Length:
30
Fax number of the person representing the new supplier. -
SuggestedSupplierContactPhone: string
Maximum Length:
30
Phone number of the person representing the new supplier. -
SuggestedSupplierSite: string
Maximum Length:
240
Value that uniquely identifies the new supplier. -
Supplier: string
Maximum Length:
360
Name of the supplier tasked with fulfillment of the ordered goods and services. -
SupplierContact: string
Maximum Length:
4000
Name of the person representing the supplier with regards to communication with the buying company. -
SupplierContactEmail: string
Read Only:
true
Maximum Length:2000
Email address of the supplier contact. -
SupplierContactFax: string
Read Only:
true
Maximum Length:255
Fax number if the supplier contact. -
SupplierContactId: integer
(int64)
Value that uniquely identifies the supplier contact.
-
SupplierContactPhone: string
Read Only:
true
Maximum Length:255
Phone number of the supplier contact. -
SupplierId: integer
(int64)
Value that uniquely identifies the supplier.
-
SupplierItemAuxiliaryId: string
Maximum Length:
150
Auxiliary part number that uniquely identifies the supplier item. -
SupplierItemNumber: string
Title:
Supplier Item
Maximum Length:300
Number that identifies the supplier or code for the goods or services ordered on the purchase requisition line. -
SupplierOnPurchaseOrder: string
Read Only:
true
Maximum Length:360
Name of the supplier who fulfills the ordered item. -
SupplierSite: string
Title:
Supplier Site
Maximum Length:240
Name of the supplier location from where goods or services are purchased. -
SupplierSiteId: integer
(int64)
Value that uniquely identifies the supplier site.
-
TransferOrder: string
Title:
Transfer Order
Read Only:true
Maximum Length:50
Number that identifies the transfer order document associated with the requisition line. -
TransferOrderHeaderId: integer
(int64)
Read Only:
true
Value that uniquely identifies the transfer order document associated with the requisition line. -
TransferOrderLineId: integer
(int64)
Read Only:
true
Value that uniquely identifies the transfer order line associated with the requisition line. -
UnitPrice: number
Price of the requested item in the currency of the buying company.
-
UNNumber: string
Title:
UN Number
Read Only:true
Maximum Length:20
United Nations identification number for the hazardous material. -
UNNumberId: integer
(int64)
Value that uniquely identifies the United Nations identification number for hazardous material.
-
UNSPSCCode: string
Maximum Length:
700
Abbreviation that identifies the United Nations Standard Products and Services Code (UNSPSC) for taxonomy of products and services. -
UOM: string
Title:
UOM Name
Maximum Length:25
Unit of measure of the item quantity. -
UOMCode: string
Maximum Length:
3
Abbreviation that identifies the unit of measure. -
UrgentFlag: boolean
Read Only:
true
Maximum Length:1
Contains one of the following values: true or false. If true, then the requisition line requires urgent processing. If false, then the line doesn't require urgent processing. This attribute doesn't have a default value. -
WorkOrder: string
Read Only:
true
Maximum Length:120
Display number that uniquely identifies a work order in a plant. -
WorkOrderId: integer
(int64)
Read Only:
true
Value that uniquely identifies the work order in a plant. -
WorkOrderOperationId: integer
(int64)
Read Only:
true
Value that uniquely identifies an operation of a work order. -
WorkOrderOperationSequence: number
Read Only:
true
Sequence to use when performing the work order operations. -
WorkOrderProduct: string
Read Only:
true
Maximum Length:300
Value that identifies the finished goods of the contract manufacturing work order. -
WorkOrderSubType: string
Read Only:
true
Maximum Length:30
Display name used to identify the subtype of the manufacturing work order.
Nested Schema : Attachments for Lines
Type:
array
Title:
Attachments for Lines
The Attachments for Lines resource manages attachments for a purchase requisition line.
Show Source
Nested Schema : Flexfields for Purchase Requisition Lines
Type:
array
Title:
Flexfields for Purchase Requisition Lines
The Flexfields for Purchase Requisition Lines resource manages details about purchase requisition lines.
Show Source
Nested Schema : Distributions
Type:
array
Title:
Distributions
The Distributions resource manages purchasing details such as details about accounting or the project.
Show Source
Nested Schema : Information Templates for Purchase Requisition Lines
Type:
array
Title:
Information Templates for Purchase Requisition Lines
The Information Templates for Purchase Requisitions Lines resource manages the information templates associated with a smart form used to create a requisition line. This resource is not currently used.
Show Source
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Special Handling Flexfields for Purchase Requisition Lines
Type:
array
Title:
Special Handling Flexfields for Purchase Requisition Lines
The Special Handling Flexfields for Purchase Requisitions Lines resource manages details about purchase requisition lines.
Show Source
-
Array of:
object Discriminator: __FLEX_Context
Discriminator:
{ "propertyName":"__FLEX_Context", "mapping":{ "ORA_PO_BILL_ONLY_LINES":"#/components/schemas/oracle_apps_flex_prc_por_manageReq_restModel_specialHandlingLines_view_RequisitionLineSHDFFORA__5FPO__5FBILL__5FONLY__5FLINESVO-item-response" } }
Nested Schema : purchaseRequisitions-lines-attachments-item-response
Type:
Show Source
object
-
AsyncTrackerId: string
Title:
Asynchronous Upload Tracker Id
An identifier used for tracking the uploaded files. -
AttachedDocumentId: integer
(int64)
Title:
Attached Document Id
Value that uniquely identifies the attached document. -
CategoryName: string
Title:
Category
Maximum Length:30
Name of the attachment category. - ContentRepositoryFileShared: boolean
-
CreatedBy: string
Title:
Created By
Read Only:true
Maximum Length:255
User who created the record. -
CreatedByUserName: string
Title:
Created By User Name
Read Only:true
Login that the user used when creating the document. -
CreationDate: string
(date-time)
Title:
Creation Date
Read Only:true
Date and time when the user created the record. -
DatatypeCode: string
Title:
Type
Maximum Length:30
Default Value:FILE
Abbreviation that identifies the data type. -
Description: string
Title:
Description
Maximum Length:255
Description of the attachment. -
DmDocumentId: string
Maximum Length:
255
Value that uniquely identifies the document from which the attachment is created. -
DmFolderPath: string
Title:
Dm Folder Path
Maximum Length:1000
Path of the folder from which the attachment is created. -
DmVersionNumber: string
Maximum Length:
255
Number that identifies the document version from which the attachment is created. -
DownloadInfo: string
Title:
DownloadInfo
JSON object represented as a string containing information used to programmatically retrieve a file attachment. -
ErrorStatusCode: string
Title:
Error Status Code
Abbreviation that identifies the error code, if any, for the attachment. -
ErrorStatusMessage: string
Title:
Error Status Message
Text of the error message, if any, for the attachment. -
ExpirationDate: string
(date-time)
Title:
Expiration Date
Date when the contents of the attachment are no longer valid. -
FileContents: string
(byte)
Title:
File Contents
Contents of the attached file. -
FileName: string
Title:
File Name
Maximum Length:2048
Name of the attached file. -
FileUrl: string
Title:
File Url
Uniform resource locator of the file. -
FileWebImage: string
(byte)
Title:
File Web Image
Read Only:true
Base64-encoded image of the file displayed in .png format if the source is a convertible image. -
LastUpdateDate: string
(date-time)
Title:
Last Update Date
Read Only:true
Date and time when the user most recently updated the record. -
LastUpdatedBy: string
Title:
Last Updated By
Read Only:true
Maximum Length:255
User who most recently updated the record. -
LastUpdatedByUserName: string
Title:
Last Updated By User
Read Only:true
Login that the user used when updating the document. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
PostProcessingAction: string
Title:
PostProcessingAction
The name of the action that can be performed after an attachment is uploaded. -
Title: string
Title:
Title
Title of the attachment. -
UploadedFileContentType: string
Title:
Uploaded File Content Type
Content type of the attached file. -
UploadedFileLength: integer
Title:
File Size
Size of the attached file. -
UploadedFileName: string
Title:
Uploaded File Name
Name of the attached file. -
UploadedText: string
Title:
Uploaded Text
Contents of text file that is attached. -
Uri: string
Title:
Uri
Maximum Length:4000
URI (Uniform Resource Identifier) of the topology manager type attachment. -
Url: string
Title:
Url
Maximum Length:4000
Uniform resource locator of the web page type attachment. -
UserName: string
Title:
User Name
Read Only:true
Maximum Length:255
Login that the user used when creating the attachment.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : purchaseRequisitions-lines-DFF-item-response
Type:
Show Source
object
-
__FLEX_Context: string
Title:
Attribute Value
Maximum Length:30
Descriptive flexfield context name for purchase requisition distributions -
__FLEX_Context_DisplayValue: string
Title:
Attribute Value
Descriptive flexfield context display value for purchase requisition distributions. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
RequisitionLineId: integer
(int64)
Value that uniquely identifies the requisition line.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : purchaseRequisitions-lines-distributions-item-response
Type:
Show Source
object
-
BudgetDate: string
(date)
Title:
Budget Date
Date from which the budget is consumed. This date is used to determine the budget period. -
ChargeAccount: string
Maximum Length:
255
Account that the purchase from a requisition is charged to. -
ChargeAccountId: integer
(int64)
Value that uniquely identifies the account that the purchase from a requisition is charged to.
-
ChartOfAccountId: integer
Read Only:
true
Value that uniquely identifies the chart of accounts. -
CurrencyAmount: number
Monetary amount associated with the distribution line in the currency of the supplier.
-
CurrencyNonrecoverableExclusiveTax: number
Read Only:
true
Tax that the requisition amount doesn't include. The tax amount is added to the line amount. The purchaser cannot recover this tax. -
CurrencyRecoverableExclusiveTax: number
Read Only:
true
Tax that the requisition amount doesn't include. The tax amount is added to the line amount. The purchaser can recover this tax. -
DFF: array
Flexfields for Purchase Requisition Distributions
Title:
Flexfields for Purchase Requisition Distributions
The Flexfields for Purchase Requisition Distributions resource manages details about purchase requisition distributions. -
DistributionNumber: number
Title:
DistributionNumber
Number that uniquely identifies the distribution associated with a purchase requisition line. -
FundsStatus: string
Title:
Funds Status
Read Only:true
Maximum Length:80
Status of the funds reservation request at the distribution level. -
FundsStatusCode: string
Read Only:
true
Maximum Length:30
Abbreviation that identifies the status of funds check or the validation result of funds reservation at the distribution level. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
projectDFF: array
Project Costing Flexfields for Purchase Requisition Distributions
Title:
Project Costing Flexfields for Purchase Requisition Distributions
The Project Costing Flexfields for Purchase Requisition Distributions resource manages details about purchase requisition distributions. -
Quantity: number
Title:
Quantity
Quantity of goods being purchased. -
RequisitionDistributionId: integer
(int64)
Read Only:
true
Value that uniquely identifies the purchasing requisition distribution. -
RequisitionLineId: integer
(int64)
Read Only:
true
Value that uniquely identifies the requisition line. -
UserAccountOverrideFlag: boolean
Read Only:
true
Contains one of the following values: Y or N. If Y, the charge account is updated by the user. If N, the charge account isn't updated by the user.
Nested Schema : Flexfields for Purchase Requisition Distributions
Type:
array
Title:
Flexfields for Purchase Requisition Distributions
The Flexfields for Purchase Requisition Distributions resource manages details about purchase requisition distributions.
Show Source
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Project Costing Flexfields for Purchase Requisition Distributions
Type:
array
Title:
Project Costing Flexfields for Purchase Requisition Distributions
The Project Costing Flexfields for Purchase Requisition Distributions resource manages details about purchase requisition distributions.
Show Source
-
Array of:
object Discriminator: __FLEX_Context
Discriminator:
{ "propertyName":"__FLEX_Context", "mapping":{ "AP_Distribution_Sets":"#/components/schemas/oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFAP__5FDistribution__5FSetsVO-item-response", "AP_Invoice_Distribution":"#/components/schemas/oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFAP__5FInvoice__5FDistributionVO-item-response", "AP_Invoice_Line":"#/components/schemas/oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFAP__5FInvoice__5FLineVO-item-response", "EXM_Expense_Report":"#/components/schemas/oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFEXM__5FExpense__5FReportVO-item-response", "EXM_Expense_Report_Line":"#/components/schemas/oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFEXM__5FExpense__5FReport__5FLineVO-item-response", "INV_Misc_Transactions":"#/components/schemas/oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFINV__5FMisc__5FTransactionsVO-item-response", "OM_Sales_Order":"#/components/schemas/oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFOM__5FSales__5FOrderVO-item-response", "PJC_All":"#/components/schemas/oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFPJC__5FAllVO-item-response", "PJC_Expenditure_Batch":"#/components/schemas/oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFPJC__5FExpenditure__5FBatchVO-item-response", "POR_Requisition":"#/components/schemas/oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFPOR__5FRequisitionVO-item-response", "POR_User_Preferences":"#/components/schemas/oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFPOR__5FUser__5FPreferencesVO-item-response", "PO_Purchase_Order":"#/components/schemas/oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFPO__5FPurchase__5FOrderVO-item-response", "PO_Purchase_Order_Line":"#/components/schemas/oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFPO__5FPurchase__5FOrder__5FLineVO-item-response", "PO_Purchase_Order_Schedule":"#/components/schemas/oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFPO__5FPurchase__5FOrder__5FScheduleVO-item-response" } }
Nested Schema : purchaseRequisitions-lines-distributions-DFF-item-response
Type:
Show Source
object
-
__FLEX_Context: string
Title:
Attribute Value
Maximum Length:30
Descriptive flexfield context name for purchase requisition distributions -
__FLEX_Context_DisplayValue: string
Title:
Attribute Value
Descriptive flexfield context display value for purchase requisition distributions. -
DistributionId: integer
(int64)
Value that uniquely identifies the requisition distribution.
-
links: array
Links
Title:
Links
The link relations associated with the resource instance.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Discriminator: __FLEX_Context
Type:
object
Discriminator: __FLEX_Context
Discriminator Values
- AP_Distribution_Sets
- AP_Invoice_Distribution
- AP_Invoice_Line
- EXM_Expense_Report
- EXM_Expense_Report_Line
- INV_Misc_Transactions
- OM_Sales_Order
- PJC_All
- PJC_Expenditure_Batch
- POR_Requisition
- POR_User_Preferences
- PO_Purchase_Order
- PO_Purchase_Order_Line
- PO_Purchase_Order_Schedule
Match One Schema
Show Source
-
AP_Distribution_Sets -
object
oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFAP__5FDistribution__5FSetsVO-item-response
-
AP_Invoice_Distribution -
object
oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFAP__5FInvoice__5FDistributionVO-item-response
-
AP_Invoice_Line -
object
oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFAP__5FInvoice__5FLineVO-item-response
-
EXM_Expense_Report -
object
oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFEXM__5FExpense__5FReportVO-item-response
-
EXM_Expense_Report_Line -
object
oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFEXM__5FExpense__5FReport__5FLineVO-item-response
-
INV_Misc_Transactions -
object
oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFINV__5FMisc__5FTransactionsVO-item-response
-
OM_Sales_Order -
object
oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFOM__5FSales__5FOrderVO-item-response
-
PJC_All -
object
oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFPJC__5FAllVO-item-response
-
PJC_Expenditure_Batch -
object
oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFPJC__5FExpenditure__5FBatchVO-item-response
-
POR_Requisition -
object
oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFPOR__5FRequisitionVO-item-response
-
POR_User_Preferences -
object
oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFPOR__5FUser__5FPreferencesVO-item-response
-
PO_Purchase_Order -
object
oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFPO__5FPurchase__5FOrderVO-item-response
-
PO_Purchase_Order_Line -
object
oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFPO__5FPurchase__5FOrder__5FLineVO-item-response
-
PO_Purchase_Order_Schedule -
object
oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFPO__5FPurchase__5FOrder__5FScheduleVO-item-response
Nested Schema : oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFAP__5FDistribution__5FSetsVO-item-response
Type:
Show Source
object
-
__FLEX_Context: string
Title:
Context Value
Maximum Length:40
Default Value:AP_Distribution_Sets
Project costing descriptive flexfield context name for purchase requisition distributions. -
__FLEX_Context_DisplayValue: string
Title:
Context Value
Project costing descriptive flexfield context display value for purchase requisition distributions. -
_BILLABLE_FLAG: string
Title:
Billable
Maximum Length:1
-
_BILLABLE_FLAG_Display: string
Title:
Billable
-
_CAPITALIZABLE_FLAG: string
Title:
Capitalizable
Maximum Length:1
-
_CAPITALIZABLE_FLAG_Display: string
Title:
Capitalizable
-
_CONTRACT_ID: integer
(int64)
Title:
Contract Number
-
_CONTRACT_ID_Display: string
Title:
Contract Number
-
_EXPENDITURE_TYPE_ID: integer
(int64)
Title:
Expenditure Type
-
_EXPENDITURE_TYPE_ID_Display: string
Title:
Expenditure Type
-
_ORGANIZATION_ID: integer
(int64)
Title:
Expenditure Organization
-
_ORGANIZATION_ID_Display: string
Title:
Expenditure Organization
-
_PROJECT_ID: integer
(int64)
Title:
Project Number
-
_PROJECT_ID_Display: string
Title:
Project Number
-
_RESERVED_ATTRIBUTE1: string
Title:
Funding Source
Maximum Length:150
-
_RESERVED_ATTRIBUTE1_Display: string
Title:
Funding Source
-
_TASK_ID: integer
(int64)
Title:
Task Number
-
_TASK_ID_Display: string
Title:
Task Number
-
_WORK_TYPE_ID: integer
(int64)
Title:
Work Type
-
_WORK_TYPE_ID_Display: string
Title:
Work Type
-
DistributionId: integer
(int64)
Value that uniquely identifies the requisition distribution.
-
links: array
Links
Title:
Links
The link relations associated with the resource instance.
Nested Schema : oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFAP__5FInvoice__5FDistributionVO-item-response
Type:
Show Source
object
-
__FLEX_Context: string
Title:
Context Value
Maximum Length:40
Default Value:AP_Invoice_Distribution
Project costing descriptive flexfield context name for purchase requisition distributions. -
__FLEX_Context_DisplayValue: string
Title:
Context Value
Project costing descriptive flexfield context display value for purchase requisition distributions. -
_BILLABLE_FLAG: string
Title:
Billable
Maximum Length:1
-
_BILLABLE_FLAG_Display: string
Title:
Billable
-
_CAPITALIZABLE_FLAG: string
Title:
Capitalizable
Maximum Length:1
-
_CAPITALIZABLE_FLAG_Display: string
Title:
Capitalizable
-
_CONTRACT_ID: integer
(int64)
Title:
Contract Number
-
_CONTRACT_ID_Display: string
Title:
Contract Number
-
_EXPENDITURE_ITEM_DATE: string
(date)
Title:
Expenditure Item Date
-
_EXPENDITURE_TYPE_ID: integer
(int64)
Title:
Expenditure Type
-
_EXPENDITURE_TYPE_ID_Display: string
Title:
Expenditure Type
-
_ORGANIZATION_ID: integer
(int64)
Title:
Expenditure Organization
-
_ORGANIZATION_ID_Display: string
Title:
Expenditure Organization
-
_PROJECT_ID: integer
(int64)
Title:
Project Number
-
_PROJECT_ID_Display: string
Title:
Project Number
-
_RESERVED_ATTRIBUTE1: string
Title:
Funding Source
Maximum Length:150
-
_RESERVED_ATTRIBUTE1_Display: string
Title:
Funding Source
-
_TASK_ID: integer
(int64)
Title:
Task Number
-
_TASK_ID_Display: string
Title:
Task Number
-
_WORK_TYPE_ID: integer
(int64)
Title:
Work Type
-
_WORK_TYPE_ID_Display: string
Title:
Work Type
-
DistributionId: integer
(int64)
Value that uniquely identifies the requisition distribution.
-
links: array
Links
Title:
Links
The link relations associated with the resource instance.
Nested Schema : oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFAP__5FInvoice__5FLineVO-item-response
Type:
Show Source
object
-
__FLEX_Context: string
Title:
Context Value
Maximum Length:40
Default Value:AP_Invoice_Line
Project costing descriptive flexfield context name for purchase requisition distributions. -
__FLEX_Context_DisplayValue: string
Title:
Context Value
Project costing descriptive flexfield context display value for purchase requisition distributions. -
_BILLABLE_FLAG: string
Title:
Billable
Maximum Length:1
-
_BILLABLE_FLAG_Display: string
Title:
Billable
-
_CAPITALIZABLE_FLAG: string
Title:
Capitalizable
Maximum Length:1
-
_CAPITALIZABLE_FLAG_Display: string
Title:
Capitalizable
-
_CONTRACT_ID: integer
(int64)
Title:
Contract Number
-
_CONTRACT_ID_Display: string
Title:
Contract Number
-
_EXPENDITURE_ITEM_DATE: string
(date)
Title:
Expenditure Item Date
-
_EXPENDITURE_TYPE_ID: integer
(int64)
Title:
Expenditure Type
-
_EXPENDITURE_TYPE_ID_Display: string
Title:
Expenditure Type
-
_ORGANIZATION_ID: integer
(int64)
Title:
Expenditure Organization
-
_ORGANIZATION_ID_Display: string
Title:
Expenditure Organization
-
_PROJECT_ID: integer
(int64)
Title:
Project Number
-
_PROJECT_ID_Display: string
Title:
Project Number
-
_RESERVED_ATTRIBUTE1: string
Title:
Funding Source
Maximum Length:150
-
_RESERVED_ATTRIBUTE1_Display: string
Title:
Funding Source
-
_TASK_ID: integer
(int64)
Title:
Task Number
-
_TASK_ID_Display: string
Title:
Task Number
-
_WORK_TYPE_ID: integer
(int64)
Title:
Work Type
-
_WORK_TYPE_ID_Display: string
Title:
Work Type
-
DistributionId: integer
(int64)
Value that uniquely identifies the requisition distribution.
-
links: array
Links
Title:
Links
The link relations associated with the resource instance.
Nested Schema : oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFEXM__5FExpense__5FReportVO-item-response
Type:
Show Source
object
-
__FLEX_Context: string
Title:
Context Value
Maximum Length:40
Default Value:EXM_Expense_Report
Project costing descriptive flexfield context name for purchase requisition distributions. -
__FLEX_Context_DisplayValue: string
Title:
Context Value
Project costing descriptive flexfield context display value for purchase requisition distributions. -
_BILLABLE_FLAG: string
Title:
Billable
Maximum Length:1
-
_BILLABLE_FLAG_Display: string
Title:
Billable
-
_CAPITALIZABLE_FLAG: string
Title:
Capitalizable
Maximum Length:1
-
_CAPITALIZABLE_FLAG_Display: string
Title:
Capitalizable
-
_CONTRACT_ID: integer
(int64)
Title:
Contract Number
-
_CONTRACT_ID_Display: string
Title:
Contract Number
-
_EXPENDITURE_ITEM_DATE: string
(date)
Title:
Expenditure Item Date
-
_EXPENDITURE_TYPE_ID: integer
(int64)
Title:
Expenditure Type
-
_ORGANIZATION_ID: integer
(int64)
Title:
Expenditure Organization
-
_ORGANIZATION_ID_Display: string
Title:
Expenditure Organization
-
_PROJECT_ID: integer
(int64)
Title:
Project Number
-
_PROJECT_ID_Display: string
Title:
Project Number
-
_RESERVED_ATTRIBUTE1: string
Title:
Funding Source
Maximum Length:150
-
_RESERVED_ATTRIBUTE1_Display: string
Title:
Funding Source
-
_TASK_ID: integer
(int64)
Title:
Task Number
-
_TASK_ID_Display: string
Title:
Task Number
-
_WORK_TYPE_ID: integer
(int64)
Title:
Work Type
-
_WORK_TYPE_ID_Display: string
Title:
Work Type
-
DistributionId: integer
(int64)
Value that uniquely identifies the requisition distribution.
-
links: array
Links
Title:
Links
The link relations associated with the resource instance.
Nested Schema : oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFEXM__5FExpense__5FReport__5FLineVO-item-response
Type:
Show Source
object
-
__FLEX_Context: string
Title:
Context Value
Maximum Length:40
Default Value:EXM_Expense_Report_Line
Project costing descriptive flexfield context name for purchase requisition distributions. -
__FLEX_Context_DisplayValue: string
Title:
Context Value
Project costing descriptive flexfield context display value for purchase requisition distributions. -
_BILLABLE_FLAG: string
Title:
Billable
Maximum Length:1
-
_BILLABLE_FLAG_Display: string
Title:
Billable
-
_CAPITALIZABLE_FLAG: string
Title:
Capitalizable
Maximum Length:1
-
_CAPITALIZABLE_FLAG_Display: string
Title:
Capitalizable
-
_CONTRACT_ID: integer
(int64)
Title:
Contract Number
-
_CONTRACT_ID_Display: string
Title:
Contract Number
-
_EXPENDITURE_ITEM_DATE: string
(date)
Title:
Expenditure Item Date
-
_EXPENDITURE_TYPE_ID: integer
(int64)
Title:
Expenditure Type
-
_ORGANIZATION_ID: integer
(int64)
Title:
Expenditure Organization
-
_ORGANIZATION_ID_Display: string
Title:
Expenditure Organization
-
_PROJECT_ID: integer
(int64)
Title:
Project Number
-
_PROJECT_ID_Display: string
Title:
Project Number
-
_RESERVED_ATTRIBUTE1: string
Title:
Funding Source
Maximum Length:150
-
_RESERVED_ATTRIBUTE1_Display: string
Title:
Funding Source
-
_TASK_ID: integer
(int64)
Title:
Task Number
-
_TASK_ID_Display: string
Title:
Task Number
-
_WORK_TYPE_ID: integer
(int64)
Title:
Work Type
-
_WORK_TYPE_ID_Display: string
Title:
Work Type
-
DistributionId: integer
(int64)
Value that uniquely identifies the requisition distribution.
-
links: array
Links
Title:
Links
The link relations associated with the resource instance.
Nested Schema : oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFINV__5FMisc__5FTransactionsVO-item-response
Type:
Show Source
object
-
__FLEX_Context: string
Title:
Context Value
Maximum Length:40
Default Value:INV_Misc_Transactions
Project costing descriptive flexfield context name for purchase requisition distributions. -
__FLEX_Context_DisplayValue: string
Title:
Context Value
Project costing descriptive flexfield context display value for purchase requisition distributions. -
_BILLABLE_FLAG: string
Title:
Billable
Maximum Length:1
-
_BILLABLE_FLAG_Display: string
Title:
Billable
-
_CAPITALIZABLE_FLAG: string
Title:
Capitalizable
Maximum Length:1
-
_CAPITALIZABLE_FLAG_Display: string
Title:
Capitalizable
-
_CONTRACT_ID: integer
(int64)
Title:
Contract Number
-
_CONTRACT_ID_Display: string
Title:
Contract Number
-
_EXPENDITURE_ITEM_DATE: string
(date)
Title:
Expenditure Item Date
-
_EXPENDITURE_TYPE_ID: integer
(int64)
Title:
Expenditure Type
-
_EXPENDITURE_TYPE_ID_Display: string
Title:
Expenditure Type
-
_ORGANIZATION_ID: integer
(int64)
Title:
Expenditure Organization
-
_ORGANIZATION_ID_Display: string
Title:
Expenditure Organization
-
_PROJECT_ID: integer
(int64)
Title:
Project Number
-
_PROJECT_ID_Display: string
Title:
Project Number
-
_RESERVED_ATTRIBUTE1: string
Title:
Funding Source
Maximum Length:150
-
_RESERVED_ATTRIBUTE1_Display: string
Title:
Funding Source
-
_TASK_ID: integer
(int64)
Title:
Task Number
-
_TASK_ID_Display: string
Title:
Task Number
-
_WORK_TYPE_ID: integer
(int64)
Title:
Work Type
-
_WORK_TYPE_ID_Display: string
Title:
Work Type
-
DistributionId: integer
(int64)
Value that uniquely identifies the requisition distribution.
-
links: array
Links
Title:
Links
The link relations associated with the resource instance.
Nested Schema : oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFOM__5FSales__5FOrderVO-item-response
Type:
Show Source
object
-
__FLEX_Context: string
Title:
Context Value
Maximum Length:40
Default Value:OM_Sales_Order
Project costing descriptive flexfield context name for purchase requisition distributions. -
__FLEX_Context_DisplayValue: string
Title:
Context Value
Project costing descriptive flexfield context display value for purchase requisition distributions. -
billableFlag: string
Title:
Billable
Maximum Length:1
-
billableFlag_Display: string
Title:
Billable
-
capitalizableFlag: string
Title:
Capitalizable
Maximum Length:1
-
capitalizableFlag_Display: string
Title:
Capitalizable
-
contractId: integer
(int64)
Title:
Contract Number
-
contractId_Display: string
Title:
Contract Number
-
DistributionId: integer
(int64)
Value that uniquely identifies the requisition distribution.
-
expenditureItemDate: string
(date)
Title:
Expenditure Item Date
-
expenditureTypeId: integer
(int64)
Title:
Expenditure Type
-
expenditureTypeId_Display: string
Title:
Expenditure Type
-
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
organizationId: integer
(int64)
Title:
Expenditure Organization
-
organizationId_Display: string
Title:
Expenditure Organization
-
projectId: integer
(int64)
Title:
Project Number
-
projectId_Display: string
Title:
Project Number
-
reservedAttribute1: string
Title:
Funding Source
Maximum Length:150
-
reservedAttribute1_Display: string
Title:
Funding Source
-
taskId: integer
(int64)
Title:
Task Number
-
taskId_Display: string
Title:
Task Number
-
workTypeId: integer
(int64)
Title:
Work Type
-
workTypeId_Display: string
Title:
Work Type
Nested Schema : oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFPJC__5FAllVO-item-response
Type:
Show Source
object
-
__FLEX_Context: string
Title:
Context Value
Maximum Length:40
Default Value:PJC_All
Project costing descriptive flexfield context name for purchase requisition distributions. -
__FLEX_Context_DisplayValue: string
Title:
Context Value
Project costing descriptive flexfield context display value for purchase requisition distributions. -
_BILLABLE_FLAG: string
Title:
Billable
Maximum Length:1
-
_BILLABLE_FLAG_DisplayValue: string
Title:
Billable
-
_CAPITALIZABLE_FLAG: string
Title:
Capitalizable
Maximum Length:1
-
_CAPITALIZABLE_FLAG_DisplayValue: string
Title:
Capitalizable
-
_CONTRACT_ID: integer
(int64)
Title:
Contract Number
-
_CONTRACT_ID_Display: string
Title:
Contract Number
-
_EXPENDITURE_ITEM_DATE: string
(date)
Title:
Expenditure Item Date
-
_EXPENDITURE_TYPE_ID: integer
(int64)
Title:
Expenditure Type
-
_EXPENDITURE_TYPE_ID_Display: string
Title:
Expenditure Type
-
_ORGANIZATION_ID: integer
(int64)
Title:
Expenditure Organization
-
_ORGANIZATION_ID_Display: string
Title:
Expenditure Organization
-
_PROJECT_ID: integer
(int64)
Title:
Project Number
-
_PROJECT_ID_Display: string
Title:
Project Number
-
_RESERVED_ATTRIBUTE1: string
Title:
Funding Source
Maximum Length:150
-
_RESERVED_ATTRIBUTE1_Display: string
Title:
Funding Source
-
_TASK_ID: integer
(int64)
Title:
Task Number
-
_TASK_ID_Display: string
Title:
Task Number
-
_WORK_TYPE_ID: integer
(int64)
Title:
Work Type
-
_WORK_TYPE_ID_Display: string
Title:
Work Type
-
DistributionId: integer
(int64)
Value that uniquely identifies the requisition distribution.
-
links: array
Links
Title:
Links
The link relations associated with the resource instance.
Nested Schema : oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFPJC__5FExpenditure__5FBatchVO-item-response
Type:
Show Source
object
-
__FLEX_Context: string
Title:
Context Value
Maximum Length:40
Default Value:PJC_Expenditure_Batch
Project costing descriptive flexfield context name for purchase requisition distributions. -
__FLEX_Context_DisplayValue: string
Title:
Context Value
Project costing descriptive flexfield context display value for purchase requisition distributions. -
_BILLABLE_FLAG: string
Title:
Billable
Maximum Length:1
-
_BILLABLE_FLAG_Display: string
Title:
Billable
-
_CAPITALIZABLE_FLAG: string
Title:
Capitalizable
Maximum Length:1
-
_CAPITALIZABLE_FLAG_Display: string
Title:
Capitalizable
-
_CONTRACT_ID: integer
(int64)
Title:
Contract Number
-
_CONTRACT_ID_Display: string
Title:
Contract Number
-
_EXPENDITURE_ITEM_DATE: string
(date)
Title:
Expenditure Item Date
-
_EXPENDITURE_TYPE_ID: integer
(int64)
Title:
Expenditure Type
-
_EXPENDITURE_TYPE_ID_Display: string
Title:
Expenditure Type
-
_ORGANIZATION_ID: integer
(int64)
Title:
Expenditure Organization
-
_ORGANIZATION_ID_Display: string
Title:
Expenditure Organization
-
_PROJECT_ID: integer
(int64)
Title:
Project Number
-
_PROJECT_ID_Display: string
Title:
Project Number
-
_RESERVED_ATTRIBUTE1: string
Title:
Funding Source
Maximum Length:150
-
_RESERVED_ATTRIBUTE1_Display: string
Title:
Funding Source
-
_TASK_ID: integer
(int64)
Title:
Task Number
-
_TASK_ID_Display: string
Title:
Task Number
-
_WORK_TYPE_ID: integer
(int64)
Title:
Work Type
-
_WORK_TYPE_ID_Display: string
Title:
Work Type
-
DistributionId: integer
(int64)
Value that uniquely identifies the requisition distribution.
-
links: array
Links
Title:
Links
The link relations associated with the resource instance.
Nested Schema : oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFPOR__5FRequisitionVO-item-response
Type:
Show Source
object
-
__FLEX_Context: string
Title:
Context Value
Maximum Length:40
Default Value:POR_Requisition
Project costing descriptive flexfield context name for purchase requisition distributions. -
__FLEX_Context_DisplayValue: string
Title:
Context Value
Project costing descriptive flexfield context display value for purchase requisition distributions. -
_BILLABLE_FLAG: string
Title:
Billable
Maximum Length:1
-
_BILLABLE_FLAG_Display: string
Title:
Billable
-
_CAPITALIZABLE_FLAG: string
Title:
Capitalizable
Maximum Length:1
-
_CAPITALIZABLE_FLAG_Display: string
Title:
Capitalizable
-
_CONTRACT_ID: integer
(int64)
Title:
Contract Number
-
_CONTRACT_ID_Display: string
Title:
Contract Number
-
_EXPENDITURE_ITEM_DATE: string
(date)
Title:
Expenditure Item Date
-
_EXPENDITURE_TYPE_ID: integer
(int64)
Title:
Expenditure Type
-
_EXPENDITURE_TYPE_ID_Display: string
Title:
Expenditure Type
-
_ORGANIZATION_ID: integer
(int64)
Title:
Expenditure Organization
-
_ORGANIZATION_ID_Display: string
Title:
Expenditure Organization
-
_PROJECT_ID: integer
(int64)
Title:
Project Number
-
_PROJECT_ID_Display: string
Title:
Project Number
-
_RESERVED_ATTRIBUTE1: string
Title:
Funding Source
Maximum Length:150
-
_RESERVED_ATTRIBUTE1_Display: string
Title:
Funding Source
-
_TASK_ID: integer
(int64)
Title:
Task Number
-
_TASK_ID_Display: string
Title:
Task Number
-
_WORK_TYPE_ID: integer
(int64)
Title:
Work Type
-
_WORK_TYPE_ID_Display: string
Title:
Work Type
-
DistributionId: integer
(int64)
Value that uniquely identifies the requisition distribution.
-
links: array
Links
Title:
Links
The link relations associated with the resource instance.
Nested Schema : oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFPOR__5FUser__5FPreferencesVO-item-response
Type:
Show Source
object
-
__FLEX_Context: string
Title:
Context Value
Maximum Length:40
Default Value:POR_User_Preferences
Project costing descriptive flexfield context name for purchase requisition distributions. -
__FLEX_Context_DisplayValue: string
Title:
Context Value
Project costing descriptive flexfield context display value for purchase requisition distributions. -
_CONTRACT_ID: integer
(int64)
Title:
Contract Number
-
_CONTRACT_ID_Display: string
Title:
Contract Number
-
_EXPENDITURE_TYPE_ID: integer
(int64)
Title:
Expenditure Type
-
_EXPENDITURE_TYPE_ID_Display: string
Title:
Expenditure Type
-
_ORGANIZATION_ID: integer
(int64)
Title:
Expenditure Organization
-
_ORGANIZATION_ID_Display: string
Title:
Expenditure Organization
-
_PROJECT_ID: integer
(int64)
Title:
Project Number
-
_PROJECT_ID_Display: string
Title:
Project Number
-
_RESERVED_ATTRIBUTE1: string
Title:
Funding Source
Maximum Length:150
-
_RESERVED_ATTRIBUTE1_Display: string
Title:
Funding Source
-
_TASK_ID: integer
(int64)
Title:
Task Number
-
_TASK_ID_Display: string
Title:
Task Number
-
DistributionId: integer
(int64)
Value that uniquely identifies the requisition distribution.
-
links: array
Links
Title:
Links
The link relations associated with the resource instance.
Nested Schema : oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFPO__5FPurchase__5FOrderVO-item-response
Type:
Show Source
object
-
__FLEX_Context: string
Title:
Context Value
Maximum Length:40
Default Value:PO_Purchase_Order
Project costing descriptive flexfield context name for purchase requisition distributions. -
__FLEX_Context_DisplayValue: string
Title:
Context Value
Project costing descriptive flexfield context display value for purchase requisition distributions. -
_BILLABLE_FLAG: string
Title:
Billable
Maximum Length:1
-
_BILLABLE_FLAG_Display: string
Title:
Billable
-
_CAPITALIZABLE_FLAG: string
Title:
Capitalizable
Maximum Length:1
-
_CAPITALIZABLE_FLAG_Display: string
Title:
Capitalizable
-
_CONTRACT_ID: integer
(int64)
Title:
Contract Number
-
_CONTRACT_ID_Display: string
Title:
Contract Number
-
_EXPENDITURE_ITEM_DATE: string
(date)
Title:
Expenditure Item Date
-
_EXPENDITURE_TYPE_ID: integer
(int64)
Title:
Expenditure Type
-
_EXPENDITURE_TYPE_ID_Display: string
Title:
Expenditure Type
-
_ORGANIZATION_ID: integer
(int64)
Title:
Expenditure Organization
-
_ORGANIZATION_ID_Display: string
Title:
Expenditure Organization
-
_PROJECT_ID: integer
(int64)
Title:
Project Number
-
_PROJECT_ID_Display: string
Title:
Project Number
-
_RESERVED_ATTRIBUTE1: string
Title:
Funding Source
Maximum Length:150
-
_RESERVED_ATTRIBUTE1_Display: string
Title:
Funding Source
-
_TASK_ID: integer
(int64)
Title:
Task Number
-
_TASK_ID_Display: string
Title:
Task Number
-
_WORK_TYPE_ID: integer
(int64)
Title:
Work Type
-
_WORK_TYPE_ID_Display: string
Title:
Work Type
-
DistributionId: integer
(int64)
Value that uniquely identifies the requisition distribution.
-
links: array
Links
Title:
Links
The link relations associated with the resource instance.
Nested Schema : oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFPO__5FPurchase__5FOrder__5FLineVO-item-response
Type:
Show Source
object
-
__FLEX_Context: string
Title:
Context Value
Maximum Length:40
Default Value:PO_Purchase_Order_Line
Project costing descriptive flexfield context name for purchase requisition distributions. -
__FLEX_Context_DisplayValue: string
Title:
Context Value
Project costing descriptive flexfield context display value for purchase requisition distributions. -
_BILLABLE_FLAG: string
Title:
Billable
Maximum Length:1
-
_BILLABLE_FLAG_Display: string
Title:
Billable
-
_CAPITALIZABLE_FLAG: string
Title:
Capitalizable
Maximum Length:1
-
_CAPITALIZABLE_FLAG_Display: string
Title:
Capitalizable
-
_CONTRACT_ID: integer
(int64)
Title:
Contract Number
-
_CONTRACT_ID_Display: string
Title:
Contract Number
-
_EXPENDITURE_ITEM_DATE: string
(date)
Title:
Expenditure Item Date
-
_EXPENDITURE_TYPE_ID: integer
(int64)
Title:
Expenditure Type
-
_EXPENDITURE_TYPE_ID_Display: string
Title:
Expenditure Type
-
_ORGANIZATION_ID: integer
(int64)
Title:
Expenditure Organization
-
_ORGANIZATION_ID_Display: string
Title:
Expenditure Organization
-
_PROJECT_ID: integer
(int64)
Title:
Project Number
-
_PROJECT_ID_Display: string
Title:
Project Number
-
_RESERVED_ATTRIBUTE1: string
Title:
Funding Source
Maximum Length:150
-
_RESERVED_ATTRIBUTE1_Display: string
Title:
Funding Source
-
_TASK_ID: integer
(int64)
Title:
Task Number
-
_TASK_ID_Display: string
Title:
Task Number
-
_WORK_TYPE_ID: integer
(int64)
Title:
Work Type
-
_WORK_TYPE_ID_Display: string
Title:
Work Type
-
DistributionId: integer
(int64)
Value that uniquely identifies the requisition distribution.
-
links: array
Links
Title:
Links
The link relations associated with the resource instance.
Nested Schema : oracle_apps_flex_prc_por_manageReq_restModel_pjcRequisitionDistributions_view_PJCDFFPO__5FPurchase__5FOrder__5FScheduleVO-item-response
Type:
Show Source
object
-
__FLEX_Context: string
Title:
Context Value
Maximum Length:40
Default Value:PO_Purchase_Order_Schedule
Project costing descriptive flexfield context name for purchase requisition distributions. -
__FLEX_Context_DisplayValue: string
Title:
Context Value
Project costing descriptive flexfield context display value for purchase requisition distributions. -
_BILLABLE_FLAG: string
Title:
Billable
Maximum Length:1
-
_BILLABLE_FLAG_Display: string
Title:
Billable
-
_CAPITALIZABLE_FLAG: string
Title:
Capitalizable
Maximum Length:1
-
_CAPITALIZABLE_FLAG_Display: string
Title:
Capitalizable
-
_CONTRACT_ID: integer
(int64)
Title:
Contract Number
-
_CONTRACT_ID_Display: string
Title:
Contract Number
-
_EXPENDITURE_ITEM_DATE: string
(date)
Title:
Expenditure Item Date
-
_EXPENDITURE_TYPE_ID: integer
(int64)
Title:
Expenditure Type
-
_EXPENDITURE_TYPE_ID_Display: string
Title:
Expenditure Type
-
_ORGANIZATION_ID: integer
(int64)
Title:
Expenditure Organization
-
_ORGANIZATION_ID_Display: string
Title:
Expenditure Organization
-
_PROJECT_ID: integer
(int64)
Title:
Project Number
-
_PROJECT_ID_Display: string
Title:
Project Number
-
_RESERVED_ATTRIBUTE1: string
Title:
Funding Source
Maximum Length:150
-
_RESERVED_ATTRIBUTE1_Display: string
Title:
Funding Source
-
_TASK_ID: integer
(int64)
Title:
Task Number
-
_TASK_ID_Display: string
Title:
Task Number
-
_WORK_TYPE_ID: integer
(int64)
Title:
Work Type
-
_WORK_TYPE_ID_Display: string
Title:
Work Type
-
DistributionId: integer
(int64)
Value that uniquely identifies the requisition distribution.
-
links: array
Links
Title:
Links
The link relations associated with the resource instance.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : purchaseRequisitions-lines-informationTemplates-item-response
Type:
Show Source
object
-
InformationTemplate: string
Name of the information template.
-
informationTemplateDFF: array
Information Template Flexfields for Purchase Requisition Lines
Title:
Information Template Flexfields for Purchase Requisition Lines
The Information Template Flexfields for Purchase Requisitions Lines resource manages details about information templates descriptive flexfields. -
InformationTemplateDisplayName: string
Read Only:
true
Maximum Length:250
Display name of the information template. -
InformationTemplateId: integer
(int64)
Value that uniquely identifies the information template.
-
InformationTemplateValuesId: integer
(int64)
Read Only:
true
Value that uniquely identifies the information template segment values. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
RequisitionLineId: integer
(int64)
Read Only:
true
Value that uniquely identifies the requisition line.
Nested Schema : Information Template Flexfields for Purchase Requisition Lines
Type:
array
Title:
Information Template Flexfields for Purchase Requisition Lines
The Information Template Flexfields for Purchase Requisitions Lines resource manages details about information templates descriptive flexfields.
Show Source
-
Array of:
object Discriminator: __FLEX_Context
Discriminator:
{ "propertyName":"__FLEX_Context", "mapping":{ "Employee Name":"#/components/schemas/oracle_apps_flex_prc_por_manageReq_restModel_infoTemplate_view_InfoTemplateDFFEmployee____NameVO-item-response" } }
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Discriminator: __FLEX_Context
Type:
object
Discriminator: __FLEX_Context
Discriminator Values
Match One Schema
Show Source
Nested Schema : oracle_apps_flex_prc_por_manageReq_restModel_infoTemplate_view_InfoTemplateDFFEmployee____NameVO-item-response
Type:
Show Source
object
-
__FLEX_Context: string
Title:
Context Value
Maximum Length:30
Default Value:Employee Name
Descriptive flexfield context name for purchase requisition information template. -
__FLEX_Context_DisplayValue: string
Title:
Context Value
Descriptive flexfield context display value for purchase requisition information template. -
employeeName: string
Title:
Employee Name
Maximum Length:150
-
InfoTemplateValuesId: integer
(int64)
Value that uniquely identifies the information template segment values.
-
links: array
Links
Title:
Links
The link relations associated with the resource instance.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Discriminator: __FLEX_Context
Type:
object
Discriminator: __FLEX_Context
Discriminator Values
Match One Schema
Show Source
Nested Schema : oracle_apps_flex_prc_por_manageReq_restModel_specialHandlingLines_view_RequisitionLineSHDFFORA__5FPO__5FBILL__5FONLY__5FLINESVO-item-response
Type:
Show Source
object
-
__FLEX_Context: string
Title:
Context Prompt
Maximum Length:30
Default Value:ORA_PO_BILL_ONLY_LINES
Special handling descriptive flexfield context name for purchase requisition lines. -
__FLEX_Context_DisplayValue: string
Title:
Context Prompt
Special handling descriptive flexfield context display value for purchase requisition lines. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
lot: string
Title:
Lot
Maximum Length:150
-
RequisitionLineId: integer
(int64)
Value that uniquely identifies the requisition line.
-
serialNumber: string
Title:
Serial Number
Maximum Length:150
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Discriminator: __FLEX_Context
Type:
object
Discriminator: __FLEX_Context
Discriminator Values
Match One Schema
Show Source
Nested Schema : oracle_apps_flex_prc_por_manageReq_restModel_specialHandlingHeaders_view_RequisitionHeaderSHDFFORA__5FPO__5FBILL__5FONLY__5FHEADERSVO-item-response
Type:
Show Source
object
-
__FLEX_Context: string
Title:
Context Prompt
Maximum Length:30
Default Value:ORA_PO_BILL_ONLY_HEADERS
Special handling descriptive flexfield context name for purchase requisition lines. -
__FLEX_Context_DisplayValue: string
Title:
Context Prompt
Special handling descriptive flexfield context display value for purchase requisition lines. -
dateOfService: string
(date)
Title:
Date of Service
-
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
physicianName: string
Title:
Physician Name
Maximum Length:150
-
referenceNumber: string
Title:
Reference Number
Maximum Length:150
-
RequisitionHeaderId: integer
(int64)
Value that uniquely identifies the requisition.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : purchaseRequisitions-summaryAttributes-item-response
Type:
Show Source
object
-
AccountUserOverrideFlag: boolean
Maximum Length:
1
Contains one of the following values: Y, or N, or Null. If Y, the charge account is updated by the user on all the requisition lines. If N, the charge account isn't updated by the user on all the requisition lines. If Null, the charge account is updated by the user on some of the requisition lines. -
ActiveLineCount: number
Number of requisition lines excluding split and replaced lines for the requisition.
-
Buyer: string
Maximum Length:
255
Name of the buyer responsible for managing the requisition line or purchase order associated with the line through its life cycle. -
BuyerCount: number
Number of buyers from the orders that were opened or assigned to the lines for the requisition.
-
BuyerId: integer
Value that uniquely identifies the buyer responsible for managing the requisition line or purchase order associated with the line through its life cycle.
-
CategoryId: integer
Value that uniquely identifies the purchasing category across all the requisition lines. The value is set to Null if the purchasing category is different across the requisition lines.
-
ChargeAccount: string
Title:
Charge Account
Maximum Length:255
Account that the purchase from a requisition is charged to. -
ChargeAccountId: integer
Value that uniquely identifies the account that the purchase from a requisition is charged to.
-
ChargeToSingleAccountFlag: boolean
Maximum Length:
1
Contains one of the following values: true or false. If true, all the requisition lines are charged to the same charge account. If false, then the charge account is different on lines. The default value is false. -
ContainsNoneditableLinesFlag: boolean
Maximum Length:
1
Contains one of the following values: true or false. If true, then the requisition contains lines that can't be edited. If false, then it doesn't contain noneditable lines. The default value is false. -
DeliverToLocationCode: string
Title:
Deliver-to Location
Maximum Length:255
Abbreviation that identifies the final location where the buying company should deliver the goods that were previously received from a supplier. -
DeliverToLocationId: integer
Value that uniquely identifies the final location where the buying company should deliver the goods that were previously received from a supplier.
-
DeliverToOneTimeLocationAddress: string
Title:
One-Time Location Address
Maximum Length:255
Physical address of the one time location where the buying company should deliver the goods previously received from a supplier. -
DeliverToOneTimeLocationId: integer
Value that uniquely identifies the one time location where the buying company should deliver the goods that were previously received from a supplier.
-
DeliverToSingleLocationFlag: boolean
Maximum Length:
1
Contains one of the following values: true or false. If true, all the requisition lines have the same delivery location. If false, then the delivery location is different on lines. The default value is false. -
DestinationTypeCode: string
Maximum Length:
255
Value that uniquely identifies the destination type code on the requisition lines. The value is set to Null if the destination type code is different across the requisition lines. -
HasAllMasterItemsFlag: boolean
Maximum Length:
1
Contains one of the following values: true or false. If true, then all the requisition lines are for master items. This attribute doesn't have a default value. -
HasOneTimeLocAcrossLinesFlag: boolean
Maximum Length:
1
Contains one of the following values: true or false. If true, then at least one of the requisition lines has a one-time deliver-to location type. This attribute doesn't have a default value. -
LineCount: number
Number of lines in the requisition.
-
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
MaximumSequenceNumber: integer
Value that's used to generate the identification key for a requisition.
-
OneTimeLocationCountAcrossRequisition: integer
Total count of the one-time locations available across requisition. This count doesn't include one-time location for the current requisition.
-
OneTimeLocationCountAcrossRequisitionLine: integer
Total count of the one-time locations available across requisition lines. This count doesn't include one-time location for the current requisition line.
-
POHeaderId: integer
Value that uniquely identifies first purchase order that was opened for the requisition.
-
ProjectCostingDetailsCode: string
Maximum Length:
25
Contains one of the following values: NONE, SINGLE, or MULTIPLE. If none of the distributions have project costing details associated with them, the attribute value is set to NONE. If all the distributions have exactly the same project and task associated with them, it is set to SINGLE. If the project and task associated with the distributions are different, it is set to MULTIPLE. -
ProjectId: number
Value that uniquely identifies the project.
-
ProjectName: string
Maximum Length:
240
Name of the project, which is displayed on the requisition header. -
ProjectNumber: string
Maximum Length:
25
Number of the project, which is displayed on the requisition header. -
ProjectsInformationAcrossLines: string
Maximum Length:
25
Contains one of the following values: NONE, SINGLE, or MULTIPLE. If none of the distributions have project costing details associated with them, the attribute value is set to NONE. If all the distributions have the same project associated with them and the costing details are exactly the same, it is set to SINGLE. If the project costing details of the distributions are different, it is set to MULTIPLE. -
PurchaseOrder: string
Maximum Length:
255
Number that identifies the first purchase order that was opened for the requisition. -
PurchaseOrderCount: number
Number of purchase orders that were opened for the requisition.
-
RequestedDeliveryDate: string
(date)
Title:
Requested Delivery Date
Date when the buying company requested the ordered item or service to be delivered. -
Requester: string
Maximum Length:
240
Display name of the person for whom goods or services are being ordered. The value is set to Null if the requester is different across requisition lines. -
RequesterId: integer
Value that uniquely identifies the person for whom goods or services are being ordered. The value is set to Null if the requester is different across the requisition lines.
-
RequisitionApprovalAmount: number
Title:
Approval Amount
Sum total of RequisitionTotalAmount and RequisitionNonRecoverableTaxAmount expressed in the functional currency. -
RequisitionHeaderId: integer
Value that uniquely identifies the requisition.
-
RequisitionNonRecoverableTaxAmount: number
Title:
Nonrecoverable Tax
Sum total of nonrecoverable tax amounts across all requisition lines expressed in the functional currency. -
RequisitionTotalAmount: number
Title:
Requisition Amount
Sum total of distribution amounts across all requisition lines expressed in the functional currency. -
SameAccountUserOverrideFlag: boolean
Maximum Length:
1
Contains one of the following values: true or false. If true, all the requisition lines have the charge account either updated or not updated by the user. If false, the charge account is updated on some of the requisition lines by the user. This attribute doesn't have a default value. -
SameCategoryIdFlag: boolean
Maximum Length:
1
Contains one of the following values: true or false. If true, all the requisition lines have the same purchasing category. If false, the purchasing category is different across the requisition lines. This attribute doesn't have a default value. -
SameDestinationOrganizationIdFlag: boolean
Maximum Length:
1
Contains one of the following values: true or false. If true, then all the lines in the requisition contain the same destination organization ID. -
SameDestinationSubinventoryFlag: boolean
Maximum Length:
1
Contains one of the following values: true or false. If true, then all the requisition lines have the same destination subinventory attribute. This attribute doesn't have a default value. -
SameDestinationTypeCodeFlag: boolean
Maximum Length:
1
Contains one of the following values: true or false. If true, all the requisition lines have the same destination type. If false, the destination type is different on the requisition lines. This attribute doesn't have a default value. -
SameRequestedDeliveryDateFlag: boolean
Maximum Length:
1
Contains one of the following values: true or false. If true, all the requisition lines carry the same requested delivery date value. If false, then the requested delivery date is different on lines. The default value is false. -
SameRequesterIdFlag: boolean
Maximum Length:
1
Contains one of the following values: true or false. If true, all the requisition lines are ordered for the same person. If false, the requisition lines are ordered for different persons. This attribute doesn't have a default value. -
SameVendorIdFlag: boolean
Maximum Length:
1
Contains one of the following values: true or false. If true, all the requisition lines have the same supplier. If false, the supplier is different across the requisition lines. This attribute doesn't have a default value. -
TaskName: string
Maximum Length:
240
Name of the project task, which is displayed on the requisition header. -
TaskNumber: string
Maximum Length:
240
Number of the project task, which is displayed on the requisition header. -
TOHeaderId: integer
Value that uniquely identifies the first transfer order that was opened for the requisition.
-
TotalIMTLinesCount: number
Number of internal material transfer lines in a requisition.
-
TransferOrder: string
Maximum Length:
255
Number that identifies the first transfer order that was opened for the requisition. -
TransferOrderCount: number
Number of transfer orders that were opened for the requisition.
-
UnprocessedIMTLinesCount: number
Number of internal material transfer lines in a requisition for which the transfer price hasn't been derived.
-
VendorId: integer
Value that uniquely identifies the supplier across all the requisition lines. The value is set to Null if the supplier is different across the requisition lines.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Examples
This example describes how to get all headers.
Example 1 cURL Command
Use the following cURL command to submit a request on the REST resource:
curl -u username:password "https://servername/fscmRestApi/resources/version/purchaseRequisitions"
Example 1 Response Body
The following shows an example of the response body in JSON format.
{ { "items": [ { "RequisitionHeaderId": 1000004955, "Requisition": "5004955", "RequisitioningBUId": 888, "RequisitioningBU": "Vision France - Organization", "PreparerId": 1562, "Preparer": "Jean Jones", "PreparerEmail": null, "Description": null, "Justification": null, "DocumentStatus": "Approved", "DocumentStatusCode": "APPROVED", "SubmissionDate": "2018-08-29T18:38:24.144+00:00", "ApprovedDate": "2018-08-29T18:38:44.707+00:00", "FunctionalCurrencyCode": "EUR", "SoldToLegalEntityId": null, "SoldToLegalEntity": null, "FundsStatus": null, "FundsStatusCode": null, "InterfaceSourceCode": null, "InterfaceSourceLineId": null, "EmergencyPONumber": null, "ModifyingApproverId": null, "ModifyingApprover": null, "ModifyingApproverEmail": null, "OverridingApproverId": null, "OverridingApprover": null, "OverridingApproverEmail": null, "FundsOverrideApproverId": null, "FundsOverrideApprover": null, "FundsOverrideApproverEmail": null, "BudgetaryControlEnabledFlag": false, "EmergencyRequisitionFlag": null, "ExternallyManagedFlag": null, "InternalTransferFlag": false, "FundsChkFailWarnFlag": null, "CreationDate": "2018-08-29T18:37:16.321+00:00", "LastUpdateDate": "2018-08-29T18:38:44.760+00:00", "CreatedBy": "CVRQST01", "LastUpdatedBy": "CVRQST10", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/1000004955", "name": "purchaseRequisitions", "kind": "item", "properties": { "changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A657870000000017704000000017372001B6F7261636C652E6A626F2E646F6D61696E2E4E756C6C56616C75655899C1C58DAABEEB02000149000A6D53514C54797065496478700000000C78" } }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/1000004955", "name": "purchaseRequisitions", "kind": "item" }, { "rel": "child", "href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/1000004955/child/lines", "name": "lines", "kind": "collection" } ] }, { ... } ], "count": 25, "hasMore": true, "limit": 25, "offset": 0, "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions", "name": "purchaseRequisitions", "kind": "collection" } ] } "items": [ { "RequisitionHeaderId": 1000004955, "Requisition": "5004955", "RequisitioningBUId": 888, "RequisitioningBU": "Vision France - Organization", "PreparerId": 1562, "Preparer": "Jean Jones", "PreparerEmail": null, "Description": null, "Justification": null, "DocumentStatus": "Approved", "DocumentStatusCode": "APPROVED", "SubmissionDate": "2018-08-29T18:38:24.144+00:00", "ApprovedDate": "2018-08-29T18:38:44.707+00:00", "FunctionalCurrencyCode": "EUR", "SoldToLegalEntityId": null, "SoldToLegalEntity": null, "ProcurementCardId": null, "ProcurementCard": null, "FundsStatus": null, "FundsStatusCode": null, "InterfaceSourceCode": null, "InterfaceSourceLineId": null, "EmergencyPONumber": null, "ModifyingApproverId": null, "ModifyingApprover": null, "ModifyingApproverEmail": null, "OverridingApproverId": null, "OverridingApprover": null, "OverridingApproverEmail": null, "FundsOverrideApproverId": null, "FundsOverrideApprover": null, "FundsOverrideApproverEmail": null, "BudgetaryControlEnabledFlag": false, "EmergencyRequisitionFlag": null, "ExternallyManagedFlag": null, "InternalTransferFlag": false, "FundsChkFailWarnFlag": null, "CreationDate": "2018-08-29T18:37:16.321+00:00", "LastUpdateDate": "2018-08-29T18:38:44.760+00:00", "CreatedBy": "CVRQST01", "LastUpdatedBy": "CVRQST10", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/1000004955", "name": "purchaseRequisitions", "kind": "item", "properties": { "changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A657870000000017704000000017372001B6F7261636C652E6A626F2E646F6D61696E2E4E756C6C56616C75655899C1C58DAABEEB02000149000A6D53514C54797065496478700000000C78" } }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/1000004955", "name": "purchaseRequisitions", "kind": "item" }, { "rel": "child", "href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/1000004955/child/lines", "name": "lines", "kind": "collection" } ] }, { ... } ], "count": 25, "hasMore": true, "limit": 25, "offset": 0, "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions", "name": "purchaseRequisitions", "kind": "collection" } ] }
Example 2 cURL Command
Use the following cURL command to submit a request on the REST resource to get all requisitions created for a requisitioning business unit:
curl -u username:password "https://servername/fscmRestApi/resources/version/purchaseRequisitions?q=RequisitioningBUId=RequisitioningBUId"
Example 2 Response Body
The following shows an example of the response body in JSON format.
{ { "items": [ { "RequisitionHeaderId": 1000004955, "Requisition": "5004955", "RequisitioningBUId": 888, "RequisitioningBU": "Vision France - Organization", "PreparerId": 1562, "Preparer": "Jean Jones", "PreparerEmail": null, "Description": null, "Justification": null, "DocumentStatus": "Approved", "DocumentStatusCode": "APPROVED", "SubmissionDate": "2018-08-29T18:38:24.144+00:00", "ApprovedDate": "2018-08-29T18:38:44.707+00:00", "FunctionalCurrencyCode": "EUR", "SoldToLegalEntityId": null, "SoldToLegalEntity": null, "FundsStatus": null, "FundsStatusCode": null, "InterfaceSourceCode": null, "InterfaceSourceLineId": null, "EmergencyPONumber": null, "ModifyingApproverId": null, "ModifyingApprover": null, "ModifyingApproverEmail": null, "OverridingApproverId": null, "OverridingApprover": null, "OverridingApproverEmail": null, "FundsOverrideApproverId": null, "FundsOverrideApprover": null, "FundsOverrideApproverEmail": null, "BudgetaryControlEnabledFlag": false, "EmergencyRequisitionFlag": null, "ExternallyManagedFlag": null, "InternalTransferFlag": false, "FundsChkFailWarnFlag": null, "CreationDate": "2018-08-29T18:37:16.321+00:00", "LastUpdateDate": "2018-08-29T18:38:44.760+00:00", "CreatedBy": "CVRQST01", "LastUpdatedBy": "CVRQST10", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/1000004955", "name": "purchaseRequisitions", "kind": "item", "properties": { "changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A657870000000017704000000017372001B6F7261636C652E6A626F2E646F6D61696E2E4E756C6C56616C75655899C1C58DAABEEB02000149000A6D53514C54797065496478700000000C78" } }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/1000004955", "name": "purchaseRequisitions", "kind": "item" }, { "rel": "child", "href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/1000004955/child/lines", "name": "lines", "kind": "collection" } ] }, { ... } ], "count": 25, "hasMore": true, "limit": 25, "offset": 0, "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions", "name": "purchaseRequisitions", "kind": "collection" } ] } "items": [ { "RequisitionHeaderId": 1000004955, "Requisition": "5004955", "RequisitioningBUId": 888, "RequisitioningBU": "Vision France - Organization", "PreparerId": 1562, "Preparer": "Jean Jones", "PreparerEmail": null, "Description": null, "Justification": null, "DocumentStatus": "Approved", "DocumentStatusCode": "APPROVED", "SubmissionDate": "2018-08-29T18:38:24.144+00:00", "ApprovedDate": "2018-08-29T18:38:44.707+00:00", "FunctionalCurrencyCode": "EUR", "SoldToLegalEntityId": null, "SoldToLegalEntity": null, "ProcurementCardId": null, "ProcurementCard": null, "FundsStatus": null, "FundsStatusCode": null, "InterfaceSourceCode": null, "InterfaceSourceLineId": null, "EmergencyPONumber": null, "ModifyingApproverId": null, "ModifyingApprover": null, "ModifyingApproverEmail": null, "OverridingApproverId": null, "OverridingApprover": null, "OverridingApproverEmail": null, "FundsOverrideApproverId": null, "FundsOverrideApprover": null, "FundsOverrideApproverEmail": null, "BudgetaryControlEnabledFlag": false, "EmergencyRequisitionFlag": null, "ExternallyManagedFlag": null, "InternalTransferFlag": false, "FundsChkFailWarnFlag": null, "CreationDate": "2018-08-29T18:37:16.321+00:00", "LastUpdateDate": "2018-08-29T18:38:44.760+00:00", "CreatedBy": "CVRQST01", "LastUpdatedBy": "CVRQST10", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/1000004955", "name": "purchaseRequisitions", "kind": "item", "properties": { "changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A657870000000017704000000017372001B6F7261636C652E6A626F2E646F6D61696E2E4E756C6C56616C75655899C1C58DAABEEB02000149000A6D53514C54797065496478700000000C78" } }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/1000004955", "name": "purchaseRequisitions", "kind": "item" }, { "rel": "child", "href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/1000004955/child/lines", "name": "lines", "kind": "collection" } ] }, { ... } ], "count": 25, "hasMore": true, "limit": 25, "offset": 0, "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions", "name": "purchaseRequisitions", "kind": "collection" } ] }