Jump to

• Request
• Response
• Examples

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.
• 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 Top

Response

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.

Body ()

Root Schema : projectAssetLines

Type: object

Show Source

• 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.

{
    "required":[
        "count",
        "hasMore",
        "limit",
        "links",
        "offset"
    ],
    "type":"object",
    "properties":{
        "totalResults":{
            "type":"integer",
            "description":"The estimated row count when \"?totalResults=true\", otherwise the count is not included."
        },
        "offset":{
            "type":"integer",
            "description":"The offset value used in the current page."
        },
        "count":{
            "type":"integer",
            "description":"The number of resource instances returned in the current range."
        },
        "hasMore":{
            "type":"boolean",
            "description":"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."
        },
        "limit":{
            "type":"integer",
            "description":"The actual paging size used by the server."
        },
        "links":{
            "title":"Links",
            "type":"array",
            "description":"The link relations associated with the resource instance.",
            "items":{
                "$ref":"#/components/schemas/link"
            }
        },
        "items":{
            "title":"Items",
            "type":"array",
            "description":"The items in the collection.",
            "items":{
                "$ref":"#/components/schemas/projectAssetLines-item-response"
            }
        }
    },
    "x-hints":{
        "usage":"BusinessObject"
    }
}

Nested Schema : Items

Type: array

Title: Items

The items in the collection.

Show Source

• Array of: object projectAssetLines-item-response

{
    "title":"Items",
    "type":"array",
    "description":"The items in the collection.",
    "items":{
        "$ref":"#/components/schemas/projectAssetLines-item-response"
    }
}

Nested Schema : Links

Type: array

Title: Links

The link relations associated with the resource instance.

Show Source

• Array of: object link

{
    "title":"Links",
    "type":"array",
    "description":"The link relations associated with the resource instance.",
    "items":{
        "$ref":"#/components/schemas/link"
    }
}

Nested Schema : projectAssetLines-item-response

Type: object

Show Source

• 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.

