Best Of
Re: The Create Accounting process in Receivables errors for one OU
Thanks Bharat.
Appreciate your response.
Re: I do not see my operating unit to define system options in Receivables
Thank you, Bharat. It is working now.
Re: Purchase Order Approval Issue – Record Not Appearing in Approval Screen
Hi Vaibhav,
Glad to hear that the issue is resolved! Feel free to reach out to Oracle Communities or Oracle Support if you run into any more issues.
Regards,
Mahesh
Re: Requisition
Hi Oliver,
No, Oracle does not support merging multiple internal requisitions into a single one at the requisition level.
Thanks !!
Re: How to set up Privilege Delegation to sudo to oracle with shell set to /sbin/nologin
Hi,
Find the steps provided below:
1) On the target host configure sudo with no password for the user in question e.g.
visudo
<username> ALL=(ALL) NOPASSWD: ALL
2) Configure the public a private keys as per usual using "ssh-keygen".
3) On the target server
agent_inst/sysman/config/emd.properties
# EMPDP_PASSWORD_PROMPT_SUDO=MAYBE
EMPDP_PASSWORD_PROMPT_SUDO=FALSE # Add this line
(This is the key step here).
4) Restart the agent
5) Configure a global set of named credentials in the UI as per normal, but this time using the "Run Privilege" sudo and the user as oracle/root
6) Create a test file:
[oracle@apem16 ~]$ ls -l test
-rw------- 1 oracle oracle 33 Sep 10 00:58 test
[oracle@apem16 ~]$ cat test
This is an oracle read only file
6) Create a simple job using the named ssh key credentials to confirm your steps are correct.
Display the read only test file would be a good test:
cat /home/oracle/test (Assumes your runas in step 5 was oracle).
Best Regards,
Venkat
Re: Sorry - Simple SIP-Manip question
Cheers Antonio.
I must have tried every combination I could think of.
KISS always works.
Paul.
Re: Sorry - Simple SIP-Manip question
Hello Paul
give it a try to the following ER :
element-rule
name mod_from_ER
parameter-nametype uri-user-only
action replace
match-val-type any
comparison-type pattern-rule
match-value ^\+697\d{2}(.+)
new-value "+"+$1
Cheers
Antonio
Re: Oracle database 19c libraries are installed but throwing error on sqlplus
@Mr. C Your opinion is just that, your opinion. While you may raise some "valid" points for optional ways of doing things - which may be better suited to those more versed in Linux/Unix - many (most) are not.
The instructions were written for those with no experience in mind, and ensuring that one is in the expected locations prior to actions being taken.
Your suggested improvements have been reviewed and rejected.
I'll maintain the written instructions as they are, for the benefit of that absolute Unix/Linux Novice. A more advanced user can see the instructions and is welcome implement in a manner that best suits himself/herself.
Re: How can I get all 9 digits of precision in systimestamp?
I'm not sure which version of java oracle 19 is using but I think the java version is too old to support nano-seconds. For what I have read nano seconds are available at Java 17 and above.
***Update
I find it out, it's too old.
SQL> SELECT dbms_java.get_jdk_version JDK_Version FROM dual;
JDK_VERSION
1.8.0_201
Re: How can I get all 9 digits of precision in systimestamp?
I guess that was done with the idea of "sub order by some arbitrary value", but then you may just sub order on some other column value instead as well.
Mr. C