Unable To Create Billing Events Using Standard PA_EVENT_PUB API

(Doc ID 729177.1)

Last updated on JULY 17, 2017

Applies to:

Oracle Project Billing - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.




******Checked for relevance on 12-Sep-2011*******


Symptoms

PAEVAPBB.pls PA_EVENT_PUB
Unable to create events using Oracle Public API: PA_EVENT_PUB.Create_Event
Running wrapper code as a process
ERROR
 Entering the Main Program
 .... 
Execute Create Event Status = E
Created New Event" Project = XXXXX RETURNS

Also in FND_LOG file:
fnd.plsql.FND_FUNCTION.TEST.begin 2 FND_FUNCTION.TEST(function_name =>PA_EV_CREATE_EVENT);
pa.plsql.PA_EVENT_PVT.CHECK_MDTY_PARAMS1.begin 1 Beginning of Function security Check
fnd.plsql.FND_FILE.PUT_LINE 3 x_revenue_amount 0
fnd.plsql.FND_FILE.PUT_LINE 3 x_invoice_amount 347.14
fnd.plsql.FND_FILE.PUT_LINE 3 Revenue Amount = 208.4625
fnd.plsql.FND_FILE.PUT_LINE 3 Invoice Amount = 0
fnd.plsql.FND_FILE.PUT_LINE 3 Loading Event
fnd.plsql.FND_FILE.PUT_LINE 3 Next Event Num = 114
fnd.plsql.FND_FILE.PUT_LINE 3 organization Nmae = XXXXX
fnd.plsql.FND_FILE.PUT_LINE 3 Task number 66
fnd.plsql.FND_FILE.PUT_LINE 3 Project Number = 498
fnd.plsql.FND_FILE.PUT_LINE 3 Created New Event: Project = 1042Q70 RETURNS
fnd.plsql.FND_FILE.PUT_LINE 3 Execute Create Event Status = E:
fnd.plsql.FND_FUNCTION.TEST_ID(4_ARGS).end_false 2 returning FALSE;
fnd.plsql.FND_FUNCTION.TEST_INSTANCE_ID_MAINTMODE.end_false 2 returning FALSE;
fnd.plsql.FND_DATA_SECURITY.CHECK_GLOBAL_OBJECT_TYPE_GRANT.end 2 F
fnd.plsql.FND_DATA_SECURITY.CHECK_GLOBAL_OBJECT_GRANT.end_no_inst 2 F
fnd.plsql.FND_DATA_SECURITY.CHECK_GLOBAL_OBJECT_GRANT.fetch_instance_grants 1 l_result:
fnd.plsql.FND_DATA_SECURITY.CHECK_GLOBAL_OBJECT_GRANT.open_grants_cursor 1 cp_user_name:
XXXXUSERNAME cp_function_id: 21258 l_sysdate: 28-JUL-08 cp_object_id: -1
fnd.plsql.FND_DATA_SECURITY.GET_FUNCTION_ID.end 2 returning v_function_id:21258



.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms