Explain the conversion of holds done using API? What are the tables affected? what are the fields to be passed and to which base tables?
Submitted by: AdministratorThe tables effected are
oe_hold_definitions (contains hold name would be defined as apart of setup)
oe_hold_sources (hold applied info would be saved in this)
oe_order_holds (contins the hold info in this as well)
Data to be passed sales order header id order line id hold id (type of hold) hold code like OEOH means hold at the header level OEOL hold at the line level.
Submitted by: Administrator
oe_hold_definitions (contains hold name would be defined as apart of setup)
oe_hold_sources (hold applied info would be saved in this)
oe_order_holds (contins the hold info in this as well)
Data to be passed sales order header id order line id hold id (type of hold) hold code like OEOH means hold at the header level OEOL hold at the line level.
Submitted by: Administrator
Read Online General Oracle Job Interview Questions And Answers
Top General Oracle Questions
☺ | What is ONT stands for, as OE stands for Order Entry? |
☺ | Explain What should be done when sales order lines are closed but header is still in Booked status? |
☺ | Explain Order Management Flow in detail? |
☺ | Explain shipping process along with some screen shots? |
☺ | Explain What are the APIs used in Order Management? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Forms Reports Interview Questions. |