Home » Applications » Oracle Fusion Apps & E-Business Suite » Import Standard PO (Oracle Application 12.0.0.0)
Import Standard PO [message #294282] Thu, 17 January 2008 01:29 Go to next message
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
icon9.gif  Re: Import Standard PO [message #336884 is a reply to message #294282] Tue, 29 July 2008 05:12 Go to previous messageGo to next message
ton63
Messages: 4
Registered: July 2008
Junior Member
Did someone resolved this problem?
Help, please!
Re: Import Standard PO [message #337097 is a reply to message #336884] Tue, 29 July 2008 21:57 Go to previous messageGo to next message
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
Re: Import Standard PO [message #337667 is a reply to message #336884] Thu, 31 July 2008 10:12 Go to previous messageGo to next message
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 Go to previous messageGo to next message
kittu915
Messages: 51
Registered: February 2006
Location: Hyderabad,India
Member
Hi,
You better upload it to forum...so that everyone get benefit.

Thanks,
Kittu.
Re: Import Standard PO [message #337848 is a reply to message #337795] Fri, 01 August 2008 06:17 Go to previous messageGo to next message
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 825 times)

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

Report message to a moderator

icon9.gif  Re: Import Standard PO [message #337866 is a reply to message #337848] Fri, 01 August 2008 07:04 Go to previous messageGo to next message
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 Go to previous messageGo to next message
sreekee
Messages: 12
Registered: July 2008
Junior Member
hi
pass 'ORIGINAL' FOR ACTION COLUMN IN HEADERS
Re: Import Standard PO [message #337881 is a reply to message #337878] Fri, 01 August 2008 08:06 Go to previous messageGo to next message
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?
Re: Import Standard PO [message #337886 is a reply to message #337881] Fri, 01 August 2008 08:22 Go to previous messageGo to next message
sreekee
Messages: 12
Registered: July 2008
Junior Member
document_type_code='STANDARD'
Re: Import Standard PO [message #337891 is a reply to message #337886] Fri, 01 August 2008 08:26 Go to previous messageGo to next message
ton63
Messages: 4
Registered: July 2008
Junior Member
Razz worked!!! Thanks a lot!!!
Re: Import Standard PO [message #379807 is a reply to message #337848] Thu, 08 January 2009 00:37 Go to previous messageGo to next message
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
Re: Import Standard PO [message #379820 is a reply to message #379807] Thu, 08 January 2009 00:56 Go to previous messageGo to next message
sreekee
Messages: 12
Registered: July 2008
Junior Member
Its the common package we are using to store the errored out records
Re: Import Standard PO [message #379826 is a reply to message #379820] Thu, 08 January 2009 01:08 Go to previous messageGo to next message
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.
Re: Import Standard PO [message #379827 is a reply to message #379826] Thu, 08 January 2009 01:15 Go to previous messageGo to next message
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.
Re: Import Standard PO [message #379831 is a reply to message #379827] Thu, 08 January 2009 01:33 Go to previous messageGo to next message
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
Re: Import Standard PO [message #379838 is a reply to message #294282] Thu, 08 January 2009 01:46 Go to previous messageGo to next message
sreekee
Messages: 12
Registered: July 2008
Junior Member
Please see the attached text
  • Attachment: po.txt
    (Size: 1.97KB, Downloaded 385 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 Go to previous messageGo to next message
sappi51
Messages: 7
Registered: January 2009
Location: secundrabad
Junior Member
Iam unable to open the attachment.

Re: Import Standard PO [message #379897 is a reply to message #294282] Thu, 08 January 2009 04:41 Go to previous messageGo to next message
sreekee
Messages: 12
Registered: July 2008
Junior Member
Try this
  • Attachment: po.sql
    (Size: 1.97KB, Downloaded 335 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 Go to previous messageGo to next message
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
Re: Import Standard PO [message #379904 is a reply to message #379900] Thu, 08 January 2009 05:22 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: Import Standard PO [message #380111 is a reply to message #380108] Fri, 09 January 2009 03:29 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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.
Re: Import Standard PO [message #380130 is a reply to message #380125] Fri, 09 January 2009 04:08 Go to previous message
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)
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:
  


Current Time: Tue Dec 06 14:14:57 CST 2016

Total time taken to generate the page: 0.15140 seconds