Get all project asset lines associated with this project
get
/fscmRestApi/resources/11.13.18.05/projectAssetLines
Request
Query Parameters
-
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- PrimaryKey Finds a project asset line using the project asset line identifier as a primary key.
Finder Variables- ProjectAssetLineId; integer; Finds a project asset line using the project asset line identifier as a primary key.
- findAssetLinesByProject Finds all project asset lines associated with a project.
Finder Variables- ProjectName; string; Finds all project asset lines associated with a project using the bind value of the project name.
- ProjectNumber; string; Finds all project asset lines associated with a project using the bind value of the project number.
- findAssetLinesByProjectAndAsset Finds all project asset lines that are associated with a project and an asset.
Finder Variables- ProjectAssetId; string; Finds all project asset lines associated with a project and an asset using the bind value of the asset identifier.
- ProjectName; string; Finds all project asset lines associated with a project and an asset using the bind value of the project name.
- ProjectNumber; string; Finds all project asset lines associated with a project and an asset using the bind value of the project number.
- findAssetLinesPendingTieback Finds all project asset lines that are associated with a project and which haven't been tied back.
Finder Variables- ProjectName; string; Finds all project asset lines that are associated with a project and which haven't been tied back using the bind value of the project name.
- ProjectNumber; string; Finds all project asset lines that are associated with a project and which haven't been tied back using the bind value of the project number.
- findAssetLinesPendingTransfer Finds all pending or rejected project asset lines associated with a project.
Finder Variables- ProjectName; string; Finds all pending or rejected project asset lines associated with a project using the bind value of the project name.
- ProjectNumber; string; Finds all pending or rejected project asset lines associated with a project using the bind value of the project number.
- findUnassignedLinesByProject Finds all project asset lines that are associated with a project and which haven't been assigned to a project asset.
Finder Variables- ProjectName; string; Finds all project asset lines that are associated with a project and which haven't been assigned to a project asset using the bind value of the project name.
- ProjectNumber; string; Finds all project asset lines that are associated with a project and which haven't been assigned to a project asset using the bind value of the project number.
- PrimaryKey Finds a project asset line using the project asset line identifier as a primary key.
-
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:- AmortizeFlag; boolean; Indicates whether cost adjustments should be amortized in Oracle Assets. The two options are Y and N. The default value is N.
- ApDistributionLineNumber; integer; The unique number of a supplier invoice distribution line.
- AssetCategoryCombination; string; Segment values for asset categories, concatenated using a delimiter.
- AssetCategoryId; integer; Identifier of the asset category to which the asset is assigned.
- AssetLineType; string; Classifies project asset lines as Capital or Retirement.
- AssetLineTypeCode; string; Asset line classification code, where C stands for Capital and R for Retirement.
- BusinessUnitName; string; Name of the business unit associated with the project to which the project asset line has been assigned.
- CIPAccountCombination; string; The general ledger account to which a construction-in-progress cost is charged.
- CIPIdentifier; integer; The identifier of the general ledger account to which a construction-in-progress cost is charged.
- CapitalEventId; integer; Identifier of the capital event associated with the asset of the project.
- CurrentAssetCost; number; The project asset line's current cost. Split lines have a current cost that's greater or less than the original cost, but never equal to it.
- DepreciationExpenseAccountCombination; string; The depreciation expense account of the asset associated with the asset line. You may enter either this attribute, the depreciation expense account, or both.
- DepreciationExpenseIdentifier; integer; Identifier of the depreciation expense account of the asset associated with the asset line. You may enter either this attribute, the depreciation expense account, or both.
- Description; string; Description of the project asset line, derived from the CIP grouping method.
- FaPeriodName; string; Asset book depreciation calendar period name to which the asset cost was posted.
- InvoiceDate; string; The date on the supplier invoice. This value can either be provided while creating an invoice, or populated by default to the system date.
- InvoiceDistributionId; integer; The unique number of a supplier invoice distribution line.
- InvoiceId; integer; The identifier of the supplier invoice.
- InvoiceLineNumber; integer; A line number on a supplier invoice.
- InvoiceNumber; string; Identifies the number of the Payables invoice that was imported as an expenditure item.
- NewMasterFlag; boolean; The flag used to override a project asset line's asset category and description.
- OrgId; integer; The identifier of the business unit associated with a project asset line.
- OriginalAssetCost; number; The original asset cost on the project asset line before it was split.
- OriginalAssetId; integer; The original asset identifier on the project asset line before it was split.
- PONumber; string; The purchase order number entered by the user from Purchasing through Accounts Payable.
- POVendorId; integer; Supplier identifier received from Purchasing through Accounts Payable.
- PayablesBatchName; string; The unique name of the invoice group to which you can assign reporting and payment invoices.
- ProjectAssetId; integer; The identifier of the asset assigned to the project asset line. Its value is 0 on unassigned lines.
- ProjectAssetLineDetailId; integer; The identifier of the asset line detail linking this project asset line to cost distribution lines.
- ProjectAssetLineId; integer; The identifier of the project asset line.
- ProjectId; integer; The identifier of the project to which the CIP cost was charged.
- ProjectName; string; The name of the project to which the CIP cost was charged.
- ProjectNumber; string; The number of the project to which the CIP cost was charged.
- RetAdjustmentTransactionId; integer; The transaction identifier of the group retirement adjustment transaction.
- RetirementCostType; string; Retirement cost classification of the project asset line. The two values available are Cost of Removal and Proceeds of Sale.
- RetirementCostTypeCode; string; Retirement cost classification code of the project asset line. The two values available are COR and POS.
- ReversedFromProjAssetLineId; integer; The identifier of the project asset line that was reversed.
- ReversedProjAssetLineId; integer; The identifier of the asset line that's reversed by this project asset line.
- TaskId; integer; The identifier of the task against which the CIP cost is charged.
- TaskName; string; The name of the task against which the CIP cost is charged.
- TaskNumber; string; The number of the task against which the CIP cost is charged.
- TransferRejectionReason; string; The reason the line was rejected by the Interface Assets program.
- TransferRejectionReasonCode; string; The error code of the reason why the project asset line was rejected.
- TransferStatus; string; The asset line status that appears when cost information is transferred to Oracle Fixed Assets. The available values are Pending, Rejected, and Transferred.
- TransferStatusCode; string; Transfer status code of the project asset line. This code indicates whether an asset line was successfully moved to Fixed Assets. Possible values are P for pending, R for rejected, and T for transferred.
- TransferStatusCodeSource; string; The name of the source that performed the update to the asset line transfer status from Transferred to Pending. The available values are REST and FBDI.
- UpdationSource; string; The name of the source that performed the update to the asset line. The available values are REST and FBDI.
- VendorNumber; string; The supplier number entered by the user from Purchasing through Payables.
-
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
-
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(required):
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(required):
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 : projectAssetLines
Type:
Show Source
object
-
count(required): integer
The number of resource instances returned in the current range.
-
hasMore(required): boolean
Indicates whether more resources are available on the server than the subset returned in the response. If the value is true, then there are more resources to retrieve from the server. The default value is false.
-
items: array
Items
Title:
Items
The items in the collection. -
limit(required): integer
The actual paging size used by the server.
-
links(required): array
Links
Title:
Links
The link relations associated with the resource instance. -
offset(required): integer
The offset value used in the current page.
-
totalResults: integer
The estimated row count when "?totalResults=true", otherwise the count is not included.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : projectAssetLines-item-response
Type:
Show Source
object
-
AmortizeFlag: boolean
Title:
Amortize Adjustments
Read Only:true
Maximum Length:1
Indicates whether cost adjustments should be amortized in Oracle Assets. The two options are Y and N. The default value is N. -
ApDistributionLineNumber: integer
(int64)
Title:
Supplier Invoice Distribution Line Number
Read Only:true
The unique number of a supplier invoice distribution line. -
AssetCategoryCombination: string
Title:
Asset Category
Read Only:true
Maximum Length:255
Segment values for asset categories, concatenated using a delimiter. -
AssetCategoryId: integer
(int64)
Title:
Asset Category ID
Read Only:true
Identifier of the asset category to which the asset is assigned. -
AssetLineType: string
Title:
Asset Line Type
Read Only:true
Maximum Length:80
Classifies project asset lines as Capital or Retirement. -
AssetLineTypeCode: string
Title:
Asset Line Type Code
Read Only:true
Maximum Length:30
Asset line classification code, where C stands for Capital and R for Retirement. -
BusinessUnitName: string
Title:
Business Unit
Read Only:true
Maximum Length:240
Name of the business unit associated with the project to which the project asset line has been assigned. -
CapitalEventId: integer
(int64)
Title:
Event ID
Read Only:true
Identifier of the capital event associated with the asset of the project. -
CIPAccountCombination: string
Title:
CIP Cost Account
Read Only:true
Maximum Length:255
The general ledger account to which a construction-in-progress cost is charged. -
CIPIdentifier: integer
(int64)
Title:
CIP Code Combination ID
Read Only:true
The identifier of the general ledger account to which a construction-in-progress cost is charged. -
CurrentAssetCost: number
Title:
Unrounded Grouped Cost
Read Only:true
The project asset line's current cost. Split lines have a current cost that's greater or less than the original cost, but never equal to it. -
DepreciationExpenseAccountCombination: string
Title:
Depreciation Expense Account
Read Only:true
Maximum Length:255
The depreciation expense account of the asset associated with the asset line. You may enter either this attribute, the depreciation expense account, or both. -
DepreciationExpenseIdentifier: integer
(int64)
Title:
Depreciation Expense ID
Read Only:true
Identifier of the depreciation expense account of the asset associated with the asset line. You may enter either this attribute, the depreciation expense account, or both. -
Description: string
Title:
Asset Line Description
Read Only:true
Maximum Length:255
Description of the project asset line, derived from the CIP grouping method. -
FaPeriodName: string
Title:
Asset Period
Read Only:true
Maximum Length:15
Asset book depreciation calendar period name to which the asset cost was posted. -
InvoiceDate: string
(date)
Title:
Supplier Invoice Date
Read Only:true
The date on the supplier invoice. This value can either be provided while creating an invoice, or populated by default to the system date. -
InvoiceDistributionId: integer
(int64)
Title:
Supplier Invoice Line Distribution ID
Read Only:true
The unique number of a supplier invoice distribution line. -
InvoiceId: integer
(int64)
Title:
Supplier Invoice ID
Read Only:true
The identifier of the supplier invoice. -
InvoiceLineNumber: integer
(int64)
Title:
Supplier Invoice Line Number
Read Only:true
A line number on a supplier invoice. -
InvoiceNumber: string
Title:
Invoice Number
Read Only:true
Maximum Length:50
Identifies the number of the Payables invoice that was imported as an expenditure item. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
NewMasterFlag: boolean
Title:
Override Category and Description
Read Only:true
Maximum Length:1
The flag used to override a project asset line's asset category and description. -
OrgId: integer
(int64)
Title:
Business Unit ID
Read Only:true
The identifier of the business unit associated with a project asset line. -
OriginalAssetCost: number
Title:
Original Amount
Read Only:true
The original asset cost on the project asset line before it was split. -
OriginalAssetId: integer
(int64)
Title:
Original Asset ID
Read Only:true
The original asset identifier on the project asset line before it was split. -
PayablesBatchName: string
Title:
Supplier Invoice Group
Read Only:true
Maximum Length:50
The unique name of the invoice group to which you can assign reporting and payment invoices. -
PONumber: string
Title:
Purchase Order
Read Only:true
Maximum Length:50
The purchase order number entered by the user from Purchasing through Accounts Payable. -
POVendorId: integer
(int64)
Title:
Supplier ID
Read Only:true
Supplier identifier received from Purchasing through Accounts Payable. -
ProjectAssetId: integer
(int64)
Title:
Project Asset ID
Read Only:true
The identifier of the asset assigned to the project asset line. Its value is 0 on unassigned lines. -
ProjectAssetLineDetailId: integer
(int64)
Title:
Project Asset Line Detail ID
Read Only:true
The identifier of the asset line detail linking this project asset line to cost distribution lines. -
ProjectAssetLineDetails: array
Project Asset Line Detail Identifier
Title:
Project Asset Line Detail Identifier
The Project Asset Line Details resource is a child of the Project Asset Line resource. -
ProjectAssetLineId: integer
(int64)
Title:
Line Number
The identifier of the project asset line. -
ProjectId: integer
(int64)
Title:
Project ID
Read Only:true
The identifier of the project to which the CIP cost was charged. -
ProjectName: string
Title:
Project Name
Read Only:true
Maximum Length:240
The name of the project to which the CIP cost was charged. -
ProjectNumber: string
Title:
Project Number
Read Only:true
Maximum Length:25
The number of the project to which the CIP cost was charged. -
RetAdjustmentTransactionId: integer
(int64)
Title:
Asset Line Retirement Adjustment Transaction
Read Only:true
The transaction identifier of the group retirement adjustment transaction. -
RetirementCostType: string
Title:
Asset Line Retirement Cost Type
Read Only:true
Maximum Length:80
Retirement cost classification of the project asset line. The two values available are Cost of Removal and Proceeds of Sale. -
RetirementCostTypeCode: string
Title:
Asset Line Retirement Cost Type Code
Read Only:true
Maximum Length:30
Retirement cost classification code of the project asset line. The two values available are COR and POS. -
ReversedFromProjAssetLineId: integer
(int64)
Title:
Reversed from Project Asset Line ID
Read Only:true
The identifier of the project asset line that was reversed. -
ReversedProjAssetLineId: integer
(int64)
Title:
Reversed Asset Line
Read Only:true
The identifier of the asset line that's reversed by this project asset line. -
TaskId: integer
(int64)
Title:
Task ID
Read Only:true
The identifier of the task against which the CIP cost is charged. -
TaskName: string
Title:
Task Name
Read Only:true
Maximum Length:255
The name of the task against which the CIP cost is charged. -
TaskNumber: string
Title:
Task Number
Read Only:true
Maximum Length:100
The number of the task against which the CIP cost is charged. -
TransferRejectionReason: string
Title:
Asset Line Rejection Reason
Read Only:true
Maximum Length:240
The reason the line was rejected by the Interface Assets program. -
TransferRejectionReasonCode: string
Title:
Asset Line Rejection Reason Code
Read Only:true
Maximum Length:30
The error code of the reason why the project asset line was rejected. -
TransferStatus: string
Title:
Status
Read Only:true
Maximum Length:80
The asset line status that appears when cost information is transferred to Oracle Fixed Assets. The available values are Pending, Rejected, and Transferred. -
TransferStatusCode: string
Title:
Transfer Status Code
Maximum Length:1
Transfer status code of the project asset line. This code indicates whether an asset line was successfully moved to Fixed Assets. Possible values are P for pending, R for rejected, and T for transferred. -
TransferStatusCodeSource: string
Read Only:
true
Maximum Length:30
The name of the source that performed the update to the asset line transfer status from Transferred to Pending. The available values are REST and FBDI. -
UpdationSource: string
Read Only:
true
Maximum Length:30
The name of the source that performed the update to the asset line. The available values are REST and FBDI. -
VendorNumber: string
Title:
Supplier Number
Read Only:true
Maximum Length:30
The supplier number entered by the user from Purchasing through Payables.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Nested Schema : Project Asset Line Detail Identifier
Type:
array
Title:
Project Asset Line Detail Identifier
The Project Asset Line Details resource is a child of the Project Asset Line resource.
Show Source
Nested Schema : link
Type:
Show Source
object
-
href: string
Title:
hyperlink reference
The URI to the related resource. -
kind: string
Title:
kind
Allowed Values:[ "collection", "item", "describe", "other" ]
The kind of the related resource. -
name: string
Title:
name
The name of the link to the related resource. -
properties: object
properties
-
rel: string
Title:
relation
Allowed Values:[ "self", "lov", "parent", "canonical", "child", "enclosure", "action", "custom" ]
The name of the relation to the resource instance. Example: self.
Nested Schema : properties
Type:
Show Source
object
-
changeIndicator: string
Change indicator or the ETag value of the resource instance.
Nested Schema : projectAssetLines-ProjectAssetLineDetails-item-response
Type:
Show Source
object
-
CIPCost: number
Title:
CIP Cost
Read Only:true
The CIP cost amount from the associated cost distribution line. -
ExpenditureItemId: integer
(int64)
Title:
Transaction Number
Read Only:true
The identifier of the expenditure item summarized into the project asset line. -
LineNumber: integer
(int64)
Title:
Line Number
Read Only:true
The identifier of the cost distribution line summarized into the asset line. -
links: array
Links
Title:
Links
The link relations associated with the resource instance. -
ProjAssetLineDtlUniqId: integer
(int64)
Title:
Project Asset Line Unique Detail ID
The unique identifier of the project asset line details table. -
ProjectAssetLineDetailId: integer
(int64)
Title:
Project Asset Line Detail ID
The identifier of the asset line detail linking this project asset line to cost distribution lines. -
ReversedFlag: boolean
Title:
Reversed Asset Line Flag
Read Only:true
Maximum Length:1
Indicates if the asset line has been reversed.
Nested Schema : Links
Type:
array
Title:
Links
The link relations associated with the resource instance.
Show Source
Examples
The following example shows how to get all project asset lines associated with a project by submitting a GET request on the REST resource using cURL.
curl --user ppm_cloud_user https://your_organization.com:port/fscmRestApi/resources/11.13.18.05/projectAssetLines
Example of Response Body
The following shows an example of the response body in JSON format.
{ "ProjectAssetLineId": 1, "AmortizeFlag": false, "ApDistributionLineNumber": null, "AssetCategoryId": null, "AssetCategoryCombination": null, "DepreciationExpenseIdentifier": 16534, "DepreciationExpenseAccountCombination": "01-110-7320-000", "CapitalEventId": -1, "CIPIdentifier": 15681, "CIPAccountCombination": "01-000-1580-000", "CurrentAssetCost": 2497.5, "Description": "ADMINISTRATIVE", "FaPeriodName": "Jan-97", "InvoiceDate": null, "InvoiceDistributionId": null, "InvoiceId": null, "InvoiceLineNumber": null, "InvoiceNumber": null, "NewMasterFlag": null, "OriginalAssetCost": 2497.5, "OriginalAssetId": null, "PayablesBatchName": null, "PONumber": null, "POVendorId": null, "ProjectAssetId": 1, "ProjectAssetLineDetailId": 1, "RetAdjustmentTransactionId": null, "RetirementCostTypeCode": null, "RetirementCostType": null, "ReversedFromProjAssetLineId": null, "ReversedProjAssetLineId": null, "VendorNumber": null, "ProjectId": 1008, "ProjectNumber": "Construction", "ProjectName": "Construction", "OrgId": 458, "BusinessUnitName": "Vision Services", "TaskId": 1045, "TaskName": null, "TaskNumber": null, "AssetLineTypeCode": "C", "AssetLineType": "Capital cost", "TransferStatusCode": "T", "TransferStatus": "Transferred", "TransferRejectionReasonCode": null, "TransferRejectionReason": null, "UpdationSource": null, "TransferStatusCodeSource": null, "links": [ { "rel": "self", "href": "https://your_organization.com:port/fscmRestApi/resources/11.13.18.05/projectAssetLines/1", "name": "projectAssetLines", "kind": "item", "properties": { "changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D0300014 9000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657 212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657 286AC951D0B94E08B02000078700000000278" } }, { "rel": "canonical", "href": "https://your_organization.com:port/fscmRestApi/resources/11.13.18.05/projectAssetLines/1", "name": "projectAssetLines", "kind": "item" }, { "rel": "child", "href": "https://your_organization.com:port/fscmRestApi/resources/11.13.18.05/projectAssetLines/1/child/ProjectAssetLineDetails", "name": "ProjectAssetLineDetails", "kind": "collection" } ] }