ORA-06553: PLS-306: Wrong Number or Types of Arguments in CA

[madmax]

Dear colleagues I'm making a screen with 6i Forms in EBS R11 and now started to cling this message when I make a query with crtl + f11

ORA-06553: PLS-306: WONG NUMBER OR TYPES OF arguments in call to 'ogc_x'

I searched Google but brings me things in Japanese and does not explain how to take this message.

Someone already passed by it?

any tip and welcome.

ABS ..

Douglas - Madmax

[diegolenhardt]

It seems that you are calling something with name: 'OGC_X'

and the parameters I am not set correctly, more specifically in relation to their types, number, varchar, etc.

[madmax]

Hello Diego,

NO EBS was in the examine - System - Last_Query

and Query that appears when I make a F11 + CTL F11 and that:

Select all

SELECT ROWID, 
      REF(X), 
       X.FLAG_IMPRESO, 
       X.TICKET_NUMERO, 
       X.TICKET_BALANZA_ID, 
       X.FECHA, 
       X.TIPO_TICKET, 
       X.CANCELADO_FLAG, 
       X.PLACA1, 
       X.PLACA2, 
       X.PLACA3, 
       X.DISTANCIA_ESTIMADA, 
       X.TARA, 
       X.JUSTIF_TARA, 
       X.PESO_BRUTO, 
       X.JUSTIF_PBRUTO, 
       X.PORCENTAJE_HUMEDAD, 
       X.PRODUCTOR_SITE_ID, 
       X.PRODUCTOR_ID, 
       X.CUSTOMER_ID, 
       X.CUSTOMER_SITE_USE_ID, 
       X.SHIP_METHOD_CODE, 
       X.CARRIER_SERVICE_ID, 
       X.CREATED_BY, 
       X.CREATION_DATE, 
       X.LAST_UPDATED_BY, 
       X.LAST_UPDATE_LOGIN, 
       X.ID_USUARIO_PESAJE_TARA, 
       X.ID_USUARIO_PESAJE_PESO_BRUTO, 
       X.LAST_UPDATE_DATE, 
       X.FECHA_PESAJE_TARA, 
       X.FECHA_PESAJE_PESO_BRUTO, 
       X.TARA_AUT_FLAG, 
       X.BRUTO_AUT_FLAG, 
       X.PARCELA, 
       X.PESO_TOTAL, 
       X.NUM_DISTRIBUICAO, 
       X.TRANSBORDO, 
       X.HABILITACAO, 
       X.COD_TRANSPORT, 
       X.CAM_ID, 
       X.TIPO_VEICULO 
  FROM XX_OM_TICKETS_BAL_BR X  

But if I comment the Ref (X) line,
the Select works.

Question: Where can I change this in the forms and I just created the XX_OM_TICKETS_BAL_BOB block.

Thanks.

[madmax]

Dear colleagues,

Detested what was in the new block I made by the wizard in properties has the option = include ref item that was yes I changed to no and has the alias option that was x I took it and it worked.

Thanks and is the tip.

ABS ..