ERP Genius Guide

  QR Code Generator using Java Stored Procedure and PL/SQL in Oracle EBS R12 Generating QR codes within an Oracle database can be a powerful way to add quick data access capabilities to your applications. In this guide, I'll walk you through creating a QR code generator using a combination of Java stored procedures and PL/SQL. This approach is ideal for developers looking to enhance their database-driven applications with QR functionality. Prerequisites Java Libraries Download the required Java libraries. Unzip the jar files into a directory, e.g., C:\jars . Upload JAR Files to the Database Use the loadjava tool to upload each jar file into the database: loadjava -force -genmissing -r -user username/password@database -verbose [jarfilename] Java Stored Procedure for QR Code Generation Create a Java stored procedure to generate QR codes with the following code: *************************************************************** CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED "QRCod...

How to Default Sales Tax Based on Customer’s Tax Registration Status in Odoo Applying GST + Further Tax on Specific Customers in Odoo In Pakistan , businesses need to apply automated sales tax in Odoo based on a customer's tax registration status. The standard GST (18%) applies to most sales, but additional taxes, such as further tax (4%) or advance tax (0.1%) , may apply depending on whether the customer is: ✅ A registered customer but marked as an unfiler ✅ A registered customer who is a filer but operates as a distributor or retailer To avoid manual errors and streamline tax compliance, businesses can automate sales tax calculations in Odoo by defaulting the correct GST combination based on the customer's tax status in the Customer Master . Steps to Configure Automated Sales Tax in Odoo 1️⃣ Create Sales Taxes in Odoo ➡ Navigate to: Accounting > Settings > Taxes ➡ Define the required tax types: Standard Sales Tax (GST) – 18% Further Tax – 4% Advance Tax – 0.1 ...

Restrict Creation of #PO without a #P R Sometimes Businesses do not allow a #PO to be created manually. There are several ways through which we can restrict the creation of #PO without a requisition in #Oracle #EBS #R12. The blog discusses two different methods to achieve this goal. Introduction:  At times, businesses necessitate a requisition as a prerequisite for generating a #Purchase_Order (#PO). This blog will enlighten you on the procedure to prevent users from creating a #PO without a corresponding requisition. In #Oracle Purchasing, there are two methods for #PO creation: • Manual creation via the #Purchase #Order form. • Automatic creation from a requisition through the Autocreate function. There are instances where manual creation of a PO is not permissible. In #Oracle #EBS, there are two distinct approaches to enforce the restriction on creating a #PO without a linked requisition: Option 1 Employing form personalization on the #Oracle Purchasing form, speci...

  Track User activity in #Oracle Application - #EBS R12 / Query to #Audit user activity on #Oracle  #Forms How to Audit User Activity in Oracle Database *---------------------------------------------------------------* Pre-requisite: Set the Profile option "Sign-On:Audit Level" = 'Form' This profile option can be enabled at Site level or any specific user. It will populate the data in below tables: FND_LOGINS FND_LOGIN_RESPONSIBILITIES FND_LOGIN_RESP_FORMS SQL Query Run below #SQL query to extract the user activity details on #ERP application: "SELECT frtl.RESPONSIBILITY_NAME , fft.USER_FORM_NAME , flf.START_TIME, flf.END_TIME   FROM FND_LOGIN_RESP_FORMS flf,        FND_LOGINS fl,        FND_LOGIN_RESPONSIBILITIES flr,        FND_RESPONSIBILITY_TL FRTL,        FND_FORM_TL fft  WHERE     FLf.LOGIN_ID = FL.LOGIN_ID        and FLR.LOGIN_ID = FL.LOGIN_ID ...