Distribution - JDE1 (MOSC)

MOSC Banner

How to get a held sales order when it happens (or almost when it happens)

edited Nov 10, 2015 1:35AM in Distribution - JDE1 (MOSC) 2 commentsAnswered ✓

I need the sales orders that are held with C1 near real time.

I am having an external application that has to check if an order is held. F4209 cannot help me becuase the time field is being filled in when someone releases the order.

Then i have 2 options i have thgouht of: F4201 and F98860

From F4201 i could get the time of record updated but i dont think it is 100% safe

F98860: i could check there for any new record based on start or end time field. Then i would get the PIISTKEY , and get the sales order , and then the rest would be easy...

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

E1 Distribution 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