My Oracle Support Banner

R12: CE: Invalid Operating Unit Error When Searching For Transactions To Unclear: FRM-40212: Invalid value for field OPERATING_UNIT (Doc ID 779303.1)

Last updated on JULY 10, 2020

Applies to:

Oracle Cash Management - Version 12.1 and later
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

R12
When searching for Cash Management Cashflow transactions to unclear in the
Manual Clearing > Unclear Transactions window,

getting  the following error:

FRM-40212: Invalid value for field OPERATING_UNIT


Please provide results after the following steps.

1) Initialize the context by executing following PL/SQL Block.
Note: To obtain the parameters to be passed to the block,

Please open the Bank Statement Reconciliation Form
- Go To Help -> Diagnostics -> Examine
- Set the Block value as $PROFILES$
- Set the Field value to following one after the other and note the values.
-> RESP_ID
-> USER_ID
-> ORG_ID

- Use the Above values as arguments in the PL/SQL Block below.

begin
fnd_global.apps_initialize(&USER_ID,&RESP_ID,260);
dbms_application_info.set_client_info(&ORG_ID);
cep_standard.init_security;
end ;



2) Execute Following SQL Statement and provide us with the output in xls
format.


SELECT * FROM
CE_SECURITY_PROFILES_gt SP,
CE_LOOKUPS l
WHERE SP.ORGANIZATION_TYPE = 'LEGAL_ENTITY'
AND L.LOOKUP_CODE = SP.ORGANIZATION_TYPE
AND L.LOOKUP_TYPE = 'ORGANIZATION_TYPE'
AND (SP.ORGANIZATION_ID = (SELECT ACCOUNT_OWNER_ORG_ID
FROM CE_BANK_ACCTS_GT_V
WHERE BANK_ACCOUNT_ID = -1)
or exists
(select '*'
FROM ce_BANK_ACCT_USES_ALL bau
where sysdate <= nvl(bau.end_date,sysdate)
and bau.legal_entity_id = SP.organization_id))
and exists
(select 1 from ce_system_parameters sys
where sys.legal_entity_id=sp.organization_id);

Changes

 

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
Changes
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.