Fixed REP-0756 Warning Unable to find PL SQL library ‘inv’ in oracle apps R12 | Discrete Job Shortage Report Completes with Error (REP-0252, REP-0756, REP-0736, REP-1247, REP-0069, REP-57054, REP-1247) in oracle apps R12.
How to fix REP-0756 Warning Unable to find PL SQL library.
ERROR
———————–
REP-0756: Warning: Unable to find PL/SQL library ‘inv’.
REP-0736: There exist uncompiled program unit(s).
REP-1247: Report contains uncompiled PL/SQL.
We can reproduce the issue when rerun the Discrete Job Shortage Report.
WIP reports.
The likely cause of this issue is executable, plssql library and forms for WIP was not re-linking successfully.
Complete error as per concurrent request log.
+—————————————————————————+
Work in Process: Version: 12.1
Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.
WIPDJORQ: Discrete Job Shortage Report
+—————————————————————————+
Current system time is 18-SEP-2018 18:21:01
+—————————————————————————+
+—————————–
| Starting concurrent program execution…
+—————————–
Arguments
————
P_OPEN_SHORT=’1′
P_SORT_BY=’11’
P_NETTABLE=’2′
P_Include_Bulk=’1′
P_Include_Vendor=’1′
P_FROM_JOB=’525385′
P_TO_JOB=’525385′
P_ORGANIZATION_ID=’1029′
P_qty_precision=’2′
————
APPLLCSP Environment Variable set to:
Current NLS_LANG, NLS_NUMERIC_CHARACTERS and NLS_SORT Environment Variables are:
AMERICAN_INDIA.UTF8
‘.,’
BINARY
Enter Password:
REP-0252: Warning: The path specified by environment variable ‘REPORTS_PATH’ is too long
and will be ignored.
REP-0252: Warning: The path specified by environment variable ‘REPORTS_PATH’ is too long and will be ignored.
REP-0252: Warning: The path specified by environment variable ‘REPORTS_PATH’ is too long and will be ignored.
REP-0252: Warning: The path specified by environment variable ‘REPORTS_PATH’ is too long and will be ignored.
REP-0756: Warning: Unable to find PL/SQL library ‘inv’
REP-0736: There exist uncompiled program unit(s).
REP-0736: There exist uncompiled program unit(s).
REP-1247: Report contains uncompiled PL/SQL.
REP-0069: Internal error
REP-57054: In-process job terminated: Terminated with error:
REP-1247: There exist uncompiled program unit(s).
REP-1247: Report contains uncompiled PL/SQL.
Report Builder: Release 10.1.2.3.0 – Production on Tue Sep 18 18:21:02 2018
Copyright (c) 1982, 2005, Oracle. All rights reserved.
+—————————————————————————+
Start of log messages from FND_FILE
+—————————————————————————+
+—————————————————————————+
End of log messages from FND_FILE
+—————————————————————————+
Program exited with status 1
Concurrent Manager encountered an error while running Oracle*Report for your concurrent request 37116143.
Review your concurrent request log and/or report output file for more detailed information.
+—————————————————————————+
No completion options were requested.
Output file size:
+—————————————————————————+
Concurrent request completed
Current system time is 18-SEP-2018 18:21:03
+—————————————————————————+
Solution: –
1. Please relink the executables for WIP INV schemas using adadmin utility.
2. Please regenerate forms, pl/sql libraries for WIP and INV schemas using adadmin utility.
3. Please clear cache and bounce Apache server.
Report Builder: Release 10.1.2.3.0 – Production on Tue Sep 18 18:21:02 2018
Copyright (c) 1982, 2005, Oracle. All rights reserved.
+—————————————————————————+
Start of log messages from FND_FILE
+—————————————————————————+
+—————————————————————————+
End of log messages from FND_FILE
+—————————————————————————+
Program exited with status 1
Concurrent Manager encountered an error while running Oracle*Report for your concurrent request 37116143.
Review your concurrent request log and/or report output file for more detailed information.
+—————————————————————————+
No completion options were requested.
Output file size:
+—————————————————————————+
Concurrent request completed
Current system time is 18-SEP-2018 18:21:03
+—————————————————————————+
Solution: –
1. Please relink the executables for WIP INV schemas using adadmin utility.
2. Please regenerate forms, pl/sql libraries for WIP and INV schemas using adadmin utility.
3. Please clear cache and bounce Apache server.
Useful Post: –
Do you want to create the Blockchain account? Are you having trouble in sign-up in Blockchain account? If yes, take assistance from the team who is there to guide you. You can have conversation with the team who is there to assist you. Talk to the team who is ready to guide you in no time. Get a chance to talk to the leading team member over Blockchain customer care number which is available to cater guidance. The team is always functional to help you in every possible way for better results. Unable to execute the process of Binance 2fa reset.
More info visit here:
Blockchain customer care
Crypto customer support
Binance customer support number
I’m in my bed, you’re in yours. One of us is obviously in the wrong place. Hey, i am looking for an online sexual partner 😉 Click on my boobs if you are interested (. )( .)