Best Of
Re: Peoplesoft- I could not find the data on Match exception Collaboration Center Summary page.
Hi User_NU2EG,
Welcome to the Financial Management - PSFT (MOSC) Community and thank you for posting your question!
Here is some information - please check if you have data in the other tables
The Match exception Collaboration details are stored in the following records:
- AP_MECC_DTL-Match Exception Collaboration Detail.
- AP_MECC_ASSIGN-Match Exception Collaboration Assignments ( assign other groups/users to analyze, review, and make adjustment to data to resolve the exception)
- AP_MECC_LIST_VW- Accounts Payable(AP) MECC - Landing Summary Match Exceptions View
The Match Exception group details are stored in the following tables:
- Group details are stored in AP_MTCH_EX_GRP, AP_MTCH_GRP_ROL, and AP_MTCH_GRP_USR tables
- Group filters are stored in AP_MTCH_EX_GRP
- Group rules are stored in AP_MTCH_GRPRULE
The Accounts Payable (AP) matching process initially performs all the computations on what are all the exceptions that got triggered for a particular voucher and to whom these exceptions should be assigned.
Before inserting the exception details into AP_MTCH_EXCPTN, the process checks if there are any exceptions existing in the AP_MTCH_EXCPTN for a particular voucher. If available then these details will be overridden with the new computed values.
The exception details from AP_MTCH_EXCPTN that are not already present in the PS_AP_MECC_DTL, will be inserted into the PS_AP_MECC_DTL table with CREATE_DTTM as the system time(when the process was run).
Regards
Vaishali N
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 !!!



