Category Archives: Uncategorized

Download IRecruitment Resumes in Server and in client(TOAD)

We had a requirement from user that to download and process all the resume.

So When checked with the Doc ID 1578603.1 it tells that we can Download Resume as there is no Inbuild Tool but we can write Queries If Any. The uploaded resumes can be found in table IRC_DOCUMENTS via the column CHARACTER_DOC which is of type CLOB.

On Toad We can See below as Save to File Option by which we can download and give the same name as FILE_NAME Column to the Document.

 

Now we are going to download the same on server in bulk and Implementing for many records below is the script.

Steps to download in Server

Step: 1

CREATE DIRECTORY datadump AS ‘E:\datadump\test’;

Create a Directory with Server path by SYS user in database. As the above command is for windows server. In case your Environment is Linux use the correct path accordingly.

Step: 2

grant read, write on directory DATADUMP to apps

Grant Read, Write access to the Directory

Step: 3 Verify

select directory_path from all_directories where directory_name = ‘DATADUMP’;

SELECT * FROM all_tab_privs WHERE table_name = ‘DATADUMP’;

Check whether the directory has been created correctly  and access has been given correctly.

Step: 4 Query to retrive the records.

SELECT PPF.FULL_NAME AS PERSON_NAME,
PPF.EMAIL_ADDRESS,
PPF.DATE_OF_BIRTH,
PAV.NAME AS VACANCY_NAME,
DOC.DOCUMENT_ID,
DOC.BINARY_DOC,
DOC.FILE_NAME
FROM PER_ALL_PEOPLE_F PPF,
PER_ALL_ASSIGNMENTS_F PAF,
PER_ALL_VACANCIES PAV,
IRC_ASSIGNMENT_STATUSES IAS,
PER_ASSIGNMENT_STATUS_TYPES_V AST,
IRC_DOCUMENTS DOC,
IRC_NOTIFICATION_PREFERENCES INP
WHERE sysdate BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE
AND PPF.PERSON_ID = PAF.PERSON_ID
AND PAF.VACANCY_ID = PAV.VACANCY_ID
AND PAF.ASSIGNMENT_ID = IAS.ASSIGNMENT_ID
AND pav.name = p_vac_name
AND ias.ASSIGNMENT_STATUS_TYPE_ID = ‘4’ –Active Application
AND irc_utilities_pkg.GET_RECRUITMENT_PERSON_ID (PPF.PERSON_ID) =
INP.person_id(+)
AND INP.PERSON_ID = DOC.PERSON_ID(+)
AND IAS.ASSIGNMENT_STATUS_TYPE_ID = AST.ASSIGNMENT_STATUS_TYPE_ID(+)
AND doc.TYPE(+) LIKE ‘%RESUME’
AND doc.end_date(+) IS NULL;

Step: 5 Execute the Below Script

DECLARE
l_file UTL_FILE.FILE_TYPE;
l_buffer RAW (32767);
l_amount BINARY_INTEGER := 32767;
l_pos number := 1;
l_blob BLOB;
l_blobname VARCHAR2 (50);
l_blob_len number;
ctrl number;
— p_vac_name varchar2(100):=’IRC110′;

cursor c_irc_doc(p_vac_name in varchar) is SELECT PPF.FULL_NAME AS PERSON_NAME,
PPF.EMAIL_ADDRESS,
PPF.DATE_OF_BIRTH,
PAV.NAME AS VACANCY_NAME,
DOC.DOCUMENT_ID,
DOC.BINARY_DOC,
DOC.FILE_NAME
FROM PER_ALL_PEOPLE_F PPF,
PER_ALL_ASSIGNMENTS_F PAF,
PER_ALL_VACANCIES PAV,
IRC_ASSIGNMENT_STATUSES IAS,
PER_ASSIGNMENT_STATUS_TYPES_V AST,
IRC_DOCUMENTS DOC,
IRC_NOTIFICATION_PREFERENCES INP
WHERE sysdate BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE
AND PPF.PERSON_ID = PAF.PERSON_ID
AND PAF.VACANCY_ID = PAV.VACANCY_ID
AND PAF.ASSIGNMENT_ID = IAS.ASSIGNMENT_ID
AND pav.name = p_vac_name
AND ias.ASSIGNMENT_STATUS_TYPE_ID = ‘4’ –Active Application
AND irc_utilities_pkg.GET_RECRUITMENT_PERSON_ID (PPF.PERSON_ID) =
INP.person_id(+)
AND INP.PERSON_ID = DOC.PERSON_ID(+)
AND IAS.ASSIGNMENT_STATUS_TYPE_ID = AST.ASSIGNMENT_STATUS_TYPE_ID(+)
AND doc.TYPE(+) LIKE ‘%RESUME’
AND doc.end_date(+) IS NULL;

