Resolved Questions

Mohammed

IDAutomation.pll - REP-0756: Warning: Unable to find PL/SQL

Tagged With:-

When the IDAutomation.pll is deployed in the Oracle ERP server, the system gives REP-0756: Warning: Unable to find PL/SQL library 'IDAutomation' error. Kindly suggest how to resolve the issue.

Application: Oracle E-Business suite 12.2.8

05-14-24 221 day(s) ago

Report Abuse


debrac	Best Answer Hello Mohammed, Thank you for contacting us. The first thing we will need to do is to determine which IDAutomation product you are using and your licensing level for that product. If you have placed a prior order with us, I have so far been unable to locate that order. If you can provide some additional information that I can use to potentially locate this order in our system, I would certainly appreciate that. Any information you can provide for the time the purchase might have been made will assist us, such as: Potential date ranges of order placement Potential company names the order may have been under Potential billing or end user addresses the order may have been under. Potential email address domains the order may have been under (anything after the @ symbol in the email address) Potential purchaser/end-user last names Without locating your original licensing information, the best I can advise is the information here regarding the PLL files - REP-0756: Warning: Unable to find PL/SQL library Posted 221 day(s) ago (1) (0) Report Abuse

Find Interesting

Email to Others

Bookmark

Subscribe to Answer Alert

Add Comment

No comments yet. Be the first to comment.

Other Answers (8)

Jacque

Hello Mohammed,

When you Download the IDAutomation_BIPublisher_QRCode.zip within the folder "C:>File>Path>To>IDAutomation_BIPublisher_QRCode>IDAutomation_BIPublisher_QRCode>2DBarcode>src" you'll find a text file titled 'Read Me' inside the document is the information you're looking for:

"This folder includes a barcodeutil.java (name is different for the barcode type) file that must be compiled to a class.
It uses the xdocore.jar (XDOBarcodeEncoder.class and Logger.class) as well as the IDAutomation Java Font Encoder class/jar.
oracle > psbi > barcode > barcodeutil.java

After the file is compiled to class, it must be put into a created jar, name it barcodejar.jar, and includes a manifest file and the barcodeutil.class."

I hope this information has been helpful, let me know if you have any further questions.

Posted 207 day(s) ago

(0)

Report Abuse

Mohammed

Dear Support Team,
Hope you are doing well.
Thanks for your reply.
I am working on 'Generate Barcodes in Oracle XML BI Publisher (BIP) & E-Business Suite (EBS)'
I am following all the steps mentioned in the below link.
https://www.idautomation.com/font-encoders/java-class-library/oracle-xml-publisher/
I have got stuck at point No:10 where it is mentioned to 'Place the barcodeutilQRCode.class into the barcodejar.jar'
However, I am not able to trace the barcodejar.jar file.
Will you please let me know where to find this jar file (barcodejar.jar.)
Kindly suggest.

Regards,
Mohammed

Posted 209 day(s) ago

(0)

Report Abuse

debrac

Hello Mohammed,

If you are working in XML/BI Publisher, you will not be using the Java Barcode Package as XML/BI Publisher requires a font/encoder solution as previously advised when you were asking about replacing Code 39 with Code 128. For QR Code here is what you will need and Only experienced developers with BIP report design, XML, and Java should perform the solution. IDAutomation only supports the Java barcode encoder available through our company. To troubleshoot barcode generation issues in BIP, ensure the Java barcode encoder performs in a stand-alone application (an example is included in the product). If the Java barcode encoder performs in a stand-alone application but does not function in BIP, contact Oracle Support for more information.

Product: QR-Code Font and Encoder Suite which will need to be purchased with a minimum 1 Developer license to obtain the Java encoding tools.
Tutorial: Generate Barcodes in Oracle XML BI Publisher (BIP) & E-Business Suite (EBS)

Posted 213 day(s) ago

(0)

Report Abuse

Mohammed

Dear Support Team,
Thanks for your reply.
My issue related to REP-1401: 'cf_qr_codeformula': Fatal PL/SQL error occurred. - ORA-39565: Message 39565 not found; product=RDBMS; facility=ORA' has got resolved.
I just changed the path of jar files from REPORTS_PATH TO CLASSPATH & AF_CLASSPATH.
It worked for me.
Now I can generate QRCode through EBS - RDF in the server.
Thanks for your support.

But our company needs QRCode in XML Reports.
For that, I am following the steps mentioned in the below link.
https://www.idautomation.com/font-encoders/java-class-library/oracle-xml-publisher/

I have downloaded IDAutomation_JavaFontEncoder_QRCode.jar and xdocore.jar files and placed them in CLASSPATH.
I have opened barcodeutilQRCode.java in JDeveloper on my laptop.
When I am trying to compile it it gives one error.
Error(5,8): QRCodeEncoder not found
Cursor is blinking at
import com.idautomation.fontencoder.qrcode.QRCodeEncoder;
Even though the related jar file is at proper CLASSPATH, still my JDeveloper is not recognizing/ importing the QRCodeEncoder.class file
Please suggest any fix to this error.

Regards,
Mohammed

Posted 213 day(s) ago

(0)

Report Abuse

Jacque

Hello Mohammed,

