My Oracle Support Banner

R12: AP/IBY: Periodic Sequence is not Incrementing Between Payment Process Requests (Doc ID 2927185.1)

Last updated on FEBRUARY 09, 2023

Applies to:

Oracle Payments - Version 12.0.0 and later
Oracle Payables - Version 12.0.0 and later
BI Publisher (formerly XML Publisher) - Version 12.0 and later
Information in this document applies to any platform.

Symptoms

A periodic sequence has been set in the template and in the payment process profile, the output shows the current value of the sequence but the value is not incremented between runs.

To setup a periodic sequence in a template:

  1. In Payables navigate to Setup -> Payment -> Payment Administrator -> XML Publisher Templates
  2. Pull up the template in question
  3. Click download
  4. Open the file in Word
  5. Enter a period sequence section

    <DEFINE SEQUENCE> SomeSequenceName
    <RESET AT LEVEL> PERIODIC_SEQUENCE
    <INCREMENT BASIS> LEVEL
    <START AT> /OutboundPaymentInstruction/PaymentInstructionInfo/PaymentSequence[SequenceName=’SomeSequenceName’]/LastValue+1
    <MAXIMUM> 99999
    <END DEFINE SEQUENCE> SomeSequenceName
  6. Save
  7. Click upload on the payment screen and upload the modified template

To setup a periodic sequence in a Payment Process Profile:

  1. In Payables navigate to Setup -> Payment -> Payment Administrator -> Payment Process Profile
  2. Pull up the Payment Process Profile in question
  3. On the "Payment System" tab enter in a valid payment system
  4. On the "Payment Format" tab fill in the sequence name
  5. Fill in a reset value
  6. Fill in a last used value

To run a Payment Process Request

  1. In Payables navigate to Payments -> Entry -> Payment Manager
  2. Click "Submit a single Payment Process Request"
  3. Fill out the parameters as needed
  4. Submit

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.