Build Payments - Payments
Code: IBY_DISBURSE_SUBMIT_PUB_PKG
Build Payments will create a record in IBY_PAY_SERVICE_REQUESTS
Build Payments will create a record in IBY_PAY_SERVICE_REQUESTS
with call_app_pay_service_req_code = checkrun_name.
Primary Key: PAYMENT_SEVICE_REQUEST_ID
Key Columns:
Primary Key: PAYMENT_SEVICE_REQUEST_ID
Key Columns:
- CALL_AP_PAY_SERVICE_REQ_CODE -> PPR name
- CALLING_APP_ID
- PAYMENT_SERVICE_REQUEST_STATUS
- INTERNAL_BANK_ACCOUNT_ID
- MAXIMUM_PAYMENT_AMOUNT
- MINIMUM_PAYMENT_AMOUNT
- DOCUMENT_REJECTION_LEVEL_CODE
- PAYMENT_REJECTION_LEVEL_CODE
- REQUIRE_PROP_PMTS_REVIEW_FLAG
- CREATE_PMT_INSTRUCTIONS_FLAG
Some of the values for PAYMENT_SERVICE_REQUEST_STATUS in the table are
PAYMENT_SERVICE_REQUEST_STATUS
------------------------------
PAYMENT_SERVICE_REQUEST_STATUS
------------------------------
- DOCUMENTS_VALIDATED
- INFORMATION_REQUIRED
- INSERTED
- PAYMENTS_CREATED
- PENDING_REVIEW
- TERMINATED
- VALIDATION_FAILED
The build program populates the IBY_DOCS_PAYABLE_ALL table with the payments. Link to the payment service request table is through PAYMENT_SERVICE_REQUEST_ID.
Key Columns:
- Payment_service_request_id
- Calling_app_doc_ref_number -> invoice_number
- Document_payable_id
- Document_status
- Payment_currency_code
- Payment_amount
- Document_amount
- Exclusive_payment_flag
- Payment_method_code
- Payment_id
- Formatting_payment_id
- Ext_payee_id
- Payee_party_id
- Payment_profile_id
- Internal_bank_account_id
- Calling_app_doc_unique_ref2 -> invoice_id
- Calling_app_doc_unique_ref3 -> payment number
a) Internal Bank Account/Payment Process Profile Assignment:
Code: IBY_ASSIGN_PUB
If the payment process request has the internal bank account and payment profile assigned to it, the same is assigned to all the documents in the PPR.
If a default internal bank account and PPP were not provided when submitting the PPR, Oracle Payments attempts to default the values. If it cannot find a default value for all the documents, the PPR is set to INFORMATION REQUIRED status. The display status of the PPR is “Information Required - Pending Action”
User should complete the missing information and Run Payment Process to continue.
b) Document Validation
Code: IBY_VALIDATIONSETS_PUB
During this step, Oracle Payments validates all the documents using Payment Method based validations and then payment format based validations..
b.1 - If all the documents pass validation, all the documents are set to a status of VALIDATED and the request status is set to ‘Documents Validated’.
