Order Management - EBS (MOSC)

MOSC Banner

R12 - When trying to pick release the order getting an below error message.Due to that not able to p

edited Aug 10, 2015 7:13AM in Order Management - EBS (MOSC) 3 commentsAnswered

Hi Support,

R12 - When trying to pick release the order by selecting specific locator getting an below error message.Due to that not able to pick release the Order.

Error message :

APP-FND-01564: ORACLE error 1422 in FDFGCD

Cause: FDFGCD failed due to ORA-01422: exact fetch returns more than requested number of rows.

The SQL statement being executed at the time of the error was: SELECT ENABLED_FLAG, SUMMARY_FLAG, NVL(TO_CHAR(START_DATE_ACTIVE, 'J'), 0),NVL(TO_CHAR(END_DATE_ACTIVE, 'J'), 0),SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, SEGMENT6, INVENTORY_LOCATION_ID FROM MTL_ITEM_LOCATIONS WHERE ORGANIZATION_ID = :num AND SEGMENT1 = :SEGMENT1 AND SEGMENT2 IS NULL AND SEGMENT3 IS NULL AND SEGMENT4 IS NULL AND SEGMENT5 IS NULL AND SEGMENT6 IS NULL AND ( (DISABLE_DATE > SYSDATE OR DISABLE_DATE IS NULL) AND NVL(SUBINVENTORY_CODE,'Z') = NVL(:FND_FLEX_WHERE_BIND_0,'Z') ) and was executed from the file &ERRFILE.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Order Mgmt Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center