{
    "type":"object",
    "properties":{
        "PONumber":{
            "title":"Purchase Order",
            "maxLength":"50",
            "type":"string",
            "description":"The purchase order number entered by the user from Purchasing through Accounts Payable.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "InvoiceLineNumber":{
            "title":"Supplier Invoice Line Number",
            "type":"integer",
            "description":"A line number on a supplier invoice.",
            "format":"int64",
            "nullable":true,
            "readOnly":true,
            "x-hints":{
                "precision":"38"
            },
            "x-queryable":true
        },
        "CurrentAssetCost":{
            "title":"Unrounded Grouped Cost",
            "type":"number",
            "description":"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.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "ProjectAssetLineDetails":{
            "title":"Project Asset Line Detail Identifier",
            "type":"array",
            "description":"The Project Asset Line Details resource is a child of the Project Asset Line resource.",
            "items":{
                "$ref":"#/components/schemas/projectAssetLines-ProjectAssetLineDetails-item-response"
            }
        },
        "DepreciationExpenseAccountCombination":{
            "title":"Depreciation Expense Account",
            "maxLength":"255",
            "type":"string",
            "description":"The depreciation expense account of the asset associated with the asset line. You may enter either this attribute, the depreciation expense account, or both.",
            "nullable":true,
            "readOnly":true,
            "x-hints":{
                "DISPLAYHINT":"Hide"
            },
            "x-queryable":true
        },
        "TransferStatusCode":{
            "title":"Transfer Status Code",
            "maxLength":"1",
            "type":"string",
            "description":"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.",
            "nullable":false,
            "x-queryable":true
        },
        "RetirementCostTypeCode":{
            "title":"Asset Line Retirement Cost Type Code",
            "maxLength":"30",
            "type":"string",
            "description":"Retirement cost classification code of the project asset line. The two values available are COR and POS.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "ApDistributionLineNumber":{
            "title":"Supplier Invoice Distribution Line Number",
            "type":"integer",
            "description":"The unique number of a supplier invoice distribution line.",
            "format":"int64",
            "nullable":true,
            "readOnly":true,
            "x-hints":{
                "precision":"18"
            },
            "x-queryable":true
        },
        "PayablesBatchName":{
            "title":"Supplier Invoice Group",
            "maxLength":"50",
            "type":"string",
            "description":"The unique name of the invoice group to which you can assign reporting and payment invoices.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "links":{
            "title":"Links",
            "type":"array",
            "description":"The link relations associated with the resource instance.",
            "items":{
                "$ref":"#/components/schemas/link"
            }
        },
        "InvoiceNumber":{
            "title":"Invoice Number",
            "maxLength":"50",
            "type":"string",
            "description":"Identifies the number of the Payables invoice that was imported as an expenditure item.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "NewMasterFlag":{
            "title":"Override Category and Description",
            "maxLength":"1",
            "type":"boolean",
            "description":"The flag used to override a project asset line's asset category and description.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "ReversedFromProjAssetLineId":{
            "title":"Reversed from Project Asset Line ID",
            "type":"integer",
            "description":"The identifier of the project asset line that was reversed.",
            "format":"int64",
            "nullable":true,
            "readOnly":true,
            "x-hints":{
                "precision":"18"
            },
            "x-queryable":true
        },
        "RetirementCostType":{
            "title":"Asset Line Retirement Cost Type",
            "maxLength":"80",
            "type":"string",
            "description":"Retirement cost classification of the project asset line. The two values available are Cost of Removal and Proceeds of Sale.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "UpdationSource":{
            "maxLength":"30",
            "type":"string",
            "description":"The name of the source that performed the update to the asset line. The available values are REST and FBDI.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "ProjectAssetLineId":{
            "title":"Line Number",
            "type":"integer",
            "description":"The identifier of the project asset line.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "precision":"18",
                "fnd:GLOBALLY_UNIQUE":"true"
            },
            "x-queryable":true
        },
        "AssetCategoryId":{
            "title":"Asset Category ID",
            "type":"integer",
            "description":"Identifier of the asset category to which the asset is assigned.",
            "format":"int64",
            "nullable":true,
            "readOnly":true,
            "x-hints":{
                "FND_ACFF_CCID":"AssetCategoryKeyFlexfield",
                "precision":"18"
            },
            "x-queryable":true
        },
        "TaskName":{
            "title":"Task Name",
            "maxLength":"255",
            "type":"string",
            "description":"The name of the task against which the CIP cost is charged.",
            "nullable":false,
            "readOnly":true,
            "x-hints":{
                "controlType":"choice"
            },
            "x-queryable":true
        },
        "CIPIdentifier":{
            "title":"CIP Code Combination ID",
            "type":"integer",
            "description":"The identifier of the general ledger account to which a construction-in-progress cost is charged.",
            "format":"int64",
            "nullable":true,
            "readOnly":true,
            "x-hints":{
                "FND_ACFF_CCID":"CipAccountKeyFlexfield",
                "precision":"18"
            },
            "x-queryable":true
        },
        "AmortizeFlag":{
            "title":"Amortize Adjustments",
            "maxLength":"1",
            "type":"boolean",
            "description":"Indicates whether cost adjustments should be amortized in Oracle Assets. The two options are Y and N. The default value is N.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "TransferRejectionReasonCode":{
            "title":"Asset Line Rejection Reason Code",
            "maxLength":"30",
            "type":"string",
            "description":"The error code of the reason why the project asset line was rejected.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "CIPAccountCombination":{
            "title":"CIP Cost Account",
            "maxLength":"255",
            "type":"string",
            "description":"The general ledger account to which a construction-in-progress cost is charged.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "TransferRejectionReason":{
            "title":"Asset Line Rejection Reason",
            "maxLength":"240",
            "type":"string",
            "description":"The reason the line was rejected by the Interface Assets program.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "AssetLineType":{
            "title":"Asset Line Type",
            "maxLength":"80",
            "type":"string",
            "description":"Classifies project asset lines as Capital or Retirement.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "Description":{
            "title":"Asset Line Description",
            "maxLength":"255",
            "type":"string",
            "description":"Description of the project asset line, derived from the CIP grouping method.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "TaskId":{
            "title":"Task ID",
            "type":"integer",
            "description":"The identifier of the task against which the CIP cost is charged.",
            "format":"int64",
            "nullable":true,
            "readOnly":true,
            "x-hints":{
                "precision":"18"
            },
            "x-queryable":true
        },
        "DepreciationExpenseIdentifier":{
            "title":"Depreciation Expense ID",
            "type":"integer",
            "description":"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.",
            "format":"int64",
            "nullable":true,
            "readOnly":true,
            "x-hints":{
                "FND_ACFF_CCID":"DepreciationExpenseKeyFlexfield",
                "precision":"18"
            },
            "x-queryable":true
        },
        "ProjectName":{
            "title":"Project Name",
            "maxLength":"240",
            "type":"string",
            "description":"The name of the project to which the CIP cost was charged.",
            "nullable":false,
            "readOnly":true,
            "x-hints":{
                "controlType":"choice"
            },
            "x-queryable":true
        },
        "RetAdjustmentTransactionId":{
            "title":"Asset Line Retirement Adjustment Transaction",
            "type":"integer",
            "description":"The transaction identifier of the group retirement adjustment transaction.",
            "format":"int64",
            "nullable":true,
            "readOnly":true,
            "x-hints":{
                "precision":"18"
            },
            "x-queryable":true
        },
        "VendorNumber":{
            "title":"Supplier Number",
            "maxLength":"30",
            "type":"string",
            "description":"The supplier number entered by the user from Purchasing through Payables.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "OriginalAssetId":{
            "title":"Original Asset ID",
            "type":"integer",
            "description":"The original asset identifier on the project asset line before it was split.",
            "format":"int64",
            "nullable":true,
            "readOnly":true,
            "x-hints":{
                "precision":"18"
            },
            "x-queryable":true
        },
        "AssetCategoryCombination":{
            "title":"Asset Category",
            "maxLength":"255",
            "type":"string",
            "description":"Segment values for asset categories, concatenated using a delimiter.",
            "nullable":true,
            "readOnly":true,
            "x-hints":{
                "DISPLAYHINT":"Hide"
            },
            "x-queryable":true
        },
        "InvoiceId":{
            "title":"Supplier Invoice ID",
            "type":"integer",
            "description":"The identifier of the supplier invoice.",
            "format":"int64",
            "nullable":true,
            "readOnly":true,
            "x-hints":{
                "precision":"18"
            },
            "x-queryable":true
        },
        "OriginalAssetCost":{
            "title":"Original Amount",
            "type":"number",
            "description":"The original asset cost on the project asset line before it was split.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "POVendorId":{
            "title":"Supplier ID",
            "type":"integer",
            "description":"Supplier identifier received from Purchasing through Accounts Payable.",
            "format":"int64",
            "nullable":true,
            "readOnly":true,
            "x-hints":{
                "precision":"18"
            },
            "x-queryable":true
        },
        "FaPeriodName":{
            "title":"Asset Period",
            "maxLength":"15",
            "type":"string",
            "description":"Asset book depreciation calendar period name to which the asset cost was posted.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "TransferStatus":{
            "title":"Status",
            "maxLength":"80",
            "type":"string",
            "description":"The asset line status that appears when cost information is transferred to Oracle Fixed Assets. The available values are Pending, Rejected, and Transferred.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "InvoiceDate":{
            "title":"Supplier Invoice Date",
            "type":"string",
            "description":"The date on the supplier invoice. This value can either be provided while creating an invoice, or populated by default to the system date.",
            "format":"date",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "BusinessUnitName":{
            "title":"Business Unit",
            "maxLength":"240",
            "type":"string",
            "description":"Name of the business unit associated with the project to which the project asset line has been assigned.",
            "nullable":true,
            "readOnly":true,
            "x-hints":{
                "controlType":"choice"
            },
            "x-queryable":true
        },
        "ReversedProjAssetLineId":{
            "title":"Reversed Asset Line",
            "type":"integer",
            "description":"The identifier of the asset line that's reversed by this project asset line.",
            "format":"int64",
            "nullable":true,
            "readOnly":true,
            "x-hints":{
                "precision":"18"
            },
            "x-queryable":true
        },
        "TransferStatusCodeSource":{
            "maxLength":"30",
            "type":"string",
            "description":"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.",
            "nullable":true,
            "readOnly":true,
            "x-queryable":true
        },
        "InvoiceDistributionId":{
            "title":"Supplier Invoice Line Distribution ID",
            "type":"integer",
            "description":"The unique number of a supplier invoice distribution line.",
            "format":"int64",
            "nullable":true,
            "readOnly":true,
            "x-hints":{
                "precision":"38"
            },
            "x-queryable":true
        },
        "ProjectAssetId":{
            "title":"Project Asset ID",
            "type":"integer",
            "description":"The identifier of the asset assigned to the project asset line. Its value is 0 on unassigned lines.",
            "format":"int64",
            "nullable":false,
            "readOnly":true,
            "x-hints":{
                "precision":"18"
            },
            "x-queryable":true
        },
        "ProjectNumber":{
            "title":"Project Number",
            "maxLength":"25",
            "type":"string",
            "description":"The number of the project to which the CIP cost was charged.",
            "nullable":false,
            "readOnly":true,
            "x-hints":{
                "controlType":"choice"
            },
            "x-queryable":true
        },
        "ProjectId":{
            "title":"Project ID",
            "type":"integer",
            "description":"The identifier of the project to which the CIP cost was charged.",
            "format":"int64",
            "nullable":false,
            "readOnly":true,
            "x-hints":{
                "precision":"18"
            },
            "x-queryable":true
        },
        "TaskNumber":{
            "title":"Task Number",
            "maxLength":"100",
            "type":"string",
            "description":"The number of the task against which the CIP cost is charged.",
            "nullable":true,
            "readOnly":true,
            "x-hints":{
                "controlType":"choice"
            },
            "x-queryable":true
        },
        "OrgId":{
            "title":"Business Unit ID",
            "type":"integer",
            "description":"The identifier of the business unit associated with a project asset line.",
            "format":"int64",
            "nullable":false,
            "readOnly":true,
            "x-hints":{
                "precision":"18"
            },
            "x-queryable":true
        },
        "AssetLineTypeCode":{
            "title":"Asset Line Type Code",
            "maxLength":"30",
            "type":"string",
            "description":"Asset line classification code, where C stands for Capital and R for Retirement.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "CapitalEventId":{
            "title":"Event ID",
            "type":"integer",
            "description":"Identifier of the capital event associated with the asset of the project.",
            "format":"int64",
            "nullable":false,
            "readOnly":true,
            "x-hints":{
                "precision":"18"
            },
            "x-queryable":true
        },
        "ProjectAssetLineDetailId":{
            "title":"Project Asset Line Detail ID",
            "type":"integer",
            "description":"The identifier of the asset line detail linking this project asset line to cost distribution lines.",
            "format":"int64",
            "nullable":false,
            "readOnly":true,
            "x-hints":{
                "precision":"18"
            },
            "x-queryable":true
        }
    }
}

