Payment Process Profile Setup Queries

Payment Process profiles are manually setup by your Functional Consultants from the Payables's Administration Form.

To verify if the setups are correctly performed, you can use the below queries

-- XML Template Verification Script
select * from xdo_lobs
order by creation_date desc


--Check Payment Format Setup
 SELECT * FROM apps.IBY_FORMATS_B
  where format_code in ('<NAME_OF_FORMAT>') 
 
 
-- Check Payment Format Validation Setup
select b.assignment_entity_id, a.* from apps.IBY_VALIDATION_VALUES a , IBY_VAL_ASSIGNMENTS b
where a.validation_Assignment_id = b.validation_Assignment_id
and assignment_entity_id in ('<NAME_OF_FORMAT>')  
 order by 1,2, val_param_varchar2_value
  

--Check Payment Transmission Configuration Setup
SELECT *
  FROM iby_transmit_values transmitvalueseo,
       iby_transmit_parameters_vl PARAMETERS,
       iby_transmit_configs_vl transmit_config,
       fnd_lookups
 WHERE transmitvalueseo.transmit_parameter_code =
                                            PARAMETERS.transmit_parameter_code
   AND transmitvalueseo.transmit_configuration_id =
                                     transmit_config.transmit_configuration_id
   AND transmit_config.transmit_protocol_code =
                                             PARAMETERS.transmit_protocol_code
   AND NVL (PARAMETERS.dynamic_flag, 'N') <> 'Y'
   AND lookup_type = 'IBY_PARAMETER_TYPES'
   AND lookup_code = transmit_parameter_type
      and transmit_configuration_name like '%<NAME>%'
   order by transmitvalueseo.creation_date desc, display_order

                 
--Check Payment Process Profile Setup           
    SELECT *FROM apps.IBY_SYS_PMT_PROFILES_VL where system_profile_code in ('<NAME_OF_PROFILE>')  

--Payment Process Profile Usage Rules
   select * from IBY_APPLICABLE_PMT_PROFS
   where system_profile_code in ('<NAME_OF_PROFILE>')  
   order by 1 desc


 --Check Bank Account Setup
     select * from apps.ce_bank_Accounts
                order by last_update_Date desc 

 --Check Payment Document Setup
 select * from ce_payment_documents
  where format_code in ('<NAME_OF_FORMAT>')  
 order by creation_DAte desc

 --Business Payment Template Query
    select * from apps.AP_PAYMENT_TEMPLATES
 order by creation_date desc