Danfe Cool Message

Exclusivo para tópicos de DBA sobre Oracle EBS. Concurrent Manager, aplicação de Patch, autoconfig, ADPATCH, FNDLOAD, migração de releases, instalação do EBS, configuração do ambiente, etc.
Post Reply
vbmneto
Rank: Estagiário Júnior
Rank: Estagiário Júnior
Posts: 2
Joined: Thu, 29 Jul 2010 8:39 pm
Location: RJ

Someone can help me, where I recover the legal message, to print in Danfe, can help me, which table is the legal message used in DANFE, does not follow any more on the RA_CUSTOMER_TROX_INES? Before the Mastersaf PCK recovered from the Global_Attribute9 from RA_Customer_Trx_lines_all. Now it has changed?

** Oracle Database 12C Enterprise Edition Release 12.1.0.2.0 - 64bit Production (Oracle Applications: 12.2.5)
User avatar
madmax
Rank: DBA Pleno
Rank: DBA Pleno
Posts: 293
Joined: Wed, 13 Dec 2006 5:02 pm
Location: São Paulo
Contact:
________________________________
Douglas - Madmax.

Hello.

In R12 The legal message is in this table in the EBS

Apps.Cll_F031_Electronic_RET_ALL -> Attribute3


a look at this 3 tables in the Mastersaf return oracle.

Select all

select * from APPS.CLL_F031_ELECTRONIC_RET_ALL 
where customer_trx_id = 6727029; 
 
select * from APPS.CLL_F031_ELECTRONIC_TRX_ALL 
where customer_trx_id = 6727029; 
 
select * from APPS.JL_BR_CUSTOMER_TRX_EXTS 
where customer_trx_id = 6727029;
Att.

Douglas - Madmax
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 10 guests