E9.2 Issue Date format when orchestrator is call from application

[alfredorz]

Hi JDEFriends,

I have a problem with date format when orchestrator is call from application.

I've done a LEX for update F4072, I agregate EXDJ date as input parameters. I tested LEX as input date 31/12/2040 this formatted to 12/31/2040 and works fine.

I've done a orchestrator that call this LEX and when I execute orchestrator works fine with date format 31/12/2040 works fine.
For example as json input:

{
  "AddressNumber": "0",
  "CurrencyCodeFrom": "EUR",
  "DateExpiredJulian1": "31/12/2040",
  "IdentifierShortItem": "7580079",
  "PriceAdjustmentType": "NLDISP",
  "UnitOfMeasureAsInput": "EA",
  "QuantityMinimum": "10.0000",
  "CustomerGroup01": "DOV",
  "GroupCustomerPriceGp": "PRCHAUTH",
  "FactorValue": "60"
}

But when I associate this orchestrator to application (P4072), match grid parameters and execute this orchestrator from application doesn't work

I've activated debug log and the problem is date format, it pass the next json:

{
  "AddressNumber": "0",
  "CurrencyCodeFrom": "EUR",
  "DateExpiredJulian1": "2040-12-31",
  "IdentifierShortItem": "7580079",
  "PriceAdjustmentType": "NLDISP",
  "UnitOfMeasureAsInput": "EA",
  "QuantityMinimum": "10.0000",
  "CustomerGroup01": "DOV",
  "GroupCustomerPriceGp": "PRCHAUTH",
  "FactorValue": "60"
}

And this execute this json in orchestrator studio and doesn't work of course, but If i change date format to 31/12/2040 it works :O

Why from the application doesn't work??? Any workaround?

My user is configurated format as DME

We have tools 9.2.6.3.

Thanks! Best regards.

 

[alfredorz]

Solved: Fail me. I add inputs to orchestrator from LEX and I trusted. I check orchestrator input parameters and ExpirationDate was created as string, I've change to date format dd/mm/yyyy and now works fine! check logs and the format it's Ok! What a scary! :s

 

[DaveWagoner]

My favorite threads! Thanks for reporting back

 

[alfredorz]

My favorite threads! Thanks for reporting back

Yeah! But I have a question about it, not for this case but probably for other cases, what happens if in the company some user has configurated as format DME and others user in other countries for example MDE format. Would it respects the json format? or will be a problem?
Regards.