My Oracle Support Banner

PRC:SSP: USER DEFINED FORMULA TO UPDATE PROJECT SEGMENT OF CHARGE ACCOUNT IS NOT WORKING (Doc ID 2965579.1)

Last updated on AUGUST 29, 2023

Applies to:

Oracle Fusion Self Service Procurement Cloud Service - Version 11.13.23.01.0 and later
Oracle Fusion Self Service Procurement - Version 11.13.21.10.0 and later
Information in this document applies to any platform.

Symptoms

On 11.13.23.01.0
==================

Requirement is to derive "Project" segment of charge account (length = 5 characters) using a Formula that extracts the first 5 numerals of an alphanumeric Project Number. A segment override rule is made with Source as Formula but the segment is not getting updated.

Steps

---------

1. Create a segment override rule for Project segment of charge account

2. Keep the source as a user defined formula that uses substring function to extract the first five digits of alphanumeric project number

3. On creating a PR, its found that Project segment is not getting updated based on segment override rule



Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.