GLOOAP: Open Period Status : Error

+---------------------------------------------------------------------------+
General Ledger: Version : 12.2

Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

GLOOAP: Open Period
+---------------------------------------------------------------------------+

Current system time is 30-JAN-2023 09:57:05

+---------------------------------------------------------------------------+

[30-JAN-2023 09:57:05]: 
>> main() 
[30-JAN-2023 09:57:05]: 
>> glusca() 
[30-JAN-2023 09:57:05]: 
<< glusca() 
[30-JAN-2023 09:57:05]: 
>> glulsr() 
[30-JAN-2023 09:57:05]: 
<< glulsr() 
[30-JAN-2023 09:57:05]: 
>> glooap() 
[30-JAN-2023 09:57:05]: 
>> gloovp() 
[30-JAN-2023 09:57:05]: 
<< gloovp() 
[30-JAN-2023 09:57:05]: 
>> glopcs() 
[30-JAN-2023 09:57:05]: 
<< glopcs() 
[30-JAN-2023 09:57:05]: 
>> gloodb() 
[30-JAN-2023 09:57:05]: 
<< gloodb() 
[30-JAN-2023 09:57:05]: 
>> glucmt() 
[30-JAN-2023 09:57:05]: 
<< glucmt() 
[30-JAN-2023 09:57:05]: 
>> gloobl() 
[30-JAN-2023 09:57:05]: 
>> gloroc() 
[30-JAN-2023 09:57:05]: 
>> glucmt() 
[30-JAN-2023 09:57:05]: 
<< glucmt() 
The data that defines the flexfield on this field may be inconsistent. Inform your system administrator that the function: FDFRKS could not find the structure definition for the flexfield specified by Application = &APPL, Code = GL# and St
The data that defines the flexfield on this field may be inconsistent. Inform your system administrator that the function: FDFRKS could not find the structure definition for the flexfield specified by Application = &APPL, Code = GL# and St
SHRD0073: fdfgac()--Unable to obtain active segments.
[30-JAN-2023 09:57:05]: 
<x gloipi() 
*****************************************************
sqlcaid:   sqlabc: 0  sqlcode: 0  sqlerrml: 0
sqlerrmc:
ORA-01403: no data found                                              
sqlerrp:   sqlerrd: 0 1 0 0 0 538976288
sqlwarn:           sqltext:  
*****************************************************

oracaid:   oracabc: 0
oracchf: 0   oradbgf: 0   orahchf: 0  orastxtf: 0   orastxtl: 0
orastxtc:

orasfnmc:   oraslnr: 0  orasfnml: 0
orahoc: 0  ormoc:  0  oracoc: 0  
oranor: 0  oranpr: 0  oranex:  0

SHRD0015: gloipi() failed:
SHRD0033: Error Status:   0
SHRD0103: Function warning number: -1
*****************************************************
SHRD0044: Process logging off database and exiting ...
[30-JAN-2023 09:57:05]: 
<x gluccf() 
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+


+---------------------------------------------------------------------------+
No completion options were requested.

Output file size: 
0


Output is not being printed because:
The print option has been disabled for this report.
Deleting empty output file.
Concurrent program returned no reason for failure.

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 30-JAN-2023 09:57:05

+---------------------------------------------------------------------------+
Ledger_short_name = _SOBAccess_set_id = 1006Ledger_id = 3006Chart_of_accounts_id = 50480Application_id = 101Execution_mode = PTarget_Period_Name = 1월-23User_name = PO_SM2Request_id = 345662551User_id = 15437Login_id = 359773441glopcs() - second argument (ledger_id) = 3006

 

비슷한 예인듯 싶다.

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=81509634318102&parent=EXTERNAL_SEARCH&sourceId=HOWTO&id=473554.1&_afrWindowMode=0&_adf.ctrl-state=yndflyjgm_77

Example:

Error:
APP-FND-00668: The data that defines the flexfield on this field may be inconsistent. Inform your system administrator that the function: FDFRKS could not find the structure definition for the flexfield specified by Application = &APPL, Code = CMP and Structure number = 50378 (APPID=800)
FDFBKS: REQUIRED constraint specified for the Default Attribute qualifier is not satisfied"

Solution:
Navigation:
System Administrator > Application > Flexfield > Key > Segments > Competence Flexfield
Unfreeze your structure and set the attribute "Default Attribute" for one segment.

If you have any troubles to identify which structure is having the issue,
please run

SELECT ID_FLEX_STRUCTURE_CODE  from fnd_id_flex_structures
where ID_FLEX_NUM= 50378

To implement the solution, please execute the following steps:
1. Skip the Failed worker
2. After the upgrade completes:
SELECT ID_FLEX_STRUCTURE_CODE from fnd_id_flex_structures
where ID_FLEX_NUM= 50370
3. Navigation: System Administrator
4. > Application > Flexfield > Key > Segments > Competence Flexfield
Unfreeze your structure and set the attribute "Default Attribute" for one segment.
5.. Retest the issue.
6 Migrate the solution as appropriate to other environments. (suggestion is to make the flexfield correction prior to upgrade to avoid the error)