PayablesInvoiceHold
The invoice hold provides details regarding holds imposed on a supplier invoice by either end users or the Oracle Payables application. It includes details such as hold date, hold reason, release reason, line held, hold resolution status, and so on.
Business Views
** Available for extracting data- payablesInvoiceHoldsExtract**
The invoice hold provides details regarding holds imposed on a supplier invoice by either end users or the Oracle Payables application. It includes details such as hold date, hold reason, release reason, line held, hold resolution status, and so on.
Label, Plural Label
Payables Invoice Holds, Payables Invoice Holds
Data Source
Read-optimized data store
Fields
- createdBy (string)
The user who created the record.
Label
Created By
Properties
- not nullable
- heldBy (string)
The user that placed the hold on the invoice.
Label
Invoice Held By
Properties
- not nullable
- holdDate (date-time)
The date when the user placed the hold on the invoice.
Label
Date
Properties
- not nullable
- holdDetails (string)
The details of the hold placed on the invoice.
Label
Invoice Hold Details
- holdId (int64)
The unique identifier of the hold placed on the invoice. This is the primary key of the Invoice Holds view object.
Label
Hold ID
Properties
- searchable
- sortable
- not nullable
- holdReason (string)
The reason for the hold being placed on the invoice.
Label
Invoice Hold Reason
- holdStatus (enumeration: HoldStatus)
Indicates the status of the invoice hold. Possible values are null, R and S. A value of R indicates a system hold that has been released. A value of S indicates a system hold that hasn't been released. Null value indicates a user placed hold.
Label
Hold Status
Type
-
Module: oraErpCorePayablesInvoices
-
Enumeration Type: HoldStatus
Valid Values
- R
- S
-
- releaseReason (string)
The reason for the release being placed on invoice.
Label
Release Reason
- responsibilityIdentifier (int64)
The identifier of the responsibility associated with the Insufficient Funds hold.
- timeCreated (date-time)
The date and time when the record was created.
Label
Creation Date
Properties
- searchable
- not nullable
- timeUpdated (date-time)
The date and time when the record was last updated.
Label
Last Updated Date
Properties
- searchable
- not nullable
- updatedBy (string)
The user who last updated the record.
Label
Last Updated By
Properties
- not nullable
Reference Object
- businessUnit (BusinessUnit)
A business unit represents a unit of an enterprise that performs one or more business functions and may have service provider relationships between the units. It typically focuses on a specific market segment, product line, geographic region, or set of services. The business transactions are recorded, reported, and accounted against the business unit.
Business Object
BusinessUnitFields
- id (int64)
The unique identifier of the business unit.
Label
Business Unit ID
Properties
- inherited
- searchable
- sortable
- not nullable
- overridable
- id (int64)
- consumptionAdviceLine (ConsumptionAdviceLine)
The identifier of the consumption advice line that the hold is associated with.
Business Object
ConsumptionAdviceLineFields
- lineId (int64)
Value that uniquely describes the consumption advice line ID.
Label
Line ID
Properties
- searchable
- sortable
- not nullable
- lineId (int64)
- holdType (ERPLookupCode)
The name of the hold that's applied on the invoice. A list of accepted values is defined in the lookup type HOLD TYPE.
Business Object
ERPLookupCodeFields
- lookupCode (string)
The unique identifier of the Lookup Code.
Label
Lookup Code ID
Properties
- inherited
- searchable
- sortable
- not nullable
- lookupType (string)
The unique identifier of the Lookup Type.
Label
Lookup Type ID
Properties
- inherited
- searchable
- sortable
- not nullable
- meaning (string)
The translated meaning of the Lookup Code.
Label
Lookup Code Meaning
Properties
- inherited
- translatable
- not nullable
- lookupCode (string)
- invoiceHeader (PayablesInvoiceTransaction)
The unique identifier of the invoice against which the hold is placed. This is a foreign key of the Invoices view object.
Business Object
PayablesInvoiceTransactionFields
- invoiceId (int64)
The unique identifier of the invoice that's generated while creating the invoice.
Label
Invoice ID
Properties
- searchable
- sortable
- not nullable
- invoiceNumber (string)
The unique number for supplier invoice.
Label
Invoice Number
Properties
- searchable
- sortable
- not nullable
- invoiceTypeDiscriminator (string)
The discriminator to distinguish Payables Invoice and Payment Request subtypes.
Label
Discriminator
Properties
- creatable
- searchable
- sortable
- not nullable
- updatable
- invoiceId (int64)
- invoiceHoldResolutionWorkflowStatus (ERPLookupCode)
The holds resolution workflow status for the invoice hold. A list of possible values is defined in the lookup type HOLD_WORKFLOW_STATUS.
Business Object
ERPLookupCodeFields
- lookupCode (string)
The unique identifier of the Lookup Code.
Label
Lookup Code ID
Properties
- inherited
- searchable
- sortable
- not nullable
- lookupType (string)
The unique identifier of the Lookup Type.
Label
Lookup Type ID
Properties
- inherited
- searchable
- sortable
- not nullable
- meaning (string)
The translated meaning of the Lookup Code.
Label
Lookup Code Meaning
Properties
- inherited
- translatable
- not nullable
- lookupCode (string)
- invoiceLine (PayablesInvoiceLine)
The line number of the invoice line against which the hold is applied.
Business Object
PayablesInvoiceLineFields
- invoiceId (int64)
The unique invoice identifier that's generated while creating an invoice. This attribute is part of the primary key for the Invoice Lines view object.
Label
Invoice ID
Properties
- searchable
- sortable
- not nullable
- lineNumber (int64)
The unique number for the invoice line. This attribute is part of the primary key for the Invoice Lines view object.
Label
Number
Properties
- searchable
- sortable
- not nullable
- invoiceId (int64)
- purchaseOrderSchedule (OrderSchedule)
Shipping and delivery details for the ordered items such as promised delivery date, requested delivery date, and ship-to location.
Business Object
OrderScheduleFields
- scheduleId (int64)
Value that uniquely identifies the document shipment schedule.
Label
Schedule ID
Properties
- searchable
- sortable
- not nullable
- scheduleId (int64)
- receivingTransaction (ReceivingTransaction)
The unique identifier of the receipt that this hold is associated with.
Business Object
ReceivingTransactionFields
- id (int64)
Value that uniquely describes the receiving transaction.
Label
ID
Properties
- searchable
- sortable
- not nullable
- id (int64)
- releaseType (ERPLookupCode)
The release name that released the hold on the invoice. A list of accepted values is defined in the lookup type HOLD TYPE.
Business Object
ERPLookupCodeFields
- lookupCode (string)
The unique identifier of the Lookup Code.
Label
Lookup Code ID
Properties
- inherited
- searchable
- sortable
- not nullable
- lookupType (string)
The unique identifier of the Lookup Type.
Label
Lookup Type ID
Properties
- inherited
- searchable
- sortable
- not nullable
- meaning (string)
The translated meaning of the Lookup Code.
Label
Lookup Code Meaning
Properties
- inherited
- translatable
- not nullable
- lookupCode (string)
- createdBy (string)