I feel that this document(Doc ID 1577661.1) will be useful for people who are going for 12.2 series especially the developers.
OAF Error You have insufficient privileges for the current operation. Please contact your System Administrator.
I had this problem when I was trying to run a page with a field. But the Jdeveloper was throwing the below error without any other description about the Error. This I was facing with the latest Jdeveloper for oracle apps R12.2.7 version. I checked I was not able to find OADiagnostics as it has mentioned that it will not be in new versions.Doc ID 1313526.1, Doc ID 2296566.1
I was searching and when trying something it worked out. That was Initially the startup of Embedded OC4J server was in Local host short name that is the URL was taking as host name. Once I have changed to IP I was able to get the actual error. The error was custom application was not created.
Actually I was starting to use i3 window manager then I just want to bring the horizontal window to vertical one as shown below. I have search and then I got the info from i3 FAQ.
------------- | | | | | A | B | C | | | | | ------------- to
------------ | | B | | A |---| | | C | ------------
The exact keys you would use depend on your configuration. I’ll use this config file: http://i3wm.org/docs/user-contributed… for reference and list the corresponding i3 commands. The modifier key
$mod is most likely
Alt or the Windows key on your computer.
- If the window B is not focused, focus it via either
- Split the window in the vertical direction:
split v). There may be little or no visible difference (perhaps the bottom edge becomes visibly active).
- Move focus right, to the window C, using
- Move the window C to the left, using
move left). It should now be in the same column as the window B.
Suppose a concurrent program has three parameters – ParamA, ParamB and ParamC. If the value for ParamA is ‘ENABLE_B’, then ParamB should be enabled and if the value fo ParamA is ‘ENABLE_C’, then ParamC should be enabled. Assume that the values for the second and third parameters are fetched from a table.
The first approach that might come immediatly to mind is to setup the three parameters ParamA, ParamB and ParamC in the manner and link them up using $FLEX$:
ParamA has value set VS1 attached to it. VS1 is of type Independent and has the values ‘ENABLE_B’ and ‘ENABLE_C’.
ParamB has value set VS2 attached to it. VS2 is of type Table and in the Where/Order By clause the condition :$FLEX$.ParamA=’ENABLE_B’ is added.
ParamC has value set VS3 attached to it. VS3 is of tye Table and in the Where/Order By clause the condition :$FLEX$.ParamA=’ENABLE_C’ is added.
View original post 337 more words
I have recently installed arch linux and got error when issuing nmcli command where this command is network manager.
Error: NetworkManager is not running.
After running the below commands the Network manager service is started and Enabled
- start it:
systemctl start NetworkManager
- make it auto-start on boot:
systemctl enable NetworkManager
- tell it to connect to a WiFi network:
nmcli device wifi list
Requirement : To add a Region(Initiator Details) to a Notification for second level approver.
Problem faced : I have added that particular region and I have Imported the script but still it was not reflecting when trying to Import. We have tried to print the Region using jdr_utils and then we are able to see it was not reflecting.
We came to know that there is problem in Import script. Below was the script
java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/oracle/apps/per/selfservice/appraisals/webui/ApprNtfFinalRN.xml -username apps -password apps -dbconnection “(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST= <>)(PORT=<>))(CONNECT_DATA=(SID=<>)))” -rootdir $JAVA_TOP/oracle/apps/per
Solution : As my collegue Bala helped then he was able to find that the path of rootdir was wrong and rootPackage was not given. After we have added the page imported successfully. Below is the correct script. So the rootPackage is that which changes the exact point in the Filesystem.
java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/oracle/apps/per/selfservice/appraisals/webui/ApprNtfFinalRN.xml -username apps -password apps -dbconnection “(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST= <>)(PORT=<>))(CONNECT_DATA=(SID=<>)))” -rootdir $JAVA_TOP/oracle/apps/per/selfservice/appraisals/webui/ -rootPackage “/oracle/apps/per/selfservice/appraisals/webui”
java oracle.jrad.tools.xml.importer.XMLImporter /oraapps_new/UAT/apps/fs1/EBSapps/appl/ap/12.0.0/mds/oie/webui/OIEPROJECTLOV.xml -username apps -password uatapps -dbconnection “(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.82)(PORT=1546))(CONNECT_DATA=(SERVICE_NAME=UAT)))” -rootdir /oraapps_new/UAT/apps/fs1/EBSapps/appl/ap/12.0.0/mds/oie/webui/
The Above is my old Import script. The corrected one is below. In the above the root package was missing. Root package should be same as the jdr_utils.printdocument path without the file name.
java oracle.jrad.tools.xml.importer.XMLImporter /oraapps_new/UAT/apps/fs1/EBSapps/appl/ap/12.0.0/mds/oie/webui/OIEPROJECTLOV.xml -username apps -password uatapps -dbconnection “(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.82)(PORT=1546))(CONNECT_DATA=(SERVICE_NAME=UAT)))” -rootdir /oraapps_new/UAT/apps/fs1/EBSapps/appl/ap/12.0.0/mds/oie/webui/ -rootPackage /oracle/apps/ap/oie/webui/
Share your Views
When I tried to delete the rows I was getting stale data error as shown in the above screenshot.
I have analysed my VO that it does not have dependency like Master or Child and below is code.
for(Row row1 = A.first(); row1 != null; row1 = A.next())
if(row1 != null)
It is straight foward code to delete the row. I am getting the error on Commit on the code. I have searched and I have added the below line in the code and then it worked.
What happens it the row is getting locked internally so I have put the above code in order to release the lock during delete.
While comparing Invoice Aging Report and Trial Balance Report some records were missing in xla_trial_balances table
When we were Reconciling data for supplier outstanding amount we checked in Trial balance which was giving a different value and Aging Report was giving another value. So when we checked the records we were able to find that some records were missing in xla_trial_balances table. So Initially we thought whether to rebuild or not. After checking the same with functional we got to know that there was a setup missing.
Go to Payables Super User –> Setup –> Accounting Setups –> Subledger Accounting Setup –> Open Account Balances Listing Definitions.
In this Screen the Trial Balance Accounts will be defined for Reporting purpose. Here we have to add the expected Natural Account so that it will populate in the Trial Balance Report, which In turn will fill data in xla_trial_balances table.
Below is the Query to get HRMS Leave Element Balance from Payroll in Monthwise
FROM Per_all_assignments_f Paaf,
WHERE Papf.Person_id = Paaf.Person_id
AND Paaf.Position_id = Hapf.Position_id(+)
AND Paaf.Job_id = Pj.Job_id(+)
AND Paaf.Grade_id = Grd.Grade_id(+)
AND Paaf.People_group_id = Ppg.People_group_id
AND Paaf.Assignment_id = Paa.Assignment_id
AND Paaf.Payroll_id = Ppa.Payroll_id
AND Paa.Payroll_action_id = Ppa.Payroll_action_id
AND pbvv.assignment_action_id = paa.assignment_action_id
AND pbvv1.assignment_action_id = paa.assignment_action_id
AND pbvv.DEFINED_BALANCE_ID =2109 –Balance ID
AND pbvv1.DEFINED_BALANCE_ID =3116 –Balance ID
AND Paaf.Primary_flag = ‘Y’
AND sysdate BETWEEN Paaf.Effective_start_date AND Paaf.Effective_end_date
AND sysdate BETWEEN Paaf.Effective_start_date AND Paaf.Effective_end_date
AND sysdate BETWEEN papf.Effective_start_date AND papf.Effective_end_date
AND TO_CHAR(ppa.effective_date, ‘MMYYYY’) = :MMYYYY –Month
ORDER BY Papf.Employee_number