Total Pageviews

October 4, 2016

10/04/2016 02:50:00 AM
oracle apps Payments

Build Payments - Payments

Code: IBY_DISBURSE_SUBMIT_PUB_PKG

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: 
  1. CALL_AP_PAY_SERVICE_REQ_CODE -> PPR name 
  2. CALLING_APP_ID 
  3. PAYMENT_SERVICE_REQUEST_STATUS 
  4. INTERNAL_BANK_ACCOUNT_ID 
  5. MAXIMUM_PAYMENT_AMOUNT 
  6. MINIMUM_PAYMENT_AMOUNT 
  7. DOCUMENT_REJECTION_LEVEL_CODE 
  8. PAYMENT_REJECTION_LEVEL_CODE 
  9. REQUIRE_PROP_PMTS_REVIEW_FLAG 
  10. CREATE_PMT_INSTRUCTIONS_FLAG 



Some of the values for PAYMENT_SERVICE_REQUEST_STATUS in the table are
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’.