" ORA-01722: invalid Number@2FM_FINANCIAL_POSTING_SQL.POST_AP_GL_FINANCIALS" Error During NF Cancellation

(Doc ID 2312119.1)

Last updated on OCTOBER 02, 2017

Applies to:

Oracle Retail Fiscal Management - Version 14.1.3 and later
Information in this document applies to any platform.

Symptoms

During NF Cancellation process,below error received :

"ORA-01722: invalid Number@2FM_FINANCIAL_POSTING_SQL.POST_AP_GL_FINANCIALS"


Steps To Reproduce :
1. Approve NF.
2. Ensure that there is an existing supplier using the same id as the "location_id" for the location (wh/store) in the NF. Example NF location ID is a store with the id "1234", ensure there is a supplier with this same id.
3. For this supplier, fill some text characters in the "external_ref_id" field.
4. Submit this NF for cancellation,and note the error.

Changes

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms