User login
Sponsored links
Recent blog posts
- Unwanted Save Warnings in Display Only Pages
- Breadcrumb SQL to find the Navigation path for the component in the PIA
- Application Designer Index naming convention
- How to create Trigger in DB2
- Emplid increment automatically
- How can we romove multiple duplicate rows of data printing under each Print command in SQR Program?
- How can we call Dynamic Calling section in Peoplesoft Application Engine program?
- How can we write multiple SQL Commands/Statements under one Action by using one function?
- Peoplesoft BU VS Record Groups VS Record Group Controls VS Control Table VS Table set Sharing VS Table SETID?
- Difference between Custom and Customised objects in Peoplesoft?
Application Engine Error
i am getting the below error while running Application Engine Program .
Could you tell me what would be the reason ....
File: E:\pt84920b-retail\peopletools\SRC\PSAPPENG\aebuf.cppSQL error. Stmt #: 574 Error Position: 0 Return: 8010 - [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'PROCESS_INSTANCE'.
Failed SQL stmt:INSERT INTO PS_ECL_ADVTRA_AET (PROCESS_INSTANCE,PRCSOUTPUTDIR,EMPLID,DESCRSHORT,ECL_ARF_REQ_ID,ECL_CLAIM_REQ_ID,NAME,DEPTID,ECL_COST_CENTER,ECL_APPROVER_ID,NAME1,ZIN_ZONE,LOCATION,DESCR,ECL_STATUS,EMPL_STATUS,ECL_GL_CODE,ECL_ADV_AMOUNT,ECL_TOTAL_AMT) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19)
Message Set Number: 200
Message Number: 0
Message Reason: File: E:\pt84920b-retail\peopletools\SRC\PSAPPENG\aebuf.cppSQL error. Stmt #: 574 Error Position: 0 Return: 8010 - [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'PROCESS_INSTANCE'.
Failed SQL stmt:INSERT INTO PS_ECL_ADVTRA_AET (PROCESS_INSTANCE,PRCSOUTPUTDIR,EMPLID,DESCRSHORT,ECL_ARF_REQ_ID,ECL_CLAIM_REQ_ID,NAME,DEPTID,ECL_COST_CENTER,ECL_APPROVER_ID,NAME1,ZIN_ZONE,LOCATION,DESCR,ECL_STATUS,EMPL_STATUS,ECL_GL_CODE,ECL_ADV_AMOUNT,ECL_TOTAL_AMT) VALUES (:1,:2,:3,:4,: (200,0)
Unanswered Forum Posts
| Title | Under | Posted on |
|---|---|---|
| how to create application status in peoplesoft campus solutions 8.9 version | PeopleSoft Functional | 05/17/2012 - 4:09am |
| horizantal text in charts | PeopleSoft Technical | 05/10/2012 - 4:57am |
| no current buffer context error | PeopleSoft Technical | 05/10/2012 - 1:19am |
| Integration Broker : Operating Instance/Pub Contracts/Sub Contracts | PeopleSoft Technical | 04/24/2012 - 11:05am |
Is the field PROCESS_INSTANCE existing in the record? What type of record is it? Work Record or SQL Table?
Are you explicitly trying to insert row into AET record or are you using %Select construct?
Can you run the below in ur database with no errors?
Select PROCESS_INSTANCE,PRCSOUTPUTDIR,EMPLID,DESCRSHORT,ECL_ARF_REQ_ID,ECL_CLAIM_REQ_ID,NAME,DEPTID,ECL_COST_CENTER,ECL_APPROVER_ID,NAME1,ZIN_ZONE,LOCATION,DESCR,ECL_STATUS,EMPL_STATUS,ECL_GL_CODE,ECL_ADV_AMOUNT,ECL_TOTAL_AMT from PS_ECL_ADVTRA_AET;
Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog
Post new comment