Supply Chain Management - PSFT (MOSC)

MOSC Banner

FS_BP selects the requisition but does not process it.

edited Jul 1, 2015 9:23AM in Supply Chain Management - PSFT (MOSC) 3 commentsAnswered

Hi Team,

I am cancelling a requistion (ePRO) whose PO is already cancelled using the following query:

When I run the budget check, it goes to success with:

No documents were selected to process for request number 1.


Request 1 Statistics. Documents Processed: 0,  Errors: 0,  Warnings: 0.


Why is not picking the requisition for processing?

UPDATE PS_REQ_HDR SET REQ_STATUS = 'X', IN_PROCESS_FLG = 'N', ACTIVITY_DATE = SYSDATE, BUDGET_HDR_STATUS = 'N'

WHERE (BUSINESS_UNIT,REQ_ID) IN (('BU','REQID'))

AND REQ_STATUS NOT IN ('C','X');

UPDATE PS_REQ_LINE  SET CURR_STATUS = 'X'

WHERE (BUSINESS_UNIT,REQ_ID) IN (('BU','REQID'))

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center