Financial Management - PSFT (MOSC)

MOSC Banner

PeopleSoft Billing Interfaces

edited Dec 4, 2024 10:31PM in Financial Management - PSFT (MOSC) 3 commentsAnswered

PeopleTools 8.56 PeopleSoft Version 9.2

Have other users maxed out the allowable value of  INTFC_ID?

What actions were taken to resume billing functions?

Has anyone implemented a purge process?

details:

INTFC_ID field is 8 integers in size.

We surpassed the allowable size/value of  INTFC_ID resulting in SQL error popup when users tried accessing billing pages online and BIIF0001 could not be ran.

Our work around was to free up interface ids by executing SQL to delete the oldest records from PS_INTFC_BI_AD_CMP, PS_INTFC_BI_CMP, and PS_INTFC_BI_NT_CMP.

Oracle response: Development reviewed and did an analysis to see if it is feasible to change the length and it is not feasible now as over 100 records in different modules is impacted.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

PSFT Financial Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center