Sign Up to our social questions and Answers to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers to ask questions, answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
This promise is immense; every day and every night, we are trying our best to fulfill it by helping others, leaving something worthwhile behind us, and living for a purpose that is "Enrich & Spread knowledge everywhere".
linux command to delete file ?
To remove (or delete) a file or directory in Linux from the command line, use the rm (remove) command Examples:- 1.To delete a single file rm filename 2.To delete multiple files rm filename1 filename2 filename3 rm *.pdf Use the -i option to confirm each file before deleting it rm -i filename(s) UseRead more
To remove (or delete) a file or directory in Linux from the command line, use the
rm
(remove) commandExamples:-
1.To delete a single file
rm filename
2.To delete multiple files
rm filename1 filename2 filename3
rm *.pdf
Use the
-i
option to confirm each file before deleting itrm -i filename(s)
Use the -f
(force) optionrm -f filename(s)
3. To remove non-empty directories and all the files without being prompted use the
r
(recursive) and-f
optionsrm -rf dirname
How to open custom.pll in form builder?
Hello Alan, It's so simple as you open regular form .fmb in form builder just follow this: First you need to download then latest version of CUSTOM library that comes with your Oracle EBS version. (downloaded from production server). You can find the path of CUSTOM.pll under ($AU_TOP/resources) foldRead more
Hello Alan,
It’s so simple as you open regular form .fmb in form builder just follow this:
Using between on sysdate instead of TRUNC
Use TO_DATE Function. SELECT sum(column3) from table1 where column1 = ‘XXXXXAA12’ and column2 between to_date (<yor val>,<your format>) and to_date (<yor val>,<your format>);
Use TO_DATE Function.
SELECT sum(column3)
See lessfrom table1
where column1 = ‘XXXXXAA12’
and column2 between to_date (<yor val>,<your format>) and to_date (<yor val>,<your format>);
How to order by number inside of character for a query like ’25 AB’ ,’30 MT’ ?
Use REGEXP_SUBSTR Syntax : REGEXP_SUBSTR( string, pattern [, start_position [, nth_appearance [, match_parameter [, sub_expression ] ] ] ] ) code : SELECT t.*, REGEXP_SUBSTR (COL1, '(d+)') as sort_by_col FROM test_table t Order by sort_by_col ; Result : application2 25 AB 30 AB 3125 50 50000 AS740TRead more
Use REGEXP_SUBSTR
See lessHow to convert text with comma separated to array in pl/sql ?
Use REGEXP_SUBSTR to Extract desired info REGEXP_SUBSTR( string, pattern [, start_position [, nth_appearance [, match_parameter [, sub_expression ] ] ] ] ) And CONNECT BY to loop over the string searching for the "," and use it as a delimiter. SELECT REGEXP_SUBSTR ('text1, text2, text3', '[^,]+',Read more
Use REGEXP_SUBSTR to Extract desired info
REGEXP_SUBSTR( string, pattern [, start_position [, nth_appearance [, match_parameter [, sub_expression ] ] ] ] )
And CONNECT BY to loop over the string searching for the “,” and use it as a delimiter.
SELECT REGEXP_SUBSTR (‘text1, text2, text3’,
See less‘[^,]+’,
1,
LEVEL),LEVEL
FROM DUAL
CONNECT BY REGEXP_SUBSTR (‘text1, text2, text3’,
‘[^,]+’,
1,
LEVEL)
IS NOT NULL;
How to open gl period in oracle apps ?
General Ledger -> Setup -> Open/Close -> Find -> Open Period
General Ledger -> Setup -> Open/Close -> Find -> Open Period
See lessWhich symbol is used for concatenation? in plsql
its very simple you can use || symbol to concatenate two string or using concat function and here you can find full explanation with examples about how to use oracle || - oracle concatenation in knowledge base section. have a nice day.
its very simple you can use || symbol to concatenate two string or using concat function and here you can find full explanation with examples about how to use oracle || – oracle concatenation in knowledge base section.
have a nice day.
See lessDocument of Record
Document of Record (DOR) Overview Oracle introduced documents of record in R12 HRMS RUP 1. The Documents of Record offers greater functionality than the attachments functionality, The standard attachment functionality does not allow users to search document which is major highlight of DOR. DocumentsRead more
Document of Record (DOR)
Overview
Oracle introduced documents of record in R12 HRMS RUP 1. The Documents of Record offers greater functionality than the attachments functionality, The standard attachment functionality does not allow users to search document which is major highlight of DOR. Documents of Record (Oracle EBS R12) allows the user to create new, update existing, view and search ‘Documents of Record’ for a person. The prominent features of this functionality are as below
DOR Create Page
Now Click ‘Create Document of Record’ Button,
Functional Setup
Enable ‘Register the Program’
Navigation: System Administrator>>Security>>Responsibility>>Request Add ‘Register Extra Information Type (EITs)’ in Request Group
Create Category
Query DOCUMENT_CATEGORY (F11, CtrlF11)
Add a Code: HR_INFO
Add Meaning: HR Information
Save
Create Sub Category
Navigation: Other Definitions > User Types and Statuses
Query DOCUMENT_CATEGORY (F11, CtrlF11)
In the “System Type” field, Query the new CATEGORY using the LOV
Enter SUBCATEGORY by populating “Description” and “Code” fields
System Type: Passport Information
Description: Enter desired Subcategory
Create Sub Category
Register Document Types (EITs)
Navigation: UAE HRMS Manager>> Processes and Reports > Submit Processes and Reports > Register Document Types (EITs)
Enter the parameters as below,
Submit the request.
Add Information Type Security
Navigation: Security > Information Types Security
Search for responsibility and add Information type, Document Type will be your information type, Using EIT security model any Document type can be restricted to any particular responsibility.
Enable AME in DOR Function
System Administrator>>Application>>Function>>Form
Form Function
Create a function as ‘XX_HR_DOR_SS’ set function parameter on Form tab, Please note Parameter used will enable AME in DOR page which will allow you to setup complex approval on the other hand it will disable Supervisor Verification feature,
Add DOR in Employee Self Service Menu
System Administrator>>Application>>Function
Search for Employee Self Service Menu , Add ‘XX_HR_DOR_SS’, Clear the cache or preferably bounce Apache and check DOR functionality from respective User login.
Source : here
See lessORA-12705 invalid or unknown NLS parameter value specified error when connect to oracle 11g from a php application
Hello Waqas, ORA-12705 invalid or unknown NLS parameter value specified Cause: There are two possible causes: Either an attempt was made to issue an ALTER SESSION statement with an invalid NLS parameter or value; or the NLS_LANG environment variable contains an invalid language, territory, or characRead more
Hello Waqas,
ORA-12705 invalid or unknown NLS parameter value specified
Cause: There are two possible causes: Either an attempt was made to issue an ALTER SESSION statement with an invalid NLS parameter or value; or the NLS_LANG environment variable contains an invalid language, territory, or character set.
Action: Check the syntax of the ALTER SESSION command and the NLS parameter, correct the syntax and retry the statement, or specify correct values in the NLS_LANG environment variable. For more information about the syntax of the ALTER SESSION command, see Oracle8i SQL Reference.
See lessWhy fnd_global.conc_request_id returns -1 ?
hello Alan The problem is that your request is not being submitted properly then it will be whatever fnd_global returns, which is most likely -1.
hello Alan
The problem is that your request is not being submitted properly then it will be whatever fnd_global returns, which is most likely -1.
See less