ProjectCommitments
The project commitments resource is used to view project commitments. This includes viewing, creating, and deleting project commitments that are imported from third-party applications and viewing commitments that are created in other Oracle Fusion applications such as supplier invoices, requisitions, purchase orders, and so on.
Columns
| Name | Type | Description |
| CommitmentId [KEY] | Long | Unique identifier of the commitment transaction. |
| CommitmentNumber | String | Number of the commitment transaction. Examples include purchase requisition number, purchase order number, supplier invoice number, and external commitment transaction number. |
| BusinessUnitId | Long | Identifier of the expenditure business unit that incurred the commitment cost. You must enter at least one from among this attribute and Business Unit while creating a project commitment. |
| BusinessUnit | String | Name of the expenditure business unit that incurred the commitment cost. You must enter at least one from among this attribute and Business Unit ID while creating a project commitment. |
| OrganizationId | Long | Identifier of the expenditure organization to which the commitment cost is charged. You must enter at least one from among this attribute and Organization while creating a project commitment. The organization must be an active project expenditure organization as of the expenditure item date. |
| Organization | String | Name of the expenditure organization to which the commitment cost is charged. You must enter at least one from among this attribute and Organization ID while creating a project commitment. The organization must be an active project expenditure organization as of the expenditure item date. |
| TransactionSourceId | Long | Identifier of the application in which the commitment transaction was originally created. You must enter at least one from among this attribute and Transaction Source while creating a project commitment. |
| TransactionSource | String | Name of the application in which the commitment transaction was originally created. You must enter at least one from among this attribute and Transaction Source ID while creating a project commitment. |
| DocumentId | Long | Identifier of the document used to capture the commitment transaction. You must enter at least one from among this attribute and Document while creating a project commitment. The document must be active and enabled for commitment sources. |
| Document | String | Name of the document used to capture the commitment transaction. You must enter at least one from among this attribute and Document ID while creating a project commitment. The document must be active and enabled for commitment sources. |
| DocumentEntryId | Long | Identifier of the document entry used to capture the commitment transaction. You must enter at least one from among this attribute and Document Entry while creating a project commitment. |
| DocumentEntry | String | Name of the document entry used to capture the commitment transaction. You must enter at least one from among this attribute and Document Entry ID while creating a project commitment. |
| ProjectId | Long | Identifier of the project to which the commitment cost is charged. You must enter at least one from among this attribute, Project Number, and Project Name while creating a project commitment. The project must be active and in an appropriate status. |
| ProjectNumber | String | Number of the project to which the commitment cost is charged. You must enter at least one from among this attribute, Project ID, and Project Name while creating a project commitment. The project must be active and in an appropriate status. |
| ProjectName | String | Name of the project to which the commitment cost is charged. You must enter at least one from among this attribute, Project ID, and Project Number while creating a project commitment. The project must be active and in an appropriate status. |
| TaskId | Long | Identifier of the task to which the commitment cost is charged. You must enter at least one from among this attribute, Task Number, and Task Name while creating a project commitment. The task must be active and included in a published task structure. |
| TaskNumber | String | Number of the task to which the commitment cost is charged. You must enter at least one from among this attribute, Task ID, and Task Name while creating a project commitment. The task must be active and included in a published task structure. |
| TaskName | String | Name of the task to which the commitment cost is charged. You must enter at least one from among this attribute, Task ID, and Task Number while creating a project commitment. The task must be active and included in a published task structure. |
| CommitmentSourceType | String | Identifies the commitment transaction as either internal or external. A list of accepted values - Internal, External, or All - is defined in the lookup type PJC_COMMITMENT_TYPE. Default value is External while creating a project commitment. |
| CommitmentType | String | Identifies the commitment transaction as either purchase requisition, purchase order, supplier invoice, or external. A list of accepted values is defined in the lookup type PJC_CMT_LINE_TYPE. Default value is External while creating a project commitment. |
| ProcessingStatus | String | Identifies the commitment transaction as either unprocessed, processed, or error. A list of accepted values - Processed, Unprocessed, or Error - is defined in the lookup type PJC_CMT_PROCESSING_STATUS. Default value is Unprocessed while creating a project commitment. |
| ApprovedFlag | Bool | Identifies if the commitment transaction is approved or not in the source application. A value of true means that the project commitment is in approved status and a value of false means that the project commitment is not in approved status. |
| CommitmentCreationDate | Date | Date on which the commitment transaction is created. Default value is the system date while creating a project commitment. |
| OriginalTransactionReference | String | Original transaction reference of a third-party commitment transaction. If duplicate references aren't allowed by the document, then multiple project commitments can't refer to the same original transaction. |
| OriginallyOrderedQuantity | Decimal | Original quantity on the purchase order. |
| OriginallyOrderedAmount | Decimal | Original amount on the purchase order. |
| OrderedAmount | Decimal | Amount ordered on the purchase order. |
| DeliveredAmount | Decimal | Amount on the purchase order that is delivered. |
| CanceledAmount | Decimal | Amount on the purchase order that is cancelled. |
| OverbilledAmount | Decimal | Amount that is overbilled by the supplier. |
| InvoicedAmount | Decimal | Amount on the purchase order that is invoiced. |
| OutstandingInvoiceAmount | Decimal | Amount on the purchase order that is not yet invoiced by the supplier. |
| OutstandingDeliveryAmount | Decimal | Amount for the purchase order quantity that is not yet delivered. |
| OrderedQuantity | Decimal | Quantity ordered on the purchase order. |
| DeliveredQuantity | Decimal | Quantity on the purchase order that is delivered. |
| CanceledQuantity | Decimal | Quantity on the purchase order that is cancelled. |
| InvoicedQuantity | Decimal | Quantity on the purchase order that is invoiced. |
| OverbilledQuantity | Decimal | Quantity that is overbilled by the supplier. |
| OutstandingInvoiceQuantity | Decimal | Quantity on the purchase order that is not yet invoiced by the supplier. |
| OutstandingDeliveryQuantity | Decimal | Quantity on the purchase order that is not yet delivered. |
| Quantity | Decimal | Quantity entered on the commitment transaction. You must enter a value for this attribute while creating a project commitment that is not externally costed and uses a rate-based expenditure type. |
| Currency | String | Code identifying the currency in which the commitment transaction cost is incurred. You must enter a value for this attribute for project commitment transactions that are externally costed or accounted. The currency must be an active valid general ledger currency. |
| BurdenedCostInTransactionCurrency | Decimal | Total committed cost in the transaction currency for the project. You must provide a value for this attribute while creating an externally burdened project commitment transaction for a project that is enabled for burdening. |
| RawCostInTransactionCurrency | Decimal | Cost committed in the transaction currency for the project that is directly attributable to the work performed. You must provide a value for this attribute while creating an externally costed project commitment transaction. |
| RawCostInProjectCurrency | Decimal | Cost committed in the project currency for the project that is directly attributable to the work performed . |
| BurdenedCostInProjectCurrency | Decimal | Total committed cost in the project currency for the project. |
| RawCostInReceiverLedgerCurrency | Decimal | Cost committed in the receiver ledger currency for the project that is directly attributable to the work performed. |
| BurdenedCostInReceiverLedgerCurrency | Decimal | Total committed cost in the receiver ledger currency for the project. |
| RawCostInProviderLedgerCurrency | Decimal | Cost committed in the provider ledger currency for the project that is directly attributable to the work performed. You must provide a value for this attribute while creating an externally accounted project commitment transaction. |
| BurdenedCostInProviderLedgerCurrency | Decimal | Total committed cost in the provider ledger currency for the project. You must provide a value for this attribute while creating a project commitment transaction for which the burdened cost is accounted externally. |
| ExpenditureTypeId | Long | Identifier of the expenditure type. You must enter at least one from among this attribute and Expenditure Type while creating a project commitment. The expenditure type must be active as of the expenditure item date. |
| ExpenditureType | String | A classification of cost that is assigned to each project commitment transaction. Expenditure types are grouped into cost groups (expenditure categories) and revenue groups (revenue categories). You must enter at least one from among this attribute and Expenditure Type ID while creating a project commitment. The expenditure type must be active as of the expenditure item date. |
| ExpenditureItemDate | Date | Date on which the commitment cost was incurred. The expenditure item date must lie within the project start and finish dates. |
| ProviderProjectAccountingDate | Date | Date used to determine the provider project accounting period of the commitment transaction. |
| ProviderProjectAccountingPeriod | String | Project accounting period of the commitment transaction in the project accounting calendar of the provider organization. |
| ProviderAccountingDate | Date | Date used to determine the provider accounting period for a commitment transaction. You must provide a value for this attribute for an externally accounted project commitment transaction. |
| ProviderAccountingPeriod | String | Accounting period of the commitment transaction in the accounting calendar of the provider organization. |
| ReceiverAccountingPeriod | String | Accounting period of the commitment transaction in the accounting calendar of the receiver organization. The receiver is the organization that owns the project that incurred the commitment cost. |
| ReceiverAccountingDate | Date | Date used to determine the receiver accounting period for a commitment transaction. The receiver is the organization that owns the project that incurred the commitment cost. |
| ReceiverProjectAccountingDate | Date | Date used to determine the receiver project accounting period of the commitment transaction. The receiver is the organization that owns the project that incurred the commitment cost. |
| ReceiverProjectAccountingPeriod | String | Project accounting period of the commitment transaction in the project accounting calendar of the receiver organization. The receiver is the organization that owns the project that incurred the commitment cost. |
| NeedByDate | Date | Date by which the materials must be delivered. |
| PromisedDate | Date | Date by which the supplier has committed to deliver the materials. |
| CapitalizableFlag | Bool | Specifies whether the commitment transaction is capitalizable. A value of true means that the project commitment transaction is capitalizable and a value of false means that the project commitment transaction is not capitalizable. |
| BillableFlag | Bool | Specifies whether the commitment transaction is billable. A value of true means that the project commitment transaction is billable and a value of false means that the project commitment transaction is not billable. |
| InventoryItemId | Long | Identifier of the inventory item for the commitment cost. You must enter at least one from among this attribute, Inventory Item, and Inventory Item Number while creating a project inventory commitment. |
| InventoryItemNumber | String | Number of the inventory item for the commitment cost. You must enter at least one from among this attribute, Inventory Item, and Inventory Item ID while creating a project inventory commitment. |
| UnitOfMeasureCode | String | Code identifying the unit of measure of the item that is requested, ordered, or supplied. You must enter at least one from among this attribute or Unit of Measure while creating a project commitment that is not externally costed. |
| UnitOfMeasure | String | Name of the unit of measure for the item that is requested, ordered, or supplied. You must enter at least one from among this attribute and Unit of Measure Code while creating a project commitment that is not externally costed. |
| UnitPrice | Decimal | Price per unit of the item that is requested, ordered, or supplied. You cannot enter a value less than zero. |
| SupplierId | Long | Identifier of the supplier who sent the invoice. You can enter either this attribute or Supplier or both while creating a project commitment. The supplier must be active as of the expenditure item date. |
| Supplier | String | Name of the supplier who sent the invoice. You can enter either this attribute or Supplier ID or both while creating a project commitment. The supplier must be active as of the expenditure item date. |
| Requester | String | Name of the person who created the purchase requisition. |
| Buyer | String | Name of the buyer mentioned on the purchase order. |
| WorkTypeId | Long | Identifier of the work type for the commitment transaction. You can enter either this attribute or Work Type or both while creating a project commitment. The work type must be active as of the expenditure item date. |
| WorkType | String | Name of the work type for the commitment transaction. You can enter either this attribute or Work Type ID or both while creating a project commitment. The work type must be active as of the expenditure item date. |
| ContractId | Long | Identifier of the contract for the commitment transaction of a sponsored project. If the sponsored project is associated to multiple contracts then you must enter at least one from among this attribute, Contract Name, and Contract Number while creating a project commitment. If the sponsored project is associated to a single contract, then the default value is the identifier of the associated contract. The contract must be in one of the following statuses: Draft, Active, Under amendment, or Expired. |
| ContractName | String | Name of the contract for the commitment transaction of a sponsored project. If the sponsored project is associated to multiple contracts then you must enter at least one from among this attribute, Contract ID, and Contract Number while creating a project commitment. If the sponsored project is associated to a single contract, then the default value is the name of the associated contract. The contract must be in one of the following statuses: Draft, Active, Under amendment, or Expired. |
| ContractNumber | String | Number of the contract for the commitment transaction of a sponsored project. If the sponsored project is associated to multiple contracts then you must enter at least one from among this attribute, Contract ID, and Contract Name while creating a project commitment. If the sponsored project is associated to a single contract, then the default value is the number of the associated contract. The contract must be in one of the following statuses: Draft, Active, Under amendment, or Expired. |
| FundingSourceId | String | Identifier of the funding source of a project commitment that is processed for sponsored project costing. If the sponsored project is associated to multiple contracts or a single contract with multiple funding sources then you must enter at least one from among this attribute and Funding Source while creating a project commitment. If the sponsored project is associated to a single contract and a single funding source, then the default value is the identifier of the associated funding source. |
| FundingSource | String | Funding source of a project commitment that is processed for sponsored project costing. If the sponsored project is associated to multiple contracts or a single contract with multiple funding sources then you must enter at least one from among this attribute and Funding Source ID while creating a project commitment. If the sponsored project is associated to a single contract and a single funding source, then the default value is the name of the associated funding source. |
| AwardBudgetPeriod | String | Interval of time (usually twelve months) into which the duration of an award project is divided for budgetary and funding purposes. The award budget period must lie within the project and award start and finish dates. |
| Finder | String | finder |
| SysEffectiveDate | String | syseffectivedate |