REP-0300: ORACLE error occurred in oracle reports

If the below error occurs

REP-0300: ORACLE error occurred.
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error: 
REP-300: ORACLE error occurred.

Answer:Please check the report parameter data types.It should be correct to overcome the issue.

CE_RECONCILED_TRANSACTIONS_V returns no rows in R12

MO_GLOBAL.Init('SQLAP');

MO_GLOBAL.Set_Policy_Context('S', &l_org_id);

FND_GLOBAL.Apps_INITIALIZE (l_user_id, l_resp_id, l_resp_appl_id);

cep_standard.init_security;

See also:

http://oracle.ittoolbox.com/groups/technical-functional/oracle-apps-l/oebs-r12-how-to-query-apps-view-4517091