OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Payables Transfer To General Ledger

Home » Applications » Oracle Fusion Apps & E-Business Suite » Payables Transfer To General Ledger (11.5.10.2,10g,xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Payables Transfer To General Ledger [message #466512]

Tue, 20 July 2010 00:20

madhuarepalli
Messages: 53
Registered: June 2010
Location: Hyderabad

Member

Hi All,

I would like to Know small clarification regarding on Report Submission through backend.

I am unable to understand, how to deifin the parameters in fnd_request.submit_request package.

How to define the parameter in fnd_request.submit_request package using below query.

Code: [Select all] [Show/ hide]

SELECT   *
    FROM fnd_descr_flex_col_usage_vl
   WHERE descriptive_flexfield_name = '$SRS$.APGLTRANS'
     AND required_flag = 'Y'
     AND display_flag = 'Y'
ORDER BY column_seq_num

I am defining the paramters based on above query, but it completed with Error because, declaration of parameter is wrong.

Code: [Select all] [Show/ hide]

fnd_request.submit_request( 'SQLAP',
                             'APGLTRANS',
                             'BANK SET OF BOOKS',
                              null,
                              null,
                              null,
                              sysdate,
                             'Payments',
                             'Y',
                             'In Detail'
                              );

Kindly suggest, how to defin the paramters using above sql query.

Regards,

Madhu

Report message to a moderator

Re: Payables Transfer To General Ledger [message #466928 is a reply to message #466512]

Wed, 21 July 2010 12:24

Alien
Messages: 292
Registered: June 1999

Senior Member

Hi,

There are a few things missing. Your query only displays required and displayed parameters. However in the fnd_request.submit_request, you'll need to submit all parameters and in the right order.

Second issue is that you submit 'BANK SET OF BOOKS', while the request needs the SOB_ID. I didn't check the other parameters, but they might have the same issue.

Regards,

Arian

Report message to a moderator

Re: Payables Transfer To General Ledger [message #467146 is a reply to message #466928]

Thu, 22 July 2010 05:32

madhuarepalli
Messages: 53
Registered: June 2010
Location: Hyderabad

Member

Hi Alien,

Quote:

you'll need to submit all parameters and in the right order.

What is the meaning of right order. Can u suggest by using above query.

Is it required all the parameter while submitting the Report.

Regards,
Madhu

Report message to a moderator

Re: Payables Transfer To General Ledger [message #467163 is a reply to message #467146]

Thu, 22 July 2010 06:44

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Code: [Select all] [Show/ hide]

SELECT   *
    FROM fnd_descr_flex_col_usage_vl
   WHERE descriptive_flexfield_name = '$SRS$.APGLTRANS'
   --  AND required_flag = 'Y'
   -- AND display_flag = 'Y'
ORDER BY column_seq_num;

You need to pass all the parameters in the same order of column_seq_num.
(Or) You can give the named parameters like, attribute1, attribute3, attribute6, etc for all the required parameters, irrespective of displayed or not.

By Vamsi

Report message to a moderator

Re: Payables Transfer To General Ledger [message #467541 is a reply to message #467146]

Sun, 25 July 2010 11:31

Alien
Messages: 292
Registered: June 1999

Senior Member

Hi Madhu,

see Vamsi's reply.

Regards,

Arian

Report message to a moderator

Previous Topic:	FDPSTP failed due to ORA-06550
Next Topic:	Supplier Site Missing

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 10 17:15:58 CDT 2025