Resp: AP Manager
Setup->Payment -> Payment Administrator
Search for Type: eText outbound and Application: Payment
Choose the appropriate std template file based on either Position or delimiter. The rtf file is modified to custom need. Before to that we shall understand the structure of the rtf file and the std xml data file.
XML data file is generated by the DTD: Oracle Payments Funds Disbursement Payment Instruction Extract 1.0
The outer most tag be OutboundPaymentInstruction
Below this we have
1. PaymentInstructionInfo
2. PaymentProcessProfile
3. PaymentFormat
4. CheckFormatInfo
5. InstructionTotals
6. InstructionGrouping
7. OutboundPayment.
Of which InstructionGrouping and OutboundPayment are of importance.
InstructionGrouping: Has information about the Payer and the Payer’s Bank details.
OutboundPayment: Has information on both the Payer and the Payee details with bank information. This node gets repeated based on the Payee information. One important Node under this being the
DocumentPayable: this node gets repeated for each invoice in the payment for that Payee.
Standard package ‘IBY_FD_EXTRACT_EXT_PUB’ has been provided to add any custom information that needs to appear in the XML data. Each function in the package should return XMLTYPE data.
The RTF file has sections appearing as tables
1. Format Setup: Has information about the RTF Template such as Template type: DELIMITER_BASED / FIXED_POSITION_BASED, Character set: UTF-8, Case conversion: Upper or can be left blank, New records character: Carriage return. It can also include description about Invalid Characters that might appear in the data.
2. Format Data Levels: Custom grouping
3. Sequences: Custom sequences that will be shown in the payment file.
4. Format Data Records: This is the body for the format. This might be defined differently for Position based & delimiter based. It defines the
Then for Delimiter based it shall have
'DATA' Element Tag or constant ‘ABC’ or blank ‘’
And for Position based
'DATA' Element Tag
The
Each line in the table represents the column that appears in the payment file. Common Format types for Number: ###.00 , ###
and Date: YYMMDD , HHMI , DD/MM/YYYY
Format operations do not work when Element tag are concated with constant values.
Further Conditions can be provided with If-Else conditions in the DATA column.
Eg: IF Currency IN (‘TWD’, ‘JPY’, ‘KRW’) THEN
ROUND(SUM(OutboundPayment/PaymentAmount/Value),0)
ELSE
SUM(OutboundPayment/PaymentAmount/Value)
END IF
Operations like Sum, Count can be applied for Levels that appear below any specified Tag.
Once RTF is ready follow these steps for Payment Profile Definition and Invoice Creation for Testing.
Payment Profile Definition:
The following steps will be followed to create ‘rtf’ template:
1. Nà Payments Setup Administrator -> Formats -> XML Publisher Format Templates -> Go to Task.
2. Create XML Publisher Template and attach the customized rtf to it.
Name XXX Domestic EFT Format
Code IBY_PAY_EFT_XXX_DFT
Application Payments
Data Definition Oracle Payments Funds Disbursement Payment Instruction Extract 1.0
Type eText – Outbound
Start Date SYSDATE
File
Language English
3. Create Payment Format. N-> Payments Setup Administrator -> Formats -> Formats -> Go to Task.
Code IBY_PAY_EFT_XXX_DFT
Name XXX Domestic EFT Format
Data Extract Oracle Payments Funds Disbursement Payment Instruction Extract, Version 1.0
XML Publisher Template XXX Domestic EFT Format
4. Create a Payment Process Profile. N -> Payments Setup Administrator -> Codes -> Payment Process Profiles -> Go to Task
Code IBY_PAY_EFT_XXX_DFT
Name XXX Domestic EFT Format
Payment Instruction Format XXX Domestic EFT Format
Output Payment File Prefix XXX_
Output Payment File Extn Txt
Output Payment File Directory /usr/tmp
5. Attach the new payment format created to the Bank Account. Below setup is example for attaching Payment format to Bank Account.
N -> Cash Management Super User -> Setup-> Banks -> Bank Accounts -> Query Bank -> Select Bank using Radio and Click on “Manage Payment Documents” button. Create Payment Process Profile using below table.
Name Electronic
Payment Document Category EFT PAY
Paper Stock Type Blank Stock
Format XXX Domestic EFT Format
First Available Document Number 100 (Can be any Number)
Invoice Creation:
Resp: AP Manager
Form: Invoice
Create new Invoice, Payment being ‘Immediate’. Enter the Invoice Lines and distribution details and Save.
Choose Action ->Validate
Choose Action -> Check Create Accounting (Final)
Resp: AP Manager
Form: Payment Manager
Tab: Payment Process Requests
Choose Submit single Payment Process Request
Specify Payment Process Request Name, Disbursement Bank Name, Payment document, Payment Profile Name, Exchange Rate Type: ‘Corporate’. Choose to Submit
Query for the Payment Process request, and Initiate action
Review the selected Payments, Identify the transaction to be Included (excluded/modified) in the Payment File. Save and Submit changes. Return to Payment Dashboard (Home) after submission confirmation is received.
Check Conc Prog: Format Payment Instructions with Text Output for payment details.
Output shall be also be generated at the location & prefix specified in the Payment Profile definition. If Output shows ‘???’, the line would have formatting errors.
