Following steps are needed to Create a New Payment Format in Oracle Payables R12 and associate it with Payment Document.
Step 1: Create XML Template
Payables Manager > Setup > Payment > Payment Administrator > Formats > XML Publisher Format Templates
Click 'Create Template'
Enter valid name, Code, Application (= Payments)
Type = RTF
Data Definition = Oracle Payments Funds Disbursement Payment Instruction Extract 1.0
Default File Language = English
Default File Territory = UNITED STATES
Upload your RTF File
Step 2: Create Payment Format
Payables Manager > Setup > Payment > Payment Administrator > Formats > Formats
Select Type = Disbursement Payment Instruction
Click on Create
Enter Code, NameType = Same as above
Data Extract = Oracle Payments Funds Disbursement Payment Instruction Extract 1.0
XML Publisher Extract = XML Template name created in Step 1
Step 3: Create Payment Document
Payables Manager > Setup > Payment > Bank Accounts
Query up your Bank Name. It is assumed that your Bank has already been setup in AP.
Select the Bank Account and click on Manage Payment Documents.
Click on Create
Enter:
Name: XXXX Check Payment Document
Paper Stock Type: Blank Stock or Prenumbered Stock
Format: Enter Format defined in step 2
First Available Document Number:
Last Available Document Number
Enter any other information that you may need.
Click Apply
Step 4: Create Payment Process Profile
Payables Manager > Setup > Payment > Payment Administrator > Payment Process Profiles
Click on Create
Enter:
Code
Name
Payment Instruction Format: As defined in Step 2
Processing Type: Printed
Payment Completion Point: When the Payment Instruction is Formatted
Default Payment Document: Document created in Step 3
Payment File: Send to Printer
Check the box ‘Automatically Print After Formatting’ (Note: You mau choose not to check this box initially – it will help in testing)
Default Printer: Valid oracle printer name
Click Apply
For making Payments use the above created Payment Process profile
at erp, erp, oracleapps, oracleapps erp, oracle erp, oracle ebusiness, oracle application,
about oracle, oracle developer, oracle jobs, finance software, finance accounting accounting, r12 oracle, what is oracle database, oracle database, Oracle 11g, 11g database
.
Step 1: Create XML Template
Payables Manager > Setup > Payment > Payment Administrator > Formats > XML Publisher Format Templates
Click 'Create Template'
Enter valid name, Code, Application (= Payments)
Type = RTF
Data Definition = Oracle Payments Funds Disbursement Payment Instruction Extract 1.0
Default File Language = English
Default File Territory = UNITED STATES
Upload your RTF File
Step 2: Create Payment Format
Payables Manager > Setup > Payment > Payment Administrator > Formats > Formats
Select Type = Disbursement Payment Instruction
Click on Create
Enter Code, NameType = Same as above
Data Extract = Oracle Payments Funds Disbursement Payment Instruction Extract 1.0
XML Publisher Extract = XML Template name created in Step 1
Step 3: Create Payment Document
Payables Manager > Setup > Payment > Bank Accounts
Query up your Bank Name. It is assumed that your Bank has already been setup in AP.
Select the Bank Account and click on Manage Payment Documents.
Click on Create
Enter:
Name: XXXX Check Payment Document
Paper Stock Type: Blank Stock or Prenumbered Stock
Format: Enter Format defined in step 2
First Available Document Number:
Last Available Document Number
Enter any other information that you may need.
Click Apply
Step 4: Create Payment Process Profile
Payables Manager > Setup > Payment > Payment Administrator > Payment Process Profiles
Click on Create
Enter:
Code
Name
Payment Instruction Format: As defined in Step 2
Processing Type: Printed
Payment Completion Point: When the Payment Instruction is Formatted
Default Payment Document: Document created in Step 3
Payment File: Send to Printer
Check the box ‘Automatically Print After Formatting’ (Note: You mau choose not to check this box initially – it will help in testing)
Default Printer: Valid oracle printer name
Click Apply
For making Payments use the above created Payment Process profile
at erp, erp, oracleapps, oracleapps erp, oracle erp, oracle ebusiness, oracle application,
about oracle, oracle developer, oracle jobs, finance software, finance accounting accounting, r12 oracle, what is oracle database, oracle database, Oracle 11g, 11g database
.
7 comments:
Hi,
I am creating bank account and payment document with the format attached. But while querying from AP Disbursements i am able to query the account but the payment document is not populating. Please help.
I am creating bank account and payment document with the format attached. But while querying from AP Disbursements i am able to query the account but the payment document is not populating. Please help.
Hai Sarayu km,
Did you got the solution regards this.
I implemented the same thing as you have explained and it just worked fine. A big thanks to you for explaining and posting the complete code.
oracle r12 documentation
Hi Dear,
Thank you for your post.
I have to implement payment instruction file to Bank. And the file has to be SFTP to Bank server.
Could you please suggest me in porting the PIF to bank server.
Thanks,
Jitin
Hi! This is my first visit to your blog! We are a team of volunteers and new initiatives in the same niche. Blog gave us useful information to work. You have done an amazing job! healthy energy drink
The great service in this blog and the nice technology is visible in this blog. I am really very happy for the nice approach is visible in this blog and thank you very much for using the nice technology in this blog
CONTRACTS
Post a Comment