ERPstuff - Oracle EBS Community

Hi, but Cross Validation is a spawn one. Is there any single query to filter that ?

Regards,
Fendy

Hi all,

Is there any way to build report that filter out data by cross validation rules ?

For e.g:
Acc. Flex -> Company.CC.Natural.Future.

The cross validation rules are excluding CC -> 01 and 05.

So all the combination_id that contains CC 01 and 05 will be filter out.

TIA,
Fendy

Hi experts,

I've got the HTTP 404 - File not found when doing the file attachment in prod server but not in dev server.
I'm using Oracle 11.5.9 (Linux AS 2.1) with the same configuration between both prod and dev.
Could someone tell me how to solve this problem.

Thanks In Advance,
efends

Hi experts,

Is there anyone ever define SQLPlus or PL/SQL procedure on concurrent manager ?
Where should i put my sql script ?

Regards,
efends

say i have 2 rows data : DR CR DR_VAL CR_VAL 100 0 100 0 200 500 0 300 The logic like this : DR_VAL = DECODE(SIGN(DR-CR), 1, DR-CR, 0)) CR_VAL = DECODE(SIGN(DR-CR), -1, ABS(DR-CR), 0) It is possible to do that ? Thanks, Fendy

Hi experts,

Can I do calculation like below with FSG :
I have DR, CR column, say

DR CR
=====
10 0

I want to define 2 new column (DR_VAL & CR_VAL) where :
- DR_VAL will be show only if DR - CR >= 0
- CR_VAL will be show only if DR - CR < 0.

TIA,
efends

Hi experts,

I'm using OEBS 11.5.9.
Where does reference_3 field on gl_je_lines refers to ?
The transaction category is Trade Receipts, source is Receivables.

TIA,
efends

Hi guys, I'm having a problem at GL report which the problem raise from oracle not the query. There is the diff between period_net_cr amount from gl_balances with summary of accounted_cr from gl_je_lines but just for one code_combination_id. I have try to compare from standard oracle report (trial b...