Nested Schema : Links

Type: array

Title: Links

The link relations associated with the resource instance.

Show Source

• Array of: object link

{
    "title":"Links",
    "type":"array",
    "description":"The link relations associated with the resource instance.",
    "items":{
        "$ref":"#/components/schemas/link"
    }
}

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

• Array of: object projectAssetLines-ProjectAssetLineDetails-item-response

{
    "title":"Project Asset Line Detail Identifier",
    "type":"array",
    "description":"The Project Asset Line Details resource is a child of the Project Asset Line resource.",
    "items":{
        "$ref":"#/components/schemas/projectAssetLines-ProjectAssetLineDetails-item-response"
    }
}

Nested Schema : link

Type: object

Show Source

• 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.

{
    "type":"object",
    "properties":{
        "kind":{
            "title":"kind",
            "type":"string",
            "description":"The kind of the related resource.",
            "enum":[
                "collection",
                "item",
                "describe",
                "other"
            ]
        },
        "rel":{
            "title":"relation",
            "type":"string",
            "description":"The name of the relation to the resource instance.  Example: self.",
            "enum":[
                "self",
                "lov",
                "parent",
                "canonical",
                "child",
                "enclosure",
                "action",
                "custom"
            ]
        },
        "name":{
            "title":"name",
            "type":"string",
            "description":"The name of the link to the related resource."
        },
        "href":{
            "title":"hyperlink reference",
            "type":"string",
            "description":"The URI to the related resource."
        },
        "properties":{
            "type":"object",
            "properties":{
                "changeIndicator":{
                    "type":"string",
                    "description":"Change indicator or the ETag value of the resource instance."
                }
            }
        }
    }
}

