Best Of

Re: A lot of core.fmd.* in /var/fm/fmd

Hi,

Thanks for your response and i actually have a screen output about which i don't understand much…

how do i know which process triggers these core files ?

claude_49

1

Re: SQL Query to extract Tax Information for AR Invoices

SELECT
SUM(inv_amount) inv_amount,
SUM(line_amount) line_amount,
SUM(tax_amount) tax_amount
FROM
(
SELECT DISTINCT
rct.trx_number,
SUM(rctl.extended_amount) AS inv_amount,
CASE
WHEN rctl.line_type = 'LINE' THEN
rctl.extended_amount
ELSE
0
END AS line_amount,
CASE
WHEN rctl.line_type = 'TAX' THEN
rctl.extended_amount
ELSE
0
END AS tax_amount
FROM
ra_customer_trx_lines_all rctl,
ra_customer_trx_all rct
WHERE
1 = 1
--AND CUSTOMER_TRX_ID='171946'
AND rct.customer_trx_id = rctl.customer_trx_id
AND rct.trx_number = '&invoice_number'
GROUP BY
rct.trx_number,
rctl.extended_amount,
rctl.line_type
) x;

Thanks

from Prasanta Nath

User_4NMWW

1

Re: Purchase approvals for N line type purchase orders

Thanks for clarification @GeaninaM-Oracle

User_O17JA

1

Re: How can I get all 9 digits of precision in systimestamp?

Wow, Solomon! Some nice java code you've got there! :) Thanks for sharing it.

It looks like it won't be fast enough to solve my issue, though, since could take a noticeable amount of time to run and my issue is down in the nanoseconds, calling it for every insert is likely to cause a noticeable performance degradation. But I'll keep it as a last resort option.

Meanwhile I've continued to press for a solution from Oracle. Their Dev group had taken my report as a bug, but the latest back from the fellow working my SR is:

DEV closed the bug with the following comments :

---------------------------------------------------------

This precision is delivered by the OS. The current implementation uses SYSTEMTIME on Windows and timeval on Linux. These structures support milliseconds only.

----------------------------------------------------------

Hence the feature is not supported.

That is just crazy as I can demonstrate my OS will return nanoseconds if asked. So I replied:

Please push back on that - Oracle can support the additional precision on Linux.

Googling returns two options for getting the time - the old one mentioned by Dev "timeval" and a newer one "timespec" that would return all the precision Oracle alleges to support in the timestamp datatype.

Here's the info I got back googling:

In Linux, the timeval structure represents time in seconds and microseconds, while the timespec structure represents time in seconds and nanoseconds. The timeval structure is commonly used with functions like gettimeofday, while timespec is used with functions like clock_gettime for higher precision time measurements.

Use timeval when microsecond precision is sufficient, and you're working with older APIs or functions like gettimeofday.

Use timespec when you need nanosecond precision, especially when dealing with higher resolution clocks and functions like clock_gettime.

timespec is generally preferred for newer code and when performance is critical, as it provides a higher resolution time representation.

So now the fellow supporting my SR is kindly checking again with their Dev team. Having been a developer back in the day, I can imagine this change could be messy to implement but if they are going to advertise (9), they ought to come through with it.

I'll update this conversation if anything newsworthy comes in. :) Thanks again for the help and the slick java code!

-Lisa

Lisa Tansey

1

Re: REFER-initiated Call Transfer

Hello,

Off-topic: Adrian (QuantSBCSupport), a contributor to this community, asked me to send his greetings to you ☺️. I've worked with Adrian for many years in the same company, but he left our company in May this year.

About the REFER, I come to the same conslusion. I tried many combinations of refer-call-transfer and dyn-refer-term, without success.
The only difference between the call flows I have is the ingress realm of the initial INVITE, and it seems that this can't be used to determine how the REFER is handled.

For now, I am going to choose for terminating the REFER and generating a new INVITE for both call flows, because we need to deliver the project in the next days.

Thanks for your help

sdeferme_quant

2

Re: Purchase approvals for N line type purchase orders

Hi,

If 230 is not set as next status in order activity rules, how does the OP go to 220-230?

Please note that in the processing options of P4310 The Override Next Status processing option #4 sets the status for the system to override the next status on all lines in the purchase order. For approval processing to work, this needs to be blank. Any value other than blank in this field will "turn off" approval processing functionality. (E1 8.9 and above). (E1: 43: Approval Processing in EnterpriseOne (Doc ID 2090884.2) - Setup tab - Processing Options Purchase Order Entry )

Please also see E1: 43: Approval Processing for N Line Type orders (Doc ID 2548530.1).

Thank you,

Geanina

GeaninaM-Oracle

1

Re: Oracle Data Guard Setup between windows DB servers

Hi,

I have moved this question into the Oracle Database (MOSC)› High Availability Data Guard, Sharding and Global Data Services (MOSC) subcategory for those subject matter experts to further engage.

If an answer resolves your question, please choose the "YES" on that comment for "Did this answer the question?".

In the meantime, feel free to review the following information to learn more about our Community:

How to Find and "Follow" Categories - Learn how to Follow Categories of interest
Setting Up Category Notifications for New Content - Learn how to get notifications on content
How to Search and Do Advanced Search - Learn how to get to advanced search and filter options
Visit our MOSC Resource Center,
Browse all of our represented Product Categories.
How to Edit Your Community Username - Details are provided to change your default display name, which will allow for a more personalized profile.
How to Ask Questions and View Answers - My Oracle Support Community organization details are provided, which can be used to find the product subcategory for your question.
Community Guidelines: https://community .oracle.com/mosc/kb/articles/27-my-oracle-support-community -guidelines
How to be a good Community citizen" -- https://community .oracle.com/mosc/kb/articles/23-my-oracle-support-community -posting-etiquette
Not posting Private Information: https://community .oracle.com/mosc/kb/articles/15-what-is-pi-information-and-why-is-it-important
How to be a Community Star: https://community.oracle.com/mosc/kb/articles/30-how-to-be-a-community-star-six-behaviors-to-promote-mosc-success

Best Regards,

Margi

My Oracle Support Community Administrator

Margi-Oracle

1

Re: Oracle Data Guard Setup between windows DB servers

Hi,

You can follow the below document.

Creating a Physical Standby using RMAN Duplicate (RAC or Non-RAC) (Doc ID 1617946.1)

Thanks

Sethu

SethuKanthiah-Oracle

1

Re: How can I get all 9 digits of precision in systimestamp?

https://community.oracle.com/mosc/discussion/comment/17071165#Comment_17071165

Not as quick as SYSTIMESTAMP:

SQL> SELECT SYSTIMESTAMP FROM DUAL;


SYSTIMESTAMP

---------------------------------------------------------------------------

24-JUL-25 09.41.14.337900 AM -04:00


Elapsed: 00:00:00.00

SQL> SELECT OSCOMMAND('/usr/bin/date "+%D %T.%N %z"') TS FROM DUAL;


TS

--------------------------------------------------------------------------------

07/24/25 09:41:22.519871531 -0400


Elapsed: 00:00:00.17

SQL>

SY.

SolomonYakobson

1

Re: question about server not booting with latest kernel [after moving /boot to LVM]

"interestingly, one notable hit looks to be one of our previous exchanges", 😁

GravyKing

1

Welcome to the My Oracle Support Community

Best Of