Best Of

Re: Filter Data from a Prompt Table with no customization

The built-in function SetRecFieldEditTable() will change the metadata (record definition). It is not doing a runtime override.

The prompt edit for record-field PR_REQUEST.TXN_CURRENCY_CD is view CURR_TXN_VW. Use the Prompt Table Override feature to override this at runtime with your own view. Read the documentation for this feature.

Peter Smith Arizona

2

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

Maybe other OS can do it. I'm thinking of Unix, or even more exotic OS that may no longer be supported.

Or, it may be a future function … working on it :)

Or it may be a permanent wish list function, or it may be prepared for case somebody makes it work.

A lot of options

Mr. C

1

Re: Filter Data from a Prompt Table with no customization

Hi - you can create a dynamic view and use setrecfieldedit peoplecode to override using appclass in event mapping.

Though i have not tested but i feel it may works..let me know how it goes

-Velu

Velu Angusamy

1

Re: How do we know that job running in subsystem is working

Go to row(View Logs) for the subsystem job in WSJ, review jde.log.

In Server Manager, go to EOne Enterprise Server instance > Runtime Metrics > Process Detail > look up JDE.log of Subsystem kernel.

Dorothy Ahfat-Oracle

1

Re: Need Help: 500 Internal Server Error After Configuring SSO for WebLogic Server

Hello @User_C1OMK,

Please review the following for OEM and in case issue persists, please log an SR with support.

	EM 13.5: Is Azure AD Certified As Identity Provider (IdP) for OEM SSO configuration? (Doc ID 2826962.1)

Regards,

Satya

Satya Chandan-Oracle

1

Re: Filter Data from a Prompt Table with no customization

It depends on how the field with a prompt edit is defined on the record definition. Either way, it requires a custom view record.

If the prompt edit is dynamic (example: %EDITTABLE), then use an event map to override the prompt edit view. Below is an example.

Local Record &recDERIVED = GetLevel0().GetRow(1).GetRecord(Record.DERIVED);
&recDERIVED.EDITTABLE5.Value = Record.Z_VNDRLKUP_VW;

If it is not dynamic, you can use the delivered Prompt Table Override feature. This feature requires a dynamic view record type, and the record has specific requirements (we use "WHERE 1=1 %oprclause").

PeopleTools > Security > Security Objects > Prompt Table Overrides

Peter Smith Arizona

2

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

Hello Lisa,

thanks for your feedback.

I have the same behaviour: SYSTIMESTAMP limited to 6 "F", although the database can handle more.
For example:

SQL> SELECT systimestamp def
  2    , systimestamp(9) explicit_9
  3    , systimestamp + NUMTODSINTERVAL( 0.123456789, 'SECOND' ) add_nanosec
  4    , TO_TIMESTAMP( '13-01-2025 20:30:40.987654321', 'DD-MM-YYYY HH24:MI:SS.FF' ) built
  5    FROM dual;
DEF                                    EXPLICIT_9                             ADD_NANOSEC                            BUILT                          
-------------------------------------- -------------------------------------- -------------------------------------- -------------------------------
16-JUL-25 10.11.30.474365000 AM +02:00 16-JUL-25 10.11.30.474365000 AM +02:00 16-JUL-25 10.11.30.597821789 AM +02:00 13-JAN-25 08.30.40.987654321 PM

So I suppose that the call to OS layer routines to feed SYSTIMESTAMP is limited to 6 F, but for example you might take advantage of more digits in a SQL Loader session with the timestamps wrtten as strings of chars. So we might say that Oracle "is not the guilty" here.

As I wrote: maybe it is not important if sometimes 2 or more rows are inserted within the same millionth of a second, but you have to forget about a unique index on the column (hence my suggestion to order with the rowid added despite Gerrit's remark). If it is important, maybe you work at the CERN ;-)

Your post gave me the opportunity to look at those very tiny time intervals, and there are really people needing them, even more detailed that nanoseconds (9F), have a look at the White_Rabbit_Project wow, amazing… There are more nanoseconds in one second than seconds in 30 years… And what about picoseconds :-)

Thanks and best regards,

Bruno.