Full expand

Full collapse

RequisitionHeader

Jump to

• Fields
• Reference Objects
• Business Views
• Other Properties

The Requisition Header view object manages the purchase requisitions. A purchase requisition is an internal demand for purchasing an item or service, typically from a supplier who resides outside your organization.

Label, Plural Label

Requisition, Requisitions

Qualified Label, Qualified Plural Label

Purchase Requisition, Purchase Requisitions

Module

oraProcurementCorePurchaseRequisitions

Keys

• $primary: requisitionHeaderId (default)

• altKey: requisition, requisitioningBUId

Expand all

Collapse all

Fields

* Field can't be null

• activeRequisitionFlag (boolean)

  Contains one of the following values: true or false. If true, then the requisition should be shown to users when they log into SSP. If false, then the requisition should not be shown to users when they log into SSP.

  Label

  Active Requisition

• approvedDate (date-time)

  Date and time when the requisition was last approved.

  Label

  Approved Date

• budgetaryControlledFlag (boolean)*

  Contains one of the following values: true or false. If true, then the requisition has budgetary control enabled. If false, then the requisition doesn't have budgetary control enabled. The default value is False.

  Label

  Budgetary Controlled

  Properties

  • not nullable
• canceledLinesFlag (boolean)

  Value that indicates that at least one line on the requisition is canceled.

  Label

  Canceled Lines Indicator

• changeOrderPendingFlag (boolean)

  Contains one of the following values: true or false. If true, then the requisition is in Change Order process. If true, then the requisition isn't in Change Order process. This attribute doesn't have any default value.

  Label

  Change Order Pending

• createdBy (string)*

  The user who created the record.

  Label

  Created By

  Properties

  • not nullable
• description (string)

  Description of the requisition.

  Label

  Description

• emergencyPONumberRequiredFlag (boolean)

  Contains one of the following values: true or false. If true, then the requisition is an emergency requisition. If false, then the requisition isn't an emergency requisition. This attribute doesn't have any default value.

  Label

  Emergency purchase order number required

• emergencyPurchaseOrder (string)

  Number that identifies the purchase order reserved in advance for an emergency requisition.

  Label

  Emergency Purchase Order

• externallyManagedFlag (boolean)

  Contains one of the following values: true or false. If true, then requisition is externally managed. If false, then requisition isn't externally managed. This attribute doesn't have a default value.

  Label

  Externally Managed

• fundsCheckFailureWarningFlag (boolean)

  Contains one of the following values: true, false, or Null. If true, then funds check failed. If false, then funds check didn't fail. If Null, then the value hasn't been set. The default value is Null.

  Label

  Funds Check Failure or Warning

• fundsStatus (enumeration: RequisitionFundStatus)

  Status of the funds reservation request.

  Label

  Funds Status

  Type

  • Module: oraProcurementCorePurchaseRequisitions

  • Enumeration Type: RequisitionFundStatus

  Valid Values

  • LIQUIDATED
  • NOT_APPLICABLE
  • NOT_RESERVED
  • NOT_RESERVED_FAILED
  • NOT_RESERVED_PASSED
  • NOT_RESERVED_WARNING
  • PARTIALLY_LIQUIDATED
  • RESERVED
  • RESERVED_PARTIAL
• importSource (string)

  Code that identifies the source of the requisition from a requisition import process.

  Label

  Import Source

• incompleteLinesFlag (boolean)

  Value that indicates that at least one line on the requisition is considered incomplete or still in draft mode.

  Label

  Incomplete Lines Indicator

• insufficientFundsFlag (boolean)

  Indicates whether the implicit funds check upon submission returns failures, and an override is requested.

  Label

  Insufficient Funds

• internalTransferRequisitionFlag (boolean)

  Contains one of the following values: true or false. If true, then all lines of the requisition are for internal material transfer. If false, then all the lines of the requisition aren't for internal material transfer.

  Label

  Internal Transfer Requisition

• justification (string)

  Reason for creating the requisition.

  Label

  Justification

• lifeCycleStatus (enumeration: LifeCycleStatus)

  Value that identifies the rolled-up lifecycle status code of the requisition.

  Label

  Lifecycle Status

  Type

  • Module: oraProcurementCorePurchaseRequisitions

  • Enumeration Type: LifeCycleStatus

  Valid Values

  • BILLED
  • BILLED_ORDER_ON_HOLD
  • DELIVERED
  • DELIVERED_ORDER_ON_HOLD
  • IN_RECEIVING
  • IN_RECEIVING_ORDER_ON_HOLD
  • ORDERED
  • ORDER_CANCELED
  • ORDER_CANCELED_REINSTATED
  • ORDER_ON_HOLD

  For a complete list of valid values, see the LifeCycleStatus enumeration type.

