1 Reply Latest reply: Dec 11, 2012 2:46 AM by Ivruksha RSS

    Build payments error

    tlane
      I am trying to run a cheque payment batch but the Build payments request is erroring. I have run this successfully many times a month or so ago.

      I have tried searching metalink, on OTN and googling the error but no luck.

      Here is the log from the request:
      ---------------------------------------------------------------------------
      Payments: Version : 12.0.0

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

      IBYBUILD module: Build Payments
      ---------------------------------------------------------------------------

      Current system time is 10-DEC-2012 17:36:39

      ---------------------------------------------------------------------------

      **Starts**10-DEC-2012 17:36:40
      **Ends**10-DEC-2012 17:36:43
      BUILD PROGRAM ERROR - CANNOT COMPLETE CHECK NUMBERING
      ---------------------------------------------------------------------------
      Start of log messages from FND_FILE
      ---------------------------------------------------------------------------
      Enter Build :: Concurrent Request ID::4699011
      -----------------------------------------------------------------------------------------------------
      |STEP 1: Insert Payment Service Request:: Timestamp:10-DEC-12 05.36.40.324885000 PM +11:00|
      -----------------------------------------------------------------------------------------------------
      ----------------------------------------------------------------------------------------------------
      |STEP 2: Insert Documents :Timestamp:10-DEC-12 05.36.40.363742000 PM +11:00|
      ----------------------------------------------------------------------------------------------------
      --------------------------------------------------------------------------------------------------------
      |STEP 3: Account/Profile Assignment :Timestamp:10-DEC-12 05.36.42.262375000 PM +11:00|
      --------------------------------------------------------------------------------------------------------
      Request status after assignments: ASSIGNMENT_COMPLETE
      ----------------------------------------------------------------------------------------------------
      |STEP 4: Document Validation :Timestamp:10-DEC-12 05.36.42.305476000 PM +11:00|
      ----------------------------------------------------------------------------------------------------
      Request status after document validation: DOCUMENTS_VALIDATED
      --------------------------------------------------------------------------------------------------------
      |STEP 5: Document Re-Validation: Timestamp:10-DEC-12 05.36.42.425959000 PM +11:00|
      --------------------------------------------------------------------------------------------------------
      --------------------------------------------------------------------------------------------------
      |STEP 6: Payment Creation :Timestamp:10-DEC-12 05.36.42.427070000 PM +11:00|
      --------------------------------------------------------------------------------------------------
      Request status after payment creation: PAYMENTS_CREATED
      ---------------------------------------------------------------------------------------------------------------------
      |STEP 7: Payment Re-Creation:Timestamp:10-DEC-12 05.36.42.942589000 PM +11:00|
      ---------------------------------------------------------------------------------------------------------------------
      Final status of payment request 683 (calling app pay req cd: tdl chq 10-dec-12 #6) before exiting build program is PAYMENTS_CREATED
      --------------------------------------------------------------------------------------------------------------------------
      |STEP 8: Check PICP Kickoff Flag: Timestamp:10-DEC-12 05.36.42.945151000 PM +11:00|
      --------------------------------------------------------------------------------------------------------------------------
      --------------------------------------------------------------------------------------------------------------
      |STEP 9: Payment Instruction Creation :Timestamp:10-DEC-12 05.36.42.947062000 PM +11:00|
      --------------------------------------------------------------------------------------------------------------
      FV_FEDERAL_PAYMENT_FIELDS_PKG.GET_PAY_INSTR_SEQ_NUM: FV: Federal Enabled profile is not turned on
      Return status of payment instruction creation: S
      ----------------------------------------------------------------------------------------------------------
      |STEP 10: Check Numbering : Timestamp:10-DEC-12 05.36.43.441961000 PM +11:00|
      ----------------------------------------------------------------------------------------------------------
      After numbering, return status: E, and return message:
      Exception occured when numbering checks of payment instructions. Check numbering will be aborted ..
      SQLCODE: -20001
      SQLERRM: ORA-20001:
      Build program error: Exception occured when attempting to provide printed document numbers (check numbers) for the payments of the provided payment service request.
      ---------------------------------------------------------------------------
      End of log messages from FND_FILE
      ---------------------------------------------------------------------------


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

      Output file size:
      439


      Finished executing request completion options.

      ---------------------------------------------------------------------------
      Concurrent request completed
      Current system time is 10-DEC-2012 17:36:43

      ---------------------------------------------------------------------------
        • 1. Re: Build payments error
          Ivruksha
          Hi,

          Since you were able to run this successfully earlier, i would rule out the possibility of this being a BUG...

          The second most likely cause is that, the payment document used by this payment process request is also being used in another payment process request which is in incomplete status....So, make sure there are no other payment process requests pending apart from this one ... either complete those or terminate those...

          The Third cause is that, the payment document defined would have exhausted its sequence numbers, hence you should either increase the sequence or use a different payment document which has enough number of sequences available for generating checks...
          By sequence i am referring to the number of check leafs...

          If the above does not apply, then you would be better off logging a service request with oracle, as it could be something new which many are not aware of ...

          Regards,
          Ivruksha