This discussion is archived
3 Replies Latest reply: Dec 12, 2013 7:39 AM by CraigB RSS

New Order Type in a custom form

379746 Newbie
Currently Being Moderated

Hi All,

I have a custom form for scheduling trucks for shipping orders. I defined a new order type under a new organization and am having issues querying this new order type in this custom form. The data in this custom form comes from a view based on standard Order Management Tables.

When I explicitly set the dbms_application_info.set_client_info('org_id') in TOAD and run the query from the view definition, I can see the new order type. But when I try from the form, the new order type that I defined doesn't show up.

I checked the form triggers and no where there is the org initialized.

The application version is 11.5.9.

Forms version is :6.0.8.25.2

Database version is 9.2.0.6.

Can anyone please help with the resolution of the problem.

Thanks

A/A

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points