• lineGroup (enumeration: LineGroup)

  Group filter to which a requisition line belongs.

  Label

  Line Group

  Type

  • Module: oraProcurementCorePurchaseRequisitions

  • Enumeration Type: LineGroup

  Valid Values

  • LINES_AWAITING_PROCESSING
  • LINES_BEING_PROCESSED
  • LINES_PENDING_APPROVAL
  • LINES_REQUIRING_ATTENTION
  • NEGOTIATION
  • OTHER_REQUISITION_LINES
  • PO
  • TRANSFER_ORDER
• lines (object-collection)*

  The Requisition Lines view object stores information about requisition lines. It manages the items to be purchased, its quantity, unit of measure, price, and deliver-to location information.

  Label

  Requisition Lines

  Cardinality	Target Object
  One to many	Module: oraProcurementCorePurchaseRequisitions Business Object: RequisitionLine

  Additional Mapping Details

  Mapped by relationship: requisitionHeader

  Field in Current Object	Field in Target Object
  requisitionHeaderId	requisitionHeaderId

• linesPendingActionFlag (boolean)

  Value that indicates if at least one line on the requisition requires an action from the user to remove an invoice hold.

  Label

  Lines with Pending Action Indicator

• lockedByBuyerFlag (boolean)

  Contains one of the following values: true or false. If true, then the buyer is currently working on one of the requisition lines and this prevents the requisition preparer from amending any of the other lines. If false, then the buyer is currently not working on any of the requisition lines and the requisition preparer can amend any of the lines.

  Label

  Locked by Buyer

• pendingApprovalLinesFlag (boolean)

  Value that indicates that at least one line on the requisition is pending approval.

  Label

  Pending Approval Lines Indicator

• rejectedLinesFlag (boolean)

  Value that indicates that at least one line on the requisition is rejected.

  Label

  Rejected Lines Indicator

• rejectionReason (string)

  Reason for rejecting the requisition.

  Label

  Rejection Reason

• requisition (string)*

  Number that identifies the requisition. It's used to identify the requisition by end users.

  Label

  Requisition

  Properties

  • not nullable
• requisitionHeaderId (int64)*

  Value that uniquely identifies the requisition.

  Label

  Requisition Header ID

  Properties

  • searchable
  • sortable
  • not nullable
• returnedLinesFlag (boolean)

  Value that indicate that at least one line on the requisition was returned by the buyer.

  Label

  Returned Lines Indicator

• status (enumeration: DocumentStatus)

  Status of the requisition.

  Label

  Status

  Type

  • Module: oraProcurementCorePurchaseRequisitions

  • Enumeration Type: DocumentStatus

  Valid Values

  • APPROVED
  • CANCELED
  • INCOMPLETE
  • PENDING APPROVAL
  • REJECTED
  • RETURNED
  • WITHDRAWN
• submissionDate (date-time)

  Date and time when the requisition was submitted for approval.

  Label

  Submission Date

• taxAttributesUpdatedFlag (boolean)

  Indicates whether the user overrode the tax returned by the tax engine.

  Label

  Tax Attributes Updated

• timeCreated (date-time)*

  The date and time when the record was created.

  Label

  Creation Date

  Properties

  • searchable
  • sortable
  • not nullable
• timeUpdated (date-time)*

  The date and time when the record was last updated.

  Label

  Last Updated Date

  Properties

  • searchable
  • sortable
  • not nullable
• updatedBy (string)*

  The user who last updated the record.

  Label

  Last Updated By

  Properties

  • not nullable
• withdrawnLinesFlag (boolean)

  Value that indicates that at least one line on the requisition was withdrawn by the requisition preparer.

  Label

  Withdrawn Lines Indicator

Expand all

Collapse all

Reference Objects

• documentFiscalClassification (object)

  The code used by a tax authority to represent classifications such as party fiscal classification, party site fiscal classification, product fiscal classification, transaction fiscal classification, and document fiscal classification.

  Label

  Document Fiscal Classification

  Cardinality	Target Object
  One to One	Module: oraErpCoreTaxSetup Business Object: FiscalClassificationCodeHierarchy

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  documentSubType	concatenatedClassificationCode

• enteredBy (object)

  Value that uniquely identifies the user who created the requisition.

  Label

  Entered By

  Cardinality	Target Object
  One to One	Module: oraHcmHrCoreEmployment Business Object: Worker

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  preparerId	id

