Best Of
Re: Query to see "days until next password change"
( I couldn' t resist and I've done your homework ;-)
SELECT u.username
, u.password_change_date
, u.profile
, NVL( TO_CHAR( u.password_change_date + TO_NUMBER( p.limit DEFAULT NULL ON CONVERSION ERROR ) ), 'never' )
, ROUND( MONTHS_BETWEEN( u.password_change_date + TO_NUMBER( p.limit DEFAULT NULL ON CONVERSION ERROR )
, sysdate )
) months
FROM dba_users u
INNER JOIN dba_profiles p
ON p.profile = u.profile
AND p.resource_name = 'PASSWORD_LIFE_TIME'
[WHERE …]
;
Best regards,
Bruno
Re: Query to see "days until next password change"
Hello Charles,
simpler: ADD_MONTHS( password_change_date, 12 ) but maybe you should go to some more complexity than "add 1 year"; indeed, is this one year sure for any user? You might join with DBA_PROFILES to see the actual limit assigned to each user (and take into account the possibility of value "UNLIMITED")
Best regards,
Bruno Vroman.
Re: After April 2025 PSU materialized view refresh failing which connects to SQL Server using dg4odbc.
Please remove-
HS_FDS_REMOTE_DB_CHARSET=SQL_Latin1_General_CP1_CI_AS
Then add
HS_FDS_REMOTE_DB_CHARSET=AL32UTF8
Retest and let me know.
Thank you,
Resmi
Re: Manage Abends - Temporary Tables - Data Left in Tables?
Thanks so much. This answers my question.
Steve
Integration broker console almost empty
On our PIA Peoplesoft 9.2 HR, tools 8.61 though we have a dozen of active web services, the integration broker console is almost empty, is there any issue with configuration ?
Re: In PeopleSoft ERS Vouchers how to process lines with Tariff
Oh wow! we are lucky, in our case we do not use ERS for many supplier/locations and the ones we do wouldn't have a tariff - thankfully.
For the type of business we are, the cost of the tariff has to become part of the cost of the item, so we can't add a line for the tariff or it to the misc charge currently. I guess if we had another for DUTY that might work, assuming the coding behind it goes to the right place.
If you have a line specific for the tariff, are they receiving it to create the ERS voucher?
Wendy
Re: Migration Installation Failing at Bootstrap
Hi,
We would never allow our clients to do a migration like you are dong. We insist on always doing fresh installs since they are always much cleaner that migration installs. I am pretty sure fresh installs are also more highly tested by Oracle and used much more frequently by Siebel customers.
If it is not too late suggest to change your whole approach to something that is much safer and much more highly tested that what you are attempting.
R
Re: Migration Installation Failing at Bootstrap
You should start over and not to try to troubleshoot something that started wrong.
Regards,
Michael Harada
Re: Why is NN skipping the correct invoice number as per set NN set up India Localization R42565 ?
Hi Mahesh,
Thank you for information, Actually R42565 check F4211 and F03B11 record to assign NN from set up, If the same number find it will assign next number directly.
Thank you very much, now our issue is resolved
How to close Purchase Order at 400-400 status
Dear All,
User has created a PO for quantity 300. Through EDI, received quantity 288, 12 and 20. I see 3 lines in F43121. Quantities 288, 12 are moved to stock. Excess quantity, user has P4314, did PO receipt reversal. In F4312, I see lines at 400-400, qty order=300, Qty received=300, no open quantity. what is the best way to close the PO from front application, not using SQL update.
Please let me know if you have any questions.
Thanks