BEGIN

FOR i in c_irc_doc loop(‘IRC110’)–Position Name for taking the Resume

l_blob_len := DBMS_LOB.getlength(i.binary_doc);
l_file := UTL_FILE.fopen(‘APPS_DATA_FILE_DIR’,i.file_name,’WB’, 32767);
— Read chunks of the BLOB and write them to the file created in directory until complete.
WHILE l_pos < l_blob_len LOOP
DBMS_LOB.read(i.binary_doc, l_amount, l_pos, l_buffer);
UTL_FILE.put_raw(l_file, l_buffer, TRUE);
l_pos := l_pos + l_amount;
END LOOP; — This will end the While loop when condition met.
l_blob_len :=0;
l_pos :=1;
— Close the file.
UTL_FILE.fclose(l_file);
end loop; — This will end the FOR loop when all BLOB files in the table have been downloaded.
EXCEPTION
WHEN OTHERS THEN
dbms_output.put_line(‘Exception’||SQLERRM||SQLCODE);
— Close the file if something goes wrong.
IF UTL_FILE.is_open(l_file) THEN
UTL_FILE.fclose(l_file);
END IF;
–RAISE;
END;
/

 

Steps to download in TOAD

Execute the Query in the Step : 4

Now click on Binary Doc Column and right click Single Column Export

 

Now give the path and Column of the Value to be renamed for File

 

Then Export will be downloaded.

Now the Resumes will be downloaded in the mentioned path.

TOAD 12 is faster for Exporting Blob than in Server.

If you have an older version of Toad, it’s called “Export BLOBs (long,raw)” instead.

Happy resume Exporting….

Advertisements

Executing a LDT file in Windows Environment

Once when we try to migrate LDT files mostly we have scripts only in Linux. As our server is in windows I just gave the below command.

The command is same as the linux except on navigating to any of the TOP we put $ in Linux as $FND_TOP here we use %FND_TOP%.

However in windows we have to do the sourcing. Refer to this Link for sourcing in windows.

%FND_TOP%/bin/FNDLOAD apps/test 0 Y UPLOAD %FND_TOP%/patch/115/import/afcpprog.lct ARRCTANLZAZ.ldt CUSTOM_MODE=FORCE UPLOAD_MODE=REPLACE

Pull Back/Cancel/Resubmit Leave Request in Adrenalin

We use a tool called adrenalin. I have wrongly applied for the leave. But I don’t know how to check the leaves applied and to Cancel or Resubmit or Pullback it.

After checking with our HR I came to know and I have shared the same.

  • To Find the submitted Request

Enter “Forms raised by me” in  Adrenalin search path to know the status of your forms raised so far.

  • To Pull Back the Request

Enter “Pullback Transaction” in  Adrenalin search path to revoke or cancel or pullback the transaction and this case it is leave.

Once done successfully. You can apply for the leave again.

Thank you.

 

Unable to reserve the .lok file for Integrated WebLogic Server (IntegratedWebLogicServer) in Jdeveloper

If you face the error Unable to reserve the .lok file for Integrated WebLogic Serve then the first is you have to kill the process in Task Manager. Open Task Manager & check for java.exe process for higher memory consumption. End the process.

