Tuesday, July 17, 2012

Oracle Apps: R12 Payment Document Setup

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

.

5 comments:

sarayu km said...

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.

sarayu km said...

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.

vimal RM said...

Hai Sarayu km,

Did you got the solution regards this.

Andrea said...

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

Jithendra Kumar B said...

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