• fundsOverrideApprover (object)

  Value that uniquely identifies the user who has the insufficient funds override authority for a requisition.

  Label

  Funds Override Approver

  Cardinality	Target Object
  One to One	Module: oraHcmHrCoreEmployment Business Object: Worker

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  fundsOverrideApproverId	id

• modifyingApprover (object)

  Value that uniquely identifies the user who's currently modifying the requisition during the approval process.

  Label

  Modifying Approver

  Cardinality	Target Object
  One to One	Module: oraHcmHrCoreEmployment Business Object: Worker

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  modifyingApproverId	id

• overridingApprover (object)

  Value that uniquely identifies the user specified on the requisition as the overriding approver for approval routing.

  Label

  Overriding Approver

  Cardinality	Target Object
  One to One	Module: oraHcmHrCoreEmployment Business Object: Worker

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  overridingApproverId	id

• procurementBU (object)

  Value that uniquely identifies the Procurement Business Unit.

  Label

  Default Procurement BU

  Cardinality	Target Object
  One to One	Module: oraErpCoreStructure Business Object: BusinessUnit

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  procurementBUId	id

• rejectedByApprover (object)

  Value that uniquely identifies the person who rejected the requisition.

  Label

  Rejected By

  Cardinality	Target Object
  One to One	Module: oraHcmHrCoreEmployment Business Object: Worker

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  rejectedByApproverId	id

• requisitioningBU (object)

  Value that uniquely identifies the Requisitioning Business Unit.

  Label

  Requisitioning BU

  Cardinality	Target Object
  One to One	Module: oraErpCoreStructure Business Object: BusinessUnit

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  requisitioningBUId	id

• soldToLegalEntity (object)

  Value that uniquely identifies the sold to legal entity.

  Label

  Sold-to Legal Entity

  Cardinality	Target Object
  One to One	Module: oraErpCoreStructure Business Object: LegalEntity

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  soldtoLegalEntityId	legalEntityId

• taxationCountry (object)

  Default country used for taxation purposes.

  Label

  Taxation Country

  Cardinality	Target Object
  One to One	Module: oraCommonAppsInfraObjects Business Object: Territory

  Additional Mapping Details

  Field in Current Object	Field in Target Object
  defaultTaxationCountry	territoryCode

Expand all

Collapse all

Business Views

** Available for extracting data

• default

  Data Source

  RDBMS

  Expand all

  Collapse all

  Fields

  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • not nullable
  • description (string)

    Description of the requisition.

    Label

    Description

  • justification (string)

    Reason for creating the requisition.

    Label

    Justification

  • requisition (string)

    Number that identifies the requisition. It's used to identify the requisition by end users.

    Label

    Requisition

    Properties

    • not nullable
  • requisitionHeaderId (int64)

    Value that uniquely identifies the requisition.

    Label

    Requisition Header ID

    Properties

    • searchable
    • sortable
    • not nullable
  • timeCreated (date-time)

    The date and time when the record was created.

    Label

    Creation Date

    Properties

    • searchable
    • sortable
    • not nullable
  • timeUpdated (date-time)

    The date and time when the record was last updated.

    Label

    Last Updated Date

    Properties

    • searchable
    • sortable
    • not nullable
  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • not nullable
