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.
- ViewAccessibleRequisitionDetailsFinder: Finds all details of a requisition in the accessible requisitioning business unit for a user with privilege to view all requisitions.
Finder Variables:- bindRequisitionHeaderId; integer; Value of the requisition header ID that uniquely identifies a requisition
- 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.
- ModifyingApproverId; integer; Value that uniquely identifies the user who is currently modifying the requisition during the approval process.
- 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.
-
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:
ItemsThe items in the collection. -
limit(required): integer
The actual paging size used by the server.
-
links(required): array
Links
Title:
LinksThe 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:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : purchaseRequisitions-item-response
Type:
Show Source
object-
ActiveRequisitionFlag: boolean
Maximum Length:
1Default Value:falseContains 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 EmailMaximum Length:240Email 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:
trueDate and time when the requisition was most recently approved. -
attachments: array
Attachments for Purchase Requisitions
Title:
Attachments for Purchase RequisitionsThe Attachments for Purchase Requisitions resource manages attachments for a purchase requisition. -
BudgetaryControlEnabledFlag: boolean
Read Only:
trueMaximum Length:1Contains 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:
trueMaximum Length:64User who created the requisition. -
CreationDate: string
(date-time)
Read Only:
trueDate and time when the requisition was created. -
Description: string
Maximum Length:
240Description of the requisition. -
DFF: array
Flexfields for Purchase Requisitions
Title:
Flexfields for Purchase RequisitionsThe Flexfields for Purchase Requisitions resource manages details about purchase requisitions. -
DocumentStatus: string
Title:
StatusRead Only:trueMaximum Length:80Status of the requisition. -
DocumentStatusCode: string
Read Only:
trueMaximum Length:25Default Value:INCOMPLETEAbbreviation that identifies the requisition status. -
EmergencyPONumber: string
Read Only:
trueMaximum Length:30Number that identifies the purchase order reserved in advance for an emergency requisition. -
EmergencyRequisitionFlag: boolean
Read Only:
trueMaximum Length:1Contains 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:
1Contains 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:
trueMaximum Length:15Abbreviation that identifies the currency of the current requisitioning business unit. -
FundsChkFailWarnFlag: boolean
Maximum Length:
1Default Value:falseContains 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 ApproverRead Only:trueMaximum Length:240User who has the authority to override insufficient funds for a requisition. -
FundsOverrideApproverEmail: string
Title:
Funds Override Approver EmailRead Only:trueMaximum Length:240Email address of the specific user who has the authority to override insufficient funds for a requisition. -
FundsOverrideApproverId: integer
(int64)
Read Only:
trueValue that uniquely identifies the user who has the authority to override insufficient funds for a requisition. -
FundsStatus: string
Title:
Funds StatusRead Only:trueMaximum Length:80Status of the funds reservation request. -
FundsStatusCode: string
Read Only:
trueMaximum Length:30Abbreviation that identifies the status of funds check or funds reservation validation result. -
HasActionRequiredLinesFlag: boolean
Read Only:
trueMaximum Length:1Contains 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:
trueMaximum Length:1Contains 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:
trueMaximum Length:1Contains 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:
trueMaximum Length:1Contains 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:
trueMaximum Length:1Contains 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:
trueMaximum Length:255Value that's used to get the approval task ID that uniquely identifies the approval task for a requisition. -
InsufficientFundsFlag: boolean
Maximum Length:
1Default Value:falseContains 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:
25Abbreviation that identifies the source of the requisition from a requisition import process. -
InterfaceSourceLineId: integer
(int64)
Read Only:
trueValue that uniquely identifies the source requisition line from a requisition import process. -
InternalTransferFlag: boolean
Read Only:
trueMaximum Length:1Default Value:falseContains 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:
JustificationMaximum Length:1000Reason for creating the requisition. -
LastUpdateDate: string
(date-time)
Read Only:
trueDate and time when the requisition was last updated. -
LastUpdatedBy: string
Read Only:
trueMaximum Length:64Name of the user who last updated the requisition. -
LifecycleStatus: string
Title:
Lifecycle StatusRead Only:trueMaximum Length:80Aggregated value of the lifecycle status across requisition lines. This attribute isn't currently used. -
LifecycleStatusCode: string
Read Only:
trueMaximum Length:30Abbreviation that identifies the requisition lifecycle status. This attribute isn't currently used. -
lines: array
Lines
Title:
LinesThe Lines resource manages items to be requisitioned, their quantity, unit of measure, price, and deliver-to-location information. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
LockedByBuyerFlag: boolean
Read Only:
trueMaximum Length:1Contains 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 ApproverRead Only:trueMaximum Length:240Name of the user who is currently modifying the requisition during the approval process. -
ModifyingApproverEmail: string
Title:
Modifying Approver EmailRead Only:trueMaximum Length:240Email address of the user who is currently modifying the requisition during the approval process. -
ModifyingApproverId: integer
(int64)
Read Only:
trueValue that uniquely identifies the user who is currently modifying the requisition during the approval process. -
OverridingApprover: string
Title:
Overriding ApproverRead Only:trueMaximum Length:240Name of the user specified on the requisition as the overriding approver for approval routing. -
OverridingApproverEmail: string
Title:
Overriding Approver EmailRead Only:trueMaximum Length:240Email 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 NumberMaximum Length:30Person number of the user specified on the requisition as the overriding approver for approval routing. -
Preparer: string
Title:
Entered ByRead Only:trueMaximum Length:240Name of the user who owns the requisition. This user creates the requisition but can transfer ownership to another user. -
PreparerEmail: string
Title:
Entered by EmailMaximum Length:240Email 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:
NameRead Only:trueMaximum Length:240Display name of the person who rejected the requisition lines. -
RejectedById: integer
(int64)
Read Only:
trueValue that uniquely identifies the person who rejected the requisition lines. -
RejectedReason: string
Read Only:
trueMaximum Length:4000Reason for rejecting the requisition lines. -
Requisition: string
Read Only:
trueMaximum Length:64Number that identifies the requisition. It's used to identify the requisition by end users. -
RequisitionHeaderId: integer
(int64)
Read Only:
trueValue that uniquely identifies the requisition. -
RequisitioningBU: string
Title:
Requisitioning BUMaximum Length:240Name 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:
trueMaximum Length:30Default Value:LINES_REQUIRING_ATTENTIONValue that indicates the group of the requisition lines in the requisition. -
SoldToLegalEntity: string
Title:
Legal EntityRead Only:trueMaximum Length:240Legal entity that's liable for the corresponding purchase order amount. -
SoldToLegalEntityId: integer
(int64)
Read Only:
trueValue that uniquely identifies the legal entity that's liable for the corresponding purchase order amount. -
SourceApplicationCode: string
Maximum Length:
25Abbreviation 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 RequisitionThe Special Handling Flexfields for Purchase Requisitions resource manages details about purchase requisitions. -
SpecialHandlingType: string
Title:
Special Handling TypeMaximum Length:30Type 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:
30Abbreviation that identifies the special handling type of the requisition. -
SubmissionDate: string
(date-time)
Read Only:
trueDate and time when the requisition was submitted for approval. -
summaryAttributes: array
Summary Attributes for Purchase Requisitions
Title:
Summary Attributes for Purchase RequisitionsThe 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:
arrayTitle:
Attachments for Purchase RequisitionsThe Attachments for Purchase Requisitions resource manages attachments for a purchase requisition.
Show Source
Nested Schema : Flexfields for Purchase Requisitions
Type:
arrayTitle:
Flexfields for Purchase RequisitionsThe Flexfields for Purchase Requisitions resource manages details about purchase requisitions.
Show Source
Nested Schema : Lines
Type:
arrayTitle:
LinesThe Lines resource manages items to be requisitioned, their quantity, unit of measure, price, and deliver-to-location information.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Special Handling Flexfields for Purchase Requisition
Type:
arrayTitle:
Special Handling Flexfields for Purchase RequisitionThe 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:
arrayTitle:
Summary Attributes for Purchase RequisitionsThe 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 IdAn identifier used for tracking the uploaded files. -
AttachedDocumentId: integer
(int64)
Title:
Attached Document IdValue that uniquely identifies the attached document. -
CategoryName: string
Title:
CategoryMaximum Length:30Name of the attachment category. - ContentRepositoryFileShared: boolean
-
CreatedBy: string
Title:
Created ByRead Only:trueMaximum Length:255User who created the record. -
CreatedByUserName: string
Title:
Created By User NameRead Only:trueLogin that the user used when creating the document. -
CreationDate: string
(date-time)
Title:
Creation DateRead Only:trueDate and time when the user created the record. -
DatatypeCode: string
Title:
TypeMaximum Length:30Default Value:FILEAbbreviation that identifies the data type. -
Description: string
Title:
DescriptionMaximum Length:255Description of the attachment. -
DmDocumentId: string
Maximum Length:
255Value that uniquely identifies the document from which the attachment is created. -
DmFolderPath: string
Title:
Dm Folder PathMaximum Length:1000Path of the folder from which the attachment is created. -
DmVersionNumber: string
Maximum Length:
255Number that identifies the document version from which the attachment is created. -
DownloadInfo: string
Title:
DownloadInfoJSON object represented as a string containing information used to programmatically retrieve a file attachment. -
ErrorStatusCode: string
Title:
Error Status CodeAbbreviation that identifies the error code, if any, for the attachment. -
ErrorStatusMessage: string
Title:
Error Status MessageText of the error message, if any, for the attachment. -
ExpirationDate: string
(date-time)
Title:
Expiration DateDate when the contents of the attachment are no longer valid. -
FileContents: string
(byte)
Title:
File ContentsContents of the attached file. -
FileName: string
Title:
File NameMaximum Length:2048Name of the attached file. -
FileUrl: string
Title:
File UrlUniform resource locator of the file. -
FileWebImage: string
(byte)
Title:
File Web ImageRead Only:trueBase64-encoded image of the file displayed in .png format if the source is a convertible image. -
LastUpdateDate: string
(date-time)
Title:
Last Update DateRead Only:trueDate and time when the user most recently updated the record. -
LastUpdatedBy: string
Title:
Last Updated ByRead Only:trueMaximum Length:255User who most recently updated the record. -
LastUpdatedByUserName: string
Title:
Last Updated By UserRead Only:trueLogin that the user used when updating the document. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
PostProcessingAction: string
Title:
PostProcessingActionThe name of the action that can be performed after an attachment is uploaded. -
Title: string
Title:
TitleTitle of the attachment. -
UploadedFileContentType: string
Title:
Uploaded File Content TypeContent type of the attached file. -
UploadedFileLength: integer
Title:
File SizeSize of the attached file. -
UploadedFileName: string
Title:
Uploaded File NameName of the attached file. -
UploadedText: string
Title:
Uploaded TextContents of text file that is attached. -
Uri: string
Title:
UriMaximum Length:4000URI (Uniform Resource Identifier) of the topology manager type attachment. -
Url: string
Title:
UrlMaximum Length:4000Uniform resource locator of the web page type attachment. -
UserName: string
Title:
User NameRead Only:trueMaximum Length:255Login that the user used when creating the attachment.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : link
Type:
Show Source
object-
href: string
Title:
hyperlink referenceThe URI to the related resource. -
kind: string
Title:
kindAllowed Values:[ "collection", "item", "describe", "other" ]The kind of the related resource. -
name: string
Title:
nameThe name of the link to the related resource. -
properties: object
properties
-
rel: string
Title:
relationAllowed Values:[ "self", "lov", "parent", "canonical", "child", "enclosure", "action", "custom" ]The name of the relation to the resource instance. Example: self.
Nested Schema : properties
Type:
Show Source
object-
changeIndicator: string
Change indicator or the ETag value of the resource instance.
Nested Schema : purchaseRequisitions-DFF-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
Attribute ValueMaximum Length:30Descriptive flexfield context name for purchase requisition distributions -
__FLEX_Context_DisplayValue: string
Title:
Attribute ValueDescriptive flexfield context display value for purchase requisition distributions. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
RequisitionHeaderId: integer
(int64)
Value that uniquely identifies the requisition.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : purchaseRequisitions-lines-item-response
Type:
Show Source
object-
ActionRequired: string
Title:
MeaningRead Only:trueMaximum Length:80Action required of the requisition preparer or a requester on a requisition line. -
ActionRequiredCode: string
Read Only:
trueMaximum Length:30Abbreviation that identifies the action required of the requisition preparer or a requester on a requisition line. -
AdditionalContactEmail: string
Title:
Additional Contact EmailMaximum Length:1500Email 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:
trueTotal amount of the requested items in the currency of the buying company. -
AssignedBuyer: string
Title:
Assigned BuyerRead Only:trueMaximum Length:240Name of the person responsible for managing the purchase requisition through its life cycle. -
AssignedBuyerDisplayName: string
Title:
NameRead Only:trueMaximum Length:240Display name of the person responsible for managing the purchase requisition through its life cycle. -
AssignedBuyerEmail: string
Title:
Assigned Buyer EmailRead Only:trueMaximum Length:240Email address of the person responsible for managing the purchase requisition through its life cycle. -
AssignedBuyerId: integer
(int64)
Read Only:
trueValue that uniquely identifies the person responsible for managing the purchase requisition through its life cycle. -
attachments: array
Attachments for Lines
Title:
Attachments for LinesThe Attachments for Lines resource manages attachments for a purchase requisition line. -
BackToBackFlag: boolean
Read Only:
trueMaximum Length:1Contains 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:
trueMaximum Length:1Contains 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:
trueMaximum Length:1Contains 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:
NameRead Only:trueMaximum Length:240Display name of the person who is responsible for managing the purchase order. -
BuyerProcessingFlag: boolean
Read Only:
trueMaximum Length:1Contains 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:
trueDate when the requested items were canceled. -
CancelReason: string
Read Only:
trueMaximum Length:240Reason for canceling the requested items. -
Carrier: string
Title:
CarrierRead Only:trueMaximum Length:360Company that transports goods from one point to another by land, sea, or air. -
CarrierId: integer
(int64)
Read Only:
trueValue 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:
2400Name of the purchasing category that is used for classifying the purchase being made by using this order line. -
ConfiguredItemFlag: boolean
Read Only:
trueMaximum Length:1Default Value:falseContains 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:
30Type of rate used to determine the currency conversion rate for the purchase requisition. -
CreatedBy: string
Read Only:
trueMaximum Length:64User who created the requisition. -
CreationDate: string
(date-time)
Read Only:
trueDate and time when the purchase requisition was initiated. -
Currency: string
Title:
Currency NameMaximum Length:80Purchase requisition currency. -
CurrencyAmount: number
Total amount of the requested item in the currency of the supplier.
-
CurrencyCode: string
Maximum Length:
15Abbreviation that identifies the purchase requisition currency. -
DeliverToAddress: string
Title:
Deliver-to AddressRead Only:truePhysical address of the final location where the buying company should deliver the goods previously received from a supplier. -
DeliverToCustomer: string
Title:
Deliver-to CustomerRead Only:trueMaximum Length:360Name of the third party to whom the materials need to be delivered. -
DeliverToCustomerId: integer
(int64)
Read Only:
trueValue 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 LocationMaximum Length:60Name 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 AddressRead Only:truePhysical 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:
OrganizationRead Only:trueMaximum Length:240Name of the inventory organization that receives the item. -
DestinationOrganizationCode: string
Title:
Deliver-to OrganizationMaximum Length:18Abbreviation 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:
10Name of the subinventory that identifies where to deliver the requested item. -
DestinationType: string
Title:
Destination TypeMaximum Length:80Type 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:
25Abbreviation 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 LinesThe Flexfields for Purchase Requisition Lines resource manages details about purchase requisition lines. -
DisableAutosourceFlag: boolean
Maximum Length:
1Default Value:falseContains 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:
DistributionsThe Distributions resource manages purchasing details such as details about accounting or the project. -
EPPLineId: integer
(int64)
Value that uniquely identifies the external purchase price line.
-
FormattedDeliverToAddress: string
Title:
AddressRead Only:trueFormatted physical address of the final location where the buying company should deliver the goods previously received from a supplier. -
FundsStatus: string
Title:
Funds StatusRead Only:trueMaximum Length:80Status of the funds reservation request at the line level. -
FundsStatusCode: string
Read Only:
trueMaximum Length:30Abbreviation that identifies the status of funds check or the validation result of funds reservation at the line level. -
HazardClass: string
Title:
Hazard ClassRead Only:trueMaximum Length:40Value that uniquely identifies the hazard class. -
HazardClassCode: string
Title:
CodeRead Only:trueMaximum Length:30Abbreviation 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 LinesThe 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:
1Contains 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:
300Abbreviation that uniquely identifies the item being purchased. -
ItemDescription: string
Maximum Length:
240Description of the goods or services being purchased. -
ItemId: integer
(int64)
Value that uniquely identifies the item being purchased.
-
ItemRevision: string
Maximum Length:
18Number that identifies the revision of the item. -
ItemUserOverrideFlag: boolean
Maximum Length:
1This attribute isn't currently used. -
LastApprovalDate: string
(date-time)
Read Only:
trueDate when the requisition lines was last approved. -
LastSubmittedDate: string
(date-time)
Read Only:
trueDate when the requisition line was last submitted for approval. -
LastUpdateDate: string
(date-time)
Read Only:
trueDate when the record was last updated. -
LastUpdatedBy: string
Read Only:
trueMaximum Length:64User who most recently updated the record. -
LifecycleSecondaryStatus: string
Read Only:
trueMaximum Length:100Code 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 StatusRead Only:trueMaximum Length:80Status indicating the post approval progress of the requisition line. -
LifecycleStatusCode: string
Read Only:
trueMaximum Length:30Abbreviation that identifies the requisition line lifecycle status. -
LineImageURL: string
Title:
Image URLRead Only:trueURL (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:
trueMaximum Length:25Abbreviation that identifies the purchase requisition line status in the line life cycle. -
LineStatusDisplayValue: string
Title:
StatusRead Only:trueMaximum Length:80Status of the requisition line. -
LineTypeCode: string
Title:
Line Type CodeMaximum Length:30Abbreviation 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:
trueMaximum Length:25Abbreviation that identifies the type of agreement line. Valid values are QUANTITY or FIXED PRICE. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
ManufacturerName: string
Maximum Length:
240Name of the company that manufactures the item being purchased. -
ManufacturerPartNumber: string
Maximum Length:
700Number that uniquely identifies the item as provided by the manufacturer. -
MarketplaceItemId: string
Maximum Length:
30Value that uniquely identifies the Oracle Healthcare Marketplace Item. -
ModeOfTransport: string
Title:
Mode of TransportRead Only:trueMaximum Length:80Mode of transportation used to ship the product, such as truck, air, or boat. -
ModeOfTransportCode: string
Read Only:
trueMaximum Length:30Abbreviation that identifies the mode of transport. -
ModifiedByBuyer: string
Title:
Modified by BuyerRead Only:trueMaximum Length:240Buyer 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:
trueValue 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:
1Contains 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:
trueMaximum Length:40Value that identifies the negotiation document associated with the requisition line. -
NegotiationHeaderId: integer
(int64)
Read Only:
trueValue that uniquely identifies the negotiation document associated with the requisition line. -
NegotiationLineNumber: number
Read Only:
trueNumber that identifies the negotiation line associated with the requisition line. -
NegotiationRequiredFlag: boolean
Maximum Length:
1Contains 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:
1Contains 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 BuyerMaximum Length:1000Note to the buyer on the purchase requisition. -
NoteToReceiver: string
Title:
Note to ReceiverMaximum Length:1000Note to the receiver on the purchase requisition. -
NoteToSupplier: string
Title:
Note to SupplierMaximum Length:1000Note to the supplier on the purchase requisition. -
OneTimeLocationFlag: boolean
Read Only:
trueMaximum Length:1Default Value:falseContains 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:
trueMaximum Length:1Contains 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:
trueDate when the requisition line was first approved. -
OriginalSubmittedDate: string
(date-time)
Read Only:
trueDate when the requisition line was first submitted for approval. -
POAutomationFailedReason: string
Read Only:
trueMaximum Length:240Functional reason for the failure of automatic processing of requisition line to purchase order. -
POAutomationFailedReasonCode: string
Read Only:
trueMaximum Length:30Abbreviation that indicates the reason for the failure of automatic processing of requisition line to purchase order. -
POBuyerId: integer
(int64)
Read Only:
trueValue that uniquely identifies the buyer who is responsible for managing the purchase order. -
POCancelReason: string
Title:
Cancellation ReasonRead Only:trueMaximum Length:240Reason provided by the employee for cancelling the purchase order. -
POHeaderId: integer
(int64)
Read Only:
trueValue that uniquely identifies the purchase order. -
POHoldReason: string
Read Only:
trueThe reason provided by the buyer while placing the purchase order on hold. -
POLineId: integer
(int64)
Read Only:
trueValue 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 BURead Only:trueMaximum Length:240Business unit responsible for managing the procurement function. -
ProcurementBUId: integer
(int64)
Read Only:
trueValue 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:
OrderRead Only:trueMaximum Length:30Number 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:
trueDate when the buying company requested the ordered item to be shipped. -
Requester: string
Title:
RequesterRead Only:trueMaximum Length:240Person for whom goods or services are being ordered. -
RequesterDisplayName: string
Title:
NameRead Only:trueMaximum Length:240Display name of the person for whom goods or services are being ordered. -
RequesterEmail: string
Title:
Requester EmailMaximum Length:240Email 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:
trueValue that uniquely identifies the requisition header. -
RequisitionLineGroup: string
Read Only:
trueMaximum Length:30Value that indicates the group of the requisition line. -
RequisitionLineId: integer
(int64)
Read Only:
trueValue that uniquely identifies the requisition line. -
RequisitionLineInPool: string
Read Only:
trueMaximum Length:1Value 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:
trueUniquely identifies the request ID of the Generate Orders process that processed the requisition line. -
RequisitionLineSource: string
Maximum Length:
25Default Value:REST_INTEGRATIONValue that indicates the source of the line. This attribute isn't currently used. -
ResponseLineNumber: number
Read Only:
trueNumber that identifies the line in a response submitted by supplier for a negotiation. -
ResponseNumber: number
Read Only:
trueNumber that identifies the response submitted by supplier for a negotiation document. -
ReturnedByBuyerDisplayName: string
Title:
Returned by BuyerRead Only:trueMaximum Length:240Name of the buyer who returned the requisition line. -
ReturnedByBuyerId: integer
(int64)
Read Only:
trueValue that uniquely identifies the buyer who returned the requisition line. -
ReturnReason: string
Read Only:
trueMaximum Length:4000Reason provided by the buyer while returning the requisition line. -
SalesOrder: string
Read Only:
trueMaximum Length:50Number that uniquely identifies a backing customer sales order number. -
SalesOrderLineNumber: string
Read Only:
trueMaximum Length:50Number that uniquely identifies the sales order line for a given customer sales order. -
SalesOrderScheduleNumber: string
Read Only:
trueMaximum Length:50Number 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 NameRead Only:trueMaximum Length:25Secondary unit of measure to use for the quantity of a dual unit of measure controlled item. -
SecondaryUOMCode: string
Read Only:
trueMaximum Length:3Abbreviation that identifies the alternative unit of measure that is allowed to quantify a dual unit of measure controlled item. -
ServiceLevel: string
Title:
Service LevelRead Only:trueMaximum Length:80Transportation priority that determines how quickly to transport goods. -
ServiceLevelCode: string
Read Only:
trueMaximum Length:30Abbreviation that identifies the service level for the shipping method. -
ShipToCustomer: string
Title:
Ship-to CustomerRead Only:trueMaximum Length:360Name of the party who will receive the materials that are shipped. -
ShipToCustomerId: integer
(int64)
Read Only:
trueValue 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:
250Name of the smart form on the requisition line. This attribute isn't currently used. -
SourceAgreement: string
Title:
AgreementMaximum Length:30Number 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 LineNumber that identifies the line of the source agreement referenced by the purchase requisition line. -
SourceAgreementType: string
Title:
Agreement TypeRead Only:trueMaximum Length:80Value that indicates whether the referenced agreement is a blanket purchase agreement or a contract purchase agreement. -
SourceAgreementTypeCode: string
Maximum Length:
25Abbreviation that identifies the source agreement type. Values include CONTRACT and BLANKET. -
SourceOrganization: string
Title:
Source OrganizationRead Only:trueMaximum Length:240Name of the inventory organization that will supply the item to the destination inventory organization in an internal material transfer operation. -
SourceOrganizationCode: string
Maximum Length:
18Abbreviation 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:
10Subinventory 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 TypeMaximum Length:80Value that indicates the type of source the requisition line is sourced from. For example: Inventory, Supplier. -
SourceTypeCode: string
Maximum Length:
10Default Value:EXTERNALAbbreviation 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 LinesThe Special Handling Flexfields for Purchase Requisitions Lines resource manages details about purchase requisition lines. -
SuggestedBuyer: string
Title:
Suggested BuyerRead Only:trueMaximum Length:240Name of the buyer suggested for managing the purchase requisition line through its life cycle. -
SuggestedBuyerEmail: string
Title:
Suggested Buyer EmailMaximum Length:240Email address of the suggested buyer. -
SuggestedBuyerId: integer
(int64)
Value that uniquely identifies the suggested buyer.
-
SuggestedSupplier: string
Maximum Length:
360Name of the new supplier suggested on the requisition line for fulfillment of the ordered goods and services. -
SuggestedSupplierContact: string
Maximum Length:
80Name of the person representing the new supplier involved in supporting the customer relationship. -
SuggestedSupplierContactEmail: string
Maximum Length:
1000Email address of the person representing the new supplier. -
SuggestedSupplierContactFax: string
Maximum Length:
30Fax number of the person representing the new supplier. -
SuggestedSupplierContactPhone: string
Maximum Length:
30Phone number of the person representing the new supplier. -
SuggestedSupplierSite: string
Maximum Length:
240Value that uniquely identifies the new supplier. -
Supplier: string
Maximum Length:
360Name of the supplier tasked with fulfillment of the ordered goods and services. -
SupplierContact: string
Maximum Length:
4000Name of the person representing the supplier with regards to communication with the buying company. -
SupplierContactEmail: string
Read Only:
trueMaximum Length:2000Email address of the supplier contact. -
SupplierContactFax: string
Read Only:
trueMaximum Length:255Fax number if the supplier contact. -
SupplierContactId: integer
(int64)
Value that uniquely identifies the supplier contact.
-
SupplierContactPhone: string
Read Only:
trueMaximum Length:255Phone number of the supplier contact. -
SupplierId: integer
(int64)
Value that uniquely identifies the supplier.
-
SupplierItemAuxiliaryId: string
Maximum Length:
150Auxiliary part number that uniquely identifies the supplier item. -
SupplierItemNumber: string
Title:
Supplier ItemMaximum Length:300Number that identifies the supplier or code for the goods or services ordered on the purchase requisition line. -
SupplierOnPurchaseOrder: string
Read Only:
trueMaximum Length:360Name of the supplier who fulfills the ordered item. -
SupplierSite: string
Title:
Supplier SiteMaximum Length:240Name 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 OrderRead Only:trueMaximum Length:50Number that identifies the transfer order document associated with the requisition line. -
TransferOrderHeaderId: integer
(int64)
Read Only:
trueValue that uniquely identifies the transfer order document associated with the requisition line. -
TransferOrderLineId: integer
(int64)
Read Only:
trueValue 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 NumberRead Only:trueMaximum Length:20United 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:
700Abbreviation that identifies the United Nations Standard Products and Services Code (UNSPSC) for taxonomy of products and services. -
UOM: string
Title:
UOM NameMaximum Length:25Unit of measure of the item quantity. -
UOMCode: string
Maximum Length:
3Abbreviation that identifies the unit of measure. -
UrgentFlag: boolean
Maximum Length:
1Contains 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:
trueMaximum Length:120Display number that uniquely identifies a work order in a plant. -
WorkOrderId: integer
(int64)
Read Only:
trueValue that uniquely identifies the work order in a plant. -
WorkOrderOperationId: integer
(int64)
Read Only:
trueValue that uniquely identifies an operation of a work order. -
WorkOrderOperationSequence: number
Read Only:
trueSequence to use when performing the work order operations. -
WorkOrderProduct: string
Read Only:
trueMaximum Length:300Value that identifies the finished goods of the contract manufacturing work order. -
WorkOrderSubType: string
Read Only:
trueMaximum Length:30Display name used to identify the subtype of the manufacturing work order.
Nested Schema : Attachments for Lines
Type:
arrayTitle:
Attachments for LinesThe Attachments for Lines resource manages attachments for a purchase requisition line.
Show Source
Nested Schema : Flexfields for Purchase Requisition Lines
Type:
arrayTitle:
Flexfields for Purchase Requisition LinesThe Flexfields for Purchase Requisition Lines resource manages details about purchase requisition lines.
Show Source
Nested Schema : Distributions
Type:
arrayTitle:
DistributionsThe Distributions resource manages purchasing details such as details about accounting or the project.
Show Source
Nested Schema : Information Templates for Purchase Requisition Lines
Type:
arrayTitle:
Information Templates for Purchase Requisition LinesThe 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:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Special Handling Flexfields for Purchase Requisition Lines
Type:
arrayTitle:
Special Handling Flexfields for Purchase Requisition LinesThe 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 IdAn identifier used for tracking the uploaded files. -
AttachedDocumentId: integer
(int64)
Title:
Attached Document IdValue that uniquely identifies the attached document. -
CategoryName: string
Title:
CategoryMaximum Length:30Name of the attachment category. - ContentRepositoryFileShared: boolean
-
CreatedBy: string
Title:
Created ByRead Only:trueMaximum Length:255User who created the record. -
CreatedByUserName: string
Title:
Created By User NameRead Only:trueLogin that the user used when creating the document. -
CreationDate: string
(date-time)
Title:
Creation DateRead Only:trueDate and time when the user created the record. -
DatatypeCode: string
Title:
TypeMaximum Length:30Default Value:FILEAbbreviation that identifies the data type. -
Description: string
Title:
DescriptionMaximum Length:255Description of the attachment. -
DmDocumentId: string
Maximum Length:
255Value that uniquely identifies the document from which the attachment is created. -
DmFolderPath: string
Title:
Dm Folder PathMaximum Length:1000Path of the folder from which the attachment is created. -
DmVersionNumber: string
Maximum Length:
255Number that identifies the document version from which the attachment is created. -
DownloadInfo: string
Title:
DownloadInfoJSON object represented as a string containing information used to programmatically retrieve a file attachment. -
ErrorStatusCode: string
Title:
Error Status CodeAbbreviation that identifies the error code, if any, for the attachment. -
ErrorStatusMessage: string
Title:
Error Status MessageText of the error message, if any, for the attachment. -
ExpirationDate: string
(date-time)
Title:
Expiration DateDate when the contents of the attachment are no longer valid. -
FileContents: string
(byte)
Title:
File ContentsContents of the attached file. -
FileName: string
Title:
File NameMaximum Length:2048Name of the attached file. -
FileUrl: string
Title:
File UrlUniform resource locator of the file. -
FileWebImage: string
(byte)
Title:
File Web ImageRead Only:trueBase64-encoded image of the file displayed in .png format if the source is a convertible image. -
LastUpdateDate: string
(date-time)
Title:
Last Update DateRead Only:trueDate and time when the user most recently updated the record. -
LastUpdatedBy: string
Title:
Last Updated ByRead Only:trueMaximum Length:255User who most recently updated the record. -
LastUpdatedByUserName: string
Title:
Last Updated By UserRead Only:trueLogin that the user used when updating the document. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
PostProcessingAction: string
Title:
PostProcessingActionThe name of the action that can be performed after an attachment is uploaded. -
Title: string
Title:
TitleTitle of the attachment. -
UploadedFileContentType: string
Title:
Uploaded File Content TypeContent type of the attached file. -
UploadedFileLength: integer
Title:
File SizeSize of the attached file. -
UploadedFileName: string
Title:
Uploaded File NameName of the attached file. -
UploadedText: string
Title:
Uploaded TextContents of text file that is attached. -
Uri: string
Title:
UriMaximum Length:4000URI (Uniform Resource Identifier) of the topology manager type attachment. -
Url: string
Title:
UrlMaximum Length:4000Uniform resource locator of the web page type attachment. -
UserName: string
Title:
User NameRead Only:trueMaximum Length:255Login that the user used when creating the attachment.
Nested Schema : Links
Type:
arrayTitle:
LinksThe 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 ValueMaximum Length:30Descriptive flexfield context name for purchase requisition distributions -
__FLEX_Context_DisplayValue: string
Title:
Attribute ValueDescriptive flexfield context display value for purchase requisition distributions. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
RequisitionLineId: integer
(int64)
Value that uniquely identifies the requisition line.
Nested Schema : Links
Type:
arrayTitle:
LinksThe 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 DateDate from which the budget is consumed. This date is used to determine the budget period. -
ChargeAccount: string
Maximum Length:
255Account 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:
trueValue 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:
trueTax 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:
trueTax 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 DistributionsThe Flexfields for Purchase Requisition Distributions resource manages details about purchase requisition distributions. -
DistributionNumber: number
Title:
DistributionNumberNumber that uniquely identifies the distribution associated with a purchase requisition line. -
FundsStatus: string
Title:
Funds StatusRead Only:trueMaximum Length:80Status of the funds reservation request at the distribution level. -
FundsStatusCode: string
Read Only:
trueMaximum Length:30Abbreviation that identifies the status of funds check or the validation result of funds reservation at the distribution level. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
projectDFF: array
Project Costing Flexfields for Purchase Requisition Distributions
Title:
Project Costing Flexfields for Purchase Requisition DistributionsThe Project Costing Flexfields for Purchase Requisition Distributions resource manages details about purchase requisition distributions. -
Quantity: number
Title:
QuantityQuantity of goods being purchased. -
RequisitionDistributionId: integer
(int64)
Read Only:
trueValue that uniquely identifies the purchasing requisition distribution. -
RequisitionLineId: integer
(int64)
Read Only:
trueValue that uniquely identifies the requisition line. -
UserAccountOverrideFlag: boolean
Read Only:
trueContains 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:
arrayTitle:
Flexfields for Purchase Requisition DistributionsThe Flexfields for Purchase Requisition Distributions resource manages details about purchase requisition distributions.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Project Costing Flexfields for Purchase Requisition Distributions
Type:
arrayTitle:
Project Costing Flexfields for Purchase Requisition DistributionsThe 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 ValueMaximum Length:30Descriptive flexfield context name for purchase requisition distributions -
__FLEX_Context_DisplayValue: string
Title:
Attribute ValueDescriptive flexfield context display value for purchase requisition distributions. -
DistributionId: integer
(int64)
Value that uniquely identifies the requisition distribution.
-
links: array
Links
Title:
LinksThe link relations associated with the resource instance.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Discriminator: __FLEX_Context
Type:
objectDiscriminator: __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 ValueMaximum Length:40Default Value:AP_Distribution_SetsProject costing descriptive flexfield context name for purchase requisition distributions. -
__FLEX_Context_DisplayValue: string
Title:
Context ValueProject costing descriptive flexfield context display value for purchase requisition distributions. -
_BILLABLE_FLAG: string
Title:
BillableMaximum Length:1 -
_BILLABLE_FLAG_Display: string
Title:
Billable -
_CAPITALIZABLE_FLAG: string
Title:
CapitalizableMaximum 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 SourceMaximum 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:
LinksThe 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 ValueMaximum Length:40Default Value:AP_Invoice_DistributionProject costing descriptive flexfield context name for purchase requisition distributions. -
__FLEX_Context_DisplayValue: string
Title:
Context ValueProject costing descriptive flexfield context display value for purchase requisition distributions. -
_BILLABLE_FLAG: string
Title:
BillableMaximum Length:1 -
_BILLABLE_FLAG_Display: string
Title:
Billable -
_CAPITALIZABLE_FLAG: string
Title:
CapitalizableMaximum 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 SourceMaximum 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:
LinksThe 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 ValueMaximum Length:40Default Value:AP_Invoice_LineProject costing descriptive flexfield context name for purchase requisition distributions. -
__FLEX_Context_DisplayValue: string
Title:
Context ValueProject costing descriptive flexfield context display value for purchase requisition distributions. -
_BILLABLE_FLAG: string
Title:
BillableMaximum Length:1 -
_BILLABLE_FLAG_Display: string
Title:
Billable -
_CAPITALIZABLE_FLAG: string
Title:
CapitalizableMaximum 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 SourceMaximum 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:
LinksThe 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 ValueMaximum Length:40Default Value:EXM_Expense_ReportProject costing descriptive flexfield context name for purchase requisition distributions. -
__FLEX_Context_DisplayValue: string
Title:
Context ValueProject costing descriptive flexfield context display value for purchase requisition distributions. -
_BILLABLE_FLAG: string
Title:
BillableMaximum Length:1 -
_BILLABLE_FLAG_Display: string
Title:
Billable -
_CAPITALIZABLE_FLAG: string
Title:
CapitalizableMaximum 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 SourceMaximum 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:
LinksThe 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 ValueMaximum Length:40Default Value:EXM_Expense_Report_LineProject costing descriptive flexfield context name for purchase requisition distributions. -
__FLEX_Context_DisplayValue: string
Title:
Context ValueProject costing descriptive flexfield context display value for purchase requisition distributions. -
_BILLABLE_FLAG: string
Title:
BillableMaximum Length:1 -
_BILLABLE_FLAG_Display: string
Title:
Billable -
_CAPITALIZABLE_FLAG: string
Title:
CapitalizableMaximum 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 SourceMaximum 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:
LinksThe 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 ValueMaximum Length:40Default Value:INV_Misc_TransactionsProject costing descriptive flexfield context name for purchase requisition distributions. -
__FLEX_Context_DisplayValue: string
Title:
Context ValueProject costing descriptive flexfield context display value for purchase requisition distributions. -
_BILLABLE_FLAG: string
Title:
BillableMaximum Length:1 -
_BILLABLE_FLAG_Display: string
Title:
Billable -
_CAPITALIZABLE_FLAG: string
Title:
CapitalizableMaximum 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 SourceMaximum 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:
LinksThe 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 ValueMaximum Length:40Default Value:OM_Sales_OrderProject costing descriptive flexfield context name for purchase requisition distributions. -
__FLEX_Context_DisplayValue: string
Title:
Context ValueProject costing descriptive flexfield context display value for purchase requisition distributions. -
billableFlag: string
Title:
BillableMaximum Length:1 -
billableFlag_Display: string
Title:
Billable -
capitalizableFlag: string
Title:
CapitalizableMaximum 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:
LinksThe 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 SourceMaximum 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 ValueMaximum Length:40Default Value:PJC_AllProject costing descriptive flexfield context name for purchase requisition distributions. -
__FLEX_Context_DisplayValue: string
Title:
Context ValueProject costing descriptive flexfield context display value for purchase requisition distributions. -
_BILLABLE_FLAG: string
Title:
BillableMaximum Length:1 -
_BILLABLE_FLAG_DisplayValue: string
Title:
Billable -
_CAPITALIZABLE_FLAG: string
Title:
CapitalizableMaximum 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 SourceMaximum 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:
LinksThe 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 ValueMaximum Length:40Default Value:PJC_Expenditure_BatchProject costing descriptive flexfield context name for purchase requisition distributions. -
__FLEX_Context_DisplayValue: string
Title:
Context ValueProject costing descriptive flexfield context display value for purchase requisition distributions. -
_BILLABLE_FLAG: string
Title:
BillableMaximum Length:1 -
_BILLABLE_FLAG_Display: string
Title:
Billable -
_CAPITALIZABLE_FLAG: string
Title:
CapitalizableMaximum 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 SourceMaximum 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:
LinksThe 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 ValueMaximum Length:40Default Value:POR_RequisitionProject costing descriptive flexfield context name for purchase requisition distributions. -
__FLEX_Context_DisplayValue: string
Title:
Context ValueProject costing descriptive flexfield context display value for purchase requisition distributions. -
_BILLABLE_FLAG: string
Title:
BillableMaximum Length:1 -
_BILLABLE_FLAG_Display: string
Title:
Billable -
_CAPITALIZABLE_FLAG: string
Title:
CapitalizableMaximum 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 SourceMaximum 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:
LinksThe 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 ValueMaximum Length:40Default Value:POR_User_PreferencesProject costing descriptive flexfield context name for purchase requisition distributions. -
__FLEX_Context_DisplayValue: string
Title:
Context ValueProject 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 SourceMaximum 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:
LinksThe 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 ValueMaximum Length:40Default Value:PO_Purchase_OrderProject costing descriptive flexfield context name for purchase requisition distributions. -
__FLEX_Context_DisplayValue: string
Title:
Context ValueProject costing descriptive flexfield context display value for purchase requisition distributions. -
_BILLABLE_FLAG: string
Title:
BillableMaximum Length:1 -
_BILLABLE_FLAG_Display: string
Title:
Billable -
_CAPITALIZABLE_FLAG: string
Title:
CapitalizableMaximum 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 SourceMaximum 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:
LinksThe 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 ValueMaximum Length:40Default Value:PO_Purchase_Order_LineProject costing descriptive flexfield context name for purchase requisition distributions. -
__FLEX_Context_DisplayValue: string
Title:
Context ValueProject costing descriptive flexfield context display value for purchase requisition distributions. -
_BILLABLE_FLAG: string
Title:
BillableMaximum Length:1 -
_BILLABLE_FLAG_Display: string
Title:
Billable -
_CAPITALIZABLE_FLAG: string
Title:
CapitalizableMaximum 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 SourceMaximum 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:
LinksThe 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 ValueMaximum Length:40Default Value:PO_Purchase_Order_ScheduleProject costing descriptive flexfield context name for purchase requisition distributions. -
__FLEX_Context_DisplayValue: string
Title:
Context ValueProject costing descriptive flexfield context display value for purchase requisition distributions. -
_BILLABLE_FLAG: string
Title:
BillableMaximum Length:1 -
_BILLABLE_FLAG_Display: string
Title:
Billable -
_CAPITALIZABLE_FLAG: string
Title:
CapitalizableMaximum 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 SourceMaximum 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:
LinksThe link relations associated with the resource instance.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe 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 LinesThe Information Template Flexfields for Purchase Requisitions Lines resource manages details about information templates descriptive flexfields. -
InformationTemplateDisplayName: string
Read Only:
trueMaximum Length:250Display name of the information template. -
InformationTemplateId: integer
(int64)
Value that uniquely identifies the information template.
-
InformationTemplateValuesId: integer
(int64)
Read Only:
trueValue that uniquely identifies the information template segment values. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
RequisitionLineId: integer
(int64)
Read Only:
trueValue that uniquely identifies the requisition line.
Nested Schema : Information Template Flexfields for Purchase Requisition Lines
Type:
arrayTitle:
Information Template Flexfields for Purchase Requisition LinesThe Information Template Flexfields for Purchase Requisitions Lines resource manages details about information templates descriptive flexfields.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : purchaseRequisitions-lines-informationTemplates-informationTemplateDFF-item-response
Type:
Show Source
object-
__FLEX_Context: string
Title:
Context ValueMaximum Length:30Descriptive flexfield context name for purchase requisition information template. -
__FLEX_Context_DisplayValue: string
Title:
Context ValueDescriptive flexfield context display value for purchase requisition information template. -
InfoTemplateValuesId: integer
(int64)
Value that uniquely identifies the information template segment values.
-
links: array
Links
Title:
LinksThe link relations associated with the resource instance.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Discriminator: __FLEX_Context
Type:
objectDiscriminator: __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 PromptMaximum Length:30Default Value:ORA_PO_BILL_ONLY_LINESSpecial handling descriptive flexfield context name for purchase requisition lines. -
__FLEX_Context_DisplayValue: string
Title:
Context PromptSpecial handling descriptive flexfield context display value for purchase requisition lines. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
lot: string
Title:
LotMaximum Length:150 -
RequisitionLineId: integer
(int64)
Value that uniquely identifies the requisition line.
-
serialNumber: string
Title:
Serial NumberMaximum Length:150
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Discriminator: __FLEX_Context
Type:
objectDiscriminator: __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 PromptMaximum Length:30Default Value:ORA_PO_BILL_ONLY_HEADERSSpecial handling descriptive flexfield context name for purchase requisition lines. -
__FLEX_Context_DisplayValue: string
Title:
Context PromptSpecial handling descriptive flexfield context display value for purchase requisition lines. -
dateOfService: string
(date)
Title:
Date of Service -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
physicianName: string
Title:
Physician NameMaximum Length:150 -
referenceNumber: string
Title:
Reference NumberMaximum Length:150 -
RequisitionHeaderId: integer
(int64)
Value that uniquely identifies the requisition.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : purchaseRequisitions-summaryAttributes-item-response
Type:
Show Source
object-
AccountUserOverrideFlag: boolean
Maximum Length:
1Contains 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:
255Name 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 AccountMaximum Length:255Account 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:
1Contains 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:
1Contains 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 LocationMaximum Length:255Abbreviation 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 AddressMaximum Length:255Physical 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:
1Contains 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:
255Value 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:
1Contains 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:
1Contains 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:
LinksThe 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:
25Contains 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:
240Name of the project, which is displayed on the requisition header. -
ProjectNumber: string
Maximum Length:
25Number of the project, which is displayed on the requisition header. -
ProjectsInformationAcrossLines: string
Maximum Length:
25Contains 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:
255Number 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 DateDate when the buying company requested the ordered item or service to be delivered. -
Requester: string
Maximum Length:
240Display 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 AmountSum total of RequisitionTotalAmount and RequisitionNonRecoverableTaxAmount expressed in the functional currency. -
RequisitionHeaderId: integer
Value that uniquely identifies the requisition.
-
RequisitionNonRecoverableTaxAmount: number
Title:
Nonrecoverable TaxSum total of nonrecoverable tax amounts across all requisition lines expressed in the functional currency. -
RequisitionTotalAmount: number
Title:
Requisition AmountSum total of distribution amounts across all requisition lines expressed in the functional currency. -
SameAccountUserOverrideFlag: boolean
Maximum Length:
1Contains 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:
1Contains 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:
1Contains 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:
1Contains 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:
1Contains 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:
1Contains 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:
1Contains 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:
1Contains 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:
240Name of the project task, which is displayed on the requisition header. -
TaskNumber: string
Maximum Length:
240Number 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:
255Number 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:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Links
- initiateApproverCheckout
-
Initiates approver checkout flow when an approver chooses to edit a requisition from a requisition approval notification. The approver checkout flow ends when the approver submits the requisition after completing the changes.
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"
}
]
}