Best Of
Re: How can I get all 9 digits of precision in systimestamp?
You can see the nano-seconds on linux with the following command:
date +%T+%N
On our linux systems we see in OS 9 digits but in de oracle database just 6 digits. Looks like an oracle issue.
But like @Mr. C says use a sequence is a much better way to keep the order.
[oracle@ ~]$ date +%T+%N
11:00:30+627382024
SQL> SELECT SYSTIMESTAMP(9) FROM DUAL;
SYSTIMESTAMP(9)
11-JUL-25 11.01.11.855980000 AM +02:00
Re: How can I get all 9 digits of precision in systimestamp?
Maybe the system can't provide that much detail, as what we are talking about is 1 millionth of a second. I'm not sure what the timespecs are of regular Linux/Windows machines, but there is a limit somewhere and I think you found it. I've never needed to go less precise than a second ever, but your mileage may vary.
But, if the order is that important, and you need to be able to track the order, why don't you use a sequence instead ? This is what they are built for, by the way.
Mr. C
Re: Union Bargaining Unit Service Date for Leave Accrual
Hi Stella,
There is no blanket way to do this for the entire union group, but you could enter that date as an override on the Benefits Service Date (Workforce Administration > Job Information > Job Data > Employment Data link) for each affected employee if you don't have any other benefits for these employees that are dependent on Service where a different date would be needed.
Another option would be to consider Absence Management which provides greater flexibility in configuring leave entitlements.
Other customers who have had similar requirements are encouraged to share how they were able to meet that need in either Base Benefits Leave Accruals or Absence Management.
Regards,
Joyce
Re: why GL effective date is always end on the period
Hi,
the behavior for manual journals is described here:
GLXJEENT Journal Entry: How Do GL Effective Date and Period Default in GL Journals? (Doc ID 2906220.1)
For imported journals, please see:
R12 Why Does the Journal Effective Date for Journals Imported From the Subledger Default to the Last Date of the Period ? (Doc ID 472928.1)
How Does Journal Import Derive DEFAULT_EFFECTIVE_DATE for Journal Batches in R12 (Doc ID 1679020.1)
Let us know for further questions.
Kind regards,
Adriana
Re: ANNOUNCEMENT: Oracle Forms and Reports 14.1.2 has been released.
@User_MMEYT Please refer to the Certification Matrix and System Requirements Guides before performing any installation. To your question, if you want to use F/R 14.1.2 you will need a 19.14 or newer database both for RCU data and app data IF you are concerned about using a certified and supported configuration.
Links to all the needed documents can be found on the Forms product page in the Documentation section. General FMW documents like Cert Matrix and Sys Reqs are under the section titled Related FMW Content.
https://www.oracle.com/application-development/technologies/forms/forms.html
Re: LCM Migration Question
Pradeep,
You had asked in another thread about Database Migration from Oracle DB → SQL Server. If you do that, you won't need to migrate FDMEE artifacts via LCM. The caveat being if you have Location Security or LDAP configuration in Shared Services (in this case you will need to utilize LCM). Be aware that LCM extracts are not DB specific since they are XML based files which allow for dynamic migration.
LCM Doc for EPM 11.2
Best Regards,
Nathan
FDMEE MOSC Community Lead
Senior FDMEE Support/Developer Hybrid Engineer
For the benefit of your community peers, if you find this reply has either resolved or helped progress your issue, please answer "Yes" to the prompt, "Did this answer the question?" That will make it easier for others with the same question to find the best solutions.
Re: MasterCard CDF3 Transaction Loader program is now populating Billed Date after upgrade to 12.2.13.
Thanks, George. I will do that.
Thanks,
Sharla
Re: How to generate Cash at Bank Account with Location (seg2)
Thanks, from Bharat's advice and referring Doc ID 1544633.1 we able to configure the SLA/ADR to generate the Cash Account with location segment based on Mapping.