Tuesday, June 1, 2010

AP Payment Testing in R12

Your Ad Here



1) Login to Payables Manager and Navigate to Payments > Entry > Payments Manager


2) Click on Payment Process Request Tab and then click submit single request button. Specify PPR Name and fill all values and click on submit button. Alternatively, you can also create template with all values such as payment attributes, payment priority, pay thru days..etc and attach it while creating PPR. Once request is submitted, it submits program- Auto Select (Payment Process Request Program) in SRS window.

3) Go back to PPR tab and search for your request by name or date. Click on Refresh Status Button until Status=Invoices Pending Review and Start Action button turns green.


4) Click on Start Action, review payments and click on submit button. It ran multiple programs in SRS like- Scheduled Payment Selection Report, Build Payments and Format Payment Instructions

5) Go back to PPR tab again and search for your request. Click on Refresh Status Button until Status=Formatted.

6) Review the output file for Format Payment Instructions. It will be XML template output attached to
Data Definition=Oracle Payments Funds Disbursement Payment Instruction Extract 1.0

7) Finally Click on Start Action, choose printer and submit check for printing. Status will become Printed

Note:
AP Payment has been moved to new module in R12 called as iPayments. All base tables starts with IBY in R12. Below are the key tables in R12 for Payments


IBY_DOCS_PAYABLE_ALL
IBY_PAYMENTS_ALL
IBY_PAY_SERVICE_REQUESTS
IBY_PAY_INSTRUCTIONS_ALL
IBY_PMT_INSTR_USES_ALL
Your Ad Here

2 comments:

  1. Hi Amit,

    Thank you very much for this post. Now I am very much clear about this PPR Program.

    I am having an small issue, When we are submitting this it is erroring out with below Log file message.

    Could you please help me in this.

    +-------------------------------------------------------------------

    --------+
    Payables: Version : 12.0.0

    Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

    APXPBASL module: Payment Process Request Program
    +-------------------------------------------------------------------

    --------+

    Current system time is 18-AUG-2011 07:43:59

    +-------------------------------------------------------------------

    --------+

    **Starts**18-AUG-2011 07:43:59
    ORA-01403: no data found occurred in
    &CALLING_SEQUENCE
    with parameters (&PARAMETERS)
    while performing the following operation:
    &DEBUG_INFO
    +-------------------------------------------------------------------

    --------+
    Start of log messages from FND_FILE
    +-------------------------------------------------------------------

    --------+
    +-------------------------------------------------------------------

    --------+
    End of log messages from FND_FILE
    +-------------------------------------------------------------------

    --------+


    +-------------------------------------------------------------------

    --------+
    Executing request completion options...

    Output file size:
    0


    Output is not being printed because:
    The print option has been disabled for this report.


    Finished executing request completion options.

    +-------------------------------------------------------------------

    --------+
    Concurrent request completed
    Current system time is 18-AUG-2011 07:44:00

    +-------------------------------------------------------------------

    --------+

    ReplyDelete
  2. Hi Venu,
    I think you have not provided all required values while creating PPR.
    Flexfield $SRS$.APXPBASL is used for accepting parameters for concurrent program "Payment Process Request Program"

    ReplyDelete