11i Payment Documents Do not Exist in R12--How to create the payment documents from 11i data

MOS:(Doc ID 549024.1)
11i Payment Documents Do not Exist in R12--How to create the payment documents from 11i data

Solution:

To create the records in CE_PAYMENT_DOCUMENTS, the custom format should be created in R12. Do the following: 

1. Create corresponding rtf template for the custom rdf format in ap_check_formats that was used in 11i. 

From Payables responsibility, navigate to Setup/Payments/Payment Administrator 
Payments Setup/Formats/XML Publisher Format Templates 
Click on Create Template 

2. Register the rtf template in Xml Publisher using XDO administrator resp 

3. Define Payment Format (corresponding to ap_payment_program) in Oracle Payments. 

From Payables responsibility, navigate to Setup/Payments/Payment Administrator 
Payments Steup/Formats/Formats 
Select Type: Disbursement Payment Instruction 
Click on Create 
Enter details and save. 
This should create a record in IBY_FORMATS_B 

4. Associate this new rtf template to the format. 

5. Using sqlplus, associate the IBY_FORMATS_B with ap payment program via reference_format_code column. 

To determine the ap Payment Program name to associate with the new IBY format created, do the following.

a) Determine the format payment program used by the 11i format.
Select format_payments_program_id
from ap_check_formats
where name = '&11i format name';
Note down the result.

Example:
Select format_payments_program_id
from ap_check_formats
where name = 'Long Check Format'
FORMAT_PAYMENTS_PROGRAM_ID
--------------------------
10002

b) Determine the program name relevant to this program id.
 select  program_name from ap_payment_programs
    where program_id = &id; ---> Id returned in previous sql.

Example:
select program_name from ap_payment_programs
where program_id = 10002;
PROGRAM_NAME
------------------------------
APXPBFEG


c) Now associate this short program_name to the R12 IBY format created in step 3.

UPDATE IBY_FORMATS_B 
SET Reference_format_code = '<ap program name>' 
WHERE format_code = '<Format_Code of Format created using IBY UI in step 3>' 
and reference_format_code is null; 

Example:
UPDATE IBY_FORMATS_B
SET Reference_format_code = 'APXPBFEG'
WHERE format_code = '<Format_Code of Format created using IBY UI in step 3>'
and reference_format_code is null; 

6. Execute the upgrade script ibypaydocupg.sql in Patch 15895924 
to create payment documents in CE_PAYMENT_DOCUMENTS table. 

Hope this is usefull

Regards,