• requisitionsExtract**

  Label

  Requisitions

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • activeRequisitionFlag (boolean)

    Contains one of the following values: true or false. If true, then the requisition should be shown to users when they log into SSP. If false, then the requisition should not be shown to users when they log into SSP.

    Label

    Active Requisition

  • approvedDate (date-time)

    Date and time when the requisition was last approved.

    Label

    Approved Date

  • budgetaryControlledFlag (boolean)

    Contains one of the following values: true or false. If true, then the requisition has budgetary control enabled. If false, then the requisition doesn't have budgetary control enabled. The default value is False.

    Label

    Budgetary Controlled

    Properties

    • not nullable
  • canceledLinesFlag (boolean)

    Value that indicates that at least one line on the requisition is canceled.

    Label

    Canceled Lines Indicator

  • changeOrderPendingFlag (boolean)

    Contains one of the following values: true or false. If true, then the requisition is in Change Order process. If true, then the requisition isn't in Change Order process. This attribute doesn't have any default value.

    Label

    Change Order Pending

  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • not nullable
  • description (string)

    Description of the requisition.

    Label

    Description

  • emergencyPONumberRequiredFlag (boolean)

    Contains one of the following values: true or false. If true, then the requisition is an emergency requisition. If false, then the requisition isn't an emergency requisition. This attribute doesn't have any default value.

    Label

    Emergency purchase order number required

  • emergencyPurchaseOrder (string)

    Number that identifies the purchase order reserved in advance for an emergency requisition.

    Label

    Emergency Purchase Order

  • externallyManagedFlag (boolean)

    Contains one of the following values: true or false. If true, then requisition is externally managed. If false, then requisition isn't externally managed. This attribute doesn't have a default value.

    Label

    Externally Managed

  • fundsCheckFailureWarningFlag (boolean)

    Contains one of the following values: true, false, or Null. If true, then funds check failed. If false, then funds check didn't fail. If Null, then the value hasn't been set. The default value is Null.

    Label

    Funds Check Failure or Warning

  • fundsStatus (enumeration: RequisitionFundStatus)

    Status of the funds reservation request.

    Label

    Funds Status

    Type

    • Module: oraProcurementCorePurchaseRequisitions

    • Enumeration Type: RequisitionFundStatus

    Valid Values

    • LIQUIDATED
    • NOT_APPLICABLE
    • NOT_RESERVED
    • NOT_RESERVED_FAILED
    • NOT_RESERVED_PASSED
    • NOT_RESERVED_WARNING
    • PARTIALLY_LIQUIDATED
    • RESERVED
    • RESERVED_PARTIAL
  • importSource (string)

    Code that identifies the source of the requisition from a requisition import process.

    Label

    Import Source

  • incompleteLinesFlag (boolean)

    Value that indicates that at least one line on the requisition is considered incomplete or still in draft mode.

    Label

    Incomplete Lines Indicator

  • insufficientFundsFlag (boolean)

    Indicates whether the implicit funds check upon submission returns failures, and an override is requested.

    Label

    Insufficient Funds

  • internalTransferRequisitionFlag (boolean)

    Contains one of the following values: true or false. If true, then all lines of the requisition are for internal material transfer. If false, then all the lines of the requisition aren't for internal material transfer.

    Label

    Internal Transfer Requisition

  • justification (string)

    Reason for creating the requisition.

    Label

    Justification

  • lifeCycleStatus (enumeration: LifeCycleStatus)

    Value that identifies the rolled-up lifecycle status code of the requisition.

    Label

    Lifecycle Status

    Type

    • Module: oraProcurementCorePurchaseRequisitions

    • Enumeration Type: LifeCycleStatus

    Valid Values

    • BILLED
    • BILLED_ORDER_ON_HOLD
    • DELIVERED
    • DELIVERED_ORDER_ON_HOLD
    • IN_RECEIVING
    • IN_RECEIVING_ORDER_ON_HOLD
    • ORDERED
    • ORDER_CANCELED
    • ORDER_CANCELED_REINSTATED
    • ORDER_ON_HOLD

    For a complete list of valid values, see the LifeCycleStatus enumeration type.

  • lineGroup (enumeration: LineGroup)

    Group filter to which a requisition line belongs.

    Label

    Line Group

    Type

    • Module: oraProcurementCorePurchaseRequisitions

    • Enumeration Type: LineGroup

    Valid Values

    • LINES_AWAITING_PROCESSING
    • LINES_BEING_PROCESSED
    • LINES_PENDING_APPROVAL
    • LINES_REQUIRING_ATTENTION
    • NEGOTIATION
    • OTHER_REQUISITION_LINES
    • PO
    • TRANSFER_ORDER
  • linesPendingActionFlag (boolean)

    Value that indicates if at least one line on the requisition requires an action from the user to remove an invoice hold.

    Label

    Lines with Pending Action Indicator

  • lockedByBuyerFlag (boolean)

    Contains one of the following values: true or false. If true, then the buyer is currently working on one of the requisition lines and this prevents the requisition preparer from amending any of the other lines. If false, then the buyer is currently not working on any of the requisition lines and the requisition preparer can amend any of the lines.

    Label

    Locked by Buyer

  • pendingApprovalLinesFlag (boolean)

    Value that indicates that at least one line on the requisition is pending approval.

    Label

    Pending Approval Lines Indicator

  • rejectedLinesFlag (boolean)

    Value that indicates that at least one line on the requisition is rejected.

    Label

    Rejected Lines Indicator

  • rejectionReason (string)

    Reason for rejecting the requisition.

    Label

    Rejection Reason

  • requisition (string)

    Number that identifies the requisition. It's used to identify the requisition by end users.

    Label

    Requisition

    Properties

    • not nullable
  • requisitionHeaderId (int64)

    Value that uniquely identifies the requisition.

    Label

    Requisition Header ID

    Properties

    • searchable
    • sortable
    • not nullable
  • returnedLinesFlag (boolean)

    Value that indicate that at least one line on the requisition was returned by the buyer.

    Label

    Returned Lines Indicator

  • status (enumeration: DocumentStatus)

    Status of the requisition.

    Label

    Status

    Type

    • Module: oraProcurementCorePurchaseRequisitions

    • Enumeration Type: DocumentStatus

    Valid Values

    • APPROVED
    • CANCELED
    • INCOMPLETE
    • PENDING APPROVAL
    • REJECTED
    • RETURNED
    • WITHDRAWN
  • submissionDate (date-time)

    Date and time when the requisition was submitted for approval.

    Label

    Submission Date

  • taxAttributesUpdatedFlag (boolean)

    Indicates whether the user overrode the tax returned by the tax engine.

    Label

    Tax Attributes Updated

  • timeCreated (date-time)

    The date and time when the record was created.

    Label

    Creation Date

    Properties

    • searchable
    • sortable
    • not nullable
  • timeUpdated (date-time)

    The date and time when the record was last updated.

    Label

    Last Updated Date

    Properties

    • searchable
    • sortable
    • not nullable
  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • not nullable
  • withdrawnLinesFlag (boolean)

    Value that indicates that at least one line on the requisition was withdrawn by the requisition preparer.

    Label

    Withdrawn Lines Indicator

  Expand all

  Collapse all

  Reference Object

  • documentFiscalClassification (FiscalClassificationCodeHierarchy)

    The code used by a tax authority to represent classifications such as party fiscal classification, party site fiscal classification, product fiscal classification, transaction fiscal classification, and document fiscal classification.

    Business Object

    FiscalClassificationCodeHierarchy

    Expand all

    Collapse all

    Fields

    • concatenatedClassificationCode (string)

      The hierarchy of parent records where a specific fiscal classification code was defined in a hierarchical fiscal classification.

      Label

      Code Path

      Properties

      • searchable
      • sortable
      • not nullable

  • enteredBy (Worker)

    Value that uniquely identifies the user who created the requisition.

    Business Object

    Worker

    Expand all

    Collapse all

    Fields

    • id (int64)

      Unique identifier of person business object.

      Label

      Id

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • fundsOverrideApprover (Worker)

    Value that uniquely identifies the user who has the insufficient funds override authority for a requisition.

    Business Object

    Worker

    Expand all

    Collapse all

    Fields

    • id (int64)

      Unique identifier of person business object.

      Label

      Id

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • modifyingApprover (Worker)

    Value that uniquely identifies the user who's currently modifying the requisition during the approval process.

    Business Object

    Worker

    Expand all

    Collapse all

    Fields

    • id (int64)

      Unique identifier of person business object.

      Label

      Id

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • overridingApprover (Worker)

    Value that uniquely identifies the user specified on the requisition as the overriding approver for approval routing.

    Business Object

    Worker

    Expand all

    Collapse all

    Fields

    • id (int64)

      Unique identifier of person business object.

      Label

      Id

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • procurementBU (BusinessUnit)

    Value that uniquely identifies the Procurement Business Unit.

    Business Object

    BusinessUnit

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the business unit.

      Label

      Business Unit ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
      • overridable

  • rejectedByApprover (Worker)

    Value that uniquely identifies the person who rejected the requisition.

    Business Object

    Worker

    Expand all

    Collapse all

    Fields

    • id (int64)

      Unique identifier of person business object.

      Label

      Id

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable

  • requisitioningBU (BusinessUnit)

    Value that uniquely identifies the Requisitioning Business Unit.

    Business Object

    BusinessUnit

    Expand all

    Collapse all

    Fields

    • id (int64)

      The unique identifier of the business unit.

      Label

      Business Unit ID

      Properties

      • inherited
      • searchable
      • sortable
      • not nullable
      • overridable

  • soldToLegalEntity (LegalEntity)

    Value that uniquely identifies the sold to legal entity.

    Business Object

    LegalEntity

    Expand all

    Collapse all

    Fields

    • legalEntityId (int64)

      The unique identifier of the legal entity. This is the primary key of the Legal Entities view object.

      Label

      Legal Entity ID

      Properties

      • searchable
      • sortable
      • not nullable

  • taxationCountry (Territory)

    Default country used for taxation purposes.

    Business Object

    Territory

    Expand all

    Collapse all

    Fields

    • territoryCode (string)

      The unique code of the territory.

      Label

      Territory Code

      Properties

      • searchable
      • sortable
      • not nullable

Other Properties

Property	Value
Application Package Name	ora_procurement_core_purchaseRequisitions
Extensible	Yes

Back to Top