Sales Order Lines Are Getting Stuck In Pricing Error Hold (Doc ID 2445678.1)

Last updated on JULY 29, 2020

Applies to:

Symptoms

After Ship Confirm, Sales Order Lines are getting stuck in 'Pricing Error Hold'.
These lines are not able to Invoice.


ERROR

Exiting OE_Flex_Cogs_Pub.Start_process : E
User-Defined Exception:80
  NO. OF OE MESSAGES :1
  RETURN STATUS FROM OE_FLEX_COGS_PUB.START_PROCESS IS E
  CONCAT_SEGS IS
  CONCAT_IDS IS
  CONCAT_DESCRS IS
  L_CONGS_RETURN_CCID IS
  Cost Of Goods Sold Account Generation Failed with error : ORA-20002: 3136: Item 'OECOGS/519090' cannot be accessed while synchronous process in progress.

  l_account ==> 328805
  Exiting WSH_SHIP_CONFIRM_ACTIONS.GET_ACCOUNT (08/31/2018 03:37:20 AM, 4.27 seconds)
  RET_STATUS:E ACCOUNT_ID:328805
Unable to get account for delivery detail id xxxxx
  Warning at line ==> XXXXX
  delivery_detail_id ==> xxxxx
  trx_interface_id ==> xXxXxX
  freight_code ==> <FREIGHT CODE>

...

  RETURN STATUS FROM OE_FLEX_COGS_PUB.START_PROCESS IS E
  CONCAT_SEGS IS
  CONCAT_IDS IS
  CONCAT_DESCRS IS
  L_CONGS_RETURN_CCID IS
  Cost Of Goods Sold Account Generation Failed with error : ORA-20002: 3136: Item 'OECOGS/519091' cannot be accessed while synchronous process in progress.
  

...

  RETURN STATUS FROM OE_FLEX_COGS_PUB.START_PROCESS IS E
  CONCAT_SEGS IS
  CONCAT_IDS IS
  CONCAT_DESCRS IS
  L_CONGS_RETURN_CCID IS
  Cost Of Goods Sold Account Generation Failed with error : ORA-20002: 3136: Item 'OECOGS/519093' cannot be accessed while synchronous process in progress.

  l_account ==> 328805
  Exiting WSH_SHIP_CONFIRM_ACTIONS.GET_ACCOUNT (08/31/2018 03:37:26 AM, 1.71 seconds)
  RET_STATUS:E ACCOUNT_ID:328805
Unable to get account for delivery detail id xxxxx
  Warning at line ==> xxxxx



STEPS
The issue can be reproduced at will with the following steps:
1. Ship confirm order

Cause

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