Description for Journal Entry Line not Populated in GL_JE_LINES.REFERENCE10 in Oracle R12

Issue:

When Journal Import runs in summary mode, the description will always be 'Journal Import Created'. When Journal Import runs in detail mode, the description will only be 'Journal Import Created' if reference10 is null, and the subledger_doc_sequence_value is null on GL_INTERFACE.

Solution

Run Journal Import in detail mode. 

1. Use General Ledger Super User

2. The Navigation Path is:Journal>Import>Run 

3. Make sure Create Summary Journals checkbox is blank.

How to check Prepayment Fully applied status using Invoice_id input in Oracle Payables

SELECT pv.VENDOR_NAME,
ai.invoice_num,
NVL (
DECODE (
SIGN (SUM (amount - NVL (prepay_amount_remaining, amount))),
1,
DECODE (SUM (prepay_amount_remaining), 0, 'Y', NULL),
NULL
),
'N'
)
AS PP_F -- Y is Fully Applied, N is Partially or Not Applied
FROM ap_invoice_distributions_all aid, ap_invoices_all ai, po_vendors pv
WHERE aid.invoice_id = ai.INVOICE_ID
AND pv.VENDOR_ID = ai.VENDOR_ID
AND aid.line_type_lookup_code = 'ITEM'
AND ai.invoice_type_lookup_code = 'PREPAYMENT'
AND ai.INVOICE_ID = :P_INVOICE_ID
AND NVL (reversal_flag, 'N') <> 'Y'
GROUP BY pv.vendor_name, ai.invoice_num
HAVING NVL (
DECODE (
SIGN (SUM (amount - NVL (prepay_amount_remaining, amount))),
1,
DECODE (SUM (prepay_amount_remaining), 0, 'Y', NULL),
NULL
),
'N'
) <> 'Y';

How to check online FND_USERS in Oracle EBS R12

SELECT DISTINCT icx.session_id, icx.user_id, fu.user_name, fu.description
FROM icx_sessions icx, fnd_user fu
WHERE disabled_flag != 'Y'
AND icx.pseudo_flag = 'N'
AND ( last_connect
+ DECODE (fnd_profile.VALUE ('ICX_SESSION_TIMEOUT'),
NULL, limit_time,
0, limit_time,
fnd_profile.VALUE ('ICX_SESSION_TIMEOUT') / 60
)
/ 24
) > SYSDATE
AND icx.counter < limit_connects
AND icx.user_id = fu.user_id