IF above does not help then go to C:\Users\RRA\AppData\Roaming\JDeveloper\system11.1.2.1.38.60.81\DefaultDomain . Delete the edit.lok file.

This error happens due to JDeveloper closes unexpected without shutting down IntegratedWebLogicServer

Thanks

Source

Why are you not using an application in your language?

Good Post…

Going GNU

Last week, listened a conversation between two of my friends, Khaleel and Navin.

Khaleel is contributing to Mozilla community by doing localization. i.e translating the strings on the user interface of Mozilla products like firefox in Tamil. Navin is a tech guy, who likes to read Tamil anywhere.

localization க்கான பட முடிவு

image source – http://www.softwaretestingclass.com/what-is-globalization-internationalization-and-localization-in-software-testing/

“Hi Navin, Do you know that the firefox in your mobile and computer can be converted to Tamil?” Khaleel Asked.

“Yes dude. I have heard about it. Tried few times. But, the tamil interface gave me some issues. So reverted back to English UI”. Navin replied.

khaleel Khaleel

“Oh. Is it? It is just a habital issue. You are so used to English. I never faced any issues on using Tamil interface. What are the issues you faced?” Khaleel asked.

“New words to learn. All the new words make me to feel very unfriendly.” This is Navin.

“Yes. We…

View original post 732 more words

Beautify your terminal with screenFetch which is a Info tool

I have recently installed opensuse 42.2 gnome and making some changes. The changes were more about visual so I changed default theme as red arc theme and vivacious Icon theme then I changed color schemes in terminal and while searching I came accross this screenfetch.

Below is the screenshot

screenfetch-opensuse

 

Error while mounting NTFS file system as read write

Below is the error which comes when trying to mount NTFS file system with read and write access

The disk contains an unclean file system (0, 0).
Metadata kept in Windows cache, refused to mount.
Falling back to read-only mount because the NTFS partition is in an
unsafe state. Please resume and shutdown Windows fully (no hibernation
or fast restarting.)

After searching I got what to do

Run the below command

$ sudo ntfsfix /dev/sda8

Now mount the file system read and write access by below command

$ sudo mount -o rw /dev/sda8 /media/user

 

Journal IN PROCESS Issue

We had a Issue that the journal approval went to the approver and then we got the Error stating that No Approver found. After that we have cancelled the workflow and checked the Journal. Journal Approval was in Process and we were not able to modify the Journal. After that raising the SR we go the solution

Please use the follow script to be able to approve again the journal. Please note you should have the setup corrected at the time
you try to approve again the journal.

1. Backup the gl_je_batches
create table gl_je_batch_bak as select * from gl_je_batches

2. update gl_je_batches
set approval_status_code = ‘R’
where je_batch_id = 958912
and approval_status_code = ‘I’
and status = ‘U’;

Normally, in such cases you need to correct the setup to avoid the error ‘No approver found‘ and then try to restart the workflow of the journal batch by following the solution in Document 415875.1.
Then you can reassign or resubmit it for approval.
Also please review GLXJEENT Journal Approval Workflow is Stuck with Batch Approval Status “In Process” Can not Delete, Modify or Approve it ( Doc ID 161382.1 )

Listing Employees Based on Elements

Listing Employees Based on Elements

Sometimes we need to get a report based on Elements and everytime we cant write a Query as it consumes time by the way. So there is a Inbuilt form which is found in the above screenshot that is List Employees by element. So by this we can easily get the list of employees by the element.

Invoking Report Based on Trigger in Oracle Apps

We have a Requirement that to run the Payment Voucher Report when user makes the payment.

Trigger1

So we have a Trigger for the purpose and Trigger is on IBY_PAYMENTS_ALL table. So when a payment is Made this trigger will be initiated.

In the trigger the Concurrent Request will be called and depending on the Operating Unit the Report Layout will change and the request will be submitted. I have attached the script in this Blog. Below is the script.

XX_check_print_trg1

Now you can just Include a Menu in the forms like View Payment Voucher Report Button and then the report comes. This is one way of automating the report invocation.