Peoplesoft: Prompts not working?

Setid based prompts require a row for current setid to be present in SET_CNTRL_TBL and a row in PS_INSTALLATION if anything deleted in them check if this is the reason prompts not working.

NLS_LENGTH_SEMANTIC

Before setting NLS_LENGTH_SEMANTIC = CHAR and recreating tables, check if tables are already created in unicode (CHAR) format. query user_tab_columns where char_length < data_length

How to find running services on a Oracle Cluster

Use lsnrctl status to know if there is anything running on Oracle cluster

Integration Broker Setup

Question: How to find HTTP/HTTPS port of Webserver? Answer: Refer to the file ServerIndex.xml (bin--> config--> cells--> cellname--> nodes-->) Question: How to find JOLT port and AppServer URL? Answer: Appsrv.cfg or press ctrl+J in PIA. But if your IB domain is different than your web domain, check appsrv.cfg file of the IB domain (IB folder). Question:What is Next? Answer: Finish Gateway Configuration. Setup Default Local Node in Advanced Gateway Properties. Setup other Node there.

GLPCLOSE not producing any Journal Entry - Fixed

Came across a scenario where GLPCLOSE ran with success status but haven't created any Journal Entries. After debugging we found that Book Code Balancing on Installation Options level was active and calender was only setup till end of this year only, not any further going to next year.

In order to make it to first mountain top, we have to descend the first one. -Ms Fu.

Thoughts to motivate self

When I read Chirs Sacca saying: “Everything good in my life has come immediately following a period of anxiety, intensity, uncertainty and commitment.” Don’t stop believin’. I couldn't stop myself writing this. It is true, ain't it? in everybody's case probably, when you start you are full with energy, that intensity later on moves to state of uncertainty and anxiety, but if you loose the commitment all is waste. I think key is to keep a commitment to the goals, unbroken, unshaken. Pursue the goal with no look backs what so ever. I know it is hard but at least we can give it a good try!