Nested Schema : properties

Type: object

Show Source

• changeIndicator: string
  Change indicator or the ETag value of the resource instance.

{
    "type":"object",
    "properties":{
        "changeIndicator":{
            "type":"string",
            "description":"Change indicator or the ETag value of the resource instance."
        }
    }
}

Nested Schema : projectAssetLines-ProjectAssetLineDetails-item-response

Type: object

Show Source

• 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.

{
    "type":"object",
    "properties":{
        "ProjAssetLineDtlUniqId":{
            "title":"Project Asset Line Unique Detail ID",
            "type":"integer",
            "description":"The unique identifier of the project asset line details table.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "precision":"18"
            },
            "x-queryable":true
        },
        "ReversedFlag":{
            "title":"Reversed Asset Line Flag",
            "maxLength":"1",
            "type":"boolean",
            "description":"Indicates if the asset line has been reversed.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "links":{
            "title":"Links",
            "type":"array",
            "description":"The link relations associated with the resource instance.",
            "items":{
                "$ref":"#/components/schemas/link"
            }
        },
        "ProjectAssetLineDetailId":{
            "title":"Project Asset Line Detail ID",
            "type":"integer",
            "description":"The identifier of the asset line detail linking this project asset line to cost distribution lines.",
            "format":"int64",
            "nullable":false,
            "x-hints":{
                "precision":"18"
            },
            "x-queryable":true
        },
        "CIPCost":{
            "title":"CIP Cost",
            "type":"number",
            "description":"The CIP cost amount from the associated cost distribution line.",
            "nullable":false,
            "readOnly":true,
            "x-queryable":true
        },
        "ExpenditureItemId":{
            "title":"Transaction Number",
            "type":"integer",
            "description":"The identifier of the expenditure item summarized into the project asset line.",
            "format":"int64",
            "nullable":false,
            "readOnly":true,
            "x-hints":{
                "precision":"18"
            },
            "x-queryable":true
        },
        "LineNumber":{
            "title":"Line Number",
            "type":"integer",
            "description":"The identifier of the cost distribution line summarized into the asset line.",
            "format":"int64",
            "nullable":false,
            "readOnly":true,
            "x-hints":{
                "precision":"18"
            },
            "x-queryable":true
        }
    }
}

Nested Schema : Links

Type: array

Title: Links

The link relations associated with the resource instance.

Show Source

• Array of: object link

{
    "title":"Links",
    "type":"array",
    "description":"The link relations associated with the resource instance.",
    "items":{
        "$ref":"#/components/schemas/link"
    }
}

Back to Top

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"
        }
    ]
}

Back to Top