OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Import Standard PO

Home » Applications » Oracle Fusion Apps & E-Business Suite » Import Standard PO (Oracle Application 12.0.0.0)

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

Import Standard PO [message #294282]

Thu, 17 January 2008 01:29

satya.das2007
Messages: 33
Registered: February 2007
Location: India

Member

Hi All,

I am trying to insert values into PO interface tables and then calling "Import Standard Purchase Order program" to populate data from interface table to base table.

But PO is not getting created even error table is not getting populated. I think the data is not picking up from interface table.

output file details:
Enter value for 12: EXEC FND_CONC_STAT.COLLECT; Enter Value for 14:

Please guide me.

Regards
Satya

Report message to a moderator

Re: Import Standard PO [message #336884 is a reply to message #294282]

Tue, 29 July 2008 05:12

ton63
Messages: 4
Registered: July 2008

Junior Member

Did someone resolved this problem?
Help, please!

Report message to a moderator

Re: Import Standard PO [message #337097 is a reply to message #336884]

Tue, 29 July 2008 21:57

satya.das2007
Messages: 33
Registered: February 2007
Location: India

Member

I think all the correct values were not inserted to interface tables. Please check your org id value.

org id was not correct in my case.

regards,
satya

Report message to a moderator

Re: Import Standard PO [message #337667 is a reply to message #336884]

Thu, 31 July 2008 10:12

sreekee
Messages: 12
Registered: July 2008

Junior Member

if anybody wants standard purchase order import prg please send me your mail id

[Updated on: Thu, 31 July 2008 10:17]

Report message to a moderator

Re: Import Standard PO [message #337795 is a reply to message #337667]

Fri, 01 August 2008 04:10

kittu915
Messages: 51
Registered: February 2006
Location: Hyderabad,India

Member

Hi,
You better upload it to forum...so that everyone get benefit.

Thanks,
Kittu.

Report message to a moderator

Re: Import Standard PO [message #337848 is a reply to message #337795]

Fri, 01 August 2008 06:17

sreekee
Messages: 12
Registered: July 2008

Junior Member

Hai here by i am attaching the standard po import

Attachment: po_import.sql
(Size: 13.51KB, Downloaded 1827 times)

[Updated on: Fri, 01 August 2008 06:22]

Report message to a moderator

Re: Import Standard PO [message #337866 is a reply to message #337848]

Fri, 01 August 2008 07:04

ton63
Messages: 4
Registered: July 2008

Junior Member

Can somebody show what columns and values are inserted in po_headers_interface and po_lines_interface? Especially interests column "ACTION"
Thnx!

p.s. Namely as to R12

[Updated on: Fri, 01 August 2008 07:39]

Report message to a moderator

Re: Import Standard PO [message #337878 is a reply to message #337866]

Fri, 01 August 2008 07:53

sreekee
Messages: 12
Registered: July 2008

Junior Member

hi
pass 'ORIGINAL' FOR ACTION COLUMN IN HEADERS

Report message to a moderator

Re: Import Standard PO [message #337881 is a reply to message #337878]

Fri, 01 August 2008 08:06

ton63
Messages: 4
Registered: July 2008

Junior Member

i'm not sure, that is right value for oebs 12R.
Whetever, what about DOCUMENT_TYPE_CODE?

Report message to a moderator

Re: Import Standard PO [message #337886 is a reply to message #337881]

Fri, 01 August 2008 08:22

sreekee
Messages: 12
Registered: July 2008

Junior Member

document_type_code='STANDARD'

Report message to a moderator

Re: Import Standard PO [message #337891 is a reply to message #337886]

Fri, 01 August 2008 08:26

ton63
Messages: 4
Registered: July 2008

Junior Member

Razz

worked!!! Thanks a lot!!!

Report message to a moderator

Re: Import Standard PO [message #379807 is a reply to message #337848]

Thu, 08 January 2009 00:37

sappi51
Messages: 7
Registered: January 2009
Location: secundrabad

Junior Member

Hi,
In the attached import Standard PO
what is Iappz_common_pkg.insert_conv_error
can u please provide what code will be in that package

Report message to a moderator

Re: Import Standard PO [message #379820 is a reply to message #379807]

Thu, 08 January 2009 00:56

sreekee
Messages: 12
Registered: July 2008

Junior Member

Its the common package we are using to store the errored out records

Report message to a moderator

Re: Import Standard PO [message #379826 is a reply to message #379820]

Thu, 08 January 2009 01:08

sappi51
Messages: 7
Registered: January 2009
Location: secundrabad

Junior Member

Thanks.

In the packge you are defined the two procedures one for Headers and one for lines.
What about the distrbutions?

can u please give me some inputs.

Report message to a moderator

Re: Import Standard PO [message #379827 is a reply to message #379826]

Thu, 08 January 2009 01:15

sreekee
Messages: 12
Registered: July 2008

Junior Member

Requirement was not there for us to populate Distribution tables.If u want i can send insert statement for the same.

Report message to a moderator

Re: Import Standard PO [message #379831 is a reply to message #379827]

Thu, 08 January 2009 01:33

sappi51
Messages: 7
Registered: January 2009
Location: secundrabad

Junior Member

OK.Thanks for your Response.

please provide the distribution aslo and if possible provide me your comman package for storing the error details.

Thanks

Report message to a moderator

Re: Import Standard PO [message #379838 is a reply to message #294282]

Thu, 08 January 2009 01:46

sreekee
Messages: 12
Registered: July 2008

Junior Member

Please see the attached text

Attachment: po.txt
(Size: 1.97KB, Downloaded 1428 times)

[Updated on: Thu, 08 January 2009 01:47]

Report message to a moderator

Re: Import Standard PO [message #379895 is a reply to message #379838]

Thu, 08 January 2009 04:36

sappi51
Messages: 7
Registered: January 2009
Location: secundrabad

Junior Member

Iam unable to open the attachment.

Report message to a moderator

Re: Import Standard PO [message #379897 is a reply to message #294282]

Thu, 08 January 2009 04:41

sreekee
Messages: 12
Registered: July 2008

Junior Member

Try this

Attachment: po.sql
(Size: 1.97KB, Downloaded 1293 times)

[Updated on: Thu, 08 January 2009 04:51]

Report message to a moderator

Re: Import Standard PO [message #379900 is a reply to message #379897]

Thu, 08 January 2009 05:03

sappi51
Messages: 7
Registered: January 2009
Location: secundrabad

Junior Member

Still Iam unable to open the attchement.
It showing error while clicking on the po.txt link

Report message to a moderator

Re: Import Standard PO [message #379904 is a reply to message #379900]

Thu, 08 January 2009 05:22

sreekee
Messages: 12
Registered: July 2008

Junior Member

Try po.sql not po.txt

[Updated on: Thu, 08 January 2009 06:26]

Report message to a moderator

Re: Import Standard PO [message #380108 is a reply to message #379904]

Fri, 09 January 2009 03:17

sappi51
Messages: 7
Registered: January 2009
Location: secundrabad

Junior Member

HI,
Yesturday I am unable to open the po.txt and po.sql
Can u pelase resend the document in other format.

thanks

Report message to a moderator

Re: Import Standard PO [message #380111 is a reply to message #380108]

Fri, 09 January 2009 03:29

sreekee
Messages: 12
Registered: July 2008

Junior Member

ITS OPENING WITH PO.SQL

[Updated on: Fri, 09 January 2009 03:38]

Report message to a moderator

Re: Import Standard PO [message #380125 is a reply to message #380111]

Fri, 09 January 2009 03:57

sappi51
Messages: 7
Registered: January 2009
Location: secundrabad

Junior Member

hi,
Not Opening.yesturday your not attached the PO.sql
And pdf is aslo not opening.

Report message to a moderator

Re: Import Standard PO [message #380130 is a reply to message #380125]

Fri, 09 January 2009 04:08

sreekee
Messages: 12
Registered: July 2008

Junior Member

FOR DISTRIBUTIONS

INSERT INTO po_distributions_interface
(
interface_header_id,
interface_line_id,
interface_distribution_id,
quantity_ordered,
charge_account_id,
last_update_date,
last_updated_by,
creation_date,
created_by,
org_id
)
VALUES(GIVE your VALUES)

Report message to a moderator

Previous Topic:	Query from XLA_AEL_SL_V gives nothing. what to do
Next Topic:	cannot convert oracle apps report output file into excel file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 17:51:55 CDT 2024