Best Of
Re: When can we expect a patch for Ireland on the Auto-Enrolment Retirement Savings Scheme
Hello Bernard,
There have been no detailed specifications released on how the scheme is going to be operated.
We have had no technical specifications given yet, therefore we can't advise on any time scales currently.
Unfortunately, at this time, we don't have sufficient technical details to guide us on what change is needed.
This is the same for all vendors.
Kind regards,
Mariana
Re: Can Oracle EBS R12 be used on mobile phones?
Oracle provides a set of mobile applications for key Oracle EBS modules such as Approvals, Timecards, and Expenses. These apps are purpose-built, available for iOS and Android, and offer a user-friendly mobile experience. Please refer Oracle EBS Mobile Apps documentation for details.
https://docs.oracle.com/cd/E26401_01/doc.122/e64384/T656045T656048.htm
Re: Any recommendations "India - Period Ending Process" how many times we can run it in a month?
Thanks a lot Priyanka and Avinash for need full support on sharing the required details and knowledge
Re: Issue in redirection between Public and non-public web domains
Mathesh - Servlet filter approach requires java code.. i will try building over the weekend if i am free and share the code.
-Velu
Re: How to resolve Pending transaction with error INV_GROUP_ERROR?
Hi
Its intended that whatever number of records processing in one batch, if even one get to error, rest all will also get stuck in interface.
Regards
Re: Application of Receipt in one gainst an invoice in another OU
As the note suggests you cannot apply the receipt across the OU's.
You may have to do the following manual steps .
1) Create a Credit Memo and apply it to the invoice in the OU1 . This will close the O/S in OU1.
2) Create a Debit memo with the same amount as the CM above and apply it to the receipt in OU2.
This would ensure that the receipt is fully applied .
A more complex but correct method ( if you are using R12 ) would be to create the CM and Debit Memo like above , but create them for the OU.
i.e. CM in OU1 with the customer as OU2 and DM in OU2 with OU1 as the customer.
Later you can settle the outstanding between the two OU's by using the AGIS ( Oracle Advanced Global Intercompany System ).
Let me know if that helps.
Regards,
Vikranth
Re: How to identify database files that were NOT backed up in 24 hours?.
Actually I can see advantages to using queries over connecting to rman to get this information. It would be pretty easy to write a script to connect to all your database and run a query to verify that the files have been successfully backed up overnight etc....
- -
If an rman catalog is in use then you should be able to do the same using it.
- -
set echo off
--
-- Find files not backued up within cutoff period
--
-- 2014-09-08 Mark D Powell Develop 2 answ Ora forum post
-- 2014-09-16 Mark D Powell Mod 2 filter against last bkup
--
set pagesize 999
set verify off
col file_name format a60
prompt 'Script will display files not backed up in N days. Enter 0 to see last backup'
prompt 'Enter .5 for 12 hrs, 1 for 24 hrs, etc ... '
prompt 'No rows means all files backed up'
accept cutoff number
select
df.file_name
,coalesce(to_char(bd.completion_time,'YYYY-MM-DD HH24:MI:SS'),'MISSING') as LAST_COMPLETION
from
dba_data_files df
left outer join
( select
iv.file#
,max(iv.completion_time) as completion_time
from
v$backup_datafile iv
group by
iv.file#
) bd
on
( df.file_id = bd.file# )
where
bd.completion_time <= ( sysdate - &cutoff ) or
bd.completion_time is null
/
- -
What works best always depends on exactly why you need to do something and the environment. I am a big fan of getting information from the rdbms itself where possible.
HTH -- Mark D Powell --
Re: Account field mandatory when Creating Requisitions in Purchasing v9.1
Hi Wael,
First of all, thank you for your fast response. Going back to this issue, so there is basically no "On/Off" switch? I would actually like to make the Account field mandatory so instead of getting a Warning message, the user would be getting an Error message instead, preventing the creation of the requisition unless there was a valid value inserted in the Account Field (since it is already mandatory in the Purchase Order, I don't see why the requisition should be created without this value).
Again, thank you for your help.
Jorge
Re: Generate UKID for records that need to be SQL'd into F43199 and F43121
From Oracle Support: thank you for the post Angie.
For the F43199 specifically, you can launch the P00022 application, query on the F43199, and it will display the next UKID to be used; try to insert that manually in your SQL, ensuring that it is not already used by another user etc…..
The F43121 is not shown in the P00022 here, and is probably the same for you. Looking at our F43121, out of 25000+ records, only a handful have a UKID number; do the majority/all of your F43121 records carry a UKID? We may need to investigate further under a Service Request.
WIth regards,
-Matt
