My Oracle Support Banner

PRC:SSP: Project Information Does Not Default on Requisition Line Due to Error: ORA-01722: Invalid Number (Doc ID 2626386.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Fusion Self Service Procurement Cloud Service - Version 11.13.19.10.0 and later
Oracle Fusion Self Service Procurement - Version 11.13.18.05.0 and later
Information in this document applies to any platform.

Symptoms

Cannot create a Requisition with Project Information because the Project information does not default on the Requisition.
The Project information is not coming into Procurement.

The error appears to be related to the Project Expenditure Type.

ERROR:

ORA-01722: invalid number

 

Steps to Reproduce:

1.  Procurement
2.  Purchase Requisitions
3.  More Tasks > Request non-catalog item
4.  Enter the information:
     -  category name
     -  item description
     -  UOM
     -  Price
     -  USD (Currency)
     -  Supplier name
     -  Supplier Site
5.  Add to cart
6.  Click on cart
7.  Review
8.  The charge account defaults
9.  The project number does not default
10. Enter the Project number
11. Expenditure type does not default
12. click Save
13. Error ORA-01722: invalid number
14. Enter Expenditure type > Save
15. ORA error appears again

 

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
References


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