Best Of
Re: patch download corrupt
Hi Team,
Thank you for reaching out to Oracle Communities. We will arrange for an expert to review your post and work with you at the earliest.
Regards,
Satheesh Kumar N
Re: Product certification search in MOS
ahhh, I see for that version none show, Usually it shows up under the 'Category' column. Let me follow up with the Portal team and will update you when they get me an actual answer….
Thanks,
Margi
Re: is it possible to include negative invoices in Dunning?
Hi,
It is possible, but you must create your own custom views, scoring engines and possibly templates.
By design, the seeded scoring engine (Scoring Engine 2) will not flag negative invoices as delinquent as they customer has a negative balance.
The seeded scoring engine uses the following criteria to insert data into IEX_DELINQUENCIES:
1. Must have a class of Invoice (INV), Debit Memo (DM), Chargeback (CB)
2. Amount due remaining must be > 0
3. Status must be Open (OP)
4. Dispute Date must be null
5. Invoice is not selected to be paid by a receipt batch (selected_for_receipt_batch_id must be
null).
6. Due Date < Sysdate
The above is detailed in this KM Document:
Invoice in Advanced Collections is Past Due but Still has a Current Status KB750365
You can review the views used by the seeded scoring component (IEX_DELINQUENCIES_NEW_V) and the seeded scoring engine (IEX_F_SCORE_INVOICES_V) and create your own custom views and engine.
Unapplied receipts can be show on the dunning letter by using the seeded template 'Dunning Soft Letter with On Account credit memos & unapplied receipts'. You can model your custom template after that template. The query behind the template is what controls what shows on the template. This is detailed in this KM document:
Unapplied Receipts are not Included on a Dunning Work Item (KB722700)
Best Regards,
John
Re: PSPPFUND constraint error
It's been a few weeks but as I recall after we applied all the patches, including the 38678079 Penny mentioned above, we saw the select statement had been changed to include a "NOT EXISTS" so it will not attempt to insert a duplicate value into the staging table:
SELECT DISTINCT C.TAX_CLASS FROM PS_PY_PFF_PGID_CHD C WHERE C.EFFDT = (SELECT MAX(C1.EFFDT) FROM PS_PY_PFF_PGID_CHD C1 WHERE C1.EFFDT <= :1 AND C1.PY_PFF_PROGID = C.PY_PFF_PROGID) AND C.EFFSEQ = (SELECT MAX(C2.EFFSEQ) FROM PS_PY_PFF_PGID_CHD C2 WHERE C2.PY_PFF_PROGID = C.PY_PFF_PROGID AND C2.EFFDT = C.EFFDT) AND C.PY_PFF_TAX_CAT = 'R' AND NOT EXISTS (SELECT 'X' FROM PS_PY_PFFTXCLS_STG S WHERE S.TAX_CLASS = C.TAX_CLASS AND S.PY_PFF_TAX_CAT = C.PY_PFF_TAX_CAT AND S.PROCESSINSTANCE = :2 AND S.COMPANY = :3 AND S.PAYGROUP = :4)
Re: When is the Affordable Care Act for 2025 patch going to be released?
Happy New Year! The patch is targeted for release sometime this week.
Re: How Oracle is going to adjust the W2 to be in line with the One Big Beautiful Bill.
Thanks Justine! Happy New Year! :-)
Re: What happened to My Oracle Support?
Shame, Shame, Shame on Oracle!!!
This new MOS for the Oracle Database is a complete disaster !!!
Oracle must bring back the classic MOS interface immediately !!!
Oracle must listen to customers !!!
This should have been rollout in phases, and the classic MOS still available for a long time till all glitches were sorted out in the new MOS. !!!
I am really upset !!! : (
I cannot find anything in MOS anymore !!!
Re: My Oracle Support, are you really happy with what you've delivered ?
Shame, Shame, Shame on Oracle!!!
This new MOS for the Oracle Database is a complete disaster !!!
Oracle must bring back the classic MOS interface immediately !!!
Oracle must listen to customers !!!
This should have been rollout in phases, and the classic MOS still available for a long time till all glitches were sorted out in the new MOS. !!!
I am really upset !!! : (
I cannot find anything in MOS anymore !!!


