Skip to main content
Solved

ORA-20181: ReserveCustomerOrders.ACCESS_FAILURE


Forum|alt.badge.img+4

Im using aurena 10 app and im trying to invoke /int/ifsapplications/projection/v1/CustomerOrderHandling.svc with bellow json payload

{

"OrderNo": "xxxxxxx",

"LineNo": "1",

"RelNo": "1",

"LineItemNo": 0,

"FormSource": "0",

"SourceId": 1

}

 

and i get bellow response
 

{

    "error": {

        "code": "DATABASE_ERROR",

        "message": "Database error occurred. Contact administrator.",

        "details": [

            {

                "code": 20181,

                "message": "ORA-20181: CustomerOrderHandling.ACCESS_FAILURE: Arguments used to execute current operation are not allowed."

            }

        ]

    }

}

 

can anyone help with this please ?

Best answer by Marcel.Ausan

@Roshan0001 what exactly are you trying to do? Reservation is not done from CustomerOrderHandling.

 

  • Reserve full CO:

ifs.cloud/main/ifsapplications/projection/v1/ReserveCustomerOrders.svc/ReserveOrder

Payload: {"Selection":"ORDER_NO=R100129^"}

  • Reserve CO Line

ifs.cloud/main/ifsapplications/projection/v1/ReserveCustomerOrderLines.svc/ReserveOrder

View original
Did this topic help you find an answer to your question?

4 replies

Marcel.Ausan
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • 1143 replies
  • Answer
  • December 6, 2023

@Roshan0001 what exactly are you trying to do? Reservation is not done from CustomerOrderHandling.

 

  • Reserve full CO:

ifs.cloud/main/ifsapplications/projection/v1/ReserveCustomerOrders.svc/ReserveOrder

Payload: {"Selection":"ORDER_NO=R100129^"}

  • Reserve CO Line

ifs.cloud/main/ifsapplications/projection/v1/ReserveCustomerOrderLines.svc/ReserveOrder


Forum|alt.badge.img+4
  • Author
  • Sidekick
  • 10 replies
  • December 6, 2023

@Marcel.Ausan

Thank you for the comment

 

my payload is 

 

{

"Selection": "ORDER_NO=B1102330"

}


still same error,

{

    "error": {

        "code": "DATABASE_ERROR",

        "message": "Database error occurred. Contact administrator.",

        "details": [

            {

                "code": 20181,

                "message": "ORA-20181: ReserveCustomerOrders.ACCESS_FAILURE: Arguments used to execute current operation are not allowed."

            }

        ]

    }

}

I’m spending 2 days with this error

Can you help me to understand this message please

 

Forum|alt.badge.img+4
  • Author
  • Sidekick
  • 10 replies
  • December 6, 2023

@Marcel.Ausan 

Found the answer, i miss the ā€œ^ā€ character after the order number.

Thank you for the guidance. 


Marcel.Ausan
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • 1143 replies
  • December 6, 2023

@Roshan0001 glad I could help!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings