Another option to investigate:
Write a before-insert trigger on OE_HEADERS_IFACE_ALL and make booked_Flag ='N' for internal orders
Also write a before-insert trigger on oe_actions_iface_all to remove any BOOK action row Oracle is inserting.
BUT BE VERY CAREFUL.
By not booking the internal order, you are creating a mismatch between the supply-demand picture of the 2 orgs.
The DESTINATION org sees an approved requisition and hence assumes a confirmed supply.
The SOURCE org sees a ENTERED order and hence does not see a confirmed demand.
I would first check with the business why they want to leave the ISO in Entered status.
Hope this helps,
I realize this is an old thread but it is exactly what I have encountered.
I am able to import an internal Sales Order with a Status of Entered. However, I need to import these orders with a Status of Booked (we have no process for Booking Internal Sales Orders).
We are on 18.104.22.168 EBS on 10.2.0.4 DB.
We have multiple inventory orgs but we have only processed Internal order between two of them P Org to F Org. those internal Sales orders are imported with a Status of Booked.
However we need to have Internal Sales Order from P Org to N Org. When I import these internal Sales Orders they import with a Status of Entered.
As it works as expected in one Org but not the other, I believe it must be a Org setup issue.
Any suggestions on where to look?
, I agree that is should be impossible but i was setill getting Internal Sales orders with a Status of Entered.
I recloned and was not able to reproduce the problem. A few weeks later the problem reoccured. I checked for recent changes and found that another member of the team was testing changes to the Sales Tax Defaulting rules.
If you have a Bad Sales Tax rule, the Internal Order cannot book and has a status of entered. I figured I would just close the loop.
Thank you for your suggestions.