Do you have any kind of example/blog/tutorial to implement the custom Role based functionality for the Users (from users table) so particular users can only have an access to certain pages or page component (say Button) based on user role. We can have user role like Super User or Admin, Manager, Clerk and User. Your help and support would be greatly appreciated. Kind Regards, Bhavin Adhvaryu
Discy Latest Questions
Hello Sir, How can I preserve the checkbox in an Interactive Report with Select All option (eg, Report on EMP table). Once selected then need to load the selected rows into a new table (EMP_NEW). Your help and support would be appreciated.
Hello Vinish Sir, I need your little help if possible. I have 2 tables (1) CONTACT_TYPES table as below: Contact_Type_Id Contact_Type_Description --------------- ------------------------ 1 Alternate Contact Number 2 Email 3 Fax 4 Website 5 Twitter 6 Facebook 7 Linkedin 8 Preferred Contact Number (2) PERSON_CONTACT_DETS table as below: Person_Contact_Det_Id Person_Id Contact_Type_Id --------------------- -------- --------------- 1 11111 ...
Hello Sir, I have a requirement to create a Wizard style form in Apex. It is exactly the same as the Order Processing in Sample Database Application. The change I need is, instead of using APEX_COLLECTION method for the Order Items I need to use Interactive Grid and save the data at the end in the Confirmation page. So process would be something like Customer Details -> Order Items -> Order Summary -> Confirm Order. Customer Details = to enter new customer details (Cust_Id is PK - auto generate on Seq) Order Items = to enter order details (Order_Id is PK, Order_Item_Id is PK - auto generated on Seq) Order Summary = to view/review current order Order Confirm = to confirm the current order and To Save data in Customers and Orders/Orders_Details tables respectively. Would it be possible for you to guide me and provide me the steps ? Your help is greatly appreciated.
Hello Apex Expert, In Apex, I have Master Detail form where Detail part is created using Interactive Grid. This is one go form i.e. entering master and detail record on the same form. I do not have Master Report. So when I click the Save button I want to save the data in Master table as well as in Detail table. I have tried manual PL/SQL Code process but when trying to enter the data in Detail table it raises an error saying "Cannot enter NULL value in Master_Id". I have no idea how can I capture the Master_Id for manual IG Process? Your help would be greatly appreciated. Kind Regards,
Good Afternoon, How to create an Interactive Grid on a table with Checkbox column for Y or N? For example, we have a column in a table called Competed and would like to show this as a Checkbox in IG and would like to save as Y or N in the table. Your help and support would be appreciated. Kind Regards