My Oracle Support Banner

R12 Format Payment Instructions Formatting In Error APP-FND-01564: ORACLE error -936 (Doc ID 2558012.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Payables - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

On : 12.2 version, Setup Issue On Payments

Format Payment Instructions Formatting in Error


ERROR - On Format Payment Instruction Log
-----------------------
Output XXX.out deleted successfully
oracle.apps.iby.exception.PSException: An error has occured while updating instruction and payment statuses and marking them as complete.
at oracle.apps.iby.scheduler.FDExtractAndFormatting.postResults(FDExtractAndFormatting.java:580)
at oracle.apps.iby.scheduler.FDExtractAndFormatting.runMainLogic(FDExtractAndFormatting.java:335)
at oracle.apps.iby.scheduler.FDExtractAndFormatting.runProgram(FDExtractAndFormatting.java:159)
at oracle.apps.fnd.cp.request.Run.main(Run.java:156)

ERROR - On FND Debug Log
-----------------------

AP.PLSQL.AP_PMT_CALLOUT_PKG..assign_sequences - FND_SEQNUM.Get_Seq_Info returned succesfully
APP-FND-01564: ORACLE error -936 in get_next_auto_seq

Cause: get_next_auto_seq failed due to ORA-00936: missing expression.

The SQL statement being executed at the time of the error was: select .nextval into :next_val from sys.dual and was executed from the file AFSQNUMB.pls.
ERROR Code : -20001
ERROR Msg : ORA-20001: APP-FND-01564: ORACLE error -936 in get_next_auto_seq

Cause: get_next_auto_seq failed due to ORA-00936: missing expression.

The SQL statement being executed at the time of the error was: select .nextval into :next_val from sys.dual and was executed from the file AFSQNUMB.pls.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Setup : Sequential Numbering - Profile (from System Administrator) is set to Always Used

Document Category is assigned at Payment Method Level for Disbursement Bank Account used to create payments. 


2. Using Payables Responsability -> Submit new PPR


3. PPR stuck in Formatting and bellow message error can be found in Format Payment Instruction log


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create payment batches

Changes

 

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
Changes
Cause
Solution
 Standard Patching Process
 Patch Wizard
 Have more questions?
References


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