Best Of
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
Re: Journal Source Freeze/Unfreeze report
Hi
Not sure about report but you can find details in GL_JE_SOURCES. Use OVERRIDE_EDITS_FLAG for freeze information and standard who columns shall inform you about last edits
Regards
G1
G1
expect database version PMDB,2509.000.000 but found database version PMDB,2312.000.000
I am connecting p6 pro with P6 EPPM and getting a database mismatch error:
expect database version PMDB,2509.000.000 but found database version PMDB,2312.000.000
How to resolve this error.