Best Of
Re: Summary Ledger
Hello
please find below some information from PeopleBooks and KM DB.
Summary ledgers store combined account balances from detail ledgers. You use summary ledgers primarily in PS/nVision reporting. Summary ledgers increase reporting speed and efficiency by eliminating the need to summarize detail ledger balances each time that you request a report. Instead, General Ledger summarizes detail ledger balances in a background process according to the criteria that you select and stores them in summary ledgers.
You can incrementally update summary ledgers with changes made since the summary ledgers were last created or updated in one of two ways:
- This updates only preexisting summary ledgers, which include business unit, summary ledger name, fiscal, and accounting period information.
- Start the Build Summary Ledger process using PeopleSoft Process Scheduler with an increment option to update summary ledgers.
More details:
EGL: How to Set Up Summary Ledgers and nVision Reports? (Doc ID 612741.1)
EGL: Can you build summary ledgers for Commitment Control ledgers? (Doc ID 648767.1)
Than you! Regards, Vali
Re: i am looking for information on PeopleSoft Archive Manager specifically for HCM/NA Payroll-PSHUP
Hi Rosemary,
We have used Data Archive Manager for PSHUP table transactions in past, you can follow below listed steps and implement PSArchive job.
Similarly you need to setup run control id for a Delete (from base table) job, create psquery, select archive number and schedule right after archive run control id. This job will delete data set based on archived data number.
so while scheduling make sure to update archive number input in delete job using Post AE or Pre AE customization to get updated for identifying next archive number. This is the important logic to make sure we schedule these jobs.
Create History Table:
- Duplicate PSHUP_TXNS in Application Designer, name it PSHUP_TXNS_H.
- Add PSARCHIVE_SBR subrecord as first field.
- Build table with indexes.
Define Archive Object:
- Go to PeopleTools > Data Archive Manager > Manage Archive Objects.
- Create object (e.g., HUP_TXNS), set PSHUP_TXNS as base, PSHUP_TXNS_H as history.
- Include related child tables if applicable.
- Save.
Create Archive Query:
- In Query Manager, create ARCHIVE_PSHUP_TXNS (Archive type, Public).
- Select PSHUP_TXNS, add criteria (e.g., PROCESS_DT < :1).
- Save and test.
Create Archive Template:
- Go to PeopleTools > Data Archive Manager > Manage Archive Templates.
- Create template (e.g., HUPTXNS, max 8 chars).
- Link archive object (HUP_TXNS) and query (ARCHIVE_PSHUP_TXNS).
- Save.
Run Archive Job:
- Go to PeopleTools > Data Archive Manager > Archive Data to History.
- Create job, select template (HUPTXNS).
- Choose Selection (copy) or Delete (copy and delete).
- Set commit intervals, enter bind parameters (e.g., date).
- Submit via Process Scheduler.
Verify Results:
- Query PSHUP_TXNS_H to confirm archived data.
- Check row counts against archive query results.
- Review audit log in Data Archive Manager > Audit Archiving.
Restore Data (Optional):
- Create restore query (e.g., RESTORE_PSHUP_TXNS) for PSHUP_TXNS_H.
- Update template with restore query.
- Run restore job via Archive Data to History.
Best Practices:
- Archive old data (e.g., >5 years for compliance).
- Use small batches, schedule off-peak.
- Test in non-production first.
- Check compatibility during upgrades.
Thanks,
Kiran.
Mandala
Re: i am looking for information on PeopleSoft Archive Manager specifically for HCM/NA Payroll-PSHUP
Rosemary - Please refer below post in case if you are in higher PUM version.
Paysheet Update Enhancement - how we are using it — oracle-mosc
-Velu
Re: i am looking for information on PeopleSoft Archive Manager specifically for HCM/NA Payroll-PSHUP
Please see PeopleBooks > Administration Tools > Data Management > Using PeopleSoft Data Archive Manager
https://docs.oracle.com/cd/F86650_01/pt859pbr5/eng/pt/tadm/UnderstandingPeopleSoftDataArchiveManager-077a9f.html
Re: Is there a native way to integrate PeopleSoft with SAP
Hello @user9502163 ,
There are several options to integrate 3rd parties to PeopleSoft, however there is no predelivered connector or interface for SAP.
PeopleSoft Integration worker is able to receive a variety of incoming data streams and perform services based on the content of the stream. Tradicional Web Services using SOAP , REST services using the the http and REST listening connectors, JMS connector , etc.
Please see the Integration Broker architecture diagram:
Re: Is there a native way to integrate PeopleSoft with SAP
Hi - Peoplesoft does not provide any native connector for third party but Integration broker is a common platform to integrate with other application..Peoplesoft support Rest / Soap for third party and you can provide or consume the webservice..
Please elaborate your requirement so that we can guide you further.
-Velu
Re: OEM 13.5 purging OMS and AGENT trace files safely
Hello @Alan Walker Alzueta ,
I searched in MOS and found the folloing MOS notes:
EM 12c, EM 13c: Locate and Manage the Various Logs/Trace files in Enterprise Manager Cloud Control Installation (Doc ID 1448308.1)
EM 12c, EM 13c: Which WLS Log Files Can be Removed / Purged Manually at Regular Intervals in OMS Installation for Space Considerations? (Doc ID 1445743.1)
Hope, that helps
Regards
Birgit
Re: Supplier Split Percentage - Mass Upload Tool
Hello Jayashree,
As the P43211 Enter Change form has the item number in the header, it is not a ready candidate for bulk entry, such as from import from Excel. I do not find an interoperability utility for P43211. This would likely best be met with a custom object to populate the F43211 or V43211A. Perhaps another client has a ready solution or third party code.
Regards,
Jeff
Re: Oracle BIP- Unifier report question- Default parameters
I'm not sure how you built the data model for your custom report, but if you used an internal data model, then you'll need the project_id column in the main data view. At report runtime, Unifier will filter the results of the main data view to only return rows where project_id matches the project id of the shell you're running the report from.
If you used a custom report with external data model, then there's a predefined Unifier parameter (uuu_p_context_project_id - see https://docs.oracle.com/cd/G18097_01/English/admin/admin_general/10282207.htm#subhead_predefinedunifierparameters28) that gets passed from Unifier to BI Publisher at runtime to accomplish the same thing.
To summarize, Unifier should only output results based on the shell you're running the custom report from. If you wanted to bypass that - you could (like getting all shells, or getting just the child shells) in the data model.
