" ORA-01722: invalid Number@2FM_FINANCIAL_POSTING_SQL.POST_AP_GL_FINANCIALS" Error During NF Cancellation
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.
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.
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