IBY_PAY_SERVICE_REQUESTS
IBY_PAY_SERVICE_REQUESTS stores payment process requests from source products. A payment process request is a group of documents payable that a source product submits to Oracle Payments for payment service processing. This table corresponds to the Payment Process Requests page.
Details
-
Schema: FUSION
-
Object owner: IBY
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
IBY_PAY_SERVICE_REQUESTS_PK |
PAYMENT_SERVICE_REQUEST_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PAYMENT_SERVICE_REQUEST_ID | NUMBER | 18 | Yes | System-generated primary key. | |
| CALLING_APP_ID | NUMBER | 18 | Yes | Source product Identifier | |
| CALL_APP_PAY_SERVICE_REQ_CODE | VARCHAR2 | 255 | Yes | Source product's payment process request identifier. | |
| PAYMENT_SERVICE_REQUEST_STATUS | VARCHAR2 | 30 | Yes | Payment process request status. Values from the lookup IBY_REQUEST_STATUSES include PAYMENTS_CREATED. | |
| PROCESS_TYPE | VARCHAR2 | 30 | Yes | Specifies the process by which documents payable are built into payments and payments into payment instructions. Values from the lookup IBY_PROCESS_TYPES include STANDARD, IMMEDIATE, and MANUAL. | |
| ALLOW_ZERO_PAYMENTS_FLAG | VARCHAR2 | 1 | Yes | Yes or No flag that indicates whether zero payments are allowed for this payment request. If set to No, any zero value payments created for this payment request will be failed. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| INTERNAL_BANK_ACCOUNT_ID | NUMBER | 18 | Internal bank account identifier | ||
| PAYMENT_PROFILE_ID | NUMBER | 18 | Payment process profile Identifier. This is mandatory if COMPLETE_INSTRUCTION_FLAG is Y. | ||
| MAXIMUM_PAYMENT_AMOUNT | NUMBER | Maximum payment amount used to override default maximum payment amount | |||
| MINIMUM_PAYMENT_AMOUNT | NUMBER | Minimum payment amount used to override default minimum payment amount | |||
| DOCUMENT_REJECTION_LEVEL_CODE | VARCHAR2 | 30 | Specifies what is rejected if a document payable fails validation. Values from the IBY_DOCUMENT_REJECTION_LEVELS lookup include REQUEST, PAYEE, and DOCUMENT. | ||
| PAYMENT_REJECTION_LEVEL_CODE | VARCHAR2 | 30 | Specifies how much of a payment process request is rejected if a payment fails validation. Values from the IBY_PAYMENT_REJECTION_LEVELS lookup include REQUEST, PAYMENT, and NONE. | ||
| REQUIRE_PROP_PMTS_REVIEW_FLAG | VARCHAR2 | 1 | Flag indicating whether Oracle Payments should stop the payment creation flow to allow an administrator to review and modify proposed payments before grouping them into payment instructions. Values from the lookup IBY_PROPOSED_PMTS_REVIEW_CODES include Y and N. | ||
| ORG_TYPE | VARCHAR2 | 30 | Organization type, such as business unit. Values taken from lookup: IBY_ORGANIZATION_TYPES | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| CREATE_PMT_INSTRUCTIONS_FLAG | VARCHAR2 | 1 | Flag indicating whether the Build Payments program automatically kicks off the Create Payment Instructions program after payment build completes. | ||
| PAYMENT_DOCUMENT_ID | NUMBER | 18 | Stores the payment document Identifier on which the payment instructions created from the payments of this request are printed. This parameter is only applicable where the Build Payments program kicks off the Create Payment Instructions program. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| NOTIFICATION_MESSAGE_ID | NUMBER | 18 | Notification message identifier. | ||
| PAYMENT_MODE_CODE | VARCHAR2 | 30 | Invoice payment mode identifier. | ||
| PAYMENT_INSTRUMENT_ID | NUMBER | 18 | Funding instrument used for making payments. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| IBY_PAY_SERVICE_REQUESTS | ce_bank_accounts | INTERNAL_BANK_ACCOUNT_ID |
| IBY_PAY_SERVICE_REQUESTS | iby_acct_pmt_profiles_b | PAYMENT_PROFILE_ID |
| iby_payments_all | iby_pay_service_requests | PAYMENT_SERVICE_REQUEST_ID |
| iby_documents_payable_h | iby_pay_service_requests | PAYMENT_SERVICE_REQUEST_ID |
| iby_docs_payable_all | iby_pay_service_requests | PAYMENT_SERVICE_REQUEST_ID |
| iby_pay_instructions_all | iby_pay_service_requests | PAYMENT_SERVICE_REQUEST_ID |
| iby_payments_h | iby_pay_service_requests | PAYMENT_SERVICE_REQUEST_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| IBY_PAY_SERVICE_REQUESTS_N1 | Non Unique | Default | INTERNAL_BANK_ACCOUNT_ID |
| IBY_PAY_SERVICE_REQUESTS_N2 | Non Unique | Default | PAYMENT_PROFILE_ID |
| IBY_PAY_SERVICE_REQUESTS_N3 | Non Unique | Default | PAYMENT_SERVICE_REQUEST_STATUS |
| IBY_PAY_SERVICE_REQUESTS_N4 | Non Unique | Default | UPPER("CALL_APP_PAY_SERVICE_REQ_CODE") |
| IBY_PAY_SERVICE_REQUESTS_U1 | Unique | Default | PAYMENT_SERVICE_REQUEST_ID |
| IBY_PAY_SERVICE_REQUESTS_U2 | Unique | Default | CALLING_APP_ID, CALL_APP_PAY_SERVICE_REQ_CODE |