Happy to hear you're able to generate QR Codes on your PC using the DEMO file. Since you're able to get the QR Codes generated on your machine but not the server, it would suggest a possible permissions issue. Verify your permissions, check that the IDAQRCode.jar file and its directory have correct read and execute permissions. Also, ensure the REPORTS_CLASSPATH includes the correct path to the JAR file. Some users found this forum post helpful to verifying the classpath. After any changes, restart the Oracle Reports server and review the logs for more details.

However, you may need to reach out to Oracle Support for further assistance as support for Oracle is limited to our documentation.

I hope this information has been helpful.

Posted 215 day(s) ago

(0)

Report Abuse

Mohammed

Dear Support Team,
Thanks for your reply.
As suggested we have decided to go for Java Barcode Generator Package.

I have downloaded IDAQRCode.jar DEMO file from your website on my laptop and provided the path in REPORTS_CLASSPATH.
Then imported the qrcode and barcodeEncoder classes in the rdf file. Compiled the rdf and executed it in the local machine.
It is displaying QRCode on my PC.

Same IDAQRCode.jar DEMO file, I have deployed it in our server IN JAVA TOP and provided a path in REPORTS_CLASSPATH.
When I run the report it gives the below error.

REP-1401: 'cf_qr_codeformula': Fatal PL/SQL error occurred.
ORA-39565: Message 39565 not found; product=RDBMS; facility=ORA

Our server details are as mentioned below
************************************************
OS : AIX 7.2
RDBMS : 19.0.0.0.0
Oracle Applications : 12.2.8

Kindly suggest how to resolve this error.

Posted 216 day(s) ago

(0)

Report Abuse

debrac

Thank you for the additional information.

Code 39 is a simple barcode type that does not require encoding tools as you can apply asterisks **, exclamation points !!, or parentheses () around your data and apply the font to complete the barcode. The character set is limited in Code 39 but there may be options for using Extended Code 39 for your data and you can read more about that here Extended Code 39 Barcode Font Information if you wish to continue to use Code 39.

Code 128 is a more complex barcode type that requires that you pass your data through an encoding tool to encode the data before applying the font to complete the barcode. The PLL for use in Oracle Reports requires purchasing a Developer license or higher for the Code 128 Barcode Font Package but this is a legacy encoding method and for use in Oracle EBS Reports, IDAutomation recommends ourJava Barcode Generator Package with a tutorial located here: Creating Barcodes in Oracle Reports using Java. If you are working in XML/BI Publisher, this would require the above linked Code 128 font/encoder package and the tutorial for installation is here: How to create 1D Barcodes in BI Publisher

Unfortunately, for any Oracle Reports installation, the information we have available online is the support we can provide and the PLL instructions for installation are here: Oracle Reports Barcode PL/SQL Font Encoder. Only experienced developers with Oracle report design and Java should perform the solution. IDAutomation only supports the Java barcode encoder available through our company. To troubleshoot barcode generation issues in deployment, ensure the Java barcode encoder performs in a stand-alone application (an example is included in the product). If the Java barcode encoder performs in a stand-alone application but does not function when deployed, contact Oracle Support for more information.

Posted 220 day(s) ago

(0)

Report Abuse

Mohammed

Dear Support Team,
Thanks for your reply.
Currently, we are using code39 for encoding and displaying barcodes in Oracle reports which was working fine.
But for a few delivery numbers as code39 encoder is returning space and it is not able to handle a few special characters, so the barcode scanner is unable to scan the barcode.
So, we want to check whether the code128 encoder will resolve our issue and demo version ( IDAutomation.pll) has been downloaded.
When we attach this pll file and run the report in Report Builder locally, it is properly encoded, and we can scan the barcode
But the same .rdf file when we deploy in the server, the encoder is not encoding the string properly and we are unable to scan the barcode
If this demo version works properly on the server, then we will purchase the licensed version.
Kindly suggest.

Posted 220 day(s) ago

(0)

Report Abuse

Categories

» Barcode Applications » Barcode Components ● Barcode FAQ » Barcode Fonts » Barcode Hardware ● Barcode Learning » Font Encoders ● General License Questions ● General Sales Questions » MICR & OCR Fonts » Other ● Product Updates » Saas Hosted Products

Email this question link to friends

Your comment on this question

Allows to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption	:
Link URL	:	(Must starts with "http://")
Add \| Cancel

Allow to insert an image. Must be among the following file types - .jpg, .gif, .png & .bmp.
Image Url	:	Upload New (Image url must always starts with " http:// ")
Width	:	pixels (Must not be greater than 450px. Enter 0px for no resize)
Add \| Cancel

Allow to insert YouTube video. Insert the video embed code.
Embed Code	:
Add \| Cancel

Up to 5000 Characters are allowed. Current Count: 0

Your comment on this answer

Allow you to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption	:
Link URL	:	(Must start with "http://" or "https://")
Add \| Cancel

Allow to insert an image. Must be among the following file types - .jpg, .gif, .png & .bmp.
Image Url	:	Upload New (Image url must always start with "http://" or "https://")
Width	:	pixels (Must not be greater than 450px. Enter 0px for no resize)
Add \| Cancel

Allow to insert YouTube video. Insert the video embed code.
Embed Code	:
Add \| Cancel

Up to 5000 characters are allowed. Current Count: 0

My Profile

You may answer and comment on any thread according to the